colmem: gifts_committee_search

Custom SQL query returning 123 rows (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

idnamenamedate_strdate
1226 Alastair Michael Moss Invited to the Pensions Age Award as a guest of CBRE Thursday 23 February 2017 2017-02-23
1226 Alastair Michael Moss Two tickets to the London Symphony Orchestra and reception 19 September 2018 2018-09-19
1226 Alastair Michael Moss Lunch with City Property Association - President and Director, 1 Poultry 2 November 2018 2018-11-02
1226 Alastair Michael Moss Lunch with Keltbray at Chez Marlene 13 March 2019 2019-03-13
1226 Alastair Michael Moss Guest at London Chamber of Commerce reception at the Five Seasons Hotel, Cannes 12 March 2019 2019-03-12
1226 Alastair Michael Moss Westminster Property Association/City Property Association – Stakeholder Lunch – Majestic Hotel, Cannes 12 March 2019 2019-03-12
1226 Alastair Michael Moss UK Cities Investor Dinner – Cannes 12 March 2019 2019-03-12
1226 Alastair Michael Moss Guest of Lloyd's of London [lunch] 15 May 2019 2019-05-15
1226 Alastair Michael Moss Guest of Surveyor's Association - Carlton Club [dinner as guest speaker] 23 May 2019 2019-05-23
1945 Andrew Paul Mayer Two tickets to RSC performance of Julius Caesar - Barbican Centre 15th January 2018 2018-01-15
1942 Christopher Hill Dinner at the Walbrook Club as guest of Tenacity Group. 20th November 2018 2018-11-20
1218 Christopher Michael Hayward Invitation (with guest) to Supper at National Gallery marking Sir Stuart Lipton's 50 years' involvement in property. 13 June 2016 2016-06-13
1218 Christopher Michael Hayward Invitation to Mischon de Reya Lunch with Sir Stuart Lipton 7 October 2016 2016-10-07
1218 Christopher Michael Hayward Lunch at the Goring with Mike Hussey, Almacantar Ltd 29 November 2016 2016-11-29
1218 Christopher Michael Hayward Hosted to dinner at 1 Lombard Street by the City Architecture Forum (Guest Speaker) 23 November 2016 2016-11-23
1218 Christopher Michael Hayward Hosted breakfast at Guildhall by Gerald Eve Associates (Guest Speaker) 24th November 2016 2016-11-24
1218 Christopher Michael Hayward Guest at lunch hosted by Richard Desmond (Northern & Shell plc) 12th June 2017 2017-06-12
1218 Christopher Michael Hayward Lunch with the owners of Harry’s Bar and Restaurant, 5 Abchurch Yard, EC4N 7BA 17 July 2017 2017-07-17
1218 Christopher Michael Hayward Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited (Guest Speaker) 23rd September 2017 2017-09-23
1218 Christopher Michael Hayward Gresham Dinner, guest of the Mercers' Company 14 November 2017 2017-11-14
1218 Christopher Michael Hayward Lunch - Richard Desmond (Northern & Shell PLC) 2nd February 2018 2018-02-02
1218 Christopher Michael Hayward Lunch with Harrry Haddad, Harry’s Bar, Ironmonger Lane, EC2V 8EP 13 February 2018 2018-02-13
1218 Christopher Michael Hayward Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22
1218 Christopher Michael Hayward Guest of KPMG at Dinner at Plage l'Ondine at MIPIM 13 March 2018 2018-03-13
1218 Christopher Michael Hayward Guest of London Chamber of Commerce at a Presidents Lunch at MIPIM 14 March 2018 2018-03-14
1218 Christopher Michael Hayward Guest of Christopher Moran Dinner at Crosby Hall 16 May 2018 2018-05-16
1218 Christopher Michael Hayward Guest of Farebrother Chartered Surveyors, dinner at the RAC Club 3 September 2018 2018-09-03
1218 Christopher Michael Hayward Guest of London and Oriental, lunch at The Ned 4 September 2018 2018-09-04
1218 Christopher Michael Hayward Guest of City Property Association, lunch at The Coq D'argent 2 November 2018 2018-11-02
1218 Christopher Michael Hayward Lunch with Chairman of Northern & Shell Plc 7 January 2019 2019-01-07
1458 Emma Edhem Drinks reception at Is Bank (hosted by CEO of Is Bank) - organsied by TBCCI 5th September 2018 2018-09-05
1458 Emma Edhem Drinks reception at the House of lords for JETCO - organised by DIT and DEIK 11th September 2018 2018-09-11
1458 Emma Edhem Tea at the House of Lords hosted by Baroness Verma and Baroness Ece 12th September 2018 2018-09-12
1458 Emma Edhem No2H8 Crime Awards dinner - organised by Faith Matters/Tell Mama 13th September 2018 2018-09-13
1458 Emma Edhem Installation of Master Farrier and dinner at Vintner's Hall (guest of Martin Dudley) 26th September 2018 2018-09-26
1458 Emma Edhem Drinks reception and fair at Goldsmith's Hall - organised by the Goldsmiths 27th September 2018 2018-09-27
1458 Emma Edhem Tea and Tour of the Chapel at Kensington Palace with Serena Richards 3rd october 2018 2018-10-03
1458 Emma Edhem Drinks reception for the departure of inga Beale (CEO of Lloyds) at the Lloyds Building - hosted by Inga Beale and organised by Lloyds Market Place 4th October 2018 2018-10-04
1458 Emma Edhem Tea with the Turkish Ambassador at the Turkish Embassy - hosted by the Ambassador 10th October 2018 2018-10-10
1458 Emma Edhem Presentation Dinner for the Lord Mayor-Elect at Ironmonger's Hall 22nd October 2018 2018-10-22
1458 Emma Edhem Drinks reception at the residence of the Turksih Ambassador - organised by the Turkish Embassy 29th October 2018 2018-10-29
1458 Emma Edhem Diwali dinner at Drapers Hall hosted by Baroness Verma - organised by The Hinduja Foundation 30th October 2018 2018-10-30
1458 Emma Edhem Drinks reception and debate at the residence of the Dutch Ambassador - organised by IBDE and hosted by the Dutch Ambassador 31st October 2018 2018-10-31
1458 Emma Edhem Lunch at the House of Lords hosted by Lord Rana - organised by UK Asian Business Council & Overseas Friends of India 5th November 2018 2018-11-05
1458 Emma Edhem Installation of Master City Livery - guest of Trevor Brignall 7th November 2018 2018-11-07
1458 Emma Edhem Vin d’honneur at the Residence of the Turkish Ambassador upon presentation of his Credentials to HM the Queen 22nd November 2018 2018-11-22
1658 James de Sausmarez Installation dinner of the Master of the Worshipful Company of Tax Advisers Thursday 21 September 2017 2017-09-21
1658 James de Sausmarez Annual Budget Banquet - Worshipful Company of Tax Advisers 7 March 2018 2018-03-07
1223 Jamie Ingham Clark Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22
1666 Keith David Forbes Bottomley Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited 23 September 2017 2017-09-23
1666 Keith David Forbes Bottomley Private dinner given by the Lord Mayor of Westminster at the In & Out Club 12 May 2018 2018-05-12
1666 Keith David Forbes Bottomley Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation 31 July 2018 2018-07-31
223 Marianne Bernadette Fredericks Reception at the National Gallery (Stuart and Ruth Lipton) 13th June 2016 2016-06-13
223 Marianne Bernadette Fredericks Dinner at 10 Trinity Square (Reignwood) 14th June 2016 2016-06-14
223 Marianne Bernadette Fredericks Concert and charity dinner at the Four Seasons Hotel London, 10 Trinity Square, London (Reignwood and Four Seasons) 25th May 2017 2017-05-25
223 Marianne Bernadette Fredericks Dinner at Mansion House (Canary Wharf Group) 6th September 2018 2018-09-06
223 Marianne Bernadette Fredericks Dinner at the Walbrook Club as guest of Tenacity Group 20th November 2018 2018-11-20
1958 Mark Bostock Dinner at the Walbrook Club as guests of Tenacity Group 20th November 2018 2018-11-20
1949 Munsur Ali Dinner at Mansion House (Canary Wharf Group) 6th September 2018 2018-09-06
200 Peter Gerard Dunphy 9th September - 1 ticket and hospitality in a Private Box at Lords Cricket Ground provided by White & Case LLP    
397 Sir David Hugh Wootton Dinner, University of Greenwich 14 July 2015 2015-07-14
397 Sir David Hugh Wootton Dinner, Institute of Directors 16 September 2015 2015-09-16
397 Sir David Hugh Wootton Dinner, Young Presidents’ Organisation 25 September 2015 2015-09-25
397 Sir David Hugh Wootton Dinner, Association of Financial Markets in Europe 15 October 2015 2015-10-15
397 Sir David Hugh Wootton Dinner, the Worshipful Company of Tin Plate Workers alias Wire Workers 5 July 2016 2016-07-05
397 Sir David Hugh Wootton Dinner, Institute of Directors 14 July 2016 2016-07-14
397 Sir David Hugh Wootton Dinner, Royal Military Academy, Sandhurst 2 August 2016 2016-08-02
397 Sir David Hugh Wootton Dinner, Chartered Bankers Institute 1 September 2016 2016-09-01
397 Sir David Hugh Wootton Dinner, Association of Financial Markets in Europe 3 November 2016 2016-11-03
397 Sir David Hugh Wootton Reception and Dinner, Co-operation Ireland 8 November 2016 2016-11-08
397 Sir David Hugh Wootton Dinner, The Worshipful Company of Wheelwrights 8 December 2016 2016-12-08
397 Sir David Hugh Wootton Dinner, Classics for All 26 January 2017 2017-01-26
397 Sir David Hugh Wootton Dinner, The Worshipful Company of Clothworkers 7 March 2017 2017-03-07
397 Sir David Hugh Wootton Dinner, Remenham Club 21 April 2017 2017-04-21
397 Sir David Hugh Wootton Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22
136 Sir Mark Boleat In my capacity as Policy Chairman I was Deputy Chairman of TheCityUK and in that capacity that organisation regularly invited me to working lunches and dinners normally held in private dining rooms of City institutions. Also in my capacity as Policy Chairman I attended a number of receptions and working dinners as the guest of the German Ambassador, the French Ambassador, the Swedish Ambassador and the President of the CBI. This continued while I was Deputy Chairman of the Policy and Resources Committee. I have been given Membership of the KMPG '20 Club', which provides 'drop in' work facilities, and of Ten Trinity Square Private Club.    
136 Sir Mark Boleat Dinner paid for by AIG Group. 14 April 2015 2015-04-14
136 Sir Mark Boleat The Worshipful Company of Insurers Banquet, double invitation. 29 April 2015 2015-04-29
136 Sir Mark Boleat Dinner, The Fishmongers' Company. 13 May 2015 2015-05-13
136 Sir Mark Boleat Dinner, Institute of Economic Affairs. 19 June 2015 2015-06-19
136 Sir Mark Boleat Dinner and Tickets for England vs. Switzerland provided by the Swiss Ambassador. 8 September 2015 2015-09-08
136 Sir Mark Boleat China International Capital Corporation, three dinners and one lunch. Various  
136 Sir Mark Boleat Dinner, PwC, 'Building Public Trust'. 1 October 2015 2015-10-01
136 Sir Mark Boleat Dinner, Association of Financial Markets in Europe. 15 October 2015 2015-10-15
136 Sir Mark Boleat Dinner, China Construction Bank. 19 October 2015 2015-10-19
136 Sir Mark Boleat Ticket for Rugby World Cup Final and Hospitality provided by EY. 31 October 2015 2015-10-31
136 Sir Mark Boleat European rugby cup match and hospitality at Saracens, double invitation from CME Group. 16 January 2016 2016-01-16
136 Sir Mark Boleat Dinner, CLS Group. 25 January 2016 2016-01-25
136 Sir Mark Boleat Livery Banquet - Worshipful Company of Chartered Architects 16 February 2016 2016-02-16
136 Sir Mark Boleat Dinner, French Ambassador 22 March 2016 2016-03-22
136 Sir Mark Boleat CD collection from London Symphony Orchestra 22 March 2016 2016-03-22
136 Sir Mark Boleat Philharmonie de Paris - Concert and Dinner 12 April 2016 2016-04-12
136 Sir Mark Boleat City Debate and Dinner - HSBC 19 April 2016 2016-04-19
136 Sir Mark Boleat Association of Foreign Banks - Annual Lunch 26 April 2016 2016-04-26
136 Sir Mark Boleat St Gallen Symposium - Hotel Accommodation and Airport Transit 12-13 May 2016 2016-05-12
136 Sir Mark Boleat Reignwood Investments UK - Double Invitation, Final Day of BMW Golf Championship, Wentworth 29 May 2016 2016-05-29
136 Sir Mark Boleat Dinner, Reignwood Investments UK 14 June 2016 2016-06-14
136 Sir Mark Boleat Michael Bloomberg - Double Invitation, Reception and Dinner at Tate Modern 22 June 2016 2016-06-22
136 Sir Mark Boleat Joseph Zammit Tabona, Special Envoy to the Maltese Prime Minister - Accommodation and Hospitality in Malta 28-31 August 2016 2016-08-28
136 Sir Mark Boleat Lloyds City Dinner - Lloyds of London 5 September 2016 2016-09-05
136 Sir Mark Boleat Dinner, Commonwealth Bank of Australia - Double Invitation 7 September 2016 2016-09-07
136 Sir Mark Boleat Double invitation to Royal Shakespeare Company performance of 'King Lear' - Barbican Centre 7 December 2016 2016-12-07
136 Sir Mark Boleat Double invitation to concert - Barbican Centre 22 December 2016 2016-12-22
136 Sir Mark Boleat Chinese New Year Lunch - HSBC 6 February 2017 2017-02-06
136 Sir Mark Boleat 25th Anniversary Dinner - CISI 22 February 2017 2017-02-22
136 Sir Mark Boleat Dinner (double invitation) Latvian Ambassador 6 March 2017 2017-03-06
136 Sir Mark Boleat Dinner (double invitation) Worshipful Company of Cordwainers 10 March 2017 2017-03-10
136 Sir Mark Boleat Dinner (double invitation) Andre Villeneuve 15 March 2017 2017-03-15
136 Sir Mark Boleat Theatre and hospitality (double invitation) PwC 20 April 2017 2017-04-20
136 Sir Mark Boleat Livery Banquet (double invitation) Worshipful Company of Information Technologists 4 May 2017 2017-05-04
136 Sir Mark Boleat Dinner: Ten Trinity Square Private Club 5 May 2017 2017-05-05
136 Sir Mark Boleat Dinner: Reignwood 10 May 2017 2017-05-10
136 Sir Mark Boleat Concert and Dinner with Reignwood 25 May 2017 2017-05-25
136 Sir Mark Boleat Hospitality at BMW Golf Championship with Reignwood 28 May 2017 2017-05-28
136 Sir Mark Boleat Royal Academy Summer Exhibition and reception (double invitation), BNY Mellon. 13 June 2017 2017-06-13
136 Sir Mark Boleat Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22
136 Sir Mark Boleat Livery Dinner, Worshipful Company of International Bankers 27 February 2018 2018-02-27
136 Sir Mark Boleat City Debate and dinner, Centre for the Study of Financial Innovation 6 March 2018 2018-03-06
136 Sir Mark Boleat Dinner with the French Ambassador 21 March 2018 2018-03-21
136 Sir Mark Boleat Rugby Match and lunch x2, CME Group 24 March 2018 2018-03-24
381 Sylvia Doreen Moys Hospitality at Barbican Centre - 13/05/15 - J.P Gaultier World of Fashion, Theatre ticket to RSC Henry IV part 1 - 19/1/15 and ticket x 2 to LSO concert - 16/10/14. Note: After the RSC Theatre invitation in January 2015, previously reported, I have declined all subsequent invitations from RSC.    
381 Sylvia Doreen Moys Barbican Centre - I continue to accept a number of invitations:- Breakfast gatherings and guided visits to Exhibitions in Art Gallery and Curve Occasional LSO Concerts (ticket prices generally £42) GSMD Gold Medal Final in Barbican Hall LSSO Concerts Jan, April, Sept 3 @ £25 I consider cumulatively, giving the above as examples, on a 1 year rolling total, I receive hospitality which could reach the declaration figure of £200.    
381 Sylvia Doreen Moys Barbican Centre I continue to accept a number of invitations:- Breakfast gatherings and guided visits to Exhibitions in Art Gallery and Curve Occasional LSO Concerts (ticket prices with Rattle in post now, generally £55) GSMD Gold Medal Final in Barbican Hall LSSO Concerts Jan, April, Sept 3 @ £26 Recently an evening reception in Garden Room, followed by guided tour of ‘The Japanese House’ I consider cumulatively, giving the above as examples, on a 1 year rolling total, I receive hospitality which can well reach the declaration figure of £200. Note: After the RSC Theatre invitation in January 2015, previously reported, I have declined all subsequent invitations from RSC. Above updated from April 2017, given the modest increase in LSSO tickets, ticket prices for Rattle concerts, and also the Reception and evening guided visit to Japanese House.