SELECT * FROM site_produse p WHERE p.prod_sters=0 AND p.prod_status=1 AND p.prod_clonat=0 AND p.prod_in_shop=1 AND prod_id_categ IN (SELECT categ_id FROM site_categorii WHERE categ_departament=) ORDER BY prod_ord DESC, prod_id DESC