The sql is:
lect * from calendar where description LIKE '%investigation%' or short_name LIKE '%investigation%' AND date>='2015-08-20' AND date<='2015-08-22' group by event_id order by date
The result I get is an event that happened from 2015-06-30 to 2017-07-08. Seems like that wouldn't be a viable "return" on the above statement in that I've qualified the range of dates to be between August 20th and August 22nd.
What am I doing wrong?