1538914819    011 4589-7910    Lu a Vie 9:30 a 19:30 - Sab 9:30 a 17hs - ¡Más de 550 productos con envío GRATIS a todo el país!
 
 ¡Todos nuestros pedidos se están despachando con normalidad!

Equipamiento Outdoor - Camping - Montañismo

Porta Objetos Estanco Bewolk Moto
EN STOCK
Bolso Estanco Urbano Bewolk 18 litros
EN STOCK
Bolso Estanco Urbano Bewolk 15 litros
EN STOCK
 
Linterna Frontal Led Lenser L7 115 lumens
EN STOCK
Linterna Frontal Led Lenser F1 400 lumens
EN STOCK
Termo Stanley Classic 750 ml Polar ( Blanco )
EN STOCK
Mochila Osprey Kestrel 48 lts
EN STOCK
 
Mosqueton Black Diamond Rocklock Magnetron
EN STOCK
Funda Estanca Flotante para celular Chums
¡ Nuevo !
EN STOCK
Funda Estanca para celular Chums
EN STOCK
Riñonera Estanca Chums
¡ Nuevo !
EN STOCK
 
Zapatillas de Agua Aqurun
¡ Nuevo !
EN STOCK
Bastones Trekking Bamboo Acon
EN STOCK
Vaso Termico Coleman Acero Inox Claret 384 ml
15%
OFF
EN STOCK

Coleman
Vaso Termico Coleman Acero Inox Claret 384 ml
$1.636
$1.925.-  15% OFF

Vaso Termico Coleman Acero Inox Brew 600 ml
15%
OFF
EN STOCK

Coleman
Vaso Termico Coleman Acero Inox Brew 600 ml
$2.359
$2.775.-  15% OFF

 
Mochila Osprey Viva 50 lts Mujer
EN STOCK
 
Lentes Oakley Frogskins Lite
EN STOCK
Lentes Oakley Forager Prizm Polarized
EN STOCK
Lentes Oakley Siphon Prizm
EN STOCK
 
Lentes Oakley Holbrook Mix
EN STOCK
Lentes Oakley Siphon Prizm Sapphire
EN STOCK
Lentes Oakley Holbrook MotoGP Prizm
EN STOCK
 
Lentes Oakley Frogskins Prizm Ruby
EN STOCK
 
(default) 4 queries took 44 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `283377_aquadelta`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'cac4n9dp365ucnjn499fur9k45' LIMIT 1003
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 `283377_aquadelta`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND `Articulo`.`discontinuado` = 0 AND ((`Articulo`.`categoria_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_sec_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_ter_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_cuar_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`created` DESC LIMIT 30303015
3SELECT COUNT(*) AS `count` FROM `283377_aquadelta`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND `Articulo`.`discontinuado` = 0 AND ((`Articulo`.`categoria_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_sec_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_ter_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_cuar_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)))1111
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 `283377_aquadelta`.`articulos` AS `Articulo` LEFT JOIN `283377_aquadelta`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_sec_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_ter_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209)) OR (`Articulo`.`categoria_cuar_id` IN (116, 442, 47, 368, 198, 370, 261, 46, 352, 48, 353, 183, 86, 381, 389, 380, 390, 384, 424, 427, 426, 425, 316, 161, 405, 369, 378, 219, 197, 71, 196, 195, 96, 434, 435, 437, 409, 214, 184, 209))) GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC363615