****************
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 (433) 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€
78.43%  

Original Blanco

45,90€9,90€
65.72%  

V-Pro Azul

49,30€16,90€
63.18%  

Original Rojo

45,90€16,90€
66.6%  

Revival Blanco

50,60€16,90€
66.06%  

Aniversary Blanco

43,90€14,90€
66.06%  

Aniversary Celeste

43,90€14,90€
66.06%  

Aniversary Azul

43,90€14,90€
66.6%  

Revival Marron

50,60€16,90€
66.6%  

Revival Azul

50,60€16,90€
63.18%  

Original Blanco

45,90€16,90€
65.72%  

V-Pro Celeste

49,30€16,90€
78.5%  

Fusion Azul

46,04€9,90€
78.5%  

Fusion Rojo

46,04€9,90€
78.43%  

Tech Aguamarina

45,90€9,90€
78.43%  

Tech Rojo

45,90€9,90€
78.43%  

Original Gris

45,90€9,90€
72.77%  

Original Azul

45,90€12,50€
80.26%  

Performance Gris/Amarillo

50,14€9,90€
80.26%  

Performance Blanco/Azul

50,14€9,90€
80.26%  

Performance Blanco/Naranja

50,14€9,90€
80.26%  

Original Line Gris

50,14€9,90€
80.26%  

Original Line Azul

50,14€9,90€
80.26%  

Original Line Blanco

50,14€9,90€
60.31%  

70s Sport Line Blanco

50,14€19,90€
60.31%  

70s Sport Line Gris

50,14€19,90€
60.31%  

70s Sport Line Gris claro

50,14€19,90€
79.42%  

80s Cheto Gris

48,10€9,90€
80.26%  

80s Cheto Blanco

48,10€9,50€
79.84%  

Multifunctional Negro

49,11€9,90€
79.84%  

Multifunctional Azul

49,11€9,90€