****************
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 (310) AND P.portada = I.idimg ORDER BY C.orden ASC LIMIT 500 OFFSET 0
****************


Sitio oficial de Varlion
Inicio > OUTLET > Sportswear > Polos M/Larga
42,35%

Polo

103,90€59,90€
45,55%

Ruca Malen Verde

110,00€59,90€
46,23%

Chivas Granate

92,90€49,95€
45,70%

Chapa Uno Marrón

91,90€49,90€
32,72%

Reutemann

103,90€69,91€
50,86%

Basic Marron

121,90€59,90€
70,47%

Championship Rosa

101,41€29,95€
70,47%

Brand Azul

101,41€29,95€
62,09%

Flags

92,19€34,95€
70,47%

Brand Verde

101,41€29,95€
70,47%

Brand Marron

101,41€29,95€
70,47%

Brand Rojo

101,41€29,95€
70,47%

Championship Verde

101,41€29,95€
62,09%

Flags Marron

92,19€34,95€
46,23%

Chivas Blanco

92,90€49,95€