Chaid:select 0 AS hasdiscount, 0 AS discountqstart1, 0 AS discountqstart2, 0 AS discountqstart3, 0 AS discountqstart4, 0 AS discountqstart5, 0 AS DISCOUNT1, 0 AS DISCOUNT2, 0 AS DISCOUNT3, 0 AS DISCOUNT4, 0 AS DISCOUNT5, products.prodescription, products.discount AS discountx, products.minimumstep AS step, products.minquantity AS qquantity, products.retailprice, products.activity, products.vatid, products.realcode AS prodcode, products.pricesid, products.price, products.specialprice, CASE WHEN (SELECT COUNT(checkcode) FROM vlachostoolsgr.[index] WHERE (checkcode = products.checkcode)) > 1 THEN 1 WHEN products.minquantity > 1 THEN 2 ELSE 0 END AS counter, (SELECT TOP (1) foto1 FROM vlachostoolsgr.[index] WHERE (checkcode = products.checkcode and [index].foto1 <> '' ) ORDER BY myaa) AS foto1, products.checkcode, desc1, desc2, CASE WHEN discount > 0 THEN 1 WHEN (discount = 0) THEN 0 ELSE 0 END AS ratio FROM v_products products inner join vlachostoolsgr.[index] i on i.checkcode=products.checkcode where i.prodcode like '%tkk%' or i.keywords LIKE '%τκκ%' or i.keywords LIKE '%tkk%' or i.foto1 like '%tkk%' or products.keywords LIKE '%τκκ%' or products.keywords LIKE '%tkk%' or lower(products.prodescription) LIKE '%τκκ%' or lower(products.prodescription) LIKE '%tkk%' or lower(i.sizedesc) LIKE '%τκκ%' or lower(i.sizedesc) LIKE '%tkk%' and products.activity=1 order by menuid, products.prodid, secprodid, ordervalue, taksinomisi
B2B VLACHOSTOOLS

Ολα τα προϊόντα μας διατίθενται σε ΧΟΝΔΡΙΚΗ ΠΩΛΗΣΗ

  • Contrast
  • Font Size
  • 12
  • 14
  • 16
  • 18
  • 20

Language

Ολα τα προϊόντα μας διατίθενται σε ΧΟΝΔΡΙΚΗ ΠΩΛΗΣΗ

Το καλαθάκι σας είναι άδειο!

Ολα τα προϊόντα μας διατίθενται σε ΧΟΝΔΡΙΚΗ ΠΩΛΗΣΗ

Επιστροφή




Λυπούμαστε, αλλά αυτό που ψάχνετε ή έχει μεταφερθεί σε άλλη κατηγορία ή απλά δεν είναι διαθέσιμο αυτή τη στιγμή!