select id,rdate,rbanner from (select * from tbltwar where rdate >= '2009-05-15' and rdate <= '2021-08-13') as y where lower(rquote) like '%righthaven%' order by id desc limit 100
| 1 |
438977 | 12/18/2015 | Sheldon Adelson Bought The Las Vegas Review-Journal |
| 2 |
411309 | 02/22/2015 | Las Vegas Review-Journal parent company sold
|
| 3 |
395469 | 07/13/2014 | Harry Reid Slammed By Hometown Paper For 'Race-Baiting' |
| 4 |
364422 | 03/18/2013 | Trollhaven Copyrights 'Sold' Back To Stephens Media For $80k To Pay Legal Fees |
| 5 |
354324 | 10/21/2012 | Trollhaven agrees to turn hard drives over to creditors |
| 6 |
343429 | 04/25/2012 | The Righthaven Experiment: A Journalist Wonders If a Copyright Troll Was Right to Sue Him |
| 7 |
342668 | 04/12/2012 | Review-Journal owner facing $774,000 fee demand in Righthaven case |
| 8 |
341766 | 03/28/2012 | Copyright Troll surrenders |
| 9 |
340935 | 03/14/2012 | Judge orders failed copyright troll to forfeit "all" copyrights |
| 10 |
340934 | 03/14/2012 | Judge Orders Failed Copyright Troll to Forfeit "All" Copyrights |
| 11 |
340362 | 03/06/2012 | Judge strips Righthaven of rights to 278 copyrights and its trademark |
| 12 |
337150 | 01/15/2012 | Zedillo Lawsuit will be decided on sovereignity claims |
| 13 |
337089 | 01/14/2012 | Righthaven's lawyers now targets of State Bar investigation |
| 14 |
336871 | 01/10/2012 | Righthaven complains about 'scorched-earth' efforts to enforce judgments |
| 15 |
336297 | 01/01/2012 | Righthaven sued by process server, faces contempt motion |
| 16 |
336008 | 12/27/2011 | RightHaven.com Domain Name Auction Starts On SnapNames.com |
| 17 |
335742 | 12/22/2011 | Trollhaven files emergency appeal to block copyright auction |
| 18 |
333683 | 11/19/2011 | Righthaven case ends in victory for fair use |
| 19 |
333462 | 11/15/2011 | Attorneys seek to auction Righthaven copyrights
|
| 20 |
333226 | 11/11/2011 | Marshals execute against Righthaven bank account
|
| 21 |
332808 | 11/03/2011 | US Marshalls Authorized to Collect From Righthaven (YEEE-Haw!) |
| 22 |
332758 | 11/02/2011 | US Marshals turned loose to collect $63,720.80 from Righthaven
|
| 23 |
332749 | 11/02/2011 | US Marshals to collect $63,720.80 from Righthaven |
| 24 |
332523 | 10/29/2011 | Creditor Moves to Dismantle Copyright Troll Righthaven |
| 25 |
332455 | 10/28/2011 | Wronghaven ordered to pay nearly $120,000 in attorney fees and court costs |
| 26 |
332396 | 10/27/2011 | Righthaven ordered to pay nearly $120,000 in attorney fees, court costs |
| 27 |
331410 | 10/11/2011 | Righthaven Tells Court It's Rejected by All Bonding Companies
|
| 28 |
330685 | 09/29/2011 | Righthaven Desperately Trying To Avoid Paying Legal Fees |
| 29 |
330611 | 09/28/2011 | Righthaven's Losing Streak Continues in Colorado |
| 30 |
330198 | 09/21/2011 | Copyright Troll's Assets Targeted for Seizure |
| 31 |
329453 | 09/09/2011 | MediaNews won't renew contract with copyright troll Righthaven |
| 32 |
329439 | 09/08/2011 | And to the joy of Rantburgers - Copyright Troll Righthaven Goes on Life Support |
| 33 |
328141 | 08/17/2011 | Karmic justice visited upon Righthaven (again) |
| 34 |
326317 | 07/14/2011 | Righthaven fined $5,000 for misleading Nevadas federal court |
| 35 |
325607 | 07/02/2011 | Honest, Judge - The Dog Browser Ate My Homework |
| 36 |
324931 | 06/21/2011 | Righthaven Loss: Judge Rules Reposting Entire Article Is Fair Use |
| 37 |
324604 | 06/15/2011 | Righthaven Lacks Standing To Sue- Threatens Sanctions |
| 38 |
320562 | 04/16/2011 | Judge unseals Review-Journal/Righthaven contract |
| 39 |
318669 | 03/21/2011 | Righthaven loses second fair use ruling over copyright lawsuits |
| 40 |
316821 | 02/24/2011 | House GOP could end copyright lawsuit abuse |
| 41 |
316510 | 02/20/2011 | Autistic blogger sued by RightHaven |
| 42 |
312774 | 12/29/2010 | A reminder when posting articles |
| 43 |
311734 | 12/14/2010 | Righthaven sues for control of Drudge Report domain |
| 44 |
311535 | 12/11/2010 | The R**hthaven Blegethon Continues...... |
| 45 |
311467 | 12/10/2010 | Update of Update on R****haven... |
| 46 |
311392 | 12/09/2010 | Update on Rthvn... |
| 47 |
311338 | 12/08/2010 | Update on Rthvn... |
| 48 |
309978 | 11/19/2010 | Las Vegas Publisher and Editor Who Sued Bloggers is Out of a Job |
| 49 |
309969 | 11/19/2010 | Righthaven Loses in Court, Changes Biz Plan to "Bankruptcy" |
| 50 |
308489 | 10/28/2010 | Spend $105. Make Righthaven go away. |
| 51 |
304901 | 09/05/2010 | Updated Stephens Media Firefox Block List |
| 52 |
304414 | 08/30/2010 | Updated Stephens Media Firefox Block List |
| 53 |
303569 | 08/17/2010 | On being sued... |