events in sub-query

Good evening,

How edit query in events and use Sessions variables in where close i found. Is it possible edit sub-query in events or other methods. I need use in sub query $session variables.

Best regards

Rimantas