Here are three upcoming live drafts.
SELECT * FROM (SELECT ' ', g.NAME, g.ID, TO_CHAR (dt.draft_time, 'Dy, fmMMfm/DD @fmHHfmpm') || ' EST' FROM draft_times dt, GROUPS g, div d WHERE dt.GROUP_ID IS NOT NULL AND dt.draft_time > (SYSDATE + 1/24) AND g.ID = dt.GROUP_ID AND d.GROUP_ID = dt.GROUP_ID AND d.closed = 0 AND d.drafted = 0 AND d.keeper = 0 AND NVL (d.div_max, 0) = 0 AND d.team_count > 0 AND d.PASSWORD IS NULL ORDER BY dt.draft_time ASC) WHERE ROWNUM <= 3

&FIELD_4& &FIELD_2& » view league

Click here to view a list of all
upcoming drafts.