((year(a.gamedate) = 2002 and a.gamedate < '2002-07-09') or (year(a.gamedate) = 2003 and a.gamedate < '2003-07-15') or (year(a.gamedate) = 2004 and a.gamedate < '2004-07-13') or (year(a.gamedate) = 2005 and a.gamedate < '2005-07-12') or (year(a.gamedate) = 2006 and a.gamedate < '2006-07-11') or (year(a.gamedate) = 2007 and a.gamedate < '2007-07-10') or (year(a.gamedate) = 2008 and a.gamedate < '2008-07-15') or (year(a.gamedate) = 2009 and a.gamedate < '2009-07-14') or (year(a.gamedate) = 2010 and a.gamedate < '2010-07-13') or (year(a.gamedate) = 2011 and a.gamedate < '2011-07-12') or (year(a.gamedate) = 2012 and a.gamedate < '2012-07-10') or (year(a.gamedate) = 2013 and a.gamedate < '2013-07-16') or (year(a.gamedate) = 2014 and a.gamedate < '2014-07-15') or (year(a.gamedate) = 2015 and a.gamedate < '2015-07-13') or (year(a.gamedate) = 2016 and a.gamedate < '2016-07-11') or (year(a.gamedate) = 2017 and a.gamedate < '2017-07-11') or (year(a.gamedate) = 2018 and a.gamedate < '2018-07-17') or (year(a.gamedate) = 2019 and a.gamedate < '2019-07-09') or (year(a.gamedate) = 2020 and a.gamedate < '2020-08-24') or (year(a.gamedate) = 2021 and a.gamedate < '2021-07-13') or (year(a.gamedate) = 2022 and a.gamedate < '2022-07-19') or (year(a.gamedate) = 2023 and a.gamedate < '2023-07-11') or (year(a.gamedate) = 2024 and a.gamedate < '2024-07-16') or (year(a.gamedate) = 2025 and a.gamedate < '2025-07-15') )