colmem: interests_search

Custom SQL query returning 18 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

idnamekindname
1226 Alastair Michael Moss member Member, Conservative Party
1225 Andrew Stratton McMurtrie member Member, Conservative Party
1218 Christopher Michael Hayward member MEMBER, CONSERVATIVE PARTY
1219 Christopher Paul Boden member North East Cambridgeshire Conservative Association
1219 Christopher Paul Boden member Member, Conservative Party
1231 Graeme Martyn Smith member Member - Epping Forest Conservative Association
1220 Gregory Jones QC member Bexleyheath & Crayford Conservative Association
408 James Henry George Pollard member Member - Conservative Party
394 James Richard Tumbridge member Conservative Party
370 Jeremy Mayhew member Member, Conservative Party
1222 Karina Dostalova member Member, Hampstead and Kilburn Conservative Association
1666 Keith David Forbes Bottomley member Member - Conservative Party
1229 Mark Raymond Peter Henry Delano Wheatley member MEMBER, CONSERVATIVE & UNIONIST PARTY
1941 Oliver Sells QC member Member - Conservative Party
1941 Oliver Sells QC member Think Tank - Conservative Policy Forum
511 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA member Conservative Party Business and Entrepreneurs Club
511 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA member Conservative Party
217 Sophie Anne Fernandes member Member - Conservative Party