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

SELECT id_bien FROM as_bien WHERE actif_bien=1 AND venteloc_bien='vente' AND id_type=
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 'ORDER BY coupcoeur_bien DESC, ordre_tri_bien LIMIT 0,6' at line 1

SELECT * FROM as_bien LEFT JOIN as_statut ON as_statut.id_statut=as_bien.id_statut WHERE actif_bien=1 AND venteloc_bien='vente' AND id_type= ORDER BY coupcoeur_bien DESC, ordre_tri_bien LIMIT 0,6
 Vente appartements maisons chalets terrains 74 La Roche sur Foron - AS Immobilier & Home Staging Haute-Savoie
AS Immobilier

Ventes s

Il n' y a actuellement aucun bien de type à vendre.