Featured in the Media
No Result Found
(default) 7 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `City`.`id`, `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE 1 = 1880
2SELECT `Province`.`id`, `Province`.`name`, `Province`.`province_code`, `Province`.`status`, `Province`.`created`, `Province`.`modified` FROM `mec_realport03`.`provinces` AS `Province` WHERE 1 = 1 ORDER BY `name` asc440
3SELECT `City`.`id`, `City`.`name`, `City`.`province_id`, `City`.`display_image`, `City`.`is_video_avail`, `City`.`content`, `City`.`status`, `City`.`created`, `City`.`modified`, `City`.`student_resource`, `City`.`citiescol` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`province_id` IN (2, 1, 4, 3) 880
4SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = 'media' LIMIT 1110
5SELECT `Article`.`id`, `Article`.`title`, `Article`.`file_name`, `Article`.`link_url`, `Article`.`publish_date` FROM `mec_realport03`.`articles` AS `Article` WHERE `type` = 'video' AND `status` = 'active' ORDER BY `Article`.`publish_date` desc LIMIT 20110
6SELECT COUNT(*) AS `count` FROM `mec_realport03`.`articles` AS `Article` WHERE `type` = 'video' AND `status` = 'active'110
7SELECT `Article`.`id`, `Article`.`title`, `Article`.`description`, `Article`.`image_name`, `Article`.`file_name`, `Article`.`link_url`, `Article`.`publish_date` FROM `mec_realport03`.`articles` AS `Article` WHERE `type` = 'article' AND `status` = 'active' AND YEAR(publish_date) = '2017' ORDER BY `Article`.`publish_date` desc LIMIT 5000