1140 In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'avant16_r2supgrade.products_promotion.promotion_new_products_price'; this is incompatible with sql_mode=only_full_group_by
in:
[select count(*) as cnt,promotion_new_products_price from products_promotion where products_id = '843' and status='1']