SET datefirst 1;


SELECT * FROM

  (
    SELECT COUNT(DISTINCT wagers.customerid)             AS CustomerIDCount,
           SUM(wagers.bookvolume)                        AS BookVolumeSum,
           CONVERT(INT, CEILING(SUM(wagers.wagercount))) AS WagerCount,
           Datepart(MONTH, wagers.gradeddate)           AS GradedMonth,
           YEAR(wagers.gradeddate)                       AS GradedYear,
           events.sport AS EventSport
           SUBSTRING(wagers.userwagergroup, 0, charindex('-', SUBSTRING(val, START, len(val)))-2) AS Platform
           SUBSTRING(wagers.userwagergroup, charindex('^', SUBSTRING(val, START, len(val))) + 1, LEN(wagers.userwagergroup) - 1) AS VIEW

           CASE WHEN wagertypes.wagertype = 'Parlay' THEN 'Parlay'
                ELSE 'Straight' END AS WagerType
    FROM   olap.vfactwagers wagers
           INNER JOIN olap.vdimcustomers customers
                   ON wagers.customerid = customers.customerid
           INNER JOIN olap.vdimwagertypes wagertypes
                   ON wagers.wagertypecode = wagertypes.wagertypecode
           INNER JOIN olap.vdimeventlines events
                   ON wagers.eventlineid = events.eventlineid
                      AND wagers.periodnum = events.periodnum
                      AND wagers.sportid = events.sportid

    WHERE  ( wagers.gradeddate >= dateadd(MONTH, -26, DATEDIFF(DAY, 0, GETDATE()))
    AND ( customers.istestaccount = '0' )

    GROUP  BY YEAR(wagers.gradeddate),
              Datepart(MONTH, wagers.gradeddate),
              wagertypes.wagertype
  ) AS tempTable


WHERE tempTable.CustomerCountry IN ?selected_country
AND tempTable.EventSport IN ?selected_sport
AND tempTable.VIEW IN ?selected_view
AND tempTable.Platform IN ?selected_platform