How to form the order of requests to get users?

Question

MySQL

How to generate requests to get users with filtering.
Tables: users, education_session, test_history

structure:

users

education_session

test_history

filter window:

user output (example):

A simple selection of users, without filters:

select distinct `users`.*, `subdivisions`.`title` as `subdivision_title`, `positions`.`title` as `position_title` 
from `users` 
left join `subdivisions` on `users`.`subdivision` = `subdivisions`.`id` 
left join `positions` on `users`.`position` = `positions`.`id` 
where `users`.`role_id` = 0 
order by `users`.`full_name` asc limit 25 offset 0

And difficulties begin with filtering, since each user can have several sessions to the main programs, a common session, to additional ones, each topic has its own session, data is stored in the testing history including histories from past sessions, when performing a test, data from the user ID is saved, session, topic, and the test itself. When sampling, data from the last sessions is obtained.
How to form the order of requests for displaying users? First, look at the data on the sessions for the selected topics, taking into account that there may be different sessions for different programs. Then look in the testing history to see if there is data for the selected topics for the last sessions, and then make a request to users, according to the data from the testing history.