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="83" ORDER BY POSITION ASC
SELECT * FROM cms_1_label_hu ORDER BY NAME ASC
SELECT * FROM cms_1_newscategs_hu ORDER BY NAME ASC
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_pictures WHERE CONTENTID='372' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='369' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_contents_hu WHERE ACTIVE="1" AND SUB="83" ORDER BY NO DESC
SELECT * FROM cms_1_pictures WHERE CONTENTID='83' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='83' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='83' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND PUBDATE <= NOW() ORDER BY PUBDATE DESC LIMIT 0,9
SELECT * FROM cms_1_pictures WHERE CONTENTID='372' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='369' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='368' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='367' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='366' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='365' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='364' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='363' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='362' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='83' AND MAIN='1' AND CONTENTTYPE='1'
Magazin | 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
Magazinunk folyamatosan bővülő tartalom. Munkatársaink tevékenységét itt követhetitek nyomon. Célunk mindent megmutatni, tudatosan elmagyarázni cikkeinkben.
A Préri tó csapsta igyekszik a szabályok betartásán kívül, a lehető legbiztosnágosabban szolgálétani a horgászat lehetőségét. A lenti szabályokat is ezért...
Hasonlóan az elmúlt esztendőhöz, ennek a rendezvénynek is a préri tó kárászos tava adott otthont, ahol március 7-én az első kárászos kupán 11 versenyző...
Idén sokkal több versenyre terveztem eljutni mint az előző évben. Voltak köztük régi kedvelt rendezvények is, de volt két rendezvény amire már vágytam korábbi...
Kialakult a továbbjutók teljes névsora és a nyereménylista is teljes! Aki nyert napijegyet vagy svédasztalos ebédet, az a kupont az étteremben átveheti.
Megkezdődött a versenyszezon a Préri tavon is. Idén három saját versenysorozattal várunk mindenkit. Igyekeztünk mindenkinek kedvébe járni és kihasználni a tavak...
A Préri tó csapsta igyekszik a szabályok betartásán kívül, a lehető legbiztosnágosabban szolgálétani a horgászat lehetőségét. A lenti szabályokat is ezért hozták és kérnek mindenkit, hogy maradéktalanul tartsa be őket!