Errore del database

Error Number: 1064

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 p.rif DESC' at line 5

SELECT p.id_immobile, pd.nome, pd.desc, p.id_copertina, p.rif, p.zona, p.mq, p.richiesta, p.tipo_richiesta, p.vani, pd.uri, p.esclusive, p.consigliato FROM immobili AS p JOIN immobili_desc AS pd ON p.id_immobile = pd.id_immobile AND pd.id_lang = 1 WHERE stato = 1 AND p.id_immobile IN (SELECT c.id_immobile FROM immobili_categorie_id AS c WHERE c.id_categoria = ) ORDER BY p.rif DESC

Filename: /var/www/vhosts/guidelliimmobiliare.it/httpdocs/models/site/immobili_model.php

Line Number: 122