-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%
To καταπληκτικό φινίρισμα με σχεδίαση λέιζερ
του Crystal Minnow αντανακλά και το πιο αμυδρό υποβρύχιο φως κάτω απο
οποιε...
15,80 €14,22 €
-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 €
SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',1,', p.categories)>0) OR ( (CHARINDEX(',5,', p.categories)>0) OR (CHARINDEX(',6,', p.categories)>0) OR (CHARINDEX(',7,', p.categories)>0) OR (CHARINDEX(',9,', p.categories)>0) OR (CHARINDEX(',10,', p.categories)>0) OR (CHARINDEX(',11,', p.categories)>0) OR (CHARINDEX(',13,', p.categories)>0) OR (CHARINDEX(',27,', p.categories)>0) OR (CHARINDEX(',28,', p.categories)>0) OR (CHARINDEX(',30,', p.categories)>0) OR (CHARINDEX(',32,', p.categories)>0) OR (CHARINDEX(',33,', p.categories)>0) OR (CHARINDEX(',34,', p.categories)>0) OR (CHARINDEX(',36,', p.categories)>0) OR (CHARINDEX(',38,', p.categories)>0) OR (CHARINDEX(',41,', p.categories)>0) OR (CHARINDEX(',43,', p.categories)>0) OR (CHARINDEX(',46,', p.categories)>0) OR (CHARINDEX(',134,', p.categories)>0) OR (CHARINDEX(',197,', p.categories)>0) OR (CHARINDEX(',249,', p.categories)>0) OR (CHARINDEX(',445,', p.categories)>0) OR (CHARINDEX(',512,', p.categories)>0) OR (CHARINDEX(',846,', p.categories)>0) OR (CHARINDEX(',907,', p.categories)>0) OR (CHARINDEX(',490,', p.categories)>0) OR (CHARINDEX(',491,', p.categories)>0) OR (CHARINDEX(',58,', p.categories)>0) OR (CHARINDEX(',65,', p.categories)>0) OR (CHARINDEX(',69,', p.categories)>0) OR (CHARINDEX(',85,', p.categories)>0) OR (CHARINDEX(',102,', p.categories)>0) OR (CHARINDEX(',109,', p.categories)>0) OR (CHARINDEX(',110,', p.categories)>0) OR (CHARINDEX(',111,', p.categories)>0) OR (CHARINDEX(',933,', p.categories)>0) OR (CHARINDEX(',937,', p.categories)>0) OR (CHARINDEX(',938,', p.categories)>0) OR (CHARINDEX(',942,', p.categories)>0) OR (CHARINDEX(',943,', p.categories)>0) OR (CHARINDEX(',952,', p.categories)>0) OR (CHARINDEX(',964,', p.categories)>0) OR (CHARINDEX(',74,', p.categories)>0) OR (CHARINDEX(',75,', p.categories)>0) OR (CHARINDEX(',77,', p.categories)>0) OR (CHARINDEX(',78,', p.categories)>0) OR (CHARINDEX(',79,', p.categories)>0) OR (CHARINDEX(',81,', p.categories)>0) OR (CHARINDEX(',493,', p.categories)>0) OR (CHARINDEX(',909,', p.categories)>0) OR (CHARINDEX(',946,', p.categories)>0) OR (CHARINDEX(',948,', p.categories)>0) OR (CHARINDEX(',949,', p.categories)>0) OR (CHARINDEX(',50,', p.categories)>0) OR (CHARINDEX(',52,', p.categories)>0) OR (CHARINDEX(',89,', p.categories)>0) OR (CHARINDEX(',90,', p.categories)>0) OR (CHARINDEX(',91,', p.categories)>0) OR (CHARINDEX(',93,', p.categories)>0) OR (CHARINDEX(',94,', p.categories)>0) OR (CHARINDEX(',998,', p.categories)>0) OR (CHARINDEX(',53,', p.categories)>0) OR (CHARINDEX(',95,', p.categories)>0) OR (CHARINDEX(',96,', p.categories)>0) OR (CHARINDEX(',497,', p.categories)>0) OR (CHARINDEX(',968,', p.categories)>0) OR (CHARINDEX(',1064,', p.categories)>0) OR (CHARINDEX(',126,', p.categories)>0) OR (CHARINDEX(',140,', p.categories)>0) OR (CHARINDEX(',63,', p.categories)>0) OR (CHARINDEX(',64,', p.categories)>0) OR (CHARINDEX(',120,', p.categories)>0) OR (CHARINDEX(',935,', p.categories)>0) OR (CHARINDEX(',939,', p.categories)>0) OR (CHARINDEX(',70,', p.categories)>0) OR (CHARINDEX(',71,', p.categories)>0) OR (CHARINDEX(',72,', p.categories)>0) OR (CHARINDEX(',73,', p.categories)>0) OR (CHARINDEX(',945,', p.categories)>0) OR (CHARINDEX(',86,', p.categories)>0) OR (CHARINDEX(',101,', p.categories)>0) OR (CHARINDEX(',104,', p.categories)>0) OR (CHARINDEX(',105,', p.categories)>0) OR (CHARINDEX(',944,', p.categories)>0) OR (CHARINDEX(',146,', p.categories)>0) OR (CHARINDEX(',951,', p.categories)>0) OR (CHARINDEX(',953,', p.categories)>0)) | pagerTotal=882 | filtering=False | catID=1 | kz.count=25 | title DESC | title | 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,2189,2190,2201,2234,2238,2248,2360,2433,2434,2453,2454,2455,2490,2563,2578,2590,2594,2595,2596,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,4191,4216,4238,4257,4260,4261,4268,4271,4273,4322,4365,4685,4787,4799,4816,4886,4908,5008,5049,5054,5197,5226,5241,5256,5257,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,6026,6027,6102,6159,6162,6199,6211,6212,6256,6258,6315,6319,6362,6366,6457,6483,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,7059,7154,7174,7178,7194,7269,7366,7367,7403,7415,7517,7594,7596,7653,7657,7707,7722,7762,7769,7867,7875,7876,7880,7893,7907,8025,8027,8075,8116,8117,8118,8155,8172,8173,8174,8175,8184,8213,8234,8239,8240,8241,8242,8285,8286,8297,8394,8395,8396,8412,8413,8465,8474,8478,8479,8513,8571,8603,8629,8630,8633,8634,8635,8654,8661,8663,8664,8668,8669,8706,8714,8893,8894,8895,8897,8982,8989,8991,9046,9067,9075,9077,9138,10148,10150,10163,10174,11218,11245,11274,11307,11308,11493,11494,11495,11496,11523,11525,11542,11583,11619,11650,11666,11670,11752,11757,11785,11789,11790,11816,11829,11835,11848,11852,11861,11862,11863,11881,11882,12025,12074,12106,12107,12124,12171,12201,12224,12228,12229,12234,12256,12257,12258,12262,12264,12271,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,12359,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,12412,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,12439,12440,12441,12442,12443,12444,12445,12446,12447,12448,12449,12450,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,12484,12485,12486,12487,12488,12489,12490,12491,12492,12493,12494,12495,12496,12497,12498,12499,12500,12501,12502,12503,12504,12505,12506,12507,12508,12511,12512,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,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,12730,12731,12732,12733,12735,12736,12737,12804,12806,12807,12808,12810,12814,12815,12816,12818,12819,12820,12822,12823,12826,12828,13828,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,15002,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,15120,15121,15122,15123,15124,15125,15126,16127,16128,16129,16131,16132,16133,16134,16135,16136,16153,16157,16166,16172,16174,16175,16176,16182,16183,16185,16193,16194,16195,16196,16199,16200,16201,16202,16204,16207,16212,16213,16214,16215,16216,16229,16231,16252,16260,16281,16282,16287,16288,16289,16335,16336,16375,16381,16382,16387,16388,16392,16393,16394,16398,16401,16402,16404,16406,16407,16410,16414,16419,16420,16421,16422,16423,16427,16430,16431,16437,16438,16441,16445,16446,16450,16451,16452,16454,16455,16456,16459,16460,16461,16462,16463,16464,16480,16485,16491,16492,16493,16495,16496,16499,16500,16501,16502,16503,16504,16505,16506,16507,16509,16522,16523,16527,16528,16531,16534,16546,16547,16548,16549,16550,16551,16552,16553,16588,16636,16637,16638,16652,16654,16657,16659,16660,16662,16663,16664,16665,16675,16676,16677,16685,16687,16688,16689,16690,16691,16704)) 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,907,490,491,58,65,69,85,102,109,110,111,933,937,938,942,943,952,964,74,75,77,78,79,81,493,909,946,948,949,50,52,89,90,91,93,94,998,53,95,96,497,968,1064,126,140,63,64,120,935,939,70,71,72,73,945,86,101,104,105,944,146,951,953