SELECT id FROM shop_item WHERE id_kat='167' AND active='a' AND sklad=0 GROUP BY zbozi_skupina