Brimble.com Playoff Pool - Games 1539919938756 0.019

  • Home
  • My Picks
  • Round Results
  • Playoff Results
  • Overall Results
  • Schedule
  • Games
  • Message Board
  • NFL.com
  • Games


    query=select week as w, game as g, date, (select current_timestamp() >= (select date_add(date, interval +12 hour)) from games_p where game=g and week=w and year='2017') as locked, (select count(*) from picks_p where winner is not null and picks_p.game=games_p.game and picks_p.week=games_p.week and picks_p.year=games_p.year) as npicks, vteam, (select count(*)*locked/npicks from picks_p where winner=vteam and picks_p.game=games_p.game and picks_p.week=games_p.week and picks_p.year=games_p.year) as vptw, vscore, hteam, (select count(*)*locked/npicks from picks_p where winner=hteam and picks_p.game=games_p.game and picks_p.week=games_p.week and picks_p.year=games_p.year) as hptw, hscore, (select if(vptw is null,0,if(vptw>hptw,vptw, hptw))) as mptw, (select if(vptw>hptw,concat(round(vptw*100),'% ',vteam),if(hptw>vptw,concat(round(hptw*100),'% ',hteam),if(vptw+hptw=0 or vptw is null,'-','50% each')))) as ptw, if(vscore>hscore,vteam,if(hscore>vscore,hteam,null)) as winner from games_p where year='2017' and week=2 order by w, game
    Round 2, 2017

    Show round: all 1 2 3 4

    Note: The PTW column shows the team picked to win by more players and the percentage of players picking that team. This data is masked until the week is locked.


    Round Game Date Visitor Score Home Score PTW Winner
    2 1 2018-01-13 ATL 10 PHI 15 48% PHI PHI
    2 2 2018-01-13 TEN 14 NE 35 83% NE NE
    2 3 2018-01-14 JAX 45 PIT 42 83% PIT JAX
    2 4 2018-01-14 NO 24 MIN 29 65% MIN MIN
    Click a column header to sort the table.


    Change year: