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 ') AND t1.active = '1' AND t4.type = 'full'' at line 1
on query SELECT t1.id,t1.name,t4.file,t1.size_x,t1.size_y,t1.size_z,t1.medium,t5.display AS unit FROM aw_artwork AS t1 LEFT JOIN aw_img AS t4 ON t4.artwork = t1.id LEFT JOIN aw_units AS t5 ON t1.size_units = t5.id WHERE t1.id in () AND t1.active = '1' AND t4.type = 'full'