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 t2.type & 1 ORDER BY t4.sort_id' at line 1<br> on query SELECT DISTINCT t1.id,t1.name,t1.size_x,t1.size_y,t1.size_z,t1.medium,t2.file,t3.display AS unit FROM aw_artwork AS t1 LEFT JOIN aw_img AS t2 ON t2.artwork = t1.id LEFT JOIN aw_units AS t3 ON t3.id = t1.size_units LEFT JOIN map_artwork2album AS t4 ON t4.artwork = t1.id WHERE t1.id in () AND t2.type & 1 ORDER BY t4.sort_id