****************
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 (260, 282, 283, 423, 424, 425, 426, 427, 299, 301, 418, 419, 420, 302, 421, 422, 303, 414, 428, 429, 430, 431, 432, 433, 434, 448, 415, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 304, 298, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316) 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€
46.23%  

Chivas Blanco

92,90€49,95€
39.83%  

Avant Hexagon Difusor Verde

299,00€179,90€
50.02%  

Avant Hexagon Carbon Ti Azul

279,90€139,90€
39.43%  

L.W. Difusor Gold

330,00€199,90€
39.83%  

L.W. Carbon Hexagon Difusor

299,00€179,90€
39.83%  

Avant Carbon Hexagon Difusor

299,00€179,90€
57.14%  

L.W. Diamond 2

175,00€75,00€
40%  

L.W. Carbon Hexagon Difusor Yellow

330,00€198,00€
40%  

L.W. Carbon Difusor Hexagon Fucsia

330,00€198,00€
40%  

Avant Carbon Difusor Hexagon

330,00€198,00€
40%  

L.W. Carbon 5 GP Yellow

315,00€189,00€
40%  

L.W. Carbon 5 GP Red

315,00€189,00€
40%  

Avant Difusor Surf

330,00€198,00€
40%  

Avant Difusor España

330,00€198,00€
57.87%  

L.W. Carbon Ti SYL

235,00€99,00€
64.28%  

Avant Carbon TEX SYL

210,00€75,00€
54.55%  

L.W. Ti 8.8 SYL

165,00€75,00€
57.63%  

Avant Ti 8.8 SYL

165,00€69,90€
54.9%  

Cañon Ti 8.8 SYL

155,00€69,90€
54.9%  

Avant Velvet SYL

155,00€69,90€
53.4%  

L.W. Aqua

150,00€69,90€
50%  

Sponge Due

5,51€2,75€
30.4%  

Sponge Tex

5,75€4,00€

Intensive Woman

11,80€

Junior

4,90€
39.61%  

Oversize Woman blanco/naranja

69,90€42,21€
40.06%  

Hexagon Woman celeste

57,90€34,70€
30.28%  

Pansy Marron

27,18€18,95€
40%  

V-Hexagon Verde/Negro/Silver

129,90€77,94€
40%  

V-Hexagon Naranja/Negro/Silver

129,90€77,94€
40%  

V-Hexagon Amarillo/Negro/Silver

129,90€77,94€
40%  

V-Hexagon Rojo/Silver

129,90€77,94€
40%  

V-Hexagon Azul/Silver

129,90€77,94€
40%  

V-Pro Max Blanco

79,90€47,94€
40%  

V-Pro Max Naranja

79,90€47,94€
40%  

V-Pro Max Turquesa

79,90€47,94€
57.94%  

Woman Gris/Blanco

74,90€31,50€
40%  

V-Advanced Blanco/Rosa

64,90€38,94€
40%  

V-Pro Max Blanco/Celeste

74,90€44,94€
40%  

V-Pro Max Blanco/Naranja

74,90€44,94€
32.41%  

Classic Woman Negra

16,20€10,95€
32.41%  

Classic Woman Blanca

16,20€10,95€
67.46%  

Padel Gris

91,90€29,90€
68.86%  

Aniversary Blanco

63,90€19,90€
68.86%  

Aniversary Azul Marino

63,90€19,90€
67.46%  

Padel Azul

91,90€29,90€
67.46%  

Padel Blanco

91,90€29,90€
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€
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.7%  

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.9%  

Impulse Azul

45,01€14,90€
66.9%  

Impulse Negro

45,01€14,90€
66.9%  

Impulse Rosa

45,01€14,90€
57.14%  

Deluxe Morado

34,76€14,90€
62.78%  

Dynamic Rosa

66,90€24,90€
65.63%  

Premium Azul

57,90€19,90€
65.63%  

Premium Verde

57,90€19,90€
77.73%  

Dynamic Negro

66,90€14,90€
62.78%  

Dynamic Turquesa

66,90€24,90€
65.26%  

Tech Blanco

42,90€14,90€
67.54%  

Original Gris Claro

45,90€14,90€
55.46%  

Performance Granate

55,90€24,90€
55.29%  

Dynamic Naranja

44,50€19,90€
54.67%  

Original Azul

43,90€19,90€
66.82%  

Premium Azul

44,90€14,90€
47.49%  

Aniversary Rojo

37,90€19,90€
54.67%  

Aniversary Tablas Blanco

43,90€19,90€
54.67%  

Aniversary Tablas Azul Marino

43,90€19,90€
55.29%  

Dynamic Rosa

44,50€19,90€
55.29%  

Dynamic Turquesa

44,50€19,90€
66.82%  

Premium Verde

44,90€14,90€
47.49%  

Aniversary Azul Marino

37,90€19,90€
47.49%  

