SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 2004PAW01
[cod_articulo] => 2004PAW01
[1] => 9516354
[id] => 9516354
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => REPLICA APF ATENAS 2004
[producto] => REPLICA APF ATENAS 2004
[11] => 2004PAW01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 145254.png
[foto1] => 145254.png
[15] => 145255.png
[foto2] => 145255.png
[16] => 145256.png
[foto3] => 145256.png
[17] => 145257.png
[foto4] => 145257.png
[18] => 145258.png
[foto5] => 145258.png
[19] =>
[foto6] =>
[20] => 2024-07-29 17:31:14
[fecha] => 2024-07-29 17:31:14
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 26719
[visitas] => 26719
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-03-24 01:00:01
[updated_at] => 2026-03-24 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 428800
[precio] => 428800
[52] => 64
[precio_usd] => 64
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 2004PAW01
[codigo_ws] => 2004PAW01
[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] => 499200
[precio_retail] => 499200
[69] => 299520
[precio_final] => 299520
[70] => sale_definitivo
[tipo_descuento] => sale_definitivo
[71] => 40
[valor_descuento] => 40
[72] => GS
[moneda_descuento] => GS
)
SELECT distinct(p.cod_articulo), p.* FROM productos p WHERE p.modalidad = 'FUTBOL' AND p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Sale
Cod.: 2004PAW01
$ 38
$ 64
Array
(
[0] => 773064AKV01
[cod_articulo] => 773064AKV01
[1] => 9513043
[id] => 9513043
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY AWAY JERSEY KIDS
[producto] => PARAGUAY AWAY JERSEY KIDS
[11] => 773064AKV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143699.jpg
[foto1] => 143699.jpg
[15] => 143705.jpg
[foto2] => 143705.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:19
[fecha] => 2024-07-16 11:02:19
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 6826
[visitas] => 6826
[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] => NIÑOS
[genero] => NIÑOS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => NIÑOS
[codigoGenero] => NIÑOS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 395300
[precio] => 395300
[52] => 59
[precio_usd] => 59
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773064AKV01
[codigo_ws] => 773064AKV01
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773064AV01
[cod_articulo] => 773064AV01
[1] => 9513044
[id] => 9513044
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY AWAY JERSEY
[producto] => PARAGUAY AWAY JERSEY
[11] => 773064AV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143694.png
[foto1] => 143694.png
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:20
[fecha] => 2024-07-16 11:02:20
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 12382
[visitas] => 12382
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 435500
[precio] => 435500
[52] => 65
[precio_usd] => 65
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773064AV01
[codigo_ws] => 773064AV01
[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] => 507000
[precio_retail] => 507000
[69] => 507000
[precio_final] => 507000
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773064AWV01
[cod_articulo] => 773064AWV01
[1] => 9513045
[id] => 9513045
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY AWAY JERSEY WOMAN
[producto] => PARAGUAY AWAY JERSEY WOMAN
[11] => 773064AWV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143701.jpg
[foto1] => 143701.jpg
[15] => 143703.jpg
[foto2] => 143703.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:20
[fecha] => 2024-07-16 11:02:20
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 6646
[visitas] => 6646
[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] => DAMAS
[genero] => DAMAS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => DAMAS
[codigoGenero] => DAMAS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 422100
[precio] => 422100
[52] => 63
[precio_usd] => 63
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773064AWV01
[codigo_ws] => 773064AWV01
[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] => 491400
[precio_retail] => 491400
[69] => 491400
[precio_final] => 491400
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773407ABV01
[cod_articulo] => 773407ABV01
[1] => 10891207
[id] => 10891207
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY HOME BABY JERSEY
[producto] => PARAGUAY HOME BABY JERSEY
[11] => 773407ABV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 161606.jpg
[foto1] => 161606.jpg
[15] => 161607.jpg
[foto2] => 161607.jpg
[16] => 161608.jpg
[foto3] => 161608.jpg
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-05-22 01:23:23
[fecha] => 2025-05-22 01:23:23
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 8450
[visitas] => 8450
[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] => NIÑOS
[genero] => NIÑOS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => NIÑOS
[codigoGenero] => NIÑOS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 127300
[precio] => 127300
[52] => 19
[precio_usd] => 19
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773407ABV01
[codigo_ws] => 773407ABV01
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773407AKV01
[cod_articulo] => 773407AKV01
[1] => 9513046
[id] => 9513046
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY HOME JERSEY KIDS
[producto] => PARAGUAY HOME JERSEY KIDS
[11] => 773407AKV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143697.jpg
[foto1] => 143697.jpg
[15] => 143698.jpg
[foto2] => 143698.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:20
[fecha] => 2024-07-16 11:02:20
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 15089
[visitas] => 15089
[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] => NIÑOS
[genero] => NIÑOS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => NIÑOS
[codigoGenero] => NIÑOS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 395300
[precio] => 395300
[52] => 59
[precio_usd] => 59
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773407AKV01
[codigo_ws] => 773407AKV01
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773407AV01
[cod_articulo] => 773407AV01
[1] => 9513047
[id] => 9513047
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY HOME JERSEY
[producto] => PARAGUAY HOME JERSEY
[11] => 773407AV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143693.png
[foto1] => 143693.png
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:20
[fecha] => 2024-07-16 11:02:20
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 43266
[visitas] => 43266
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 435500
[precio] => 435500
[52] => 65
[precio_usd] => 65
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773407AV01
[codigo_ws] => 773407AV01
[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] => 507000
[precio_retail] => 507000
[69] => 507000
[precio_final] => 507000
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 773407AWV01
[cod_articulo] => 773407AWV01
[1] => 9513048
[id] => 9513048
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY HOME JERSEY WOMAN
[producto] => PARAGUAY HOME JERSEY WOMAN
[11] => 773407AWV01
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143700.jpg
[foto1] => 143700.jpg
[15] => 143702.jpg
[foto2] => 143702.jpg
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-07-16 11:02:20
[fecha] => 2024-07-16 11:02:20
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 26549
[visitas] => 26549
[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] => DAMAS
[genero] => DAMAS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => DAMAS
[codigoGenero] => DAMAS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 422100
[precio] => 422100
[52] => 63
[precio_usd] => 63
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 773407AWV01
[codigo_ws] => 773407AWV01
[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] => 491400
[precio_retail] => 491400
[69] => 491400
[precio_final] => 491400
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 774029VT02
[cod_articulo] => 774029VT02
[1] => 10408975
[id] => 10408975
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY CASUALS TEE
[producto] => PARAGUAY CASUALS TEE
[11] => 774029VT02
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 159668.jpg
[foto1] => 159668.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-02-06 01:37:00
[fecha] => 2025-02-06 01:37:00
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3016
[visitas] => 3016
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-01-05 01:00:01
[updated_at] => 2026-01-05 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 142000
[precio] => 142000
[52] => 20
[precio_usd] => 20
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 774029VT02
[codigo_ws] => 774029VT02
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 774029VT03
[cod_articulo] => 774029VT03
[1] => 10373469
[id] => 10373469
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => PARAGUAY CASUALS TEE
[producto] => PARAGUAY CASUALS TEE
[11] => 774029VT03
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 159510.jpg
[foto1] => 159510.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-01-29 01:22:44
[fecha] => 2025-01-29 01:22:44
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3047
[visitas] => 3047
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-04-26 01:00:01
[updated_at] => 2026-04-26 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 134000
[precio] => 134000
[52] => 20
[precio_usd] => 20
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 774029VT03
[codigo_ws] => 774029VT03
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => 77454401
[cod_articulo] => 77454401
[1] => 11601666
[id] => 11601666
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => APF HOME JERSEY PROMO
[producto] => APF HOME JERSEY PROMO
[11] => 77454401
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 143708.jpg
[foto1] => 143708.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2025-10-25 01:23:18
[fecha] => 2025-10-25 01:23:18
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3307
[visitas] => 3307
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-01-10 01:00:01
[updated_at] => 2026-01-10 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => FRENCH SIZE
[grupoMedida] => FRENCH SIZE
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 639000
[precio] => 639000
[52] => 90
[precio_usd] => 90
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => 77454401
[codigo_ws] => 77454401
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => M76591001
[cod_articulo] => M76591001
[1] => 10041900
[id] => 10041900
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => APF HOME JERSEY PROMO PUMA
[producto] => APF HOME JERSEY PROMO PUMA
[11] => M76591001
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 158281.jpg
[foto1] => 158281.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-11-17 01:34:34
[fecha] => 2024-11-17 01:34:34
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 7764
[visitas] => 7764
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-01-05 01:00:01
[updated_at] => 2026-01-05 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 461500
[precio] => 461500
[52] => 65
[precio_usd] => 65
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => M76591001
[codigo_ws] => M76591001
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
Array
(
[0] => M76591202
[cod_articulo] => M76591202
[1] => 10041901
[id] => 10041901
[2] => 6
[cod_rubro] => 6
[3] => PRENDAS
[rubro] => PRENDAS
[4] => 118
[cod_familia] => 118
[5] => REMERAS - CAMISETAS
[familia] => REMERAS - CAMISETAS
[6] =>
[cod_linea] =>
[7] =>
[linea] =>
[8] => 1
[cod_marca] => 1
[9] => PUMA
[marca] => PUMA
[10] => APF AWAY JERSEY PROMO
[producto] => APF AWAY JERSEY PROMO
[11] => M76591202
[12] =>
[descripcion] =>
[13] =>
[especificaciones] =>
[14] => 158282.jpg
[foto1] => 158282.jpg
[15] =>
[foto2] =>
[16] =>
[foto3] =>
[17] =>
[foto4] =>
[18] =>
[foto5] =>
[19] =>
[foto6] =>
[20] => 2024-11-17 01:34:34
[fecha] => 2024-11-17 01:34:34
[21] => 1
[visible] => 1
[22] => 1
[visible_seteo] => 1
[23] => 3909
[visitas] => 3909
[24] => 0
[lanzamiento] => 0
[25] => 0
[destacado] => 0
[26] => 0
[top] => 0
[27] => 0
[cod_creador] => 0
[28] => WEB SERVICE
[creador] => WEB SERVICE
[29] => 3
[cod_empresa] => 3
[30] => Sport House
[empresa] => Sport House
[31] =>
[medida] =>
[32] => CABALLEROS
[genero] => CABALLEROS
[33] => FUTBOL
[modalidad] => FUTBOL
[34] =>
[codigo] =>
[35] => 2026-01-05 01:00:01
[updated_at] => 2026-01-05 01:00:01
[36] => 001
[marca_ws] => 001
[37] => PRE
[cod_rubro_ws] => PRE
[38] =>
[cod_familia_ws] =>
[39] =>
[codigoGrupoMedida] =>
[40] => UK
[grupoMedida] => UK
[41] => CABALLEROS
[codigoGenero] => CABALLEROS
[42] => 5
[codigoModalidad] => 5
[43] => 4
[codigoColeccion] => 4
[44] => Paraguay
[Coleccion] => Paraguay
[45] =>
[codigoEstilo] =>
[46] => DEPORTIVO
[Estilo] => DEPORTIVO
[47] => 35
[largo] => 35
[48] => 5
[alto] => 5
[49] => 30
[ancho] => 30
[50] => 0.2
[peso] => 0.2
[51] => 461500
[precio] => 461500
[52] => 65
[precio_usd] => 65
[53] =>
[descuento] =>
[54] => 0
[sale] => 0
[55] => M76591202
[codigo_ws] => M76591202
[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 p.Coleccion = 'Paraguay' AND cod_marca='1' AND visible = 1 AND puma_flag='1' AND disponible_online ORDER BY cod_articulo ASC LIMIT 0, 36
