Advanced Mysql query help

[webdev]

I need help with a section of my query that handles the "availability checking" aspect of my system. Unfortunately this has to be done in one query, I know how to do it in several with php if statements. Code: --------- (oc_calendar.username = balances.uid) AND ($day !=...