Aniversary Celeste

37,90€19,90€
54.67%  

Original Rosa

43,90€19,90€
54.67%  

Original Gris

43,90€19,90€
65.26%  

Tech Magenta

42,89€14,90€
65.26%  

Tech Negro

42,89€14,90€
67.54%  

Original Blanco

45,90€14,90€
67.54%  

Original Gris

45,90€14,90€
55.46%  

Performance Azul

55,90€24,90€
55.46%  

Performance Gris

55,90€24,90€
48.82%  

Active Coral

38,89€19,90€
48.82%  

Active Azul

38,89€19,90€
48.82%  

Active Morado

38,89€19,90€
59.52%  

Deluxe Rosa

36,81€14,90€
59.52%  

Deluxe Gris

36,81€14,90€
53.69%  

Impulse Azul

42,97€19,90€
53.69%  

Impulse Negro

42,97€19,90€
53.69%  

Impulse Rosa

42,97€19,90€
60.62%  

Multifunctional Morado

37,84€14,90€
63.57%  

Tech Magenta

40,90€14,90€
67.54%  

Original Azul

45,90€14,90€
63.57%  

Tech Turquesa

40,90€14,90€
63.57%  

Tech Negro

40,90€14,90€
56.64%  

Original Gris

45,90€19,90€
56.64%  

Original Gris Claro

45,90€19,90€
55.46%  

Performance Gris

55,90€24,90€
55.46%  

Performance Azul

55,90€24,90€
55.46%  

Performance Granate

55,90€24,90€
70.65%  

Deluxe Blanco

33,73€9,90€
70.65%  

Deluxe Morado

33,73€9,90€
76.31%  

Original Azul

62,90€14,90€
66.78%  

Aniversary Blanco

59,90€19,90€
66.78%  

Aniversary Azul Marino

59,90€19,90€
76.31%  

Original Gris

62,90€14,90€
52.3%  

Multifunctional Negro

52,20€24,90€
52.3%  

Multifunctional Morado

52,20€24,90€
57.72%  

Multifunctional Amarillo

47,07€19,90€
57.72%  

Multifunctional Negro

47,07€19,90€
40.36%  

Aniversary Blanco

66,90€39,90€
55.31%  

Aniversary Celeste

66,90€29,90€
52.46%  

Performance Naranja

62,90€29,90€
52.46%  

Performance Azul

62,90€29,90€
52.46%  

Performance Negro

62,90€29,90€
70.66%  

Original Blanco

101,90€29,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€
72.07%  

Aniversary Azul

71,25€19,90€
72.07%  

Aniversary Blanco

71,25€19,90€
74.12%  

Brand Gris

76,90€19,90€
72.24%  

Original Negro

71,68€19,90€
71.29%  

V-Pro Turquesa

51,90€14,90€
60.91%  

Revival Naranja

50,90€19,90€
77.45%  

Aniversary Blanco

43,90€9,90€
60.91%  

Revival Celeste

50,90€19,90€
80.55%  

Revival Azul

50,90€9,90€
71.29%  

V-Pro Blanco

51,90€14,90€
71.29%  

V-Pro Celeste

51,90€14,90€
77.45%  

Aniversary Azul

43,90€9,90€
81.97%  

Revival Blanco/Naranja

54,90€9,90€
82.19%  

V-Pro Azul

55,60€9,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€
77.33%  

Original Gris Claro

131,90€29,90€
30.75%  

Cargo Basic Marron

103,90€71,95€
31.55%  

Racing Granate

109,49€74,95€
30.75%  

Cargo Basic Granate

103,90€71,95€
30.75%  

Cargo Basic Beige

103,90€71,95€
30.75%  

Cargo Basic Azul

103,90€71,95€
31.55%  

Racing Marrón

109,49€74,95€
31.55%  

Racing Celeste

109,49€74,95€
71.63%  

Punta del Este Roja

41,94€11,90€
71.63%  

Punta del Este Amarilla

41,94€11,90€
71.63%  

Punta del Este Azul

41,94€11,90€
72.31%  

Horse Rojo

42,97€11,90€
75.77%  

Flag Blanco

49,11€11,90€
73.56%  

Basic Verde

45,01€11,90€
73.56%  

Shield Rojo

45,01€11,90€
73.56%  

Punta del Este Azul

45,01€11,90€
78.86%  

Fangio Gris

56,30€11,90€
79.24%  

Le Mans

57,32€11,90€
81.25%  

Le Mans V-Neck Naranja

63,48€11,90€
80.3%  

Fangio Buenos Aires

60,40€11,90€
79.24%  

Reutemann Long Beach

57,32€11,90€
79.99%  

Monaco Rojo

59,47€11,90€
77.64%  

Silver Negro

53,22€11,90€
72.31%  

Chapelco Azul

42,97€11,90€
71.63%  

Championship Verde

41,94€11,90€
82.74%  

PCali

57,37€9,90€
78.86%  

Flags

56,30€11,90€
73.56%  

Punta del Este Amarilla

45,01€11,90€
73.56%  

Punta del Este Rosa

45,01€11,90€
77.64%  

Silver Rojo

53,22€11,90€
77.64%  

Silver Gris

53,22€11,90€
72.31%  

Chapelco Rojo

42,97€11,90€
72.31%  

Chapelco Marron

42,97€11,90€
79.99%  

Monaco Negro

59,47€11,90€
79.99%  

Monaco Morado

59,47€11,90€
79.99%  

Monaco Gris

59,47€11,90€
71.63%  

Championship Roja

41,94€11,90€
71.63%  

Championship Azul

41,94€11,90€
71.63%  

Championship Rosa

41,94€11,90€
75.77%  

Flag Gris

49,11€11,90€
75.77%  

Flag Rosa

49,11€11,90€
73.56%  

Shield Azul

45,01€11,90€
78.86%  

Fangio Blanco

56,30€11,90€
78.86%  

Fangio Negro

56,30€11,90€
73.56%  

Basic Gris

45,01€11,90€
72.31%  

Horse Amarillo

42,97€11,90€
72.31%  

Horse Azul

42,97€11,90€
72.31%  

Horse Blanco

42,97€11,90€
81.25%  

Le Mans V-Neck Blanco

63,48€11,90€
80.3%  

Fangio Buenos Aires Beig

60,40€11,90€
76.67%  

Basic Rosa

51,00€11,90€
76.67%  

Basic Granate

51,00€11,90€
54.02%  

Basic Verde

75,90€34,90€
51.19%  

Racing Granate

71,50€34,90€
30.53%  

Reutemann Rojo

71,90€49,95€
35.94%  

Le Mans Blanco

77,90€49,90€
69.81%  

Long

72,70€21,95€
69.81%  

Le Mans

72,70€21,95€
71.42%  

Podium Rojo

76,80€21,95€
71.42%  

Podium Negro

76,80€21,95€
35.94%  

Le Mans Celeste

77,90€49,90€
30.53%  

Reutemann Marrón

71,90€49,95€
51.19%  

Racing Marrón

71,50€34,90€
51.19%  

Racing Beige

71,50€34,90€
51.19%  

Racing Blanco

71,50€34,90€
54.02%  

Basic Azul Marino

75,90€34,90€
54.02%  

Basic Blanco

75,90€34,90€
54.02%  

Basic Gris

75,90€34,90€
69.81%  

Le Mans Gris

72,70€21,95€
86.01%  

Brasil

70,75€9,90€
74.77%  

Squared Polo Amarillo

78,86€19,90€
73.56%  

Shield Blanco

45,01€11,90€
42.35%  

Polo

103,90€59,90€
45.55%  

Ruca Malen Verde

110,00€59,90€
46.23%  

Chivas Granate

92,90€49,95€
45.7%  

Chapa Uno Marrón

91,90€49,90€
32.72%  

Reutemann

103,90€69,91€
50.86%  

Basic Marron

121,90€59,90€
70.47%  

Championship Rosa

101,41€29,95€
70.47%  

Brand Azul

101,41€29,95€
62.09%  

Flags

92,19€34,95€
70.47%  

Brand Verde

101,41€29,95€
70.47%  

Brand Marron

101,41€29,95€
70.47%  

Brand Rojo

101,41€29,95€
70.47%  

Championship Verde

101,41€29,95€
62.09%  

Flags Marron

92,19€34,95€
73.75%  

Fangio Rojo

113,90€29,90€
76.44%  

Reuteman G.P. Brasil

126,89€29,90€
75.67%  

Reutemann G.P. MONACO

122,90€29,90€
73.52%  

Le Mans

112,91€29,90€
74.44%  

Le Mans II

116,98€29,90€
74.2%  

Basic Rojo

115,91€29,90€
76.85%  

Le Mans

107,57€24,90€
78.41%  

Championship

92,19€19,90€
74.41%  

Escorihuela

97,31€24,90€
73.75%  

Fangio Beige

113,90€29,90€
73.75%  

Fangio Marino

113,90€29,90€
74.2%  

Basic Blanco

115,91€29,90€
46.83%  

Racing Verde

187,91€99,91€
46.83%  

Racing Negro

187,91€99,91€
31.15%  

Reutemann Negro

137,90€94,95€
42.66%  

Le Mans Negra

121,90€69,89€
62.04%  

Punta del Este Naranja

157,81€59,90€
68.79%  

Le Mans

159,87€49,89€
67.51%  

Basic

107,57€34,95€
79.75%  

Racing Azul

122,95€24,90€
79.75%  

Racing Gris

122,95€24,90€
79.75%  

Racing Marrón

122,95€24,90€