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


Sitio oficial de Varlion
Inicio > Textil > Mujer > Polos
55,68%

Tech Magenta

44,90€19,90€
89,11%

Original Rosa

45,90€5,00€
89,11%

Original Azul

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

Dynamic Turquesa

40,90€19,90€
54,67%

Original Blanco

43,90€19,90€
66,82%

Premium Verde

44,90€14,90€
46,93%

Aniversary Blanco

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

Dynamic Gris

40,90€19,90€
51,34%

Dynamic Negro

40,90€19,90€
66,82%

Premium Azul

44,90€14,90€
46,93%

Aniversary Celeste

37,50€19,90€
46,93%

Aniversary Rojo

37,50€19,90€
54,67%

Original Rosa

43,90€19,90€
54,67%

Original Amarillo

43,90€19,90€
55,68%

Tech Turquesa

44,90€19,90€
55,68%

Tech Negro

44,90€19,90€