2014 Canadian Mixed Pairs Championships
September 7 - 13, 2014
Parksville LBC, Parksville, BC
Query failed: SELECT round AS 'idx', CONCAT(DATE_FORMAT(dt1, '%a %b %e'), ' - Round ', round) AS 'value', DATE_FORMAT(dt1, '%Y-%m-%d') AS 'Date', t2.Min_DT FROM (SELECT DISTINCT date_time AS dt1, round FROM Match_sched_2014 WHERE year = 2014 AND tourney LIKE 'mx_pr' AND medal IS NULL ) AS ms, (SELECT DATE_FORMAT(MIN(date_time), '%Y-%m-%d') AS Min_DT, MIN(date_time) AS dt_min FROM Match_sched_2014 WHERE year = 2014 AND tourney LIKE 'mx_pr' AND medal IS NULL GROUP BY tourney) AS t2 ORDER BY dt1, round