SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030887__09
[cod_articulo] => 030887__09
[1] => 11727679
[id] => 11727679
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO SLEEVE
[producto] => ATTACANTO SLEEVE
[11] => 030887__09
[12] => Las canilleras Puma Attacanto Sleeve combinan una carcasa de TPU resistente con una funda de compresión para ofrecer una protección ligera y cómoda en el campo de juego.
[descripcion] => Las canilleras Puma Attacanto Sleeve combinan una carcasa de TPU resistente con una funda de compresión para ofrecer una protección ligera y cómoda en el campo de juego.
[13] =>
[especificaciones] =>
[14] => 162523.jpg
[foto1] => 162523.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-21 01:21:51
[fecha] => 2025-11-21 01:21:51
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 237
[visitas] => 237
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 111600
[precio] => 111600
[52] => 18
[precio_usd] => 18
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030887/09
[codigo_ws] => 030887/09
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030933__01
[cod_articulo] => 030933__01
[1] => 9893271
[id] => 9893271
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => KING SLEEVE
[producto] => KING SLEEVE
[11] => 030933__01
[12] => Es hora de demostrar tu potencial y será mejor que estés bien protegido con el equipo adecuado.
[descripcion] => Es hora de demostrar tu potencial y será mejor que estés bien protegido con el equipo adecuado.
[13] =>
[especificaciones] =>
[14] => 147659.jpg
[foto1] => 147659.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-10-18 01:26:04
[fecha] => 2024-10-18 01:26:04
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 334
[visitas] => 334
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 111600
[precio] => 111600
[52] => 18
[precio_usd] => 18
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030933/01
[codigo_ws] => 030933/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] => 148200
[precio_retail] => 148200
[69] => 148200
[precio_final] => 148200
[70] =>
[tipo_descuento] =>
[71] => 0
[valor_descuento] => 0
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030935__01
[cod_articulo] => 030935__01
[1] => 11722831
[id] => 11722831
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => KING STRAP
[producto] => KING STRAP
[11] => 030935__01
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162524.jpg
[foto1] => 162524.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-20 01:23:43
[fecha] => 2025-11-20 01:23:43
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 188
[visitas] => 188
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 80600
[precio] => 80600
[52] => 13
[precio_usd] => 13
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030935/01
[codigo_ws] => 030935/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030987__02
[cod_articulo] => 030987__02
[1] => 11722832
[id] => 11722832
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA FLEX SLEEVE
[producto] => ULTRA FLEX SLEEVE
[11] => 030987__02
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162526.jpg
[foto1] => 162526.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-20 01:23:43
[fecha] => 2025-11-20 01:23:43
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 232
[visitas] => 232
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 179800
[precio] => 179800
[52] => 29
[precio_usd] => 29
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030987/02
[codigo_ws] => 030987/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030987__03
[cod_articulo] => 030987__03
[1] => 11722833
[id] => 11722833
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA FLEX SLEEVE
[producto] => ULTRA FLEX SLEEVE
[11] => 030987__03
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162525.jpg
[foto1] => 162525.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-20 01:23:43
[fecha] => 2025-11-20 01:23:43
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 209
[visitas] => 209
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 179800
[precio] => 179800
[52] => 29
[precio_usd] => 29
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030987/03
[codigo_ws] => 030987/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030987__04
[cod_articulo] => 030987__04
[1] => 11826474
[id] => 11826474
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA FLEX SLEEVE
[producto] => ULTRA FLEX SLEEVE
[11] => 030987__04
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165381.jpg
[foto1] => 165381.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:35
[fecha] => 2025-12-10 01:35:35
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 199
[visitas] => 199
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 192200
[precio] => 192200
[52] => 31
[precio_usd] => 31
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030987/04
[codigo_ws] => 030987/04
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030989__01
[cod_articulo] => 030989__01
[1] => 11826475
[id] => 11826475
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT SLEEVE
[producto] => ULTRA LIGHT SLEEVE
[11] => 030989__01
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162527.jpg
[foto1] => 162527.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:35
[fecha] => 2025-12-10 01:35:35
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 179
[visitas] => 179
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 99200
[precio] => 99200
[52] => 16
[precio_usd] => 16
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030989/01
[codigo_ws] => 030989/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030989__02
[cod_articulo] => 030989__02
[1] => 11826476
[id] => 11826476
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT SLEEVE
[producto] => ULTRA LIGHT SLEEVE
[11] => 030989__02
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162528.jpg
[foto1] => 162528.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:36
[fecha] => 2025-12-10 01:35:36
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 167
[visitas] => 167
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 99200
[precio] => 99200
[52] => 16
[precio_usd] => 16
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030989/02
[codigo_ws] => 030989/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030989__03
[cod_articulo] => 030989__03
[1] => 11826477
[id] => 11826477
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT SLEEVE
[producto] => ULTRA LIGHT SLEEVE
[11] => 030989__03
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 162529.jpg
[foto1] => 162529.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:36
[fecha] => 2025-12-10 01:35:36
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 187
[visitas] => 187
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 99200
[precio] => 99200
[52] => 16
[precio_usd] => 16
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030989/03
[codigo_ws] => 030989/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030989__04
[cod_articulo] => 030989__04
[1] => 11826478
[id] => 11826478
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT SLEEVE
[producto] => ULTRA LIGHT SLEEVE
[11] => 030989__04
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165382.jpg
[foto1] => 165382.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:36
[fecha] => 2025-12-10 01:35:36
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 159
[visitas] => 159
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 99200
[precio] => 99200
[52] => 16
[precio_usd] => 16
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030989/04
[codigo_ws] => 030989/04
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030992__02
[cod_articulo] => 030992__02
[1] => 11826479
[id] => 11826479
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT STRAP
[producto] => ULTRA LIGHT STRAP
[11] => 030992__02
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 169921.jpg
[foto1] => 169921.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:36
[fecha] => 2025-12-10 01:35:36
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 156
[visitas] => 156
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 80600
[precio] => 80600
[52] => 13
[precio_usd] => 13
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030992/02
[codigo_ws] => 030992/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030992__03
[cod_articulo] => 030992__03
[1] => 11826480
[id] => 11826480
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ULTRA LIGHT STRAP
[producto] => ULTRA LIGHT STRAP
[11] => 030992__03
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165376.jpg
[foto1] => 165376.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-10 01:35:36
[fecha] => 2025-12-10 01:35:36
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 218
[visitas] => 218
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 80600
[precio] => 80600
[52] => 13
[precio_usd] => 13
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030992/03
[codigo_ws] => 030992/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030995__01
[cod_articulo] => 030995__01
[1] => 11804963
[id] => 11804963
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO SLEEVE
[producto] => ATTACANTO SLEEVE
[11] => 030995__01
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165377.jpg
[foto1] => 165377.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-06 01:51:13
[fecha] => 2025-12-06 01:51:13
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 165
[visitas] => 165
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 111600
[precio] => 111600
[52] => 18
[precio_usd] => 18
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030995/01
[codigo_ws] => 030995/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030996__01
[cod_articulo] => 030996__01
[1] => 11804964
[id] => 11804964
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO STRAP
[producto] => ATTACANTO STRAP
[11] => 030996__01
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165378.jpg
[foto1] => 165378.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-06 01:51:13
[fecha] => 2025-12-06 01:51:13
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 202
[visitas] => 202
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 80600
[precio] => 80600
[52] => 13
[precio_usd] => 13
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030996/01
[codigo_ws] => 030996/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 030997__01
[cod_articulo] => 030997__01
[1] => 11636133
[id] => 11636133
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => BVB ESS ULTRA LIGHT STRAP
[producto] => BVB ESS ULTRA LIGHT STRAP
[11] => 030997__01
[12] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[descripcion] => No dejes de tener tu kit de canilleras para todos tus partidos importantes
[13] =>
[especificaciones] =>
[14] => 165379.jpg
[foto1] => 165379.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-02 01:42:27
[fecha] => 2025-11-02 01:42:27
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 231
[visitas] => 231
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 42
[codigoColeccion] => 42
[44] => Borussia Dortmund
[Coleccion] => Borussia Dortmund
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 30
[largo] => 30
[48] => 5
[alto] => 5
[49] => 26
[ancho] => 26
[50] => 0.2
[peso] => 0.2
[51] => 93000
[precio] => 93000
[52] => 15
[precio_usd] => 15
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030997/01
[codigo_ws] => 030997/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 041641__01
[cod_articulo] => 041641__01
[1] => 4392131
[id] => 4392131
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => KING 4
[producto] => KING 4
[11] => 041641__01
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 95264.jpg
[foto1] => 95264.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2020-12-30 04:31:46
[fecha] => 2020-12-30 04:31:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3151
[visitas] => 3151
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] => 0
[descuento] => 0
[54] => 0
[sale] => 0
[55] => 041641/01
[codigo_ws] => 041641/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] => 148000
[precio_retail] => 148000
[69] => 148000
[precio_final] => 148000
[70] =>
[tipo_descuento] =>
[71] => 0
[valor_descuento] => 0
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 041949__07
[cod_articulo] => 041949__07
[1] => 10934092
[id] => 10934092
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PUMA ULTRA PRO NC
[producto] => PUMA ULTRA PRO NC
[11] => 041949__07
[12] => Guante de arquero profesional con palma de látex de 4?mm y corte negativo para máximo agarre y ajuste preciso.
[descripcion] => Guante de arquero profesional con palma de látex de 4?mm y corte negativo para máximo agarre y ajuste preciso.
[13] =>
[especificaciones] =>
[14] => 161517.jpg
[foto1] => 161517.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-06-01 01:43:49
[fecha] => 2025-06-01 01:43:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 404
[visitas] => 404
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-02 01:00:01
[updated_at] => 2026-04-02 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 609700
[precio] => 609700
[52] => 91
[precio_usd] => 91
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 041949/07
[codigo_ws] => 041949/07
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 041951__06
[cod_articulo] => 041951__06
[1] => 10726072
[id] => 10726072
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PUMA ULTRA MATCH RC
[producto] => PUMA ULTRA MATCH RC
[11] => 041951__06
[12] => El PUMA ULTRA Match RC es un guante de arquero de alto rendimiento, diseñado para ofrecer un ajuste preciso, gran agarre y durabilidad, ideal para un rendimiento óptimo durante los partidos.
[descripcion] => El PUMA ULTRA Match RC es un guante de arquero de alto rendimiento, diseñado para ofrecer un ajuste preciso, gran agarre y durabilidad, ideal para un rendimiento óptimo durante los partidos.
[13] =>
[especificaciones] =>
[14] => 160193.jpg
[foto1] => 160193.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-04-17 01:21:48
[fecha] => 2025-04-17 01:21:48
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 497
[visitas] => 497
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 297600
[precio] => 297600
[52] => 48
[precio_usd] => 48
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 041951/06
[codigo_ws] => 041951/06
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 041952__06
[cod_articulo] => 041952__06
[1] => 10670361
[id] => 10670361
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PUMA ULTRA PLAY RC
[producto] => PUMA ULTRA PLAY RC
[11] => 041952__06
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 160197.jpg
[foto1] => 160197.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-04-05 01:31:08
[fecha] => 2025-04-05 01:31:08
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 375
[visitas] => 375
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 136400
[precio] => 136400
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 041952/06
[codigo_ws] => 041952/06
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042065__02
[cod_articulo] => 042065__02
[1] => 11762314
[id] => 11762314
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => FUTURE PRO HYBRID
[producto] => FUTURE PRO HYBRID
[11] => 042065__02
[12] => Guante de arquero profesional con palma de látex Duo?Soft de 4?mm, corte híbrido (rollfinger y negativo) y dorso textil para máxima agilidad, ajuste y agarre en cualquier condición
[descripcion] => Guante de arquero profesional con palma de látex Duo?Soft de 4?mm, corte híbrido (rollfinger y negativo) y dorso textil para máxima agilidad, ajuste y agarre en cualquier condición
[13] =>
[especificaciones] =>
[14] => 161518.jpg
[foto1] => 161518.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-28 01:42:09
[fecha] => 2025-11-28 01:42:09
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 208
[visitas] => 208
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 706800
[precio] => 706800
[52] => 114
[precio_usd] => 114
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042065/02
[codigo_ws] => 042065/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042067__01
[cod_articulo] => 042067__01
[1] => 10726075
[id] => 10726075
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => FUTURE MATCH NC
[producto] => FUTURE MATCH NC
[11] => 042067__01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 160194.jpg
[foto1] => 160194.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-04-17 01:21:48
[fecha] => 2025-04-17 01:21:48
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 400
[visitas] => 400
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 353400
[precio] => 353400
[52] => 57
[precio_usd] => 57
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042067/01
[codigo_ws] => 042067/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042067__03
[cod_articulo] => 042067__03
[1] => 10726076
[id] => 10726076
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => FUTURE MATCH NC
[producto] => FUTURE MATCH NC
[11] => 042067__03
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 160195.jpg
[foto1] => 160195.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-04-17 01:21:48
[fecha] => 2025-04-17 01:21:48
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 415
[visitas] => 415
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 353400
[precio] => 353400
[52] => 57
[precio_usd] => 57
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042067/03
[codigo_ws] => 042067/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042084__01
[cod_articulo] => 042084__01
[1] => 11722851
[id] => 11722851
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PUMA ULTRA PLAY RC
[producto] => PUMA ULTRA PLAY RC
[11] => 042084__01
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165456.png
[foto1] => 165456.png
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-20 01:23:44
[fecha] => 2025-11-20 01:23:44
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 216
[visitas] => 216
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042084/01
[codigo_ws] => 042084/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042084__03
[cod_articulo] => 042084__03
[1] => 11722852
[id] => 11722852
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PUMA ULTRA PLAY RC
[producto] => PUMA ULTRA PLAY RC
[11] => 042084__03
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165446.png
[foto1] => 165446.png
[15] => 165447.png
[foto2] => 165447.png
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-20 01:23:44
[fecha] => 2025-11-20 01:23:44
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 188
[visitas] => 188
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042084/03
[codigo_ws] => 042084/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042090__01
[cod_articulo] => 042090__01
[1] => 11804986
[id] => 11804986
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO PLAY RC
[producto] => ATTACANTO PLAY RC
[11] => 042090__01
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165448.png
[foto1] => 165448.png
[15] => 165449.png
[foto2] => 165449.png
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-06 01:51:13
[fecha] => 2025-12-06 01:51:13
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 180
[visitas] => 180
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042090/01
[codigo_ws] => 042090/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042090__02
[cod_articulo] => 042090__02
[1] => 11804987
[id] => 11804987
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO PLAY RC
[producto] => ATTACANTO PLAY RC
[11] => 042090__02
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165450.png
[foto1] => 165450.png
[15] => 165451.png
[foto2] => 165451.png
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-06 01:51:13
[fecha] => 2025-12-06 01:51:13
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 174
[visitas] => 174
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042090/02
[codigo_ws] => 042090/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042090__03
[cod_articulo] => 042090__03
[1] => 11804988
[id] => 11804988
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => ATTACANTO PLAY RC
[producto] => ATTACANTO PLAY RC
[11] => 042090__03
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165452.png
[foto1] => 165452.png
[15] => 165453.png
[foto2] => 165453.png
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-12-06 01:51:13
[fecha] => 2025-12-06 01:51:13
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 191
[visitas] => 191
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042090/03
[codigo_ws] => 042090/03
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 042092__01
[cod_articulo] => 042092__01
[1] => 11636152
[id] => 11636152
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 3
[cod_familia] => 3
[5] => GUANTES
[familia] => GUANTES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => BVB ULTRA PLAY RC
[producto] => BVB ULTRA PLAY RC
[11] => 042092__01
[12] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[descripcion] => Con estos guantes de portero funcionales tendrás la protección y agilidad que necesitas en el campo
[13] =>
[especificaciones] =>
[14] => 165454.png
[foto1] => 165454.png
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-11-02 01:42:28
[fecha] => 2025-11-02 01:42:28
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 147
[visitas] => 147
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 42
[codigoColeccion] => 42
[44] => Borussia Dortmund
[Coleccion] => Borussia Dortmund
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 33
[largo] => 33
[48] => 5
[alto] => 5
[49] => 16
[ancho] => 16
[50] => 0.1
[peso] => 0.1
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 042092/01
[codigo_ws] => 042092/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Latex 30%, PU 30%, EVA 20%, Polyester 20%
[descripcionLarga] =>
- Latex 30%, PU 30%, EVA 20%, Polyester 20%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01BK
[cod_articulo] => 050011__01BK
[1] => 11406863
[id] => 11406863
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS NEGRO
[producto] => CAPTAINS ARMSBANDS NEGRO
[11] => 050011__01BK
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165203.jpg
[foto1] => 165203.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 346
[visitas] => 346
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01BK
[codigo_ws] => 050011/01BK
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01BL
[cod_articulo] => 050011__01BL
[1] => 11406864
[id] => 11406864
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS AZUL
[producto] => CAPTAINS ARMSBANDS AZUL
[11] => 050011__01BL
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165204.jpg
[foto1] => 165204.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 181
[visitas] => 181
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01BL
[codigo_ws] => 050011/01BL
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01GR
[cod_articulo] => 050011__01GR
[1] => 11406865
[id] => 11406865
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS VERDE
[producto] => CAPTAINS ARMSBANDS VERDE
[11] => 050011__01GR
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165205.jpg
[foto1] => 165205.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 199
[visitas] => 199
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01GR
[codigo_ws] => 050011/01GR
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01LB
[cod_articulo] => 050011__01LB
[1] => 11406866
[id] => 11406866
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS CELESTE
[producto] => CAPTAINS ARMSBANDS CELESTE
[11] => 050011__01LB
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165206.jpg
[foto1] => 165206.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 325
[visitas] => 325
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01LB
[codigo_ws] => 050011/01LB
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01RE
[cod_articulo] => 050011__01RE
[1] => 11406867
[id] => 11406867
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS ROJO
[producto] => CAPTAINS ARMSBANDS ROJO
[11] => 050011__01RE
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165207.jpg
[foto1] => 165207.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 443
[visitas] => 443
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01RE
[codigo_ws] => 050011/01RE
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 050011__01YE
[cod_articulo] => 050011__01YE
[1] => 11406868
[id] => 11406868
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 84
[cod_familia] => 84
[5] => EQUIPAMIENTO
[familia] => EQUIPAMIENTO
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => CAPTAINS ARMSBANDS AMARILLO
[producto] => CAPTAINS ARMSBANDS AMARILLO
[11] => 050011__01YE
[12] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[descripcion] => Premie su condición de capitán con el brazalete de capitán de PUMA. La abrazadera está disponible en 6 colores diferentes.
[13] =>
[especificaciones] =>
[14] => 165208.jpg
[foto1] => 165208.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-09-13 01:17:46
[fecha] => 2025-09-13 01:17:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 166
[visitas] => 166
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 13
[largo] => 13
[48] => 2
[alto] => 2
[49] => 9
[ancho] => 9
[50] => 0.1
[peso] => 0.1
[51] => 18600
[precio] => 18600
[52] => 3
[precio_usd] => 3
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 050011/01YE
[codigo_ws] => 050011/01YE
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] =>
[descripcionLarga] =>
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] =>
[precio_retail] =>
[69] =>
[precio_final] =>
[70] =>
[tipo_descuento] =>
[71] =>
[valor_descuento] =>
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 083292__01
[cod_articulo] => 083292__01
[1] => 2731067
[id] => 2731067
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 8
[cod_familia] => 8
[5] => PELOTAS
[familia] => PELOTAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => FTBLPLAY BIG CAT BALL
[producto] => FTBLPLAY BIG CAT BALL
[11] => 083292__01
[12] => Tanto si jugás por hobbie como si te planteas dar el salto al estrellato, la pelota de fútbol ftblPLAY Big Cat está diseñada para mejorar tu rendimiento
[descripcion] => Tanto si jugás por hobbie como si te planteas dar el salto al estrellato, la pelota de fútbol ftblPLAY Big Cat está diseñada para mejorar tu rendimiento
[13] =>
[especificaciones] =>
[14] => 80313.jpg
[foto1] => 80313.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2020-06-26 05:30:45
[fecha] => 2020-06-26 05:30:45
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3600
[visitas] => 3600
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 25
[largo] => 25
[48] => 25
[alto] => 25
[49] => 25
[ancho] => 25
[50] => 0.6
[peso] => 0.6
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] => 0
[descuento] => 0
[54] => 0
[sale] => 0
[55] => 083292/01
[codigo_ws] => 083292/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - TPU 10%, EVA 65%, Textile Lining 15%, SR Bladder 10%
[descripcionLarga] =>
- TPU 10%, EVA 65%, Textile Lining 15%, SR Bladder 10%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] => 148200
[precio_retail] => 148200
[69] => 148200
[precio_final] => 148200
[70] =>
[tipo_descuento] =>
[71] => 0
[valor_descuento] => 0
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 083292__02
[cod_articulo] => 083292__02
[1] => 2731068
[id] => 2731068
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 8
[cod_familia] => 8
[5] => PELOTAS
[familia] => PELOTAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => FTBLPLAY BIG CAT BALL
[producto] => FTBLPLAY BIG CAT BALL
[11] => 083292__02
[12] => Tanto si jugás por hobbie como si te planteas dar el salto al estrellato, la pelota de fútbol ftblPLAY Big Cat está diseñada para mejorar tu rendimiento
[descripcion] => Tanto si jugás por hobbie como si te planteas dar el salto al estrellato, la pelota de fútbol ftblPLAY Big Cat está diseñada para mejorar tu rendimiento
[13] =>
[especificaciones] =>
[14] => 80314.jpg
[foto1] => 80314.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2020-06-26 05:30:46
[fecha] => 2020-06-26 05:30:46
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3607
[visitas] => 3607
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-05-18 01:00:01
[updated_at] => 2026-05-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 25
[largo] => 25
[48] => 25
[alto] => 25
[49] => 25
[ancho] => 25
[50] => 0.6
[peso] => 0.6
[51] => 130200
[precio] => 130200
[52] => 21
[precio_usd] => 21
[53] => 0
[descuento] => 0
[54] => 0
[sale] => 0
[55] => 083292/02
[codigo_ws] => 083292/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - TPU 10%, EVA 65%, Textile Lining 15%, SR Bladder 10%
[descripcionLarga] =>
- TPU 10%, EVA 65%, Textile Lining 15%, SR Bladder 10%
[60] => 1
[disponible_online] => 1
[61] => 1
[disponible_tiendas] => 1
[62] => 0
[destacado_kemsa] => 0
[63] => 0
[destacado_ecommerce] => 0
[64] => 0
[destacado_marca] => 0
[65] => 0
[mas_visto] => 0
[66] =>
[descripcion_seo] =>
[67] =>
[palabras_claves] =>
[68] => 156000
[precio_retail] => 156000
[69] => 124800
[precio_final] => 124800
[70] => sale_definitivo
[tipo_descuento] => sale_definitivo
[71] => 20
[valor_descuento] => 20
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Sale
Cod.: 083292/02
$ 17
$ 21
