0
0 item(s) en su carrito
 IMPORTANTE: Sin atención al público en la tienda por el momento. Los pedidos del Nakasale, podrán retirarse o serán despachados desde el jueves 30 en adelante.

Cuerdas de escalada

 

La Sportiva Laspo Rope Bag 20%
OFF!
La Sportiva

La Sportiva Laspo Rope Bag

$5.951.-
$7.439  20% OFF
Altus Bolso portacuerda BC70 15%
OFF!
Altus

Altus Bolso portacuerda BC70

$3.341.-
$3.931  15% OFF
La Sportiva Alpine Backpack Nuevo 15%
OFF!
La Sportiva

La Sportiva Alpine Backpack

$12.638.-
$14.868  15% OFF
Edelrid Performance Static 10.5mm x 100m 10%
OFF!
Edelrid

Edelrid Performance Static 10.5mm x 100m

$23.798.-
$26.442  10% OFF
Edelrid Performance Static 11mm 100m Blanca 10%
OFF!
Edelrid

Edelrid Performance Static 11mm 100m Blanca

$26.099.-
$28.999  10% OFF
Edelrid Performance Static 11mm 200m Gris 10%
OFF!
Edelrid

Edelrid Performance Static 11mm 200m Gris

$55.271.-
$61.412  10% OFF
Edelrid Performance Static 11mm 100m Negro 10%
OFF!
Edelrid

Edelrid Performance Static 11mm 100m Negro

$27.637.-
$30.708  10% OFF
Edelrid Performance Static 11mm 200m Negro Nuevo 10%
OFF!
Edelrid

Edelrid Performance Static 11mm 200m Negro

$55.271.-
$61.412  10% OFF
Edelweiss Proline 11mm 100m Blanca 5%
OFF!
Edelweiss

Edelweiss Proline 11mm 100m Blanca

$26.614.-
$28.015  5% OFF
Edelrid Boa 9.8mm 60m 5%
OFF!
Edelrid

Edelrid Boa 9.8mm 60m

$18.233.-
$19.193  5% OFF
Edelweiss Promax 10,5mm 100m UNICORE 5%
OFF!
Edelweiss

Edelweiss Promax 10,5mm 100m UNICORE

$28.016.-
$29.490  5% OFF
Edelrid Parrot 9,8mm 60m 5%
OFF!
Edelrid

Edelrid Parrot 9,8mm 60m

$18.233.-
$19.193  5% OFF
Edelweiss Proline 10,5mm 200m Negra
Edelweiss

Edelweiss Proline 10,5mm 200m Negra

$63.409.-  |  $56.040.-
Edelweiss Proline 10,5mm Negra Fracción 5 metros
Edelweiss

Edelweiss Proline 10,5mm Negra Fracción 5 metros

$1.992.-  |  $1.760.-
Edelweiss Bud 10,5mm 50m
Edelweiss

Edelweiss Bud 10,5mm 50m

$13.183.-  |  $11.651.-
Edelweiss Element 10.2mm 60m
Edelweiss

Edelweiss Element 10.2mm 60m

$21.746.-  |  $19.218.-
Edelweiss O-Flex 10.2mm 60m
Edelweiss

Edelweiss O-Flex 10.2mm 60m

$21.746.-  |  $19.218.-
Edelweiss Energy 9,5mm 60m
Edelweiss

Edelweiss Energy 9,5mm 60m

$18.521.-  |  $16.369.-
Edelweiss Flashlight 10mm 50m
Edelweiss

Edelweiss Flashlight 10mm 50m

$14.461.-  |  $12.780.-
Edelweiss Flashlight 10mm 60m
Edelweiss

Edelweiss Flashlight 10mm 60m

$17.349.-  |  $15.333.-
Edelweiss Flashlight 10mm 70m
Edelweiss

Edelweiss Flashlight 10mm 70m

$20.243.-  |  $17.891.-
Edelweiss Extrem II 9mm 60m Super Everdry Doble
Edelweiss

Edelweiss Extrem II 9mm 60m Super Everdry Doble

$25.771.-  |  $22.776.-
Edelweiss Bud 10,5mm 100m
Edelweiss

Edelweiss Bud 10,5mm 100m

$26.361.-  |  $23.298.-
Edelweiss Bud 10,5mm 200m
Edelweiss

Edelweiss Bud 10,5mm 200m

$52.715.-  |  $46.588.-
Edelweiss Proline 10,5mm 100m Negra
Edelweiss

Edelweiss Proline 10,5mm 100m Negra

$31.705.-  |  $28.020.-
Edelweiss Proline 11mm 200m Blanca
Edelweiss

Edelweiss Proline 11mm 200m Blanca

$63.399.-  |  $56.031.-
Edelweiss Proline 10,5mm 100m Kaki
Edelweiss

Edelweiss Proline 10,5mm 100m Kaki

$31.705.-  |  $28.020.-
Edelweiss Bud 10,5mm Fracción de 5 metros
Edelweiss

Edelweiss Bud 10,5mm Fracción de 5 metros

$1.719.-  |  $1.520.-
Edelrid Boa 9.8mm 70m
Edelrid

Edelrid Boa 9.8mm 70m

$24.933.-  |  $22.035.-
Edelrid Python 10mm 60m
Edelrid

Edelrid Python 10mm 60m

$21.717.-  |  $19.193.-
(default) 4 queries took 140 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `190717_naka`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'qorisc7unan0qdeltjjfdedcde' LIMIT 1000
2SELECT `Articulo`.`id`, `Articulo`.`published`, `Articulo`.`curva_id`, `Articulo`.`curva2_id`, `Articulo`.`associated_curva_id`, `Articulo`.`categoria_id`, `Articulo`.`categoria_sec_id`, `Articulo`.`marca_id`, `Articulo`.`habilitado`, `Articulo`.`destacado`, `Articulo`.`borrado`, `Articulo`.`oferta`, `Articulo`.`oferta_dist`, `Articulo`.`hot_off`, `Articulo`.`delay_off`, `Articulo`.`oferta_2u`, `Articulo`.`promo`, `Articulo`.`envio_gratis`, `Articulo`.`combo`, `Articulo`.`pack`, `Articulo`.`combo_units`, `Articulo`.`codigo`, `Articulo`.`sku`, `Articulo`.`slug`, `Articulo`.`nombre`, `Articulo`.`precio`, `Articulo`.`precio_real`, `Articulo`.`precio_dist`, `Articulo`.`precio_dist_real`, `Articulo`.`rango`, `Articulo`.`precio_min`, `Articulo`.`precio_max`, `Articulo`.`meta_title`, `Articulo`.`meta_description`, `Articulo`.`nuevo`, `Articulo`.`stock_id`, `Articulo`.`stock_id_dist`, `Articulo`.`pedido_minimo_dist`, `Articulo`.`stock`, `Articulo`.`stock_dist`, `Articulo`.`img1_list`, `Articulo`.`img2_list`, `Articulo`.`colores`, `Articulo`.`score`, `Articulo`.`valoraciones`, `Articulo`.`distribucion`, `Articulo`.`peso`, `Articulo`.`limitador_oferta`, `Articulo`.`imagen1`, `Articulo`.`thumb1`, `Articulo`.`small_thumb1`, `Articulo`.`imagen2`, `Articulo`.`thumb2`, `Articulo`.`small_thumb2`, `Articulo`.`imagen3`, `Articulo`.`thumb3`, `Articulo`.`small_thumb3`, `Articulo`.`imagen4`, `Articulo`.`thumb4`, `Articulo`.`small_thumb4`, `Articulo`.`imagen5`, `Articulo`.`thumb5`, `Articulo`.`small_thumb5`, `Articulo`.`imagen6`, `Articulo`.`thumb6`, `Articulo`.`small_thumb6`, `Articulo`.`imagen7`, `Articulo`.`thumb7`, `Articulo`.`small_thumb7`, `Articulo`.`imagen8`, `Articulo`.`thumb8`, `Articulo`.`small_thumb8`, `Articulo`.`imagen9`, `Articulo`.`thumb9`, `Articulo`.`small_thumb9`, `Articulo`.`imagen10`, `Articulo`.`thumb10`, `Articulo`.`small_thumb10`, `Articulo`.`imagen11`, `Articulo`.`thumb11`, `Articulo`.`small_thumb11`, `Articulo`.`imagen12`, `Articulo`.`thumb12`, `Articulo`.`small_thumb12`, `Articulo`.`imagen13`, `Articulo`.`thumb13`, `Articulo`.`small_thumb13`, `Articulo`.`imagen14`, `Articulo`.`thumb14`, `Articulo`.`small_thumb14`, `Articulo`.`imagen15`, `Articulo`.`thumb15`, `Articulo`.`small_thumb15`, `Articulo`.`imagen16`, `Articulo`.`thumb16`, `Articulo`.`small_thumb16`, `Articulo`.`imagen17`, `Articulo`.`thumb17`, `Articulo`.`small_thumb17`, `Articulo`.`imagen18`, `Articulo`.`thumb18`, `Articulo`.`small_thumb18`, `Articulo`.`imagen19`, `Articulo`.`thumb19`, `Articulo`.`small_thumb19`, `Articulo`.`imagen20`, `Articulo`.`thumb20`, `Articulo`.`small_thumb20` FROM `190717_naka`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_sec_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_ter_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_cuar_id` IN (20, 21, 22, 24, 25, 181))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`hot_off` DESC, `Articulo`.`oferta` DESC LIMIT 30303047
3SELECT COUNT(*) AS `count` FROM `190717_naka`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_sec_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_ter_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_cuar_id` IN (20, 21, 22, 24, 25, 181)))1145
4SELECT COUNT(DISTINCT Articulo.id) as count, COUNT(DISTINCT Articulo.categoria_id) as categ_count, `Marca`.`id`, `Marca`.`nombre`, `Marca`.`meta_title`, `Marca`.`slug`, `Marca`.`imagen` FROM `190717_naka`.`articulos` AS `Articulo` LEFT JOIN `190717_naka`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_sec_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_ter_id` IN (20, 21, 22, 24, 25, 181)) OR (`Articulo`.`categoria_cuar_id` IN (20, 21, 22, 24, 25, 181))) GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC7748