Nacional / Costa del Pacífico

SELECT * FROM `contents` WHERE `id` = '36845' LIMIT 1

UPDATE `contents` SET `viewed` = '252', `updated_at` = '2026-03-26 03:59:14' WHERE `id` = '36845'

SELECT *, MATCH(`name`,`summary`,`content`) AGAINST ("Por mala calidad en las vías, Unión de Comunidades Indígenas pide frenar el Tren Interoceánico") AS score FROM `contents` WHERE (MATCH(`name`,`summary`,`content`) AGAINST ("Por mala calidad en las vías, Unión de Comunidades Indígenas pide frenar el Tren Interoceánico")) AND `published` = '1' AND `filename` != '' AND `id` != '36845' AND DATE(created_at) >= CURDATE() - INTERVAL 1 MONTH ORDER BY `score` DESC LIMIT 3

SELECT * FROM `authors` WHERE `id` IN ('1')

SELECT * FROM `categories` WHERE `id` IN ('8', '1', '5')

SELECT * FROM `subcategories` WHERE `id` IN ('14', '27', '51')

SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC

SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC

SELECT * FROM `website` WHERE `id` = '1' LIMIT 1

SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' AND DATE(created_at) >= CURDATE() - INTERVAL 7 DAY ORDER BY `viewed` DESC, `created_at` DESC LIMIT 10

SELECT * FROM `authors` WHERE `id` IN ('1')

SELECT * FROM `categories` WHERE `id` IN ('2', '1', '8', '4', '5')

SELECT * FROM `subcategories` WHERE `id` IN ('38', '27', '39', '3', '43', '8', '25', '36')

SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10

SELECT * FROM `authors` WHERE `id` IN ('1')

SELECT * FROM `categories` WHERE `id` IN ('2', '1', '5', '3', '4', '8')

SELECT * FROM `subcategories` WHERE `id` IN ('38', '27', '12', '63', '24', '11', '49', '17', '22')

SELECT * FROM `website` WHERE `id` = '1' LIMIT 1

SELECT * FROM `authors` WHERE `id` = '1' LIMIT 1

SELECT * FROM `categories` WHERE `id` = '1' LIMIT 1

SELECT * FROM `subcategories` WHERE `id` = '26' LIMIT 1

SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5

SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6

SELECT * FROM `municipios` WHERE `id` IN ('2010', '1877', '2458')

SELECT * FROM `estados` WHERE `id` IN ('25', '28', '33')

SELECT * FROM `agentes` WHERE `id` IN ('1')

SELECT * FROM `advertising` WHERE `published` = '1' AND `filename1` != '' ORDER BY RAND() ASC LIMIT 1

SELECT * FROM `photosizes` WHERE `id` = '3' LIMIT 1