Error Number: 1055
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shscoco_db.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT DISTINCT p.parent_id,p.*,pc.title as category_name,pp.title as title_en from projects p join project_category pc on p.category_id=pc.id join projects pp on p.parent_id=pp.id join project_sub_category psc on p.sub_category_id=psc.parent_id WHERE p.lang_id=1 AND p.home=1 GROUP BY p.parent_id ORDER BY p.sorts LIMIT 9
Filename: models/Project.php
Line Number: 33