« Parse Error »

encountered the following error while attempting to parse the requested resource:
« Esecuzione della query fallita
SELECT pi.id, pc.nome, pc.rewrite FROM prodotti_index AS pi LEFT JOIN prodotti_contents AS pc ON pi.id=pc.id WHERE pc.lingua_id='2' AND pi.attiva AND pi.cat_id = ORDER BY pi.ordine,pi.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 'ORDER BY pi.ordine,pi.id' at line 1 »
Parser timing
  MySQL: ( Requests)