Erreur de requete !

Requete

select annonces.id,annonces.honos_a_charge_de,villes.commune,villes.cp, annonces.prix, annonces.surface,annonces.nb_pieces,categories.libelle_fr,annonces.image1, emag_annonces.coupdecoeur,agences.libelle as ag_libelle, agences.adresse as ag_adresse, agences.cp as ag_cp,agences.ville as ag_ville,agences.logo as ag_logo from emag_annonces, annonces, villes, categories,agences where emag_annonces.id_annonce=annonces.id and annonces.id_ville=villes.id and annonces.id_agence=agences.id and annonces.id_categorie=categories.id and emag_annonces.id_emag=39 and emag_annonces.publie='1' and villes.id IN () order by prix desc

Erreur

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') order by prix desc' at line 10