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


Sitio oficial de Varlion
Inicio > OUTLET > Sportswear > Camisetas M/Larga
54,02%

Basic Verde

75,90€34,90€
51,19%

Racing Granate

71,50€34,90€
30,53%

Reutemann Rojo

71,90€49,95€
35,94%

Le Mans Blanco

77,90€49,90€
69,81%

Long

72,70€21,95€
69,81%

Le Mans

72,70€21,95€
71,42%

Podium Rojo

76,80€21,95€
71,42%

Podium Negro

76,80€21,95€
35,94%

Le Mans Celeste

77,90€49,90€
30,53%

Reutemann Marrón

71,90€49,95€
51,19%

Racing Marrón

71,50€34,90€
51,19%

Racing Beige

71,50€34,90€
51,19%

Racing Blanco

71,50€34,90€
54,02%

Basic Azul Marino

75,90€34,90€
54,02%

Basic Blanco

75,90€34,90€
54,02%

Basic Gris

75,90€34,90€
69,81%

Le Mans Gris

72,70€21,95€