Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'sagmart_db2.deals.offer_price_deals' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error getvalue.select count(*) FROM sag_products as product INNER JOIN sag_product_images as productImg ON product.id=productImg.product_id INNER JOIN sag_product_deals as deals ON product.id=deals.product_id WHERE product.is_active='t' and deals.discount_deals>0 and deals.is_active='t' group by deals.product_id order by deals.offer_price_deals asc