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


Sitio oficial de Varlion
Condiciones liquidación de outlet - contenidos
Avant Tex por 75€
Avant Velvet por 69,90€
Banner grande - Avant Hex Carbon Ti
LW Aqua por 69,90€
55.04%  

Brand

66,49€29,90€
75.77%  

Original Negro

61,50€14,90€
68.16%  

Original Azul

62,50€19,90€
68.71%  

Aniversary

63,60€19,90€
68.16%  

Original Gris

62,50€19,90€
68.16%  

Original Blanco

62,50€19,90€
51.39%  

Original Beige

61,50€29,90€
47.84%  

Multifunctional Negro

57,32€29,90€
47.84%  

Multifunctional Gris

57,32€29,90€