Bryan Memorial Gallery
Bryan Memorial Gallery

Watercolors 2020

Watercolors 2020

SELECT artists.*, paintings.*, exhibits.* FROM artists INNER JOIN paintings ON artists.artistId = paintings.artistId INNER JOIN exhibits ON paintings.itemId = exhibits.itemId WHERE artists.active = 1 AND exhibits.showId = ? AND exhibits.active = 1 GROUP BY artists.artistId ORDER BY artists.lastname ASC

Expression #15 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'alden_gallery.paintings.itemId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by