****************
SELECT P.id,P.modelo,P.pvp,P.descuento_tienda,I.img_pr,( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) + ( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) ) * 0.21 ) as precio_filtro ,P.activo FROM productos AS P ,pr_site2prod as S2P ,pr_imagenes AS I ,pr_categorias as C WHERE P.id > 0 AND P.activo = 1 AND S2P.idprod = P.id AND S2P.idsite = 1 AND I.idimg = P.portada AND P.idcat = C.idcat AND P.idcat IN (283, 423, 424, 425, 426, 427) AND P.portada = I.idimg ORDER BY C.orden ASC LIMIT 500 OFFSET 0
****************


Sitio oficial de Varlion
Inicio > OUTLET > Pádel > Palas
39,83%

Avant Hexagon Difusor Verde

299,00€179,90€
50,02%

Avant Hexagon Carbon Ti Azul

279,90€139,90€
39,43%

L.W. Difusor Gold

330,00€199,90€
39,83%

L.W. Carbon Hexagon Difusor

299,00€179,90€
39,83%

Avant Carbon Hexagon Difusor

299,00€179,90€
57,14%

L.W. Diamond 2

175,00€75,00€
40,00%

L.W. Carbon Hexagon Difusor Yellow

330,00€198,00€
40,00%

L.W. Carbon Difusor Hexagon Fucsia

330,00€198,00€
40,00%

Avant Carbon Difusor Hexagon

330,00€198,00€
40,00%

L.W. Carbon 5 GP Yellow

315,00€189,00€
40,00%

L.W. Carbon 5 GP Red

315,00€189,00€
40,00%

Avant Difusor Surf

330,00€198,00€
40,00%

Avant Difusor España

330,00€198,00€
57,87%

L.W. Carbon Ti SYL

235,00€99,00€
64,28%

Avant Carbon TEX SYL

210,00€75,00€
54,55%

L.W. Ti 8.8 SYL

165,00€75,00€
57,63%

Avant Ti 8.8 SYL

165,00€69,90€
54,90%

Cañon Ti 8.8 SYL

155,00€69,90€
54,90%

Avant Velvet SYL

155,00€69,90€
53,40%

L.W. Aqua

150,00€69,90€