SQL Error:select *
from `gallery`
inner join `gallery_image` on gallery.gallery_id = gallery_image.gallery_id
where `index_id` = '11'
group by `gallery`.`gallery_id`
order by `gallery_sort` desc,`gallery`.`gallery_id` desc
1055: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.gallery_image.gallery_image_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.gallery_image.gallery_image_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 `gallery`
inner join `gallery_image` on gallery.gallery_id = gallery_image.gallery_id
where `index_id` = '11'
group by `gallery`.`gallery_id`
order by `gallery_sort` desc,`gallery`.`gallery_id` desc
LIMIT 30
1055: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.gallery_image.gallery_image_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'humanity_humanity.gallery_image.gallery_image_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by