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 12 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'111
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` >= '2018-01-01 00:00:00' AND `fecha_fin` <= '2018-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` >= '2019-01-01 00:00:00' AND `fecha_fin` <= '2019-12-31 00:00:00'111
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` >= '2020-01-01 00:00:00' AND `fecha_fin` <= '2020-12-31 00:00:00'111
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` >= '2021-01-01 00:00:00' AND `fecha_fin` <= '2021-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` >= '2022-01-01 00:00:00' AND `fecha_fin` <= '2022-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` >= '2023-01-01 00:00:00' AND `fecha_fin` <= '2023-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` >= '2024-01-01 00:00:00' AND `fecha_fin` <= '2024-12-31 00:00:00'111
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 1000
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'000
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