SELECT * FROM subcat_relationships LEFT JOIN subcats ON subcats.id = subcat_relationships.related_subcat_id WHERE subcat_relationships.subcat_id = 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