Top Search Results With Every Time Cashback Offers

Top Seller Seal Trusted Seal User Ratings Cashback Offer -- High to Low
     
CAT CLEAN
Srikrishna Agency-ZamWays merchant | nearby store

ERROR SQL >> SELECT IF(p.star_avg IS NULL, 0 , p.star_avg) AS 'star_avg', count(1) AS 'totalReview' FROM ( SELECT (SUM(shop_star)/COUNT(1)) AS 'star_avg' FROM review_shop WHERE shop_id = 'SOP1' ) p

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'p.star_avg'; this is incompatible with sql_mode=only_full_group_by