****************
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 (303, 414, 428, 429, 430, 431, 432, 433, 434, 448, 415, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444) AND P.portada = I.idimg ORDER BY C.orden ASC LIMIT 500 OFFSET 0
****************


Sitio oficial de Varlion
Avant Velvet y LW Aqua a 69,90€
Calzado de mujer a 29,90€
Paleteros mujer a 29,90€
Polos y camisetas mujer 19,90
Polos Original de mujer a 5€
67.46%  

Padel Gris

91,90€29,90€
61.03%  

Aniversary Blanco

63,90€24,90€
61.03%  

Aniversary Azul Marino

63,90€24,90€
67.46%  

Padel Azul

91,90€29,90€
67.46%  

Padel Blanco

91,90€29,90€
56.64%  

Performance Celeste

45,90€19,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€
55.68%  

Premium Verde

44,90€19,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€
55.68%  

Premium Azul

44,90€19,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€
56.64%  

Performance Verde

45,90€19,90€
56.64%  

Performance Granate

45,90€19,90€
51.34%  

Tech Turquesa

40,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€
53.17%  

Premium Blanco

42,50€19,90€
51.34%  

Aniversary Blanco

40,90€19,90€
53.17%  

Premium Verde

42,50€19,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€
52.51%  

Original Gris

41,90€19,90€
51.34%  

Tech Magenta

40,90€19,90€
51.34%  

Tech Negro

40,90€19,90€
77.45%  

Original Gris Claro

43,90€9,90€
77.45%  

Original Gris

43,90€9,90€
52.55%  

Active Azul

41,94€19,90€
55.79%  

Impulse Azul

45,01€19,90€
55.79%  

Impulse Negro

45,01€19,90€
55.79%  

Impulse Rosa

45,01€19,90€
42.76%  

Deluxe Morado

34,76€19,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€
62.78%  

Dynamic Negro

66,90€24,90€
62.78%  

Dynamic Turquesa

66,90€24,90€
53.61%  

Tech Blanco

42,90€19,90€
56.64%  

Original Gris Claro

45,90€19,90€
55.46%  

Elegance Granate

55,90€24,90€
55.28%  

Dynamic Naranja

44,50€19,90€
54.67%  

Original Azul

43,90€19,90€
55.68%  

Premium Azul

44,90€19,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.28%  

Dynamic Rosa

44,50€19,90€
55.28%  

Dynamic Turquesa

44,50€19,90€
55.68%  

Premium Verde

44,90€19,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€
53.61%  

Tech Magenta

42,90€19,90€
53.61%  

Tech Negro

42,90€19,90€
56.64%  

Original Blanco

45,90€19,90€
56.64%  

Original Gris

45,90€19,90€
55.46%  

Elegance Azul

55,90€24,90€
55.46%  

Elegance Gris

55,90€24,90€
55.28%  

Active Coral

44,50€19,90€
55.28%  

Active Azul

44,50€19,90€
55.28%  

Active Morado

44,50€19,90€
47.49%  

Deluxe Rosa

37,90€19,90€
47.49%  

Deluxe Gris

37,90€19,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€
47.41%  

Multifunctional Morado

37,84€19,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%  

Elegance Gris

55,90€24,90€
55.46%  

Elegance Azul

55,90€24,90€
55.46%  

Elegance 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 Blanco

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€