DB Queries (10 total)
0 = SELECT * FROM `page` AS p, `mods` AS m WHERE p.page_title = 'compare candidates' AND p.mod_id = m.mod_id AND m.mod_type = 'PAGE' LIMIT 1
1 = SELECT * FROM page WHERE page_is_active = '1' AND page_hide_from_menu = '0' ORDER BY page_parent_id ASC, page_sort_order ASC
2 = INSERT INTO user_online VALUES ('1575818136', '3.231.229.89', 't5k5voa8g92ae3f47211k2k9s1', '0', '/compare-candidates/candidates/level/mpp/province/nb/riding/1074')
3 = DELETE FROM user_online WHERE timestamp <= '1575818036'
4 = SELECT COUNT(DISTINCT(session_id)) FROM user_online
5 = SELECT COUNT(DISTINCT(session_id)) FROM user_online WHERE user_id != '0'
6 = SELECT * FROM province ORDER BY province_title ASC
7 = SELECT c.candidate_id, c.candidate_first_name, c.candidate_last_name, c.candidate_clc_rating, c.candidate_light_rating, cs.`candidate_status_id`, cs.`candidate_status_text`, p.party_name, c.candidate_clc_rating, c.candidate_light_rating, c.candidate_image, r.riding_name_eng, r.riding_id, r.riding_province FROM candidate AS c LEFT JOIN party AS p ON p.party_id = c.party_id LEFT JOIN riding AS r ON r.riding_id = c.riding_code LEFT JOIN candidate_status AS cs ON cs.candidate_status_id = c.candidate_status_id WHERE r.`riding_active` = 1 AND candidate_type LIKE 'nb' AND r.riding_province = 'nb' AND r.riding_id = 1074 AND c.candidate_status_id IN ( 1, 4, 5 )ORDER BY c.`candidate_light_rating`, p.`party_sort_order_mp`
8 = SELECT evaluation_election_year FROM evaluation WHERE evaluation_id = 15 LIMIT 1
9 = SELECT * FROM `page_feature` AS pf, `mods` AS m WHERE pf.mod_id = m.mod_id AND pf.feature_is_active = 1