[select concat('x') as x ,get_precio( '0x0;', '1','1', '0.24', '0', '0', '0', '5' ) as d_1,get_precio(';5x5;;', '0','1', '0', '0', '1', '0', '5' ) as p_1 ,get_precio( '0x0;', '1','2', '0.24', '0', '0', '0', '5' ) as d_2,get_precio(';5x5;;', '0','2', '0', '0', '1', '0', '5' ) as p_2 ,get_precio( '0x0;', '1','3', '0.24', '0', '0', '0', '5' ) as d_3,get_precio(';5x5;;', '0','3', '0', '0', '1', '0', '5' ) as p_3 ,get_precio( '0x0;', '1','5', '0.24', '0', '0', '0', '5' ) as d_5,get_precio(';5x5;;', '0','5', '0', '0', '1', '0', '5' ) as p_5 ,get_precio( '0x0;', '1','6', '0.24', '0', '0', '0', '5' ) as d_6,get_precio(';5x5;;', '0','6', '0', '0', '1', '0', '5' ) as p_6 ,get_precio( '0x0;', '1','8', '0.24', '0', '0', '0', '5' ) as d_8,get_precio(';5x5;;', '0','8', '0', '0', '1', '0', '5' ) as p_8 ,get_precio( '0x0;', '1','10', '0.24', '0', '0', '0', '5' ) as d_10,get_precio(';5x5;;', '0','10', '0', '0', '1', '0', '5' ) as p_10 ,get_precio( '0x0;', '1','12', '0.24', '0', '0', '0', '5' ) as d_12,get_precio(';5x5;;', '0','12', '0', '0', '1', '0', '5' ) as p_12 ,get_precio( '0x0;', '1','15', '0.24', '0', '0', '0', '5' ) as d_15,get_precio(';5x5;;', '0','15', '0', '0', '1', '0', '5' ) as p_15 ,get_precio( '0x0;', '1','25', '0.24', '0', '0', '0', '5' ) as d_25,get_precio(';5x5;;', '0','25', '0', '0', '1', '0', '5' ) as p_25 ,get_precio( '0x0;', '1','50', '0.24', '0', '0', '0', '5' ) as d_50,get_precio(';5x5;;', '0','50', '0', '0', '1', '0', '5' ) as p_50 ,get_precio( '0x0;', '1','75', '0.24', '0', '0', '0', '5' ) as d_75,get_precio(';5x5;;', '0','75', '0', '0', '1', '0', '5' ) as p_75 ,get_precio( '0x0;', '1','100', '0.24', '0', '0', '0', '5' ) as d_100,get_precio(';5x5;;', '0','100', '0', '0', '1', '0', '5' ) as p_100 ,get_precio( '0x0;', '1','150', '0.24', '0', '0', '0', '5' ) as d_150,get_precio(';5x5;;', '0','150', '0', '0', '1', '0', '5' ) as p_150 ,get_precio( '0x0;', '1','200', '0.24', '0', '0', '0', '5' ) as d_200,get_precio(';5x5;;', '0','200', '0', '0', '1', '0', '5' ) as p_200 ,get_precio( '0x0;', '1','300', '0.24', '0', '0', '0', '5' ) as d_300,get_precio(';5x5;;', '0','300', '0', '0', '1', '0', '5' ) as p_300 ,get_precio( '0x0;', '1','400', '0.24', '0', '0', '0', '5' ) as d_400,get_precio(';5x5;;', '0','400', '0', '0', '1', '0', '5' ) as p_400 ,get_precio( '0x0;', '1','500', '0.24', '0', '0', '0', '5' ) as d_500,get_precio(';5x5;;', '0','500', '0', '0', '1', '0', '5' ) as p_500 ,get_precio( '0x0;', '1','1000', '0.24', '0', '0', '0', '5' ) as d_1000,get_precio(';5x5;;', '0','1000', '0', '0', '1', '0', '5' ) as p_1000 ,get_precio( '0x0;', '1','1500', '0.24', '0', '0', '0', '5' ) as d_1500,get_precio(';5x5;;', '0','1500', '0', '0', '1', '0', '5' ) as p_1500 ,get_precio( '0x0;', '1','2000', '0.24', '0', '0', '0', '5' ) as d_2000,get_precio(';5x5;;', '0','2000', '0', '0', '1', '0', '5' ) as p_2000 ,get_precio( '0x0;', '1','2500', '0.24', '0', '0', '0', '5' ) as d_2500,get_precio(';5x5;;', '0','2500', '0', '0', '1', '0', '5' ) as p_2500 ,get_precio( '0x0;', '1','3000', '0.24', '0', '0', '0', '5' ) as d_3000,get_precio(';5x5;;', '0','3000', '0', '0', '1', '0', '5' ) as p_3000 ,get_precio( '0x0;', '1','5000', '0.24', '0', '0', '0', '5' ) as d_5000,get_precio(';5x5;;', '0','5000', '0', '0', '1', '0', '5' ) as p_5000 ,get_precio( '0x0;', '1','10000', '0.24', '0', '0', '0', '5' ) as d_10000,get_precio(';5x5;;', '0','10000', '0', '0', '1', '0', '5' ) as p_10000
[execute command denied to user 'setlogo'@'localhost' for routine 'setlogo.get_precio']
[select concat('x') as x ,get_precio( '0x0;', '1','1', '0.24', '0', '0', '0', '5' ) as d_1,get_precio(';5x5;;', '0','1', '0', '0', '1', '0', '5' ) as p_1 ,get_precio( '0x0;', '1','2', '0.24', '0', '0', '0', '5' ) as d_2,get_precio(';5x5;;', '0','2', '0', '0', '1', '0', '5' ) as p_2 ,get_precio( '0x0;', '1','3', '0.24', '0', '0', '0', '5' ) as d_3,get_precio(';5x5;;', '0','3', '0', '0', '1', '0', '5' ) as p_3 ,get_precio( '0x0;', '1','5', '0.24', '0', '0', '0', '5' ) as d_5,get_precio(';5x5;;', '0','5', '0', '0', '1', '0', '5' ) as p_5 ,get_precio( '0x0;', '1','6', '0.24', '0', '0', '0', '5' ) as d_6,get_precio(';5x5;;', '0','6', '0', '0', '1', '0', '5' ) as p_6 ,get_precio( '0x0;', '1','8', '0.24', '0', '0', '0', '5' ) as d_8,get_precio(';5x5;;', '0','8', '0', '0', '1', '0', '5' ) as p_8 ,get_precio( '0x0;', '1','10', '0.24', '0', '0', '0', '5' ) as d_10,get_precio(';5x5;;', '0','10', '0', '0', '1', '0', '5' ) as p_10 ,get_precio( '0x0;', '1','12', '0.24', '0', '0', '0', '5' ) as d_12,get_precio(';5x5;;', '0','12', '0', '0', '1', '0', '5' ) as p_12 ,get_precio( '0x0;', '1','15', '0.24', '0', '0', '0', '5' ) as d_15,get_precio(';5x5;;', '0','15', '0', '0', '1', '0', '5' ) as p_15 ,get_precio( '0x0;', '1','25', '0.24', '0', '0', '0', '5' ) as d_25,get_precio(';5x5;;', '0','25', '0', '0', '1', '0', '5' ) as p_25 ,get_precio( '0x0;', '1','50', '0.24', '0', '0', '0', '5' ) as d_50,get_precio(';5x5;;', '0','50', '0', '0', '1', '0', '5' ) as p_50 ,get_precio( '0x0;', '1','75', '0.24', '0', '0', '0', '5' ) as d_75,get_precio(';5x5;;', '0','75', '0', '0', '1', '0', '5' ) as p_75 ,get_precio( '0x0;', '1','100', '0.24', '0', '0', '0', '5' ) as d_100,get_precio(';5x5;;', '0','100', '0', '0', '1', '0', '5' ) as p_100 ,get_precio( '0x0;', '1','150', '0.24', '0', '0', '0', '5' ) as d_150,get_precio(';5x5;;', '0','150', '0', '0', '1', '0', '5' ) as p_150 ,get_precio( '0x0;', '1','200', '0.24', '0', '0', '0', '5' ) as d_200,get_precio(';5x5;;', '0','200', '0', '0', '1', '0', '5' ) as p_200 ,get_precio( '0x0;', '1','300', '0.24', '0', '0', '0', '5' ) as d_300,get_precio(';5x5;;', '0','300', '0', '0', '1', '0', '5' ) as p_300 ,get_precio( '0x0;', '1','400', '0.24', '0', '0', '0', '5' ) as d_400,get_precio(';5x5;;', '0','400', '0', '0', '1', '0', '5' ) as p_400 ,get_precio( '0x0;', '1','500', '0.24', '0', '0', '0', '5' ) as d_500,get_precio(';5x5;;', '0','500', '0', '0', '1', '0', '5' ) as p_500 ,get_precio( '0x0;', '1','1000', '0.24', '0', '0', '0', '5' ) as d_1000,get_precio(';5x5;;', '0','1000', '0', '0', '1', '0', '5' ) as p_1000 ,get_precio( '0x0;', '1','1500', '0.24', '0', '0', '0', '5' ) as d_1500,get_precio(';5x5;;', '0','1500', '0', '0', '1', '0', '5' ) as p_1500 ,get_precio( '0x0;', '1','2000', '0.24', '0', '0', '0', '5' ) as d_2000,get_precio(';5x5;;', '0','2000', '0', '0', '1', '0', '5' ) as p_2000 ,get_precio( '0x0;', '1','2500', '0.24', '0', '0', '0', '5' ) as d_2500,get_precio(';5x5;;', '0','2500', '0', '0', '1', '0', '5' ) as p_2500 ,get_precio( '0x0;', '1','3000', '0.24', '0', '0', '0', '5' ) as d_3000,get_precio(';5x5;;', '0','3000', '0', '0', '1', '0', '5' ) as p_3000 ,get_precio( '0x0;', '1','5000', '0.24', '0', '0', '0', '5' ) as d_5000,get_precio(';5x5;;', '0','5000', '0', '0', '1', '0', '5' ) as p_5000 ,get_precio( '0x0;', '1','10000', '0.24', '0', '0', '0', '5' ) as d_10000,get_precio(';5x5;;', '0','10000', '0', '0', '1', '0', '5' ) as p_10000
[execute command denied to user 'setlogo'@'localhost' for routine 'setlogo.get_precio']
Quantity
Unit price
Customized from
Prices from 100000 € to 0 € upon quantities (VAT excl.)
2º Add customization
Size & technique
Choose Color
€ (From / Quantity)
200x150: Screen printing
Tramitación ADUANALos envíos a Canarias, Ceuta y Melilla tendrán el coste de la tramitación de DUA.
Más información...
18 €
SPORT NECKTUBE
Multiposition pant.
To protect neck and head.
Made of elastic polyester with soft and light touch.
Comfort and mobility in an accessory that It can accompany you in any activity: sports, work, free time ...
It can be used at least in 6 different positions.
Available in a wide variety of bright colors, in white color (perfect for sublimation) and, as a novelty, with Camouflage print.
Extended info (Ref: 6913/5)
Embalaje
Unidades en paquete: 20
Dimensiones: 58,0 x 29,0 x 28,0
Peso: 13
Empaquetado caja master
Cajas por pallet: 400
Material:
100% Polyester
Stock por color
Color
Talla
Actual
Próximamente
BL
5.000
LI
5.000
0000-00-00 : 270.625
MA
5.000
NA
4.890
0000-00-00 : 270.625
NE
5.000
0000-00-00 : 270.625
PS
5.000
0000-00-00 : 270.625
RO
5.000
0000-00-00 : 270.625
RY
5.000
0000-00-00 : 270.625