SQL Error:select *
from `project_category`
inner join `project` on project_category.project_category_id = project.project_category_id
group by `project_category`.`project_category_id`
order by `project_category_sort` desc,`project_category`.`project_category_id` desc
1055: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.project.project_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.project.project_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Error:select *
from `project_category`
inner join `project` on project_category.project_category_id = project.project_category_id
group by `project_category`.`project_category_id`
order by `project_category_sort` desc,`project_category`.`project_category_id` desc
LIMIT 30
1055: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.project.project_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.project.project_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by