-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%
Σιλικονούχα ψαράκια STORM Ultra Shad 30grΗ σιλικόνη Storm Ultra Shad είναι κατασκευασμένη από πολύ
ανθεκτική σιλικόνη πο...
10,60 €9,54 €
-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 €
SELECT DISTINCT p.id,[markaID],[retail_store_price],[Categories] FROM [products] AS p CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('1' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('5' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('6' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('7' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('9' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('10' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('11' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('13' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('27' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('28' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('30' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('32' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('33' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('34' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('36' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('38' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('41' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('43' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('46' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('134' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('197' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('249' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('445' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('512' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('846' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('907' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('490' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('491' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('58' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('65' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('69' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('85' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('102' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('109' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('110' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('111' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('933' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('937' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('938' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('942' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('943' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('952' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('964' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('74' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('75' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('77' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('78' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('79' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('81' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('493' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('909' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('946' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('948' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('949' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('50' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('52' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('89' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('90' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('91' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('93' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('94' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('998' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('53' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('95' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('96' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('497' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('968' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('126' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('140' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('63' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('64' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('120' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('935' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('939' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('70' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('71' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('72' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('73' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('945' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('86' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('101' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('104' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('105' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('944' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('146' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('951' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('953' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) ) | pagerTotal=874 | 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 CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('1' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('5' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('6' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('7' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('9' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('10' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('11' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('13' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('27' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('28' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('30' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('32' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('33' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('34' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('36' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('38' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('41' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('43' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('46' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('134' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('197' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('249' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('445' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('512' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('846' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('907' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('490' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('491' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('58' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('65' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('69' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('85' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('102' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('109' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('110' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('111' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('933' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('937' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('938' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('942' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('943' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('952' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('964' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('74' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('75' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('77' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('78' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('79' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('81' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('493' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('909' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('946' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('948' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('949' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('50' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('52' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('89' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('90' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('91' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('93' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('94' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('998' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('53' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('95' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('96' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('497' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('968' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('126' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('140' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('63' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('64' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('120' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('935' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('939' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('70' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('71' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('72' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('73' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('945' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('86' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('101' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('104' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('105' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('944' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('146' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('951' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('953' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) )) 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,126,140,63,64,120,935,939,70,71,72,73,945,86,101,104,105,944,146,951,953