DESIGN

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
NEWGARDA VSP 231-19SP 231-19 GARDA V
GARDA SP 151-19SP 151-19 GARDA
NEWRIO VSP 232-19SP 232-19 RIO V
RIOSP 166-19SP 166-19 RIO
KOMO VSP 233-19SP 233-19 KOMO V
KOMOSP 788-E-19SP 788-E-19 KOMO
PENTESP 095-C-20SP 095-C-20 PENTE
DISHSP 085-28SP 085-28 DISH
CENTROSP 969-5SP 969-5 CENTRO

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
MECHANISMSP 410-C-19SP 410-C-19 MECHANISM
MECHANISMSP 400-A-19SP 400-A-19 MECHANISM
MECHANISMSP 093-8SP 093-8 MECHANISM
MECHANISMSP 070-B-5SP 070-B-5 MECHANISM
MECHANISMSP 968-5SP 968-5 MECHANISM
MECHANISMSP 960-A-5SP 960-A-5 MECHANISM

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
NEWSPILLONG 274-8NG 274-8 SPILLO
NEWPROXING 134-8NG 134-8 PROXI
NEWPROXI 2NG 133-8NG 133-8 PROXI 2
NEWSTELLANG 131-8NG 131-8 STELLA
NEWALFANG 132-8NG 132-8 ALFA
NEWFENIKSBA 017-20BA 017-20 FENIKS
NEWTUKANBA 016-20BA 016-20 TUKAN
PASOBA 006-20BA 006-20 PASO
NEWHAWKBG 966-8BG 966-8 HAWK
NEWNINFABG 913-8BG 913-8 NINFA
NEWNINFABG 931-8BG 931-8 NINFA
ROSABG 149-8BG 149-8 ROSA
BONIBG 918-A-8BG 918-A-8 BONI
CLAPSYBG 765-8BG 765-8 CLAPSY
INCABG 749-8BG 749-8 INCA
CRUZBG 919-8BG 919-8 CRUZ
RONALDOBG 969-8BG 969-8 RONALDO
YOKOBG 533-8BG 533-8 YOKO
VIGOBG 531-8BG 531-8 VIGO
CORALBG 551-8BG 551-8 CORAL
DIUNABG 453-8BG 453-8 DIUNA
CORBYNG 726-8NG 726-8 CORBY
ALPESNG 399-8NG 399-8 ALPES
NEWHYMENNG 273-8NG 273-8 HYMEN
NEWLYNXNG 272-8NG 272-8 LYNX
NEWXENONBG 974-8BG 974-8 XENON
MARSBG 950-8BG 950-8 MARS
HANABG 820-8BG 820-8 HANA
NESBG 449-8BG 449-8 NES
SVENBG 306-8BG 306-8 SVEN
NEWBOVABG 976-8BG 976-8 BOVA
NEWMARINABG 977-8BG 977-8 MARINA
NEWHAWK FRAME HAWK FRAME
FURON FURON
ROMA ROMA