1140 - In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'bangonbanners_bangonba_db.c.categories_status'; this is incompatible with sql_mode=only_full_group_by

select count(*) as total, c.categories_status, c.categories_id, cd.categories_name, c.parent_id, products_name, products_meta_title, products_meta_description from osc_products p left join osc_products_to_categories p2c on p.products_id = p2c.products_id left join osc_categories c on p2c.categories_id = c.categories_id LEFT JOIN osc_categories_description cd on cd.categories_id = c.categories_id, osc_products_description pd where p.products_status = '1' and p.products_id = '68' and pd.products_id = p.products_id and pd.language_id = '1'

[TEP STOP]