colmem: interests_search

Custom SQL query returning 22 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
1756 Anne Helen Fairweather member Member, The Labour Party
1756 Anne Helen Fairweather member Member - Labour Movement for Europe
1942 Christopher Hill member Labour Party
1937 Jason Paul Pritchard member Member - The Labour Party
1937 Jason Paul Pritchard member Member - SERA - Labour Environment Campaign
1937 Jason Paul Pritchard partner Member - The Labour Party
1957 Mary Durcan member Support from City of London Branch of the Labour Party for election expenses
1957 Mary Durcan member Member - Labour Party
1957 Mary Durcan member Member - Labour Friends of Israel
1957 Mary Durcan member Member - Jewish Labour Movement
1953 Matthew Bell member The Labour Party
1949 Munsur Ali member Labour Party
2224 Natasha Maria Cabrera Lloyd-Owen member Support from the City of London Branch of the Labour Party for election expenses
2224 Natasha Maria Cabrera Lloyd-Owen member Member, Labour Party
2224 Natasha Maria Cabrera Lloyd-Owen member Member, Society of Labour Lawyers
1948 Rehana Banu Ameer member Member - Labour in the City Group
1948 Rehana Banu Ameer member Member - Labour Party
1956 Richard Peter Crossan member Member- Labour Party
1592 The Rt Hon the Baroness Patricia Scotland of Asthal, QC member Member- Labour Party
1950 Thomas Alexander Anderson member Member - The Labour Party
1213 Tom Sleigh member Labour Party
1936 William Pimlott member City of London Labour Party