DESIGN

PIEDS

SELECT menu.id,menu.aname_fr as aname,menu.name_fr 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_fr<>'' and menu.nolist=0 and cechy.name = 'NOGI' order by cechy.morder,menu.morder,menu.name
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
NEWMILENABG 978-8BG 978-8 MILENA
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

BASES

SELECT menu.id,menu.aname_fr as aname,menu.name_fr 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_fr<>'' and menu.nolist=0 and cechy.name = 'PODSTAWY' order by cechy.morder,menu.morder,menu.name
NEWMODISP 187-12SP 187-12 MODI
NEWNOTOSP 186-8SP 186-8 NOTO
NEWSPRINTSP 188-8SP 188-8 SPRINT
KOMOSP 788-E-8SP 788-E-8 KOMO
PENTESP 095-C-20SP 095-C-20 PENTE
RIOSP 166-12SP 166-12 RIO
GARDA SP 151-12SP 151-12 GARDA
DISHSP 085-28SP 085-28 DISH
CENTROSP 969-5SP 969-5 CENTRO

MÉCANISMES ROTATIFS

SELECT menu.id,menu.aname_fr as aname,menu.name_fr 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_fr<>'' and menu.nolist=0 and cechy.name = 'MECHANIZMY OBROTOWE' order by cechy.morder,menu.morder,menu.name
MÉCANISMESP 912-8SP 912-8 MÉCANISME
MÉCANISMESP 142-A-8SP 142-A-8 MÉCANISME
MÉCANISMESP 070-B-5SP 070-B-5 MÉCANISME
MÉCANISMESP 093-8SP 093-8 MÉCANISME
MÉCANISMESP 968-5SP 968-5 MÉCANISME
MÉCANISMESP 960-A-5SP 960-A-5 MÉCANISME