In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'sagmart_db2.variant.variant_display_name'; this is incompatible with sql_mode=only_full_group_by
Error getvalues.SELECT count(variant.id) as varnm_cnt,variant.variant_display_name,variant.variant_seo_url,variant.model_image,variant.id,prd.p_type_id,pimg.image_path1 FROM sag_variant as variant inner join sag_products as prd on prd.variant_id=variant.id left join sag_product_images as pimg on prd.id = pimg.product_id WHERE variant.variant_seo_url='mahindra-scorpio' and variant.is_active='t' and prd.is_active='t'