colmem: interests_search

Custom SQL query returning 2 rows (hide)

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

Query parameters

Edit SQL

This data as json, CSV

idnamekindname
373 Catherine McGuinness partner Member, Liberal Democrat Party
292 Edward Lord member Liberal Democrats