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


Sitio oficial de Varlion
Inicio > OUTLET > Sportswear > Camisas
73,75%

Fangio Rojo

113,90€29,90€
76,44%

Reuteman G.P. Brasil

126,89€29,90€
75,67%

Reutemann G.P. MONACO

122,90€29,90€
73,52%

Le Mans

112,91€29,90€
74,44%

Le Mans II

116,98€29,90€
74,20%

Basic Rojo

115,91€29,90€
76,85%

Le Mans

107,57€24,90€
78,41%

Championship

92,19€19,90€
74,41%

Escorihuela

97,31€24,90€
73,75%

Fangio Beige

113,90€29,90€
73,75%

Fangio Marino

113,90€29,90€
74,20%

Basic Blanco

115,91€29,90€