SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mint' in 'field list' with query: SELECT id as station, mint, ob, DATE_FORMAT('2022-11-01 00:00:00', '%W, %M %D, %Y') as startfulldate, DATE_FORMAT(ob, '%W, %M %D, %Y') as endfulldate, DATE_FORMAT('2022-11-01 00:00:00', '%b %D') as startmd, DATE_FORMAT(ob, '%b %D') as endmd, YEAR(ob) as year, IF(DATE_FORMAT('2022-11-01 00:00:00', '%Y') = DATE_FORMAT(ob, '%Y'), DATE_FORMAT('2022-11-06 23:59:59', '%Y'), CONCAT(DATE_FORMAT('2022-11-01 00:00:00', '%Y'),'-',DATE_FORMAT(ob, '%Y'))) as years,1+(DATEDIFF(ob,'2022-11-01 00:00:00')) as diff,1 as obsperday, IF(DATE_FORMAT('2022-11-01 00:00:00', '%Y-%m-%d') = DATE_FORMAT(ob, '%Y-%m-%d'), DATE_FORMAT(ob, '%b. %D, %Y'), CONCAT(DATE_FORMAT('2022-11-01 00:00:00', '%m/%d/%y'),' - ',DATE_FORMAT(ob, '%m/%d/%y'))) as daterange,1 as num_obs, numobs, len23p33, sdatemaxlen23p33, edatemaxlen23p33, maxlen23p33, totallen23p33,len17p78, sdatemaxlen17p78, edatemaxlen17p78, maxlen17p78, totallen17p78,len12p22, sdatemaxlen12p22, edatemaxlen12p22, maxlen12p22, totallen12p22,len6p67, sdatemaxlen6p67, edatemaxlen6p67, maxlen6p67, totallen6p67,len1p11, sdatemaxlen1p11, edatemaxlen1p11, maxlen1p11, totallen1p11,le0, sdatemaxle0, edatemaxle0, maxle0, totalle0,gt0, sdatemaxgt0, edatemaxgt0, maxgt0, totalgt0,le4p45, sdatemaxle4p45, edatemaxle4p45, maxle4p45, totalle4p45,le10, sdatemaxle10, edatemaxle10, maxle10, totalle10,le15p56, sdatemaxle15p56, edatemaxle15p56, maxle15p56, totalle15p56,le21p11, sdatemaxle21p11, edatemaxle21p11, maxle21p11, totalle21p11,ge21p11, sdatemaxge21p11, edatemaxge21p11, maxge21p11, totalge21p11,le26p67, sdatemaxle26p67, edatemaxle26p67, maxle26p67, totalle26p67,ge29p44, sdatemaxge29p44, edatemaxge29p44, maxge29p44, totalge29p44,le32p22, sdatemaxle32p22, edatemaxle32p22, maxle32p22, totalle32p22,ge35, sdatemaxge35, edatemaxge35, maxge35, totalge35,le37p78, sdatemaxle37p78, edatemaxle37p78, maxle37p78, totalle37p78,le43p33, sdatemaxle43p33, edatemaxle43p33, maxle43p33, totalle43p33 FROM (SELECT *,@'totobs':=IF(ob,@'totobs'+1,@'totobs') as 'numobs',@'clen23p33':=IF(ROUND(mint,2)<=-23.33,@'clen23p33'+1,0) as 'len23p33',@'mlen23p33':=IF(@'clen23p33'>=@'mlen23p33',@'clen23p33',@'mlen23p33') as 'maxlen23p33',@'tlen23p33':=IF(@'clen23p33'>0,@'tlen23p33'+1,@'tlen23p33') as 'totallen23p33',@'sdlen23p33':=IF(@'clen23p33'>=@'mlen23p33' AND @'clen23p33'>0,CAST(DATE_SUB(ob, INTERVAL (@'clen23p33' - 1) DAY) as DATE),@'sdlen23p33') as 'sdatemaxlen23p33',@'edlen23p33':=IF(@'clen23p33'>=@'mlen23p33' AND @'clen23p33'>0,CAST(ob as DATE),@'edlen23p33') as 'edatemaxlen23p33',@'clen17p78':=IF(ROUND(mint,2)<=-17.78,@'clen17p78'+1,0) as 'len17p78',@'mlen17p78':=IF(@'clen17p78'>=@'mlen17p78',@'clen17p78',@'mlen17p78') as 'maxlen17p78',@'tlen17p78':=IF(@'clen17p78'>0,@'tlen17p78'+1,@'tlen17p78') as 'totallen17p78',@'sdlen17p78':=IF(@'clen17p78'>=@'mlen17p78' AND @'clen17p78'>0,CAST(DATE_SUB(ob, INTERVAL (@'clen17p78' - 1) DAY) as DATE),@'sdlen17p78') as 'sdatemaxlen17p78',@'edlen17p78':=IF(@'clen17p78'>=@'mlen17p78' AND @'clen17p78'>0,CAST(ob as DATE),@'edlen17p78') as 'edatemaxlen17p78',@'clen12p22':=IF(ROUND(mint,2)<=-12.22,@'clen12p22'+1,0) as 'len12p22',@'mlen12p22':=IF(@'clen12p22'>=@'mlen12p22',@'clen12p22',@'mlen12p22') as 'maxlen12p22',@'tlen12p22':=IF(@'clen12p22'>0,@'tlen12p22'+1,@'tlen12p22') as 'totallen12p22',@'sdlen12p22':=IF(@'clen12p22'>=@'mlen12p22' AND @'clen12p22'>0,CAST(DATE_SUB(ob, INTERVAL (@'clen12p22' - 1) DAY) as DATE),@'sdlen12p22') as 'sdatemaxlen12p22',@'edlen12p22':=IF(@'clen12p22'>=@'mlen12p22' AND @'clen12p22'>0,CAST(ob as DATE),@'edlen12p22') as 'edatemaxlen12p22',@'clen6p67':=IF(ROUND(mint,2)<=-6.67,@'clen6p67'+1,0) as 'len6p67',@'mlen6p67':=IF(@'clen6p67'>=@'mlen6p67',@'clen6p67',@'mlen6p67') as 'maxlen6p67',@'tlen6p67':=IF(@'clen6p67'>0,@'tlen6p67'+1,@'tlen6p67') as 'totallen6p67',@'sdlen6p67':=IF(@'clen6p67'>=@'mlen6p67' AND @'clen6p67'>0,CAST(DATE_SUB(ob, INTERVAL (@'clen6p67' - 1) DAY) as DATE),@'sdlen6p67') as 'sdatemaxlen6p67',@'edlen6p67':=IF(@'clen6p67'>=@'mlen6p67' AND @'clen6p67'>0,CAST(ob as DATE),@'edlen6p67') as 'edatemaxlen6p67',@'clen1p11':=IF(ROUND(mint,2)<=-1.11,@'clen1p11'+1,0) as 'len1p11',@'mlen1p11':=IF(@'clen1p11'>=@'mlen1p11',@'clen1p11',@'mlen1p11') as 'maxlen1p11',@'tlen1p11':=IF(@'clen1p11'>0,@'tlen1p11'+1,@'tlen1p11') as 'totallen1p11',@'sdlen1p11':=IF(@'clen1p11'>=@'mlen1p11' AND @'clen1p11'>0,CAST(DATE_SUB(ob, INTERVAL (@'clen1p11' - 1) DAY) as DATE),@'sdlen1p11') as 'sdatemaxlen1p11',@'edlen1p11':=IF(@'clen1p11'>=@'mlen1p11' AND @'clen1p11'>0,CAST(ob as DATE),@'edlen1p11') as 'edatemaxlen1p11',@'cle0':=IF(ROUND(mint,2)<=0,@'cle0'+1,0) as 'le0',@'mle0':=IF(@'cle0'>=@'mle0',@'cle0',@'mle0') as 'maxle0',@'tle0':=IF(@'cle0'>0,@'tle0'+1,@'tle0') as 'totalle0',@'sdle0':=IF(@'cle0'>=@'mle0' AND @'cle0'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle0' - 1) DAY) as DATE),@'sdle0') as 'sdatemaxle0',@'edle0':=IF(@'cle0'>=@'mle0' AND @'cle0'>0,CAST(ob as DATE),@'edle0') as 'edatemaxle0',@'cgt0':=IF(ROUND(mint,2)>0,@'cgt0'+1,0) as 'gt0',@'mgt0':=IF(@'cgt0'>=@'mgt0',@'cgt0',@'mgt0') as 'maxgt0',@'tgt0':=IF(@'cgt0'>0,@'tgt0'+1,@'tgt0') as 'totalgt0',@'sdgt0':=IF(@'cgt0'>=@'mgt0' AND @'cgt0'>0,CAST(DATE_SUB(ob, INTERVAL (@'cgt0' - 1) DAY) as DATE),@'sdgt0') as 'sdatemaxgt0',@'edgt0':=IF(@'cgt0'>=@'mgt0' AND @'cgt0'>0,CAST(ob as DATE),@'edgt0') as 'edatemaxgt0',@'cle4p45':=IF(ROUND(mint,2)<=4.45,@'cle4p45'+1,0) as 'le4p45',@'mle4p45':=IF(@'cle4p45'>=@'mle4p45',@'cle4p45',@'mle4p45') as 'maxle4p45',@'tle4p45':=IF(@'cle4p45'>0,@'tle4p45'+1,@'tle4p45') as 'totalle4p45',@'sdle4p45':=IF(@'cle4p45'>=@'mle4p45' AND @'cle4p45'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle4p45' - 1) DAY) as DATE),@'sdle4p45') as 'sdatemaxle4p45',@'edle4p45':=IF(@'cle4p45'>=@'mle4p45' AND @'cle4p45'>0,CAST(ob as DATE),@'edle4p45') as 'edatemaxle4p45',@'cle10':=IF(ROUND(mint,2)<=10,@'cle10'+1,0) as 'le10',@'mle10':=IF(@'cle10'>=@'mle10',@'cle10',@'mle10') as 'maxle10',@'tle10':=IF(@'cle10'>0,@'tle10'+1,@'tle10') as 'totalle10',@'sdle10':=IF(@'cle10'>=@'mle10' AND @'cle10'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle10' - 1) DAY) as DATE),@'sdle10') as 'sdatemaxle10',@'edle10':=IF(@'cle10'>=@'mle10' AND @'cle10'>0,CAST(ob as DATE),@'edle10') as 'edatemaxle10',@'cle15p56':=IF(ROUND(mint,2)<=15.56,@'cle15p56'+1,0) as 'le15p56',@'mle15p56':=IF(@'cle15p56'>=@'mle15p56',@'cle15p56',@'mle15p56') as 'maxle15p56',@'tle15p56':=IF(@'cle15p56'>0,@'tle15p56'+1,@'tle15p56') as 'totalle15p56',@'sdle15p56':=IF(@'cle15p56'>=@'mle15p56' AND @'cle15p56'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle15p56' - 1) DAY) as DATE),@'sdle15p56') as 'sdatemaxle15p56',@'edle15p56':=IF(@'cle15p56'>=@'mle15p56' AND @'cle15p56'>0,CAST(ob as DATE),@'edle15p56') as 'edatemaxle15p56',@'cle21p11':=IF(ROUND(mint,2)<=21.11,@'cle21p11'+1,0) as 'le21p11',@'mle21p11':=IF(@'cle21p11'>=@'mle21p11',@'cle21p11',@'mle21p11') as 'maxle21p11',@'tle21p11':=IF(@'cle21p11'>0,@'tle21p11'+1,@'tle21p11') as 'totalle21p11',@'sdle21p11':=IF(@'cle21p11'>=@'mle21p11' AND @'cle21p11'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle21p11' - 1) DAY) as DATE),@'sdle21p11') as 'sdatemaxle21p11',@'edle21p11':=IF(@'cle21p11'>=@'mle21p11' AND @'cle21p11'>0,CAST(ob as DATE),@'edle21p11') as 'edatemaxle21p11',@'cge21p11':=IF(ROUND(mint,2)>=21.11,@'cge21p11'+1,0) as 'ge21p11',@'mge21p11':=IF(@'cge21p11'>=@'mge21p11',@'cge21p11',@'mge21p11') as 'maxge21p11',@'tge21p11':=IF(@'cge21p11'>0,@'tge21p11'+1,@'tge21p11') as 'totalge21p11',@'sdge21p11':=IF(@'cge21p11'>=@'mge21p11' AND @'cge21p11'>0,CAST(DATE_SUB(ob, INTERVAL (@'cge21p11' - 1) DAY) as DATE),@'sdge21p11') as 'sdatemaxge21p11',@'edge21p11':=IF(@'cge21p11'>=@'mge21p11' AND @'cge21p11'>0,CAST(ob as DATE),@'edge21p11') as 'edatemaxge21p11',@'cle26p67':=IF(ROUND(mint,2)<=26.67,@'cle26p67'+1,0) as 'le26p67',@'mle26p67':=IF(@'cle26p67'>=@'mle26p67',@'cle26p67',@'mle26p67') as 'maxle26p67',@'tle26p67':=IF(@'cle26p67'>0,@'tle26p67'+1,@'tle26p67') as 'totalle26p67',@'sdle26p67':=IF(@'cle26p67'>=@'mle26p67' AND @'cle26p67'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle26p67' - 1) DAY) as DATE),@'sdle26p67') as 'sdatemaxle26p67',@'edle26p67':=IF(@'cle26p67'>=@'mle26p67' AND @'cle26p67'>0,CAST(ob as DATE),@'edle26p67') as 'edatemaxle26p67',@'cge29p44':=IF(ROUND(mint,2)>=29.44,@'cge29p44'+1,0) as 'ge29p44',@'mge29p44':=IF(@'cge29p44'>=@'mge29p44',@'cge29p44',@'mge29p44') as 'maxge29p44',@'tge29p44':=IF(@'cge29p44'>0,@'tge29p44'+1,@'tge29p44') as 'totalge29p44',@'sdge29p44':=IF(@'cge29p44'>=@'mge29p44' AND @'cge29p44'>0,CAST(DATE_SUB(ob, INTERVAL (@'cge29p44' - 1) DAY) as DATE),@'sdge29p44') as 'sdatemaxge29p44',@'edge29p44':=IF(@'cge29p44'>=@'mge29p44' AND @'cge29p44'>0,CAST(ob as DATE),@'edge29p44') as 'edatemaxge29p44',@'cle32p22':=IF(ROUND(mint,2)<=32.22,@'cle32p22'+1,0) as 'le32p22',@'mle32p22':=IF(@'cle32p22'>=@'mle32p22',@'cle32p22',@'mle32p22') as 'maxle32p22',@'tle32p22':=IF(@'cle32p22'>0,@'tle32p22'+1,@'tle32p22') as 'totalle32p22',@'sdle32p22':=IF(@'cle32p22'>=@'mle32p22' AND @'cle32p22'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle32p22' - 1) DAY) as DATE),@'sdle32p22') as 'sdatemaxle32p22',@'edle32p22':=IF(@'cle32p22'>=@'mle32p22' AND @'cle32p22'>0,CAST(ob as DATE),@'edle32p22') as 'edatemaxle32p22',@'cge35':=IF(ROUND(mint,2)>=35,@'cge35'+1,0) as 'ge35',@'mge35':=IF(@'cge35'>=@'mge35',@'cge35',@'mge35') as 'maxge35',@'tge35':=IF(@'cge35'>0,@'tge35'+1,@'tge35') as 'totalge35',@'sdge35':=IF(@'cge35'>=@'mge35' AND @'cge35'>0,CAST(DATE_SUB(ob, INTERVAL (@'cge35' - 1) DAY) as DATE),@'sdge35') as 'sdatemaxge35',@'edge35':=IF(@'cge35'>=@'mge35' AND @'cge35'>0,CAST(ob as DATE),@'edge35') as 'edatemaxge35',@'cle37p78':=IF(ROUND(mint,2)<=37.78,@'cle37p78'+1,0) as 'le37p78',@'mle37p78':=IF(@'cle37p78'>=@'mle37p78',@'cle37p78',@'mle37p78') as 'maxle37p78',@'tle37p78':=IF(@'cle37p78'>0,@'tle37p78'+1,@'tle37p78') as 'totalle37p78',@'sdle37p78':=IF(@'cle37p78'>=@'mle37p78' AND @'cle37p78'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle37p78' - 1) DAY) as DATE),@'sdle37p78') as 'sdatemaxle37p78',@'edle37p78':=IF(@'cle37p78'>=@'mle37p78' AND @'cle37p78'>0,CAST(ob as DATE),@'edle37p78') as 'edatemaxle37p78',@'cle43p33':=IF(ROUND(mint,2)<=43.33,@'cle43p33'+1,0) as 'le43p33',@'mle43p33':=IF(@'cle43p33'>=@'mle43p33',@'cle43p33',@'mle43p33') as 'maxle43p33',@'tle43p33':=IF(@'cle43p33'>0,@'tle43p33'+1,@'tle43p33') as 'totalle43p33',@'sdle43p33':=IF(@'cle43p33'>=@'mle43p33' AND @'cle43p33'>0,CAST(DATE_SUB(ob, INTERVAL (@'cle43p33' - 1) DAY) as DATE),@'sdle43p33') as 'sdatemaxle43p33',@'edle43p33':=IF(@'cle43p33'>=@'mle43p33' AND @'cle43p33'>0,CAST(ob as DATE),@'edle43p33') as 'edatemaxle43p33' FROM tmp.CP_DATA272954137 WHERE station = '317069' AND ob >= '2022-11-01 00:00:00' AND ob <= '2022-11-06 23:59:59') as temps HAVING DATE_FORMAT(ob,'%Y-%m-%d')=DATE_FORMAT('2022-11-06 23:59:59','%Y-%m-%d')

Error Trace: