SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND cp.enddate='2022-07-31 23:59:59' AND cp.var='avgtemp' order by thresh ASC' at line 1 with query: SELECT * FROM sercc.climper_strthr AS cp WHERE cp.station='417945' AND cp.period IN ('1_MONTH','31_DAY','2_MONTH','61_DAY','3_MONTH','6_MONTH','212_DAY','304_DAY','1_YEAR') AND cp.thresh IN () AND cp.enddate='2022-07-31 23:59:59' AND cp.var='avgtemp' order by thresh ASC

Error Trace: in rank_query line 1194