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] => 030635__01
[cod_articulo] => 030635__01
[1] => 73
[id] => 73
[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] => CANILLERA PUMA VENTILATION SHINGUARD I
[producto] => CANILLERA PUMA VENTILATION SHINGUARD I
[11] => 030635__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] => 35496.jpg
[foto1] => 35496.jpg
[15] => 116646.jpg
[foto2] => 116646.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2019-04-29 12:08:18
[fecha] => 2019-04-29 12:08:18
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 2311
[visitas] => 2311
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 78000
[precio] => 78000
[52] => 10
[precio_usd] => 10
[53] => 30
[descuento] => 30
[54] => 0
[sale] => 0
[55] => 030635/01
[codigo_ws] => 030635/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] => 78000
[precio_retail] => 78000
[69] => 78000
[precio_final] => 78000
[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] => 030636__01
[cod_articulo] => 030636__01
[1] => 10063057
[id] => 10063057
[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] => EVOFORCE III
[producto] => EVOFORCE III
[11] => 030636__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] => 146710.jpg
[foto1] => 146710.jpg
[15] => 146711.jpg
[foto2] => 146711.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-11-22 01:19:03
[fecha] => 2024-11-22 01:19:03
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 70200
[precio] => 70200
[52] => 9
[precio_usd] => 9
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030636/01
[codigo_ws] => 030636/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] => 030871__03
[cod_articulo] => 030871__03
[1] => 10063058
[id] => 10063058
[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] => 030871__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] => 147440.jpg
[foto1] => 147440.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-11-22 01:19:03
[fecha] => 2024-11-22 01:19:03
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 119
[visitas] => 119
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 226200
[precio] => 226200
[52] => 29
[precio_usd] => 29
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 030871/03
[codigo_ws] => 030871/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] => 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] => 143
[visitas] => 143
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 148200
[precio] => 148200
[52] => 19
[precio_usd] => 19
[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] => 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] => 2626
[visitas] => 2626
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[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] =>
[descripcion] =>
[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] => 24
[visitas] => 24
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 709800
[precio] => 709800
[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] => 88
[visitas] => 88
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 374400
[precio] => 374400
[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__03
[cod_articulo] => 041952__03
[1] => 10063071
[id] => 10063071
[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__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] => 147848.jpg
[foto1] => 147848.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-11-22 01:19:04
[fecha] => 2024-11-22 01:19:04
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 223
[visitas] => 223
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 041952/03
[codigo_ws] => 041952/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] => 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] => 83
[visitas] => 83
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[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] => 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] => 67
[visitas] => 67
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 444600
[precio] => 444600
[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] => 60
[visitas] => 60
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 444600
[precio] => 444600
[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] => 076864__03
[cod_articulo] => 076864__03
[1] => 6706197
[id] => 6706197
[2] => 1
[cod_rubro] => 1
[3] => ACCESORIOS
[rubro] => ACCESORIOS
[4] => 5
[cod_familia] => 5
[5] => BOLSONES
[familia] => BOLSONES
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => TEAM GOAL 23 SHOE BAG
[producto] => TEAM GOAL 23 SHOE BAG
[11] => 076864__03
[12] => teamGOAL 23 Shoe Bag
[descripcion] => teamGOAL 23 Shoe Bag
[13] =>
[especificaciones] =>
[14] => 110312.jpg
[foto1] => 110312.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2021-11-13 04:30:43
[fecha] => 2021-11-13 04:30:43
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 266
[visitas] => 266
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 0
[codigoColeccion] => 0
[44] =>
[Coleccion] =>
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 50
[largo] => 50
[48] => 10
[alto] => 10
[49] => 40
[ancho] => 40
[50] => 1.3
[peso] => 1.3
[51] => 78000
[precio] => 78000
[52] => 10
[precio_usd] => 10
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 076864/03
[codigo_ws] => 076864/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] => 78000
[precio_retail] => 78000
[69] => 78000
[precio_final] => 78000
[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__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] => 3018
[visitas] => 3018
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 163800
[precio] => 163800
[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] => 2812
[visitas] => 2812
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 163800
[precio] => 163800
[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
Array
(
[0] => 083292__11
[cod_articulo] => 083292__11
[1] => 7831244
[id] => 7831244
[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__11
[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] => 116258.jpg
[foto1] => 116258.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2022-09-22 05:30:19
[fecha] => 2022-09-22 05:30:19
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 541
[visitas] => 541
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 163800
[precio] => 163800
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083292/11
[codigo_ws] => 083292/11
[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/11
$ 17
$ 21
Array
(
[0] => 083557__01
[cod_articulo] => 083557__01
[1] => 8991162
[id] => 8991162
[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] => PUMA BASKETBALL TOP
[producto] => PUMA BASKETBALL TOP
[11] => 083557__01
[12] => PUMA Hoops presenta una pelota de basketball de interior clásico en piel marrón.
[descripcion] => PUMA Hoops presenta una pelota de basketball de interior clásico en piel marrón.
[13] =>
[especificaciones] =>
[14] => 136918.jpg
[foto1] => 136918.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-08-30 05:30:56
[fecha] => 2023-08-30 05:30:56
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 428
[visitas] => 428
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 390000
[precio] => 390000
[52] => 50
[precio_usd] => 50
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083557/01
[codigo_ws] => 083557/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] => 390000
[precio_retail] => 390000
[69] => 312000
[precio_final] => 312000
[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.: 083557/01
$ 40
$ 50
Array
(
[0] => 083620__01
[cod_articulo] => 083620__01
[1] => 8991163
[id] => 8991163
[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] => PUMA BASKETBALL IND
[producto] => PUMA BASKETBALL IND
[11] => 083620__01
[12] => Balón de baloncesto Puma IND Multicolor El material duro de Puma se adapta a todos los deportes, combinando tecnología y comodidad en cada prenda.
[descripcion] => Balón de baloncesto Puma IND Multicolor El material duro de Puma se adapta a todos los deportes, combinando tecnología y comodidad en cada prenda.
[13] =>
[especificaciones] =>
[14] => 137360.jpg
[foto1] => 137360.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-08-30 05:30:56
[fecha] => 2023-08-30 05:30:56
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 849
[visitas] => 849
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 132600
[precio] => 132600
[52] => 17
[precio_usd] => 17
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083620/01
[codigo_ws] => 083620/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] => 132600
[precio_retail] => 132600
[69] => 132600
[precio_final] => 132600
[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] => 083774__01
[cod_articulo] => 083774__01
[1] => 9578281
[id] => 9578281
[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] => PUMA ORBITA 1 TB (FIFA QUALITY PRO)
[producto] => PUMA ORBITA 1 TB (FIFA QUALITY PRO)
[11] => 083774__01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 142070.jpg
[foto1] => 142070.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-08-11 01:30:01
[fecha] => 2024-08-11 01:30:01
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 904
[visitas] => 904
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 686400
[precio] => 686400
[52] => 88
[precio_usd] => 88
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083774/01
[codigo_ws] => 083774/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] => 686400
[precio_retail] => 686400
[69] => 686400
[precio_final] => 686400
[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] => 083775__01
[cod_articulo] => 083775__01
[1] => 9578283
[id] => 9578283
[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] => PUMA ORBITA 2 TB (FIFA QUALITY PRO)
[producto] => PUMA ORBITA 2 TB (FIFA QUALITY PRO)
[11] => 083775__01
[12] => La pelota Futsal 1 Fifa Quality Pro está hecha para adaptarse a todos los campos de juego y garantizar las mejores jugadas en la cancha.
[descripcion] => La pelota Futsal 1 Fifa Quality Pro está hecha para adaptarse a todos los campos de juego y garantizar las mejores jugadas en la cancha.
[13] =>
[especificaciones] =>
[14] => 143146.jpg
[foto1] => 143146.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-08-11 01:30:01
[fecha] => 2024-08-11 01:30:01
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 551
[visitas] => 551
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 460200
[precio] => 460200
[52] => 59
[precio_usd] => 59
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083775/01
[codigo_ws] => 083775/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] => 460200
[precio_retail] => 460200
[69] => 460200
[precio_final] => 460200
[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] => 083776__01
[cod_articulo] => 083776__01
[1] => 9508389
[id] => 9508389
[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] => PUMA ORBITA 3 TB (FIFA QUALITY)
[producto] => PUMA ORBITA 3 TB (FIFA QUALITY)
[11] => 083776__01
[12] => Perfecciona tus habilidades con el PUMA Orbita 3 TB (Calidad FIFA)
[descripcion] => Perfecciona tus habilidades con el PUMA Orbita 3 TB (Calidad FIFA)
[13] =>
[especificaciones] =>
[14] => 132249.jpg
[foto1] => 132249.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-12 17:50:47
[fecha] => 2024-07-12 17:50:47
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 539
[visitas] => 539
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 351000
[precio] => 351000
[52] => 45
[precio_usd] => 45
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083776/01
[codigo_ws] => 083776/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] => 351000
[precio_retail] => 351000
[69] => 351000
[precio_final] => 351000
[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] => 083782__01
[cod_articulo] => 083782__01
[1] => 8761940
[id] => 8761940
[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] => PUMA ORBITA 5 TB HARDGROUND
[producto] => PUMA ORBITA 5 TB HARDGROUND
[11] => 083782__01
[12] => Balón de training robusto para entrenamientos habituales, especialmente, sobre superficies duras.
[descripcion] => Balón de training robusto para entrenamientos habituales, especialmente, sobre superficies duras.
[13] =>
[especificaciones] =>
[14] => 131007.jpg
[foto1] => 131007.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-07-05 05:30:42
[fecha] => 2023-07-05 05:30:42
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 196
[visitas] => 196
[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] =>
[genero] =>
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[41] =>
[codigoGenero] =>
[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] => 351000
[precio] => 351000
[52] => 45
[precio_usd] => 45
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083782/01
[codigo_ws] => 083782/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] => 351000
[precio_retail] => 351000
[69] => 351000
[precio_final] => 351000
[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] => 083787__01
[cod_articulo] => 083787__01
[1] => 9369325
[id] => 9369325
[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] => PUMA ORBITA 6MS
[producto] => PUMA ORBITA 6MS
[11] => 083787__01
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular.
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular.
[13] =>
[especificaciones] =>
[14] => 133900.jpg
[foto1] => 133900.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-11-23 04:31:00
[fecha] => 2023-11-23 04:31:00
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 330
[visitas] => 330
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083787/01
[codigo_ws] => 083787/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] => 171600
[precio_retail] => 171600
[69] => 171600
[precio_final] => 171600
[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] => 083787__02
[cod_articulo] => 083787__02
[1] => 9333662
[id] => 9333662
[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] => PUMA ORBITA 6MS
[producto] => PUMA ORBITA 6MS
[11] => 083787__02
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 133899.jpg
[foto1] => 133899.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-11-15 04:30:53
[fecha] => 2023-11-15 04:30:53
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 441
[visitas] => 441
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083787/02
[codigo_ws] => 083787/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] => 171600
[precio_retail] => 171600
[69] => 171600
[precio_final] => 171600
[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] => 083787__03
[cod_articulo] => 083787__03
[1] => 8042189
[id] => 8042189
[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] => PUMA ORBITA 6 MS
[producto] => PUMA ORBITA 6 MS
[11] => 083787__03
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 128783.jpg
[foto1] => 128783.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2022-12-08 04:30:18
[fecha] => 2022-12-08 04:30:18
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 645
[visitas] => 645
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083787/03
[codigo_ws] => 083787/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] => 171600
[precio_retail] => 171600
[69] => 171600
[precio_final] => 171600
[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] => 083787__06
[cod_articulo] => 083787__06
[1] => 8042190
[id] => 8042190
[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] => PUMA ORBITA 6 MS
[producto] => PUMA ORBITA 6 MS
[11] => 083787__06
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 128782.jpg
[foto1] => 128782.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2022-12-08 04:30:18
[fecha] => 2022-12-08 04:30:18
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 964
[visitas] => 964
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083787/06
[codigo_ws] => 083787/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] => 171600
[precio_retail] => 171600
[69] => 171600
[precio_final] => 171600
[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] => 083992__01
[cod_articulo] => 083992__01
[1] => 8709827
[id] => 8709827
[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] => PUMA PRESTIGE BALL
[producto] => PUMA PRESTIGE BALL
[11] => 083992__01
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 133896.jpg
[foto1] => 133896.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-06-22 05:30:49
[fecha] => 2023-06-22 05:30:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 256
[visitas] => 256
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 148200
[precio] => 148200
[52] => 19
[precio_usd] => 19
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083992/01
[codigo_ws] => 083992/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] => 083992__02
[cod_articulo] => 083992__02
[1] => 8709828
[id] => 8709828
[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] => PUMA PRESTIGE BALL
[producto] => PUMA PRESTIGE BALL
[11] => 083992__02
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 133895.jpg
[foto1] => 133895.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-06-22 05:30:49
[fecha] => 2023-06-22 05:30:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 246
[visitas] => 246
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 148200
[precio] => 148200
[52] => 19
[precio_usd] => 19
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083992/02
[codigo_ws] => 083992/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] => 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] => 083992__03
[cod_articulo] => 083992__03
[1] => 8709829
[id] => 8709829
[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] => PUMA PRESTIGE BALL
[producto] => PUMA PRESTIGE BALL
[11] => 083992__03
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 133894.jpg
[foto1] => 133894.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-06-22 05:30:49
[fecha] => 2023-06-22 05:30:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 274
[visitas] => 274
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 148200
[precio] => 148200
[52] => 19
[precio_usd] => 19
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083992/03
[codigo_ws] => 083992/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] => 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] => 083994__03
[cod_articulo] => 083994__03
[1] => 8709831
[id] => 8709831
[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] => PUMA PRESTIGE BALL
[producto] => PUMA PRESTIGE BALL
[11] => 083994__03
[12] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[descripcion] => Balón de entrenamiento para utilizar durante el entrenamiento regular
[13] =>
[especificaciones] =>
[14] => 133892.jpg
[foto1] => 133892.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-06-22 05:30:49
[fecha] => 2023-06-22 05:30:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 430
[visitas] => 430
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 163800
[precio] => 163800
[52] => 21
[precio_usd] => 21
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083994/03
[codigo_ws] => 083994/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] => 163800
[precio_retail] => 163800
[69] => 131040
[precio_final] => 131040
[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.: 083994/03
$ 17
$ 21
Array
(
[0] => 083995__03
[cod_articulo] => 083995__03
[1] => 8407677
[id] => 8407677
[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] => PUMA CAGE BALL
[producto] => PUMA CAGE BALL
[11] => 083995__03
[12] => En PUMA sabemos que el equipo adecuado puede marcar la diferencia.
Ahora puedes entrenar como las leyendas del fútbol que idolatras con nuestro Cage Football.
[descripcion] => En PUMA sabemos que el equipo adecuado puede marcar la diferencia.
Ahora puedes entrenar como las leyendas del fútbol que idolatras con nuestro Cage Football.
[13] =>
[especificaciones] =>
[14] => 131006.jpg
[foto1] => 131006.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-04-01 08:01:27
[fecha] => 2023-04-01 08:01:27
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 106
[visitas] => 106
[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] =>
[genero] =>
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[41] =>
[codigoGenero] =>
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083995/03
[codigo_ws] => 083995/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] => 171600
[precio_retail] => 171600
[69] => 171600
[precio_final] => 171600
[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] => 083997__02
[cod_articulo] => 083997__02
[1] => 10961809
[id] => 10961809
[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] => PUMA KING BALL
[producto] => PUMA KING BALL
[11] => 083997__02
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143148.jpg
[foto1] => 143148.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-06-07 01:32:37
[fecha] => 2025-06-07 01:32:37
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 9
[visitas] => 9
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 171600
[precio] => 171600
[52] => 22
[precio_usd] => 22
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 083997/02
[codigo_ws] => 083997/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] => 084075__02
[cod_articulo] => 084075__02
[1] => 9500123
[id] => 9500123
[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] => PUMA CUP BALL
[producto] => PUMA CUP BALL
[11] => 084075__02
[12] => Mejora tu nivel de entrenamiento con el balón de fútbol PUMA Cup. Confeccionado con colores brillantes y un diseño moderno, este balón de fútbol ha sido creado
[descripcion] => Mejora tu nivel de entrenamiento con el balón de fútbol PUMA Cup. Confeccionado con colores brillantes y un diseño moderno, este balón de fútbol ha sido creado
[13] =>
[especificaciones] =>
[14] => 139239.jpg
[foto1] => 139239.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-01-16 04:30:45
[fecha] => 2024-01-16 04:30:45
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 318
[visitas] => 318
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 187200
[precio] => 187200
[52] => 24
[precio_usd] => 24
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 084075/02
[codigo_ws] => 084075/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] => 187200
[precio_retail] => 187200
[69] => 149760
[precio_final] => 149760
[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.: 084075/02
$ 19
$ 24
Array
(
[0] => 084107__02
[cod_articulo] => 084107__02
[1] => 9515450
[id] => 9515450
[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] => PUMA ORBITA LALIGA 1 (FIFA QUALITY)
[producto] => PUMA ORBITA LALIGA 1 (FIFA QUALITY)
[11] => 084107__02
[12] => Entra al campo de juego como las superestrellas de LaLiga con esta réplica de nuestro balón Orbita LaLiga 1, la pelota de juego oficial de la liga española.
[descripcion] => Entra al campo de juego como las superestrellas de LaLiga con esta réplica de nuestro balón Orbita LaLiga 1, la pelota de juego oficial de la liga española.
[13] =>
[especificaciones] =>
[14] => 143149.jpg
[foto1] => 143149.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-29 17:30:33
[fecha] => 2024-07-29 17:30:33
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 170
[visitas] => 170
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 390000
[precio] => 390000
[52] => 50
[precio_usd] => 50
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 084107/02
[codigo_ws] => 084107/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Esta pelota de fútbol certificada por la FIFA tiene un diseño de 32 paneles para que tenga un vuelo recto y consistente, además de una superficie texturizada de poliuretano de 0,4 mm que genera una aerodinámica excelente.
- \
- DETALLES
- Balón moldeado por termosellado: excelente retención de forma, duradero y con menor absorción de agua
- Diseño de 32 paneles: la configuración de paneles perfectamente equilibrada para un vuelo recto y uniforme
- Exterior texturizado de poliuretano de 0,4 mm: aerodinámica mejorada
- Capa de espuma de elastómero termoplástico (TPE) de 3,0 mm: rebote mejorado y mayor potencia
- Cámara de goma con válvula PAL (Puma Air Lock): excelente rebote y retención del aire
- Calidad FIFA: garantiza el máximo nivel de performance
- Hecho en China
[descripcionLarga] =>
- Esta pelota de fútbol certificada por la FIFA tiene un diseño de 32 paneles para que tenga un vuelo recto y consistente, además de una superficie texturizada de poliuretano de 0,4 mm que genera una aerodinámica excelente.
- \
- DETALLES
- Balón moldeado por termosellado: excelente retención de forma, duradero y con menor absorción de agua
- Diseño de 32 paneles: la configuración de paneles perfectamente equilibrada para un vuelo recto y uniforme
- Exterior texturizado de poliuretano de 0,4 mm: aerodinámica mejorada
- Capa de espuma de elastómero termoplástico (TPE) de 3,0 mm: rebote mejorado y mayor potencia
- Cámara de goma con válvula PAL (Puma Air Lock): excelente rebote y retención del aire
- Calidad FIFA: garantiza el máximo nivel de performance
- Hecho en China
[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] => 390000
[precio_retail] => 390000
[69] => 390000
[precio_final] => 390000
[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] => 084115__01
[cod_articulo] => 084115__01
[1] => 8709835
[id] => 8709835
[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] => PUMA ORBITA SERIE A (FIFA QUALITY)
[producto] => PUMA ORBITA SERIE A (FIFA QUALITY)
[11] => 084115__01
[12] => Esta es una réplica de fútbol PUMA ORBITA, el balón oficial de la Serie A de Italia. Un balón de alto nivel diseñado para los futuros profesionales que quieren jugar como sus héroes de la Serie A.
[descripcion] => Esta es una réplica de fútbol PUMA ORBITA, el balón oficial de la Serie A de Italia. Un balón de alto nivel diseñado para los futuros profesionales que quieren jugar como sus héroes de la Serie A.
[13] =>
[especificaciones] =>
[14] => 134498.jpg
[foto1] => 134498.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2023-06-22 05:30:49
[fecha] => 2023-06-22 05:30:49
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 419
[visitas] => 419
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 390000
[precio] => 390000
[52] => 50
[precio_usd] => 50
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 084115/01
[codigo_ws] => 084115/01
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Pelota moldeada THB: Excelente retención de forma, durabilidad y menor absorción de agua
- Configuración de 32 paneles: configuración de paneles perfectamente equilibrada para un vuelo recto y consistente
- Exterior de PU texturizado de 0.4 mm: Aerodinámica mejorada
- Capa de espuma TPE de 3.00 mm: Rebote mejorado y mayor potencia
- Cámara de goma y válvula PAL (Puma Air Lock): Excelente retención de aire y rebo
[descripcionLarga] =>
- Pelota moldeada THB: Excelente retención de forma, durabilidad y menor absorción de agua
- Configuración de 32 paneles: configuración de paneles perfectamente equilibrada para un vuelo recto y consistente
- Exterior de PU texturizado de 0.4 mm: Aerodinámica mejorada
- Capa de espuma TPE de 3.00 mm: Rebote mejorado y mayor potencia
- Cámara de goma y válvula PAL (Puma Air Lock): Excelente retención de aire y rebo
[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] => 390000
[precio_retail] => 390000
[69] => 390000
[precio_final] => 390000
[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] => 084115__02
[cod_articulo] => 084115__02
[1] => 9515452
[id] => 9515452
[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] => PUMA ORBITA SERIE A (FIFA QUALITY)
[producto] => PUMA ORBITA SERIE A (FIFA QUALITY)
[11] => 084115__02
[12] => Se trata de una réplica del balón PUMA ORBITA, el balón oficial de la Serie A italiana.
[descripcion] => Se trata de una réplica del balón PUMA ORBITA, el balón oficial de la Serie A italiana.
[13] =>
[especificaciones] =>
[14] => 143150.jpg
[foto1] => 143150.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-29 17:30:33
[fecha] => 2024-07-29 17:30:33
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 244
[visitas] => 244
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 390000
[precio] => 390000
[52] => 50
[precio_usd] => 50
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 084115/02
[codigo_ws] => 084115/02
[56] => 1
[puma_flag] => 1
[57] => 0
[skechers_flag] => 0
[58] => 0
[aeropostale_flag] => 0
[59] => - Un balón de partido de alto nivel, está diseñado para aquellos que pronto serán profesionales y quieren jugar como sus héroes de la Serie A.
- DETALLES
- Balón moldeado THB: Excelente retención de la forma, durabilidad y reducida absorción de agua.
- Configuración de 32 paneles: configuración de paneles perfectamente equilibrada para un vuelo recto y consistente
- Exterior de PU texturizado de 0,4 mm: Mejora la aerodinámica
- Capa de espuma TPE de 3,00 mm: Mejor rebote y mayor potencia
- Vejiga de goma + válvula PAL (Puma Air Lock): Excelente retención del aire y rebote
- Hecho en China
[descripcionLarga] =>
- Un balón de partido de alto nivel, está diseñado para aquellos que pronto serán profesionales y quieren jugar como sus héroes de la Serie A.
- DETALLES
- Balón moldeado THB: Excelente retención de la forma, durabilidad y reducida absorción de agua.
- Configuración de 32 paneles: configuración de paneles perfectamente equilibrada para un vuelo recto y consistente
- Exterior de PU texturizado de 0,4 mm: Mejora la aerodinámica
- Capa de espuma TPE de 3,00 mm: Mejor rebote y mayor potencia
- Vejiga de goma + válvula PAL (Puma Air Lock): Excelente retención del aire y rebote
- Hecho en China
[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] => 390000
[precio_retail] => 390000
[69] => 390000
[precio_final] => 390000
[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] => 084331__01
[cod_articulo] => 084331__01
[1] => 10758968
[id] => 10758968
[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] => ORBITA 5 FUSION
[producto] => ORBITA 5 FUSION
[11] => 084331__01
[12] => El balón de fútbol Puma ORBITA 5 FUSION . es adecuado para el entrenamiento y para el juego recreativo, tiene grandes características de rebote, resistencia y vuelo
[descripcion] => El balón de fútbol Puma ORBITA 5 FUSION . es adecuado para el entrenamiento y para el juego recreativo, tiene grandes características de rebote, resistencia y vuelo
[13] =>
[especificaciones] =>
[14] => 158474.jpg
[foto1] => 158474.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-04-24 01:21:24
[fecha] => 2025-04-24 01:21:24
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 57
[visitas] => 57
[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] => 2025-06-18 01:00:01
[updated_at] => 2025-06-18 01:00:01
[36] => 001
[marca_ws] => 001
[37] => ACC
[cod_rubro_ws] => ACC
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => N/A
[grupoMedida] => N/A
[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] => 202800
[precio] => 202800
[52] => 26
[precio_usd] => 26
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 084331/01
[codigo_ws] => 084331/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
