-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
Κωδικός Μήκος
02617-3 50cm
3,80 €3,42 €
-10,00%
ΣΗΜΑΙΕΣ ΕΥΡΩΠΑΪΚΗΣ ΕΝΩΣΗΣ.Κωδικός Μήκος Σχήμα
01247 50cm Ορθογώνια
5,00 €4,50 €
-10,00%
Κωδικός Μήκος 01242-35 35cm
01242-60 60cm
2,50 €2,25 €
-10,00%
Κωδικός
Μήκος01244-100HEL 120cm 01244-200HEL 200cm 01244-30 ...
3,13 €2,82 €
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 ('174' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) | pagerTotal=5 | filtering=False | catID=174 | kz.count=0 | 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 ('174' IN (SELECT value FROM STRING_SPLIT(p.categories, ',')))) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;