SELECT pr.*, i.filename FROM Products p, ProductsByProducts pb, Products pr LEFT JOIN Images AS i ON pr.idMediumImage=i.idImage WHERE p.idProduct=pb.idProduct AND pb.idRelatedProduct=pr.idProduct AND p.idProduct= [nativecode=1064 ** 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 1]