select id,rdate,rbanner from (select * from tbltwar where rdate >= '2016-12-11' and rdate <= '2018-03-11') as y where lower(rquote) like '%charlottesville%' order by id desc limit 100
| 1 |
507185 | 02/03/2018 | Maxine Waters: There should be a disclaimer when Trump appears on TV |
| 2 |
506498 | 01/25/2018 | Thousands march against Trump in Zurich, other Swiss cities |
| 3 |
502491 | 11/26/2017 | British Spy Novelist Reports POTUS Destroying US Intelligence Community |
| 4 |
502341 | 11/24/2017 | If You Voted for Donald Trump, You Owe My Children an Apology |
| 5 |
502075 | 11/20/2017 | The Perfumed Princes of the Pentagon |
| 6 |
500749 | 11/02/2017 | Gillespie Family Left ‘Disgusted’ By Truck Ad, Campaign Donations ‘Triple’ |
| 7 |
500478 | 10/29/2017 | George Washington's Church Says Plaque Honoring First President Must Come Down |
| 8 |
500468 | 10/28/2017 | Va. gov candidate Gillespie backs petition to keep Confederate statues |
| 9 |
500136 | 10/24/2017 | From The Gym To The Gun Range, Where Antifa Learns To Fight |
| 10 |
500085 | 10/23/2017 | Michael Rapaport Calls Trump ‘F*cking Dummy' in Climate Change Rant (Video) |
| 11 |
498613 | 10/02/2017 | Fashion Choices of The Stealth Racist |
| 12 |
498531 | 09/30/2017 | Blacks, Crime, and the Bended Knee |
| 13 |
497622 | 09/18/2017 | Brown University will offer segregated student dinners for black, Muslim students |
| 14 |
497317 | 09/15/2017 | Florida rapper music video shows him lynching a young white boy |
| 15 |
497155 | 09/13/2017 | How segregated America made Trump inevitable |
| 16 |
496957 | 09/10/2017 | UC Berkeley offers counseling ahead of talk by Jewish conservative |
| 17 |
496899 | 09/09/2017 | Tim Kaine: ‘I Don’t Know Enough About Antifa’ |
| 18 |
496727 | 09/06/2017 | Outspoken East Tennessee white nationalist at Fort Sanders rally once active in Occupy, communist groups |
| 19 |
496546 | 09/04/2017 | Financial firms raising alarm over US debt ceiling |
| 20 |
496331 | 09/01/2017 | Paul Ryan Condemns Antifa As ‘A Scourge On Our Country’
|
| 21 |
496308 | 08/31/2017 | President Trump's Reassuring Hurricane Response |
| 22 |
496248 | 08/31/2017 | Suddenly, Antifa does equal Nazis |
| 23 |
496225 | 08/30/2017 | SPLC Steps on Crank |
| 24 |
496148 | 08/30/2017 | It Only Took A Day For The March To DC To Lose Nearly All Of The Marchers |
| 25 |
496072 | 08/29/2017 | 'Civil Disobedience' March From Charlottesville to DC Will Demand Trump's Removal |
| 26 |
496054 | 08/28/2017 | Confederate flag sales surge after Charlottesville violence |
| 27 |
496008 | 08/28/2017 | Antifa and the 'Alt-Left': Everything You Need to Know |
| 28 |
495970 | 08/28/2017 | Glenn K. Beaton: There were no good guys at Charlottesville |
| 29 |
495962 | 08/27/2017 | BOOM: Charlottesville Police Officer Tells All! |
| 30 |
495958 | 08/27/2017 | 'Civil Disobedience' March From Charlottesville to DC Will Demand Trump's Removal |
| 31 |
495888 | 08/27/2017 | Calif. Catholic school removes Jesus and Mary statues: ‘Alienating’ |
| 32 |
495883 | 08/27/2017 | CNN: 'Ordinary People' Are 'White Supremacists by Default' |
| 33 |
495872 | 08/26/2017 | Netanyahu's empathy for Trump |
| 34 |
495862 | 08/26/2017 | Roger Stone: Cohn ‘Should Be Fired Immediately' for Publicly Criticizing Trump |
| 35 |
495828 | 08/26/2017 | Trump's voter fraud commission to meet in New Hampshire in September |
| 36 |
495730 | 08/24/2017 | Mr. President: Don't negotiate with the swamp. Drain it. |
| 37 |
495688 | 08/24/2017 | Clooneys donate $1mn to combat hate groups after Charlottesville |
| 38 |
495664 | 08/23/2017 | ESPN Pulls Asian-American Robert Lee From Broadcast For You Know Why |
| 39 |
495652 | 08/23/2017 | Black Lives Matter Activist Unveils List of Demands to White People: ‘Give Up the Home You Own’ |
| 40 |
495626 | 08/23/2017 | Chaos Breaks Out at Charlottesville City Council Meeting |
| 41 |
495614 | 08/23/2017 | ‘Adopt-a-Nazi’ campaign raises funds to counter white nationalist free speech rally |
| 42 |
495533 | 08/22/2017 | Missouri's top Democrats call for senator to resign for 'I hope Trump is assassinated' post |
| 43 |
495467 | 08/20/2017 | Jeh Johnson: Removal of Confederate Statues a Matter of ‘Homeland Security' |
| 44 |
495449 | 08/20/2017 | GOP senator: 'It feels like violence is coming' |
| 45 |
495441 | 08/20/2017 | Rush Limbaugh: ‘We Are on the Cusp of a Second Civil War' |
| 46 |
495432 | 08/20/2017 | Thousands march against 'Free Speech' in Boston |
| 47 |
495419 | 08/20/2017 | Tweet from the account of Charlottesville rally organizer insults slain protester Heather Heyer |
| 48 |
495416 | 08/20/2017 | Florida man kicked out of school for saluting Lee statue |
| 49 |
495394 | 08/20/2017 | 1 officer killed, 1 in 'grave critical condition' in Kissimmee shooting |
| 50 |
495386 | 08/19/2017 | Evangelical advisers stay with Trump as others criticize him |
| 51 |
495366 | 08/19/2017 | This Week in Guns, August 19th, 2017 |
| 52 |
495364 | 08/19/2017 | Mayor Phoenix, AZ does not want the President to visit next week... or ever |
| 53 |
495333 | 08/20/2017 | Civil Rights Icon Andrew Young Argues for Confederate Monuments to Remain in Place |
| 54 |
495326 | 08/18/2017 | Noam Chomsky: Antifa is a 'major gift to the Right' |
| 55 |
495304 | 08/18/2017 | Defying an age of hatred, Ben Carson sets an example for America |
| 56 |
495288 | 08/18/2017 | Democrats Push to Censure President Trump |
| 57 |
495286 | 08/18/2017 | Trump says US culture 'ripped apart' by statue removals |
| 58 |
495260 | 08/18/2017 | Senator Maria Chappelle-Nadal (D-Mo) : ‘I Hope Trump Is Assassinated!' |
| 59 |
495218 | 08/17/2017 | Something stinks about Charlottesville |
| 60 |
495214 | 08/17/2017 | Confederate Statues Today, Book Burnings Tomorrow? |
| 61 |
495211 | 08/17/2017 | Violent Tribalism on Display in Charlottesville |
| 62 |
495209 | 08/17/2017 | Dear Leftists, There Are No Nazis Under Your Bed |
| 63 |
495199 | 08/17/2017 | Former Klingon Master: Trump's comments on Charlottesville are 'a national disgrace' |
| 64 |
495150 | 08/16/2017 | Baltimore removes four Confederate statues - Civility, Law and order returning soon |
| 65 |
495149 | 08/16/2017 | Terrorism expert Steve Emmerson sez McMaster won't use the term 'radical Islam.' |
| 66 |
495077 | 08/15/2017 | Sen. Bernie Sanders Tweets That Trump Has 'Some Responsibility' for Charlottesville Attack |
| 67 |
495076 | 08/16/2017 | Fools to the Left of Me, Clowns to the Right |
| 68 |
495066 | 08/16/2017 | Three CEOs walk away from Trump after Charlottesville |
| 69 |
495059 | 08/15/2017 | White Supremacist Leader in Charlottesville Jason Kessler Was Obama Supporter – Occupy Protester |
| 70 |
495056 | 08/15/2017 | CNN guest interview - Challenges to 'blackness' and instructions to 'shut up' (Video) |
| 71 |
495055 | 08/15/2017 | CNN’s Symone Sanders Calls Out White Pundit Who Told Her To ‘Shut Up’ On Live TV (Video) |
| 72 |
495050 | 08/15/2017 | Protestors Topple Confederate Statue In North Carolina [VIDEO] |
| 73 |
495049 | 08/15/2017 | Buchanan: If We Erase Our History, Who Are We? |
| 74 |
495048 | 08/15/2017 | Charlottesville, truth, and the new cultural revolution |
| 75 |
495047 | 08/15/2017 | Sean Hannity exposes a threat to kill President Trump |
| 76 |
494994 | 08/15/2017 | Far-right supporter arrested for planning bomb in Oklahoma City |
| 77 |
494991 | 08/14/2017 | Kaepernick III - Seattle DE Michael Bennett Sits For National Anthem |
| 78 |
494980 | 08/14/2017 | Big Pharma CEO finds excuse to resign from presidential council |
| 79 |
494977 | 08/14/2017 | We'll Have More Charlottesvilles |
| 80 |
494965 | 08/14/2017 | Thousands gather in cities across the US in solidarity with Charlottesville victims |
| 81 |
494911 | 08/13/2017 | Hundreds protest in Oakland over deadly Virginia rally |
| 82 |
494908 | 08/13/2017 | State Police Helo crash deaths now linked to Charlottesville White Nationalists |
| 83 |
494907 | 08/13/2017 | Soetoro shares convicted terrorist Mandela quote after deadly white supremacist rally |
| 84 |
494906 | 08/13/2017 | Charlottesville AAR |
| 85 |
494873 | 08/12/2017 | BREAKING - Right-Wing Charlottesville (VA) Protest Rammed by Speeding Car |
| 86 |
494871 | 08/13/2017 | 1 Killed After Car Plows Into Protesters |
| 87 |
490533 | 06/17/2017 | This Week in Guns, June 17th, 2017 |
| 88 |
488245 | 05/17/2017 | Sanctuary City Mayor Trashes American Hero Robert E. Lee |
| 89 |
488061 | 05/15/2017 | Mayor of Charlottesville, VA calls Pro-Confederate rallies 'horrific' |
| 90 |
481824 | 02/22/2017 | Wegmans boycott over Trump wine backfires; supermarket sells out |
| 91 |
481635 | 02/19/2017 | Day by day the ranks diminish - god bless |