WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by artist.lastname,artist.firstname,work.artcld_artwork_name' at line 4]
select work.*,artist.firstname,artist.lastname,work.slug as work_slug,artist.slug as artist_slug from wp_ky_artworks work left join wp_ky_artists artist on artist.id=work.artist_id where work.artcld_artwork_id in (SELECT artwork_id FROM wp_ky_exhibition_artwork WHERE exhibition_id=) order by artist.lastname,artist.firstname,work.artcld_artwork_name

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by artist.lastname,artist.firstname,work.artcld_artwork_name' at line 4]
select work.*,artist.firstname,artist.lastname,work.slug as work_slug,artist.slug as artist_slug from wp_ky_artworks work left join wp_ky_artists artist on artist.id=work.artist_id where work.artcld_artwork_id in (SELECT artwork_id FROM wp_ky_exhibition_also_artwork WHERE exhibition_id=) order by artist.lastname,artist.firstname,work.artcld_artwork_name

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4]
select distinct concat(artist.firstname,' ',artist.lastname) as name from wp_ky_artworks work left join wp_ky_artists artist on artist.id=work.artist_id where work.artcld_artwork_id in (SELECT artwork_id FROM wp_ky_exhibition_artwork WHERE exhibition_id=)