select id,rdate,rbanner from (select * from tbltwar where rdate >= '2016-02-19' and rdate <= '2020-05-20') as y where lower(rquote) like '%bhr partners%' or lower(rquote) like '%chris heinz%' or lower(rquote) like '%rosemont seneca%' order by id desc limit 100
| 1 |
572026 | 05/20/2020 | Derkach unveiled conversations of voices similar to Poroshenko and Biden |
| 2 |
571848 | 05/18/2020 | Jordan Requests Pompeo Turn Over Explosive Docs Exposing Alleged ‘Whistleblower' And Hunter Biden |
| 3 |
571727 | 05/17/2020 | While VP, Plugz Weinstein paraded nude every day in front of his FEMALE Secret Service detail |
| 4 |
568831 | 04/16/2020 | Hunter Biden Still Listed As Board Member Of Chinese Company He Pledged To Resign From In October |
| 5 |
568396 | 04/11/2020 | Biden Claims People Refer to Him as a 'Foreign Policy Expert' |
| 6 |
568182 | 04/09/2020 | Look back: 2015 deal by Hunter Biden/Chris Heinz's private eq firm + Bank of China + AvIndustry Corporation of China to buy US dual-use parts manufacturer Henniges |
| 7 |
562777 | 02/06/2020 | Grassley, Johnson Seek Hunter Biden's Travel Records From Secret Service |
| 8 |
559918 | 12/31/2019 | Hunter Biden Gets Hit With Tax Liens |
| 9 |
559882 | 12/31/2019 | Hunter Biden Accused of $156M Counterfeiting Scheme With Burisma, CrowdStrike, Legal Filing Claims |
| 10 |
556335 | 11/25/2019 | Ukrainian MP Andriy Derkach revealed Joe Biden was paid nearly $1 million for lobbying activities by Burisma Holdings while he was US Vice President |
| 11 |
554559 | 11/05/2019 | Hunter Biden's Ukraine gas firm pressed Obama administration to end corruption allegations, memos show |
| 12 |
553317 | 10/21/2019 | CD Media Releasing Information On Poroshenko Money Laundering/Biden Cover Up, In Series Of Articles, With Sourcing |
| 13 |
552488 | 10/11/2019 | Judicial Watch Files Two New Lawsuits Seeking Records of How CFIUS Investments by Ukraine, China Firms Tied to Hunter Biden |
| 14 |
552402 | 10/10/2019 | Burisma paid Joe Biden $900,000 for lobbying – Ukrainian MP |
| 15 |
510286 | 03/16/2018 | Breitbart editor: Biden's and Kerry's sons inked deal with Chinese government after vice president's trip |