How to: Real Time deletion of relevant records from resulting mysql results?
Create for every table an AFTER DELETE TRIGGER, so you are sure you catch every deleted entry and can remove them from your result set.
The same goes of course for the inserts, then you can also use a TRIGGER to add rows to your result set.
Your query is probably slow and you hope that you don't need to run it again, when you simply add and remove all new entries since the query last ran.