1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nyfifth_hr2.cd.categories_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select cd.categories_name,ca.cat_url,cd.categories_id from categories_description cd,products_to_categories ptc,categories ca where ptc.categories_id = cd.categories_id and ca.categories_id=ptc.categories_id and ca.sort_order >= 0 and ptc.products_id in (43481) group by cd.categories_id
[TEP STOP]
|
