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


Sitio oficial de Varlion
Inicio > Textil > Mujer > Faldas
72,26%

Tech Blanco

42,90€11,90€
74,07%

Original Gris Claro

45,90€11,90€
78,71%

Elegance Granate

55,90€11,90€
73,26%

Dynamic Naranja

44,50€11,90€
72,89%

Original Azul

43,90€11,90€
73,50%

Premium Azul

44,90€11,90€
68,60%

Aniversary Rojo

37,90€11,90€
72,89%

Aniversary Tablas Blanco

43,90€11,90€
72,89%

Aniversary Tablas Azul Marino

43,90€11,90€
73,26%

Dynamic Rosa

44,50€11,90€
73,26%

Dynamic Turquesa

44,50€11,90€
73,50%

Premium Verde

44,90€11,90€
68,60%

Aniversary Azul Marino

37,90€11,90€
68,60%

Aniversary Celeste

37,90€11,90€
72,89%

Original Rosa

43,90€11,90€
72,89%

Original Gris

43,90€11,90€
72,26%

Tech Magenta

42,90€11,90€
72,26%

Tech Negro

42,90€11,90€
74,07%

Original Blanco

45,90€11,90€
74,07%

Original Gris

45,90€11,90€
78,71%

Elegance Azul

55,90€11,90€
78,71%

Elegance Gris

55,90€11,90€
73,26%

Active Coral

44,50€11,90€
73,26%

Active Azul

44,50€11,90€
73,26%

Active Morado

44,50€11,90€
68,60%

Deluxe Rosa

37,90€11,90€
68,60%

Deluxe Gris

37,90€11,90€
72,31%

Impulse Azul

42,97€11,90€
72,31%

Impulse Negro

42,97€11,90€
72,31%

Impulse Rosa

42,97€11,90€
68,55%

Multifunctional Morado

37,84€11,90€