SELECT * FROM shows WHERE showdate > '2016-08-31'
SELECT * FROM shows WHERE udate >1472626800
SELECT * FROM shows where udate > 1472626800 AND showstate = 'MO' OR showstate = 'KS'
Keep in mind rules of precedence in boolean expressions.
X AND Y OR Z
This is the same as:
(X AND Y) OR Z
Which is true anywhere Z is true, even if X and Y are false.
To fix this, add parentheses explicitly to override the default boolean operation precedence:
X AND (Y OR Z)