home / regmem

regmem

Custom SQL query returning 5 rows

select people.id, people.name, count(*) as num_items, group_concat(item, ':::'), group_concat(date, ' : ') from items
join people on items.person_id = people.id
join categories on items.category_id = categories.id
where items.category_id in (
  -- All forms of shareholding
  "Aead2f460", "a5bbc519",  "3aff2389",
  "21983754",  "5b34324e",  "b1cf7e3e"
)
and items.rowid in (select rowid from [items_fts] where [item] match :search) 
group by items.person_id
order by num_items desc;

Query parameters

This data as .json

idnamenum_itemsgroup_concat(item, ':::')group_concat(date, ' : ')
uk.org.publicwhip/person/10854 Jonathan Djanogly 59 BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil::: BP plc; oil 2006-11-27 : 2006-12-11 : 2007-01-09 : 2007-01-23 : 2007-02-06 : 2007-02-27 : 2007-03-13 : 2007-03-26 : 2007-05-01 : 2007-05-15 : 2007-06-05 : 2007-06-19 : 2007-07-03 : 2007-07-17 : 2007-07-30 : 2007-08-28 : 2007-10-09 : 2007-10-23 : 2007-11-06 : 2007-11-20 : 2007-12-04 : 2007-12-18 : 2008-01-09 : 2008-01-22 : 2008-02-05 : 2008-02-26 : 2008-03-11 : 2008-03-25 : 2008-04-23 : 2008-06-16 : 2008-07-08 : 2008-07-22 : 2008-09-03 : 2008-10-08 : 2008-10-22 : 2008-11-05 : 2008-11-19 : 2008-12-03 : 2008-12-17 : 2009-01-14 : 2009-01-28 : 2009-02-11 : 2009-02-25 : 2009-03-11 : 2009-03-25 : 2009-04-22 : 2009-05-06 : 2009-05-20 : 2009-06-10 : 2009-06-24 : 2009-07-08 : 2009-07-21 : 2009-09-02 : 2009-10-14 : 2009-10-28 : 2009-11-11 : 2009-11-25 : 2009-12-10 : 2010-01-06
uk.org.publicwhip/person/11420 John Hemming 58 BP::: BP::: BP::: BP::: BP::: BP::: BP::: BP::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP (Registered 30 July 2012)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013)::: BP , until October 2013(Registered 30 July 2012; updated 18 October 2013) 2011-04-18 : 2011-05-03 : 2011-05-16 : 2011-06-06 : 2011-06-20 : 2011-07-06 : 2011-07-19 : 2011-08-30 : 2012-07-30 : 2012-09-03 : 2012-10-01 : 2012-10-22 : 2012-11-05 : 2012-11-19 : 2012-12-03 : 2012-12-19 : 2013-01-18 : 2013-02-04 : 2013-02-25 : 2013-03-11 : 2013-04-08 : 2013-04-22 : 2013-05-07 : 2013-05-20 : 2013-06-10 : 2013-06-24 : 2013-07-08 : 2013-07-29 : 2013-08-27 : 2013-09-09 : 2013-09-30 : 2013-10-14 : 2013-10-28 : 2013-11-11 : 2013-11-25 : 2013-12-09 : 2014-01-06 : 2014-01-20 : 2014-02-03 : 2014-02-24 : 2014-03-10 : 2014-03-21 : 2014-03-24 : 2014-04-07 : 2014-04-28 : 2014-05-12 : 2014-06-02 : 2014-06-16 : 2014-06-30 : 2014-07-14 : 2014-07-28 : 2014-08-26 : 2014-09-22 : 2014-10-13 : 2014-10-27 : 2014-11-10 : 2014-11-24 : 2014-12-08
uk.org.publicwhip/person/25377 Chris Philp 54 BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015):::BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015) 2015-06-08 : 2015-07-13 : 2015-08-10 : 2015-09-07 : 2015-09-28 : 2015-10-12 : 2015-10-26 : 2015-11-09 : 2015-11-30 : 2015-12-14 : 2016-01-11 : 2016-01-25 : 2016-02-08 : 2016-02-22 : 2016-03-07 : 2016-03-21 : 2016-04-18 : 2016-05-03 : 2016-05-16 : 2016-06-06 : 2016-06-27 : 2016-07-11 : 2016-08-01 : 2016-09-05 : 2016-10-03 : 2016-10-17 : 2016-10-31 : 2016-11-21 : 2016-12-05 : 2016-12-19 : 2017-01-09 : 2017-01-23 : 2017-02-06 : 2017-02-20 : 2017-03-06 : 2017-03-20 : 2017-04-10 : 2017-05-02 : 2017-07-07 : 2017-07-31 : 2017-08-29 : 2017-09-11 : 2017-10-09 : 2017-10-23 : 2017-11-13 : 2017-11-27 : 2017-12-11 : 2018-01-08 : 2018-01-22 : 2018-02-05 : 2018-02-19 : 2018-03-05 : 2018-03-19 : 2018-04-16
uk.org.publicwhip/person/10457 Archie Norman 10 BP; oil and related.:::BP; oil and related:::BP; oil and related:::BP; oil and related:::BP; oil and related:::BP; oil and related:::BP; oil and related:::BP; oil and related:::(b) BP; oil and related:::(b) BP; oil and related 2002-11-26 : 2003-12-04 : 2004-01-31 : 2004-05-21 : 2004-07-16 : 2004-09-08 : 2004-10-22 : 2004-12-03 : 2005-01-28 : 2005-04-11
uk.org.publicwhip/person/10509 Marion Roe 8 BP::: BP::: BP::: BP::: BP::: BP:::BP:::BP 2004-01-31 : 2004-05-21 : 2004-07-16 : 2004-09-08 : 2004-10-22 : 2004-12-03 : 2005-01-28 : 2005-04-11
Powered by Datasette · Query took 9.379ms · Data source: mySociety Data