1 | SELECT `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` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00' ORDER BY `Obra`.`fecha_fin` DESC LIMIT 100 | | 1 | 1 | 10 |
2 | SELECT 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` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00' | | 1 | 1 | 3 |
3 | SELECT 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` >= '2017-01-01 00:00:00' AND `fecha_fin` <= '2017-12-31 00:00:00' | | 1 | 1 | 2 |
4 | SELECT 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' | | 1 | 1 | 1 |
5 | SELECT 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' | | 1 | 1 | 1 |
6 | SELECT 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' | | 1 | 1 | 1 |
7 | SELECT 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' | | 1 | 1 | 1 |
8 | SELECT 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' | | 1 | 1 | 1 |
9 | SELECT 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' | | 1 | 1 | 1 |
10 | SELECT `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/2014' AND `SeoUri`.`is_approved` = '1' LIMIT 1 | | 0 | 0 | 1 |
11 | SELECT `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/2014' AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 1 |
12 | SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 1 |
13 | SELECT `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/2014' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1 | | 0 | 0 | 0 |