Errore nella Query:
SELECT FROM dir_prodotti dp WHERE dp.lp_sys_stato = 1 AND IN( SELECT FROM dir_prodotti AS ddpp WHERE ddpp.lp_sys_stato = 1 AND ddpp.id_dir_sottocategoria = 0 ) ORDER BY 
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