Запрос для получения информации о пользователе по должности more to more

common.sql

SELECT users.*, COUNT(*) AS c
FROM users, work, userwork
WHERE userwork.wid = work.id AND userwork.uid = users.id
AND work.name IN ('%IMPLODED ARRAY%')
GROUP BY users.id
HAVING c = %COUNT OF %IMPLODED ARRAY%%

example.sql

SELECT users.*, COUNT(*) AS c
FROM users, work, userwork
WHERE userwork.wid = work.id AND userwork.uid = users.id
AND work.name IN ('Мент','Пожарный')
GROUP BY users.id
HAVING c = 2