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


Sitio oficial de Varlion
Inicio > Textil > Mujer > Camisetas
46,44%

Tech Turquesa

40,90€21,90€
56,64%

Performance Celeste

45,90€19,90€
54,67%

Performance Naranja

43,90€19,90€
55,78%

Dynamic Naranja

45,00€19,90€
52,51%

Original Blanco

41,90€19,90€
64,94%

Premium Blanco

42,50€14,90€
51,34%

Aniversary Blanco

40,90€19,90€
76,70%

Premium Verde

42,50€9,90€
55,78%

Dynamic Celeste

45,00€19,90€
55,78%

Dynamic Rosa

45,00€19,90€
51,34%

Aniversary Azul Marino

40,90€19,90€
52,51%

Original Azul

41,90€19,90€
76,37%

Original Gris

41,90€9,90€
56,64%

Performance Verde

45,90€19,90€
56,64%

Performance Granate

45,90€19,90€
63,57%

Tech Magenta

40,90€14,90€
63,57%

Tech Negro

40,90€14,90€
77,45%

Original Gris Claro

43,90€9,90€
77,45%

Original Gris

43,90€9,90€
64,47%

Active Azul

41,94€14,90€
66,90%

Impulse Azul

45,01€14,90€
66,90%

Impulse Negro

45,01€14,90€
66,90%

Impulse Rosa

45,01€14,90€
57,14%

Deluxe Morado

34,76€14,90€