SELECT cablesets.*,carcableset.manufyearfrom as yearfrom,carcableset.manufyearto as yearto,cablesettype.name as cstype FROM cablesets left join carcableset on carcableset.number=cablesets.number left join cablesettype on cablesets.cablesettypeid=cablesettype.id WHERE cablesets.number='700201' AND carcableset.carmodelid= AND carcableset.cartowbarid=<br />You have an error in your SQL syntax near 'AND carcableset.cartowbarid=' at line 1