SELECT * FROM cms_1_shop_categs_hu WHERE SUB='0' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='114' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='71' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='107' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='93' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='60' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='137' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='136' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='49' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='39' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='77' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='22' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='34' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='92' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='102' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='29' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='0' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='1' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='83' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='78' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='60' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='79' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='61' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='63' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='80' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='84' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="29" ORDER BY POSITION ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'tufty-medium-feeder-35-g-2-db-495'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1'
SELECT * FROM cms_1_shop_hu WHERE ACTIVE='1' AND ID!='' ORDER BY RAND(),VIEW DESC LIMIT 4
SELECT * FROM cms_1_pictures WHERE CONTENTID='1486' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1484' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1203' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1481' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'tufty-medium-feeder-35-g-2-db-495'
SELECT * FROM cms_1_pictures WHERE CONTENTID='495' AND CONTENTTYPE='88' AND MAIN!='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='42' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='39' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='0' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='' AND ACTIVE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='495' AND MAIN='1' AND CONTENTTYPE='88'
Tufty Medium Feeder 35 g - 2 db | Horgaszni.hu
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='0' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='84' ORDER BY NO ASC
A Tufty feeder kosaraka legújabb fejlesztésű Haldorádó termékek közé tartoznak. Sok vízparton töltött óra és hosszú évek alatt megszerzett rutin testesül meg bennük. Ez a fajta kosár teljesen különbözik a megszokott Haldorádó kosaraktól. Az első, szembetűnő formai újdonság az a trapéz alakú nehezék, ami a kosár alja felé szélesedik. Ezzel a kis módosítással a Tufty sokkal egyenesebben repül, mint akármelyik oldalnehezékes kosár. Ez a súly segíti a kosár stabil aljzaton maradását is, kevésbé tud elgördülni. A következő szembetűnő különbség a hagyományos drótos kosarakhoz képest, az a sűrű 2 mm-es hálóanyag. Ez a megoldás ötvözi a zárt cső alakú műanyag és hagyományos nagylyukú feederkosarak előnyeit. Azaz garantáltan lejuttatja a sűrű háló az anyagot a fenékre, de mégis gyors oldódást biztosít, hiszen a víz könnyedén átjárja. Hosszúságához képest a keresztmetszete látványosan nagy, ami a töltés és kioldódás folyamatát gyorsítja meg. Amit elsőre nem is mindig veszünk észre, hogy a Tufty minden eleme strapabíróan van elkészítve, egész egyszerűen nincs gyenge pontja azt eszköznek! Ilyen az erősített fülkiképzés, vagy a peremezett kosár élek, amelyek nem vágnak, nem sértik meg a horgász kezét, miközben jelentősen növelik tartását. 4 méretben, több különböző súllyal kerül forgalomba, ezek a: mini, micro, medium és large.