****************
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
SummerSales - Calzado
SummerSales - Skirts
SummerSales - Camisetas mujer
Beach Tennis: Regalo por compra de pala colección 2017
SummerSales - Paleteros
83.79%  

Padel Gris

91,90€14,90€
76.68%  

Aniversary Blanco

63,90€14,90€
76.68%  

Aniversary Azul Marino

63,90€14,90€
83.79%  

Padel Azul

91,90€14,90€
83.79%  

Padel Blanco

91,90€14,90€
74.07%  

Performance Celeste

45,90€11,90€
73.5%  

Tech Magenta

44,90€11,90€
89.11%  

Original Rosa

45,90€5,00€
89.11%  

Original Azul

45,90€5,00€
70.9%  

Dynamic Turquesa

40,90€11,90€
72.89%  

Original Blanco

43,90€11,90€
73.5%  

Premium Verde

44,90€11,90€
68.27%  

Aniversary Blanco

37,50€11,90€
70.9%  

Dynamic Gris

40,90€11,90€
70.9%  

Dynamic Negro

40,90€11,90€
73.5%  

Premium Azul

44,90€11,90€
68.27%  

Aniversary Celeste

37,50€11,90€
68.27%  

Aniversary Rojo

37,50€11,90€
72.89%  

Original Rosa

43,90€11,90€
72.89%  

Original Amarillo

43,90€11,90€
73.5%  

Tech Turquesa

44,90€11,90€
73.5%  

Tech Negro

44,90€11,90€
74.07%  

Performance Verde

45,90€11,90€
74.07%  

Performance Granate

45,90€11,90€
70.9%  

Tech Turquesa

40,90€11,90€
72.89%  

Performance Naranja

43,90€11,90€
73.56%  

Dynamic Naranja

45,00€11,90€
71.6%  

Original Blanco

41,90€11,90€
72%  

Premium Blanco

42,50€11,90€
70.9%  

Aniversary Blanco

40,90€11,90€
72%  

Premium Verde

42,50€11,90€
73.56%  

Dynamic Celeste

45,00€11,90€
73.56%  

Dynamic Rosa

45,00€11,90€
70.9%  

Aniversary Azul Marino

40,90€11,90€
71.6%  

Original Azul

41,90€11,90€
71.6%  

Original Gris

41,90€11,90€
70.9%  

Tech Magenta

40,90€11,90€
70.9%  

Tech Negro

40,90€11,90€
77.45%  

Original Gris Claro

43,90€9,90€
77.45%  

Original Gris

43,90€9,90€
71.63%  

Active Azul

41,94€11,90€
73.56%  

Impulse Azul

45,01€11,90€
73.56%  

Impulse Negro

45,01€11,90€
73.56%  

Impulse Rosa

45,01€11,90€
65.77%  

Deluxe Morado

34,76€11,90€
70.25%  

Dynamic Rosa

66,90€19,90€
65.63%  

Premium Azul

57,90€19,90€
65.63%  

Premium Verde

57,90€19,90€
70.25%  

Dynamic Negro

66,90€19,90€
70.25%  

Dynamic Turquesa

66,90€19,90€
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.5%  

Premium Azul

44,90€11,90€
68.6%  

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

Premium Verde

44,90€11,90€
68.6%  

Aniversary Azul Marino

37,90€11,90€
68.6%  

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

Deluxe Rosa

37,90€11,90€
68.6%  

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€
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€
75.13%  

Aniversary Blanco

59,90€14,90€
75.13%  

Aniversary Azul Marino

59,90€14,90€
76.31%  

Original Gris

62,90€14,90€
71.46%  

Multifunctional Negro

52,20€14,90€
71.46%  

Multifunctional Morado

52,20€14,90€
68.35%  

Multifunctional Amarillo

47,07€14,90€
68.35%  

Multifunctional Negro

47,07€14,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€
70.9%  

Aniversary Blanco

43,90€12,77€
60.91%  

Revival Celeste

50,90€19,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€