-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
Το Popper της Williamson σχεδιάστηκε
για να μπορεί να χρησιμοποιηθεί με τα βασικά καλάμια spinning.
Έχει βάρος 35gr ...
16,90 €15,21 €
-10,00%
-10,00%
Τα ψαράκια Pins Minnow θεωρούνται
τα μικρά «τεχνουργήματα» της YOZURI με άριστο ζύγισμα στη πλεύση, σε χαμηλές ή
μεγάλες...
12,00 €10,80 €
-10,00%
Το Magnet
Minnow έχει το σύστημα Μαγνητικής Μεταφοράς Βάρους. Στη βολή, ο μαγνήτης
και οι μεταλλικές μπίλιες πέφτουν στ...
13,40 €12,06 €
-10,00%
ΤΥΠΟΣ: SINKING
Βάθος
πλεύσης: 7cm: 1 – 1,6 μέτρα / 9cm-11cm: 1,2 - 1,8 μέτρα / 13cm: 1,6
– 2 μέτρα
σώμα
...
14,80 €13,32 €
-10,00%
-10,00%
-10,00%
Το πατενταρισμένο εσωτερικό 3D Prism Finish του Crystal 3D Minnow αντανακλά όλο το φως της επιφάνειας,
ακόμη και σε θολ...
15,20 €13,68 €
-10,00%
The Arc Minnow is a superb life like jerkbait.A great lure for fishing for Speckled Trout, Redfish and Snook on the flat...
7,50 €6,75 €
-10,00%
Trailer EG-140Trailer - another revolutionary lure developed by Strike Pro whichincorporates scent attractants. Scent ca...
15,00 €13,50 €
-10,00%
DTD Minnow Liganj looks like
squid vivid colors hologram effect.Technical
Characteristics
Looks like Squid
Vivid C...
13,80 €12,42 €
SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',1,', p.categories)>0 OR p.categories='1') OR ( (CHARINDEX(',5,', p.categories)>0 OR p.categories='5') OR (CHARINDEX(',6,', p.categories)>0 OR p.categories='6') OR (CHARINDEX(',7,', p.categories)>0 OR p.categories='7') OR (CHARINDEX(',9,', p.categories)>0 OR p.categories='9') OR (CHARINDEX(',10,', p.categories)>0 OR p.categories='10') OR (CHARINDEX(',11,', p.categories)>0 OR p.categories='11') OR (CHARINDEX(',13,', p.categories)>0 OR p.categories='13') OR (CHARINDEX(',27,', p.categories)>0 OR p.categories='27') OR (CHARINDEX(',28,', p.categories)>0 OR p.categories='28') OR (CHARINDEX(',30,', p.categories)>0 OR p.categories='30') OR (CHARINDEX(',32,', p.categories)>0 OR p.categories='32') OR (CHARINDEX(',33,', p.categories)>0 OR p.categories='33') OR (CHARINDEX(',34,', p.categories)>0 OR p.categories='34') OR (CHARINDEX(',36,', p.categories)>0 OR p.categories='36') OR (CHARINDEX(',38,', p.categories)>0 OR p.categories='38') OR (CHARINDEX(',41,', p.categories)>0 OR p.categories='41') OR (CHARINDEX(',43,', p.categories)>0 OR p.categories='43') OR (CHARINDEX(',46,', p.categories)>0 OR p.categories='46') OR (CHARINDEX(',134,', p.categories)>0 OR p.categories='134') OR (CHARINDEX(',197,', p.categories)>0 OR p.categories='197') OR (CHARINDEX(',249,', p.categories)>0 OR p.categories='249') OR (CHARINDEX(',445,', p.categories)>0 OR p.categories='445') OR (CHARINDEX(',512,', p.categories)>0 OR p.categories='512') OR (CHARINDEX(',846,', p.categories)>0 OR p.categories='846') OR (CHARINDEX(',1071,', p.categories)>0 OR p.categories='1071') OR (CHARINDEX(',490,', p.categories)>0 OR p.categories='490') OR (CHARINDEX(',491,', p.categories)>0 OR p.categories='491') OR (CHARINDEX(',58,', p.categories)>0 OR p.categories='58') OR (CHARINDEX(',65,', p.categories)>0 OR p.categories='65') OR (CHARINDEX(',69,', p.categories)>0 OR p.categories='69') OR (CHARINDEX(',85,', p.categories)>0 OR p.categories='85') OR (CHARINDEX(',102,', p.categories)>0 OR p.categories='102') OR (CHARINDEX(',109,', p.categories)>0 OR p.categories='109') OR (CHARINDEX(',110,', p.categories)>0 OR p.categories='110') OR (CHARINDEX(',111,', p.categories)>0 OR p.categories='111') OR (CHARINDEX(',933,', p.categories)>0 OR p.categories='933') OR (CHARINDEX(',937,', p.categories)>0 OR p.categories='937') OR (CHARINDEX(',938,', p.categories)>0 OR p.categories='938') OR (CHARINDEX(',942,', p.categories)>0 OR p.categories='942') OR (CHARINDEX(',943,', p.categories)>0 OR p.categories='943') OR (CHARINDEX(',952,', p.categories)>0 OR p.categories='952') OR (CHARINDEX(',964,', p.categories)>0 OR p.categories='964') OR (CHARINDEX(',1065,', p.categories)>0 OR p.categories='1065') OR (CHARINDEX(',74,', p.categories)>0 OR p.categories='74') OR (CHARINDEX(',75,', p.categories)>0 OR p.categories='75') OR (CHARINDEX(',77,', p.categories)>0 OR p.categories='77') OR (CHARINDEX(',78,', p.categories)>0 OR p.categories='78') OR (CHARINDEX(',79,', p.categories)>0 OR p.categories='79') OR (CHARINDEX(',81,', p.categories)>0 OR p.categories='81') OR (CHARINDEX(',493,', p.categories)>0 OR p.categories='493') OR (CHARINDEX(',909,', p.categories)>0 OR p.categories='909') OR (CHARINDEX(',946,', p.categories)>0 OR p.categories='946') OR (CHARINDEX(',948,', p.categories)>0 OR p.categories='948') OR (CHARINDEX(',949,', p.categories)>0 OR p.categories='949') OR (CHARINDEX(',50,', p.categories)>0 OR p.categories='50') OR (CHARINDEX(',52,', p.categories)>0 OR p.categories='52') OR (CHARINDEX(',89,', p.categories)>0 OR p.categories='89') OR (CHARINDEX(',90,', p.categories)>0 OR p.categories='90') OR (CHARINDEX(',91,', p.categories)>0 OR p.categories='91') OR (CHARINDEX(',93,', p.categories)>0 OR p.categories='93') OR (CHARINDEX(',94,', p.categories)>0 OR p.categories='94') OR (CHARINDEX(',998,', p.categories)>0 OR p.categories='998') OR (CHARINDEX(',53,', p.categories)>0 OR p.categories='53') OR (CHARINDEX(',95,', p.categories)>0 OR p.categories='95') OR (CHARINDEX(',96,', p.categories)>0 OR p.categories='96') OR (CHARINDEX(',497,', p.categories)>0 OR p.categories='497') OR (CHARINDEX(',968,', p.categories)>0 OR p.categories='968') OR (CHARINDEX(',126,', p.categories)>0 OR p.categories='126') OR (CHARINDEX(',140,', p.categories)>0 OR p.categories='140') OR (CHARINDEX(',1068,', p.categories)>0 OR p.categories='1068') OR (CHARINDEX(',63,', p.categories)>0 OR p.categories='63') OR (CHARINDEX(',64,', p.categories)>0 OR p.categories='64') OR (CHARINDEX(',120,', p.categories)>0 OR p.categories='120') OR (CHARINDEX(',935,', p.categories)>0 OR p.categories='935') OR (CHARINDEX(',939,', p.categories)>0 OR p.categories='939') OR (CHARINDEX(',70,', p.categories)>0 OR p.categories='70') OR (CHARINDEX(',71,', p.categories)>0 OR p.categories='71') OR (CHARINDEX(',72,', p.categories)>0 OR p.categories='72') OR (CHARINDEX(',73,', p.categories)>0 OR p.categories='73') OR (CHARINDEX(',945,', p.categories)>0 OR p.categories='945') OR (CHARINDEX(',1069,', p.categories)>0 OR p.categories='1069') OR (CHARINDEX(',1070,', p.categories)>0 OR p.categories='1070') OR (CHARINDEX(',86,', p.categories)>0 OR p.categories='86') OR (CHARINDEX(',101,', p.categories)>0 OR p.categories='101') OR (CHARINDEX(',104,', p.categories)>0 OR p.categories='104') OR (CHARINDEX(',105,', p.categories)>0 OR p.categories='105') OR (CHARINDEX(',944,', p.categories)>0 OR p.categories='944') OR (CHARINDEX(',146,', p.categories)>0 OR p.categories='146') OR (CHARINDEX(',951,', p.categories)>0 OR p.categories='951') OR (CHARINDEX(',953,', p.categories)>0 OR p.categories='953')) | Timer 0: 1 ms | Timer 1: 654 ms | Timer 2: 70 ms | pagerTotal=917 | filtering=False | Timer 3: 531 ms | catID=1 | kz.count=25 | title DESC | title | Timer 4: 221 ms | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex, p.id FROM [products] AS p WHERE p.id IN(2079,2156,2163,2172,2174,2175,2184,2233,2234,2238,2248,2360,2434,2453,2454,2455,2490,2563,2578,2590,2611,2614,2686,2687,2760,2859,2863,2864,2888,2891,2970,2978,3022,3105,3106,3120,3272,3330,3331,3346,3376,3378,3387,3388,3661,3663,3780,3816,3841,3915,3917,3923,3925,3950,3996,3997,3999,4000,4016,4018,4020,4078,4216,4238,4257,4260,4261,4268,4271,4273,4322,4365,4685,4787,4799,4816,4886,5008,5049,5054,5197,5226,5241,5256,5257,5262,5290,5293,5295,5311,5312,5323,5325,5334,5337,5519,5542,5584,5631,5632,5633,5702,5703,5770,5771,5788,5789,5832,5840,5899,6011,6027,6102,6159,6162,6199,6211,6212,6256,6258,6315,6319,6362,6366,6379,6457,6507,6538,6582,6585,6597,6634,6703,6704,6710,6770,6785,6820,6826,6837,6838,6839,6883,6888,6905,6927,6928,6944,6946,6947,6950,6951,6963,6989,6995,7154,7178,7194,7269,7366,7367,7415,7517,7594,7596,7653,7707,7722,7762,7769,7867,7875,7876,7880,7893,7907,8025,8027,8075,8116,8117,8118,8155,8172,8173,8174,8175,8184,8191,8213,8234,8239,8240,8241,8285,8286,8297,8394,8412,8413,8465,8474,8478,8479,8513,8571,8603,8623,8629,8630,8633,8634,8635,8654,8661,8663,8664,8668,8669,8706,8714,8893,8894,8895,8897,8982,8989,8991,9046,9067,9075,9077,10148,10150,10163,10174,11245,11274,11307,11308,11493,11494,11495,11496,11523,11525,11542,11583,11619,11650,11666,11670,11752,11757,11785,11789,11790,11816,11829,11848,11850,11852,11861,11862,11863,11881,11882,12025,12074,12106,12107,12124,12171,12201,12224,12228,12229,12234,12256,12257,12258,12262,12264,12279,12280,12304,12306,12307,12308,12309,12310,12311,12312,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12345,12347,12348,12349,12350,12351,12352,12353,12354,12355,12356,12357,12358,12360,12361,12362,12363,12364,12365,12366,12367,12368,12369,12370,12371,12372,12373,12374,12375,12376,12377,12378,12380,12381,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12440,12441,12442,12443,12444,12445,12446,12447,12448,12449,12451,12452,12453,12454,12455,12456,12457,12458,12459,12460,12461,12462,12463,12464,12465,12466,12467,12468,12469,12470,12471,12472,12473,12474,12475,12476,12477,12478,12479,12480,12481,12482,12483,12485,12486,12487,12488,12489,12490,12491,12492,12493,12494,12495,12496,12497,12498,12499,12500,12501,12502,12503,12504,12505,12507,12508,12511,12512,12515,12516,12517,12518,12519,12520,12521,12522,12524,12526,12527,12528,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12542,12543,12545,12549,12550,12563,12564,12566,12567,12568,12569,12618,12619,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,12663,12664,12665,12666,12667,12668,12669,12671,12672,12673,12680,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,12710,12711,12712,12713,12714,12715,12716,12717,12718,12719,12720,12721,12722,12723,12724,12725,12726,12728,12729,12730,12731,12732,12733,12735,12736,12737,12804,12806,12807,12808,12810,12814,12815,12816,12818,12819,12820,12822,12826,12828,13828,13829,13832,13833,13834,13835,13836,13837,13838,13839,13840,13841,13842,13846,13847,13848,13850,13851,13852,13853,13855,13856,13857,13858,13859,13860,13861,13862,13878,13879,13882,13884,13885,13886,13887,13888,13889,13890,13894,14890,14891,14892,14893,14894,14895,14897,14899,14900,14901,14902,14945,14954,14963,14982,14983,14984,14985,14986,14987,14988,14989,14998,14999,15003,15029,15045,15055,15056,15058,15072,15074,15076,15078,15087,15088,15089,15098,15103,15108,15109,15110,15111,15113,15114,15115,15116,15117,15118,15119,15121,15122,15123,15124,15125,15126,16127,16128,16129,16130,16131,16132,16133,16134,16135,16136,16153,16157,16166,16172,16173,16174,16175,16176,16182,16185,16193,16194,16195,16196,16199,16200,16201,16202,16204,16207,16212,16213,16214,16215,16229,16231,16252,16260,16281,16282,16287,16288,16289,16327,16334,16335,16336,16375,16381,16382,16387,16388,16392,16393,16394,16398,16399,16401,16402,16404,16406,16407,16410,16414,16419,16420,16421,16422,16423,16427,16430,16431,16437,16438,16441,16445,16446,16450,16451,16452,16453,16454,16455,16456,16459,16460,16461,16462,16463,16464,16472,16480,16481,16485,16490,16491,16492,16493,16494,16495,16496,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16522,16523,16527,16528,16531,16534,16537,16546,16547,16548,16549,16550,16551,16552,16553,16588,16629,16636,16637,16638,16651,16652,16654,16657,16659,16660,16662,16663,16664,16665,16675,16676,16677,16685,16687,16688,16689,16690,16691,16694,16698,16699,16701,16702,16703,16704,16707,16710,16711,16712,16713,16715,16719,16720,16724,16725,16726,16727,16730,16742,16743,16753,16754,16756,16757,16758,16759,16761,16762,16763,16764,16765,16766,16774,16786,16801,16804,16805,16806,16813,16814,16815,16816,16817,16818,16819,16830,16831)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;
,5,6,7,9,10,11,13,27,28,30,32,33,34,36,38,41,43,46,134,197,249,445,512,846,1071,490,491,58,65,69,85,102,109,110,111,933,937,938,942,943,952,964,1065,74,75,77,78,79,81,493,909,946,948,949,50,52,89,90,91,93,94,998,53,95,96,497,968,126,140,1068,63,64,120,935,939,70,71,72,73,945,1069,1070,86,101,104,105,944,146,951,953