DESIGN

LEGS

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

BASES

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

SWIVEL MECHANISMS

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