DESIGN

PICIOARE

SELECT menu.id,menu.aname_ro as aname,menu.name_ro 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 = 27 and menu.name_ro<>'' and menu.nolist=0 and cechy.name = 'NOGI' order by cechy.morder,menu.morder,menu.name

BAZE

SELECT menu.id,menu.aname_ro as aname,menu.name_ro 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 = 27 and menu.name_ro<>'' and menu.nolist=0 and cechy.name = 'PODSTAWY' order by cechy.morder,menu.morder,menu.name

MECANISME PIVOTANTE

SELECT menu.id,menu.aname_ro as aname,menu.name_ro 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 = 27 and menu.name_ro<>'' and menu.nolist=0 and cechy.name = 'MECHANIZMY OBROTOWE' order by cechy.morder,menu.morder,menu.name