explain

 Select  
     events.name, fields.name, seats.snumber ,    'Jegy' 
 from 
      events, fields, seats,   history, actions 
 where 
        seats.field_id = fields.field_id AND history.event_id = events.event_id  
    and seats.snumber=history.snumber and history.event_id=seats.event_id and history.action_id=actions.action_id and history.type_id = 6 
 -- ********************************
    and history.undo_action_id > 0 
 -- ********************************
    and cast(actions.created as date)='2005.02.24' 
    and actions.user_id in (23)