SELECT title, bibNumber, COUNT(bibNumber) AS counts,

# 2006
SUM(CASE
   WHEN (YEAR(cout) = 2006 and month (cout) = 1) THEN 1
   ELSE 0
END) AS '2006-1',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2006-2',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2006-3',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2006-4',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2006-5',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2006-6',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2006-7',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2006-8',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2006-9',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2006-10',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2006-11',

SUM(CASE
   WHEN (YEAR(cout) = 2006 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2006-12',

# 2007
SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2007-1',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2007-2',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2007-3',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2007-4',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2007-5',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2007-6',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2007-7',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2007-8',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2007-9',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2007-10',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2007-11',

SUM(CASE
   WHEN (YEAR(cout) = 2007 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2007-12',

# 2008
SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2008-1',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2008-2',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2008-3',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2008-4',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2008-5',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2008-6',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2008-7',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2008-8',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2008-9',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2008-10',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2008-11',

SUM(CASE
   WHEN (YEAR(cout) = 2008 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2008-12',

# 2009
SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2009-1',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2009-2',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2009-3',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2009-4',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2009-5',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2009-6',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2009-7',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2009-8',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2009-9',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2009-10',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2009-11',

SUM(CASE
   WHEN (YEAR(cout) = 2009 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2009-12',

# 2010
SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2010-1',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2010-2',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2010-3',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2010-4',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2010-5',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2010-6',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2010-7',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2010-8',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2010-9',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2010-10',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2010-11',

SUM(CASE
   WHEN (YEAR(cout) = 2010 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2010-12',

# 2011
SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2011-1',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2011-2',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2011-3',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2011-4',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2011-5',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2011-6',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2011-7',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2011-8',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2011-9',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2011-10',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2011-11',

SUM(CASE
   WHEN (YEAR(cout) = 2011 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2011-12',

# 2012
SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2012-1',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2012-2',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2012-3',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2012-4',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2012-5',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2012-6',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2012-7',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2012-8',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2012-9',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2012-10',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2012-11',

SUM(CASE
   WHEN (YEAR(cout) = 2012 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2012-12',

# 2013
SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2013-1',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2013-2',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2013-3',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2013-4',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2013-5',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2013-6',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2013-7',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2013-8',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2013-9',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2013-10',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2013-11',

SUM(CASE
   WHEN (YEAR(cout) = 2013 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2013-12',

# 2014
SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2014-1',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2014-2',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2014-3',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2014-4',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2014-5',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2014-6',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2014-7',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2014-8',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2014-9',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2014-10',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2014-11',

SUM(CASE
   WHEN (YEAR(cout) = 2014 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2014-12',

# 2015
SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2015-1',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2015-2',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2015-3',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2015-4',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2015-5',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2015-6',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2015-7',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2015-8',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2015-9',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2015-10',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2015-11',

SUM(CASE
   WHEN (YEAR(cout) = 2015 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2015-12',

# 2016
SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2016-1',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2016-2',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2016-3',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2016-4',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2016-5',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2016-6',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2016-7',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2016-8',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2016-9',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2016-10',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2016-11',

SUM(CASE
   WHEN (YEAR(cout) = 2016 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2016-12',

# 2017
SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 1) THEN 1
   ELSE 0
END) AS '2017-1',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 2) THEN 1
   ELSE 0
END) AS '2017-2',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 3) THEN 1
   ELSE 0
END) AS '2017-3',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 4) THEN 1
   ELSE 0
END) AS '2017-4',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 5) THEN 1
   ELSE 0
END) AS '2017-5',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 6) THEN 1
   ELSE 0
END) AS '2017-6',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 7) THEN 1
   ELSE 0
END) AS '2017-7',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 8) THEN 1
   ELSE 0
END) AS '2017-8',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 9) THEN 1
   ELSE 0
END) AS '2017-9',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 10) THEN 1
   ELSE 0
END) AS '2017-10',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 11) THEN 1
   ELSE 0 
END) AS '2017-11',

SUM(CASE
   WHEN (YEAR(cout) = 2017 and month(cout) = 12) THEN 1
   ELSE 0
END) AS '2017-12'

FROM
spl_2016.outraw

WHERE
   (bibNumber = '3008726') #1
   OR (bibNumber = '3077814') #2
    OR (bibNumber = '2290181') #3
    OR (bibNumber = '2368106') #4
    OR (bibNumber = '3201929') #5
    OR (bibNumber = '3255843') #6
    OR (bibNumber = '1969986') #7
    OR (bibNumber = '2430480') #8
    OR (bibNumber = '3122735') #9
    OR (bibNumber = '2627029') #10 !!!!
    OR (bibNumber = '3167619') #11
    OR (bibNumber = '2617983') #12
    OR (bibNumber = '2969106') #13
    OR (bibNumber = '2332111') #14
    OR (bibNumber = '3171454') #15 ****
    OR (bibNumber = '2603334') #16
    OR (bibNumber = '2539072') #17
    OR (bibNumber = '2112099') #18
    OR (bibNumber = '2662999') #19
    OR (bibNumber = '2940670') #20 !!!!
    OR (bibNumber = '2458866') #21
    OR (bibNumber = '2086099') #22
    OR (bibNumber = '2953130') #25
    OR (bibNumber = '3107624') #26
    OR (bibNumber = '2369568') #27
    OR (bibNumber = '3002627') #28
    OR (bibNumber = '2805744') #29
    OR (bibNumber = '1775275') #30 !!!!
    
    
GROUP BY bibNumber , title
ORDER BY counts DESC