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