• Home
  • Video Gallery
(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` = 'video' LIMIT 1110
5SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE is_video_avail='1'660
6SELECT `Video`.`title`, `Video`.`video_url` FROM `mec_realport03`.`videos` AS `Video` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`Video`.`city`=`City`.`id` AND LOWER(`City`.`name`)='abbotsford') WHERE type=1 ORDER BY `Video`.`created` DESC770
7SELECT `Video`.`title`, `Video`.`video_url` FROM `mec_realport03`.`videos` AS `Video` WHERE type=2 ORDER BY `Video`.`created` DESC770