CONSTRUCTION

SELECT menu.id,menu.aname_de as aname,menu.name_de as name,menu.new,menu.nolist,cechy.name as cecha from menu left join prod_kat on (prod_kat.id_prod=menu.id) left join ccechy on (ccechy.id_product=menu.id) left join cechy on (ccechy.id_cechy=cechy.id) where menu.active=1 and prod_kat.id_cat = 24 and menu.aname_de<>'' and menu.nolist=0 and cechy.name is null order by cechy.morder,menu.morder,menu.name