Notice (8): Undefined variable: proyFin [APP/Controller/ObrasController.php, line 100]
Warning (2): Cannot modify header information - headers already sent by (output started at /home/inviasa/sites/inviasa/current/public/lib/Cake/Utility/Debugger.php:800) [CORE/Cake/Network/CakeResponse.php, line 444]
Obras · Listado de las obras que ya han sido ejecutadas

Obras realizadas durante el año 2016

Proyectos ejecutados recientemente

Obras finalizadas

Histórico de nuestro trabajo

(default) 13 queries took 16 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Obra`.`id`, `Obra`.`title`, `Obra`.`subtitle`, `Obra`.`distrito`, `Obra`.`cliente`, `Obra`.`body`, `Obra`.`body_data`, `Obra`.`body_html_clean`, `Obra`.`user_id`, `Obra`.`url_slug`, `Obra`.`afecciones`, `Obra`.`motivo_obra`, `Obra`.`activo`, `Obra`.`fecha`, `Obra`.`fecha_fin`, `Obra`.`estado_obra`, `Obra`.`latitud`, `Obra`.`longitud`, `Obra`.`localizacion_obra`, `Obra`.`tags`, `Obra`.`created`, `Obra`.`modified` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2016-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2016-12-31 00:00:00' ORDER BY `Obra`.`fecha_fin` DESC LIMIT 10090903
2SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2016-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2016-12-31 00:00:00'112
3SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2019-01-01 00:00:00' AND `fecha_fin` <= '2019-12-31 00:00:00'112
4SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2020-01-01 00:00:00' AND `fecha_fin` <= '2020-12-31 00:00:00'112
5SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2021-01-01 00:00:00' AND `fecha_fin` <= '2021-12-31 00:00:00'112
6SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2022-01-01 00:00:00' AND `fecha_fin` <= '2022-12-31 00:00:00'111
7SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2023-01-01 00:00:00' AND `fecha_fin` <= '2023-12-31 00:00:00'111
8SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2024-01-01 00:00:00' AND `fecha_fin` <= '2024-12-31 00:00:00'111
9SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2025-01-01 00:00:00' AND `fecha_fin` <= '2025-12-31 00:00:00'110
10SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_titles` AS `SeoTitle` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2016' AND `SeoUri`.`is_approved` = '1' LIMIT 1001
11SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2016' AND `SeoUri`.`is_approved` = '1'001
12SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1'000
13SELECT `SeoCanonical`.`canonical` FROM `inviasa_inv`.`seo_canonicals` AS `SeoCanonical` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoCanonical`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2016' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1000