colmem: interests_committee_search

Custom SQL query (hide)

SELECT m.id, m.name, i.kind, i.name FROM members AS m, committee_membership AS cm, interests AS i WHERE m.id = cm.member_id AND m.id = i.member_id AND cm.committee_id = :committee_id AND i.name LIKE :term ORDER BY m.name, i.kind

Query parameters

committee_id

term

Edit SQL