home / colmem

colmem: gifts_committee_search

Custom SQL query (hide)

SELECT m.id, m.name, g.name, g.date_str, g.date FROM members AS m, committee_membership AS cm, gifts AS g WHERE m.id = cm.member_id AND m.id = g.member_id AND cm.committee_id = :committee_id AND g.name LIKE :term ORDER BY m.name

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 1.037ms