Never god **bleep** mind, I literally found the solution two seconds after I posted this. Here is the correct SQL   SELECT ID,VALUEAsReal, RecordTime, RecordId FROM CDBHISTORIC WHERE RecordTime > {ts '2019-10-17 13:00:00'} AND (ID = 40776 OR ID = 26114)    You have to put the parenthesis () for the other filters: (ID = 40776 OR ID = 26114)  *sigh* why is my life like this.   Some documentation about this can be found here: http://34.236.135.167/Help/Default.htm#SQLGuide/BuildtheSubClauseList.htm%3FTocPath%3DCore%2520Reference%7CCoding%7CSQL%2520Guide%7CSQL%2520Join%2520Optimization%7C_____1  ... View more