You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND inventory.i_id is not null  
AND event.event_salesend>NOW()