select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-09-20' and rdate <= '2008-03-21') as y where lower(rquote) like '%lancet%' order by id desc limit 100
| 1 |
227870 | 02/19/2008 | Iraqi Deaths Pain Sharon Stone |
| 2 |
224624 | 02/08/2008 | Blocking Blair |
| 3 |
218911 | 01/13/2008 | Soros Funded Lancet Excessive Death Number Study |
| 4 |
204312 | 10/29/2007 | New drive to encourage civil registration: UN |
| 5 |
203172 | 10/20/2007 | Israeli Scientists En Route to Personalized MS Medicine |
| 6 |
200512 | 09/28/2007 | Mom may be able to pass bird flu to fetus |
| 7 |
196766 | 08/21/2007 | Oil Wars: Fueling Both U.S. Empire & Ecocide |
| 8 |
187114 | 04/29/2007 | Afghan infant deaths fall by 40K/year since Taliban ouster |
| 9 |
185980 | 04/17/2007 | ask rosie |
| 10 |
184892 | 04/04/2007 | Somalia: Local doctors warn of diseases outbreak |
| 11 |
183225 | 03/16/2007 | Dick Cheneys Nonexistent Dementia |
| 12 |
182618 | 03/09/2007 | 650,000 Iraqi Deaths Study Exposed |
| 13 |
182290 | 03/05/2007 | Lancet Study Troubling |
| 14 |
182206 | 03/04/2007 | Was Lancet study fraudulent, or simply erroneous? |
| 15 |
181332 | 02/24/2007 | Circumcision better than any AIDS 'vaccine' |
| 16 |
179696 | 02/06/2007 | US immigration cavity search ends in agony |
| 17 |
176685 | 01/02/2007 | 16, 273 Deaths Reported in Iraq in 2006 |
| 18 |
175822 | 12/22/2006 | World Death Toll Of a Flu Pandemic Would Be 62 Million |
| 19 |
171490 | 11/10/2006 | 150,000 Iraqis Killed by Insurgents |
| 20 |
171089 | 11/06/2006 | Bush and Blair have forfeited the moral authority to hang Saddam |
| 21 |
169691 | 10/25/2006 | How 620,000 were killed in a four-year war |
| 22 |
169211 | 10/20/2006 | Study Claims Iraqis Have Half Million Non-Existing Death Certificates |
| 23 |
168891 | 10/17/2006 | Downer slams Labor over Iraq pullout plan |
| 24 |
168363 | 10/11/2006 | MIT Funds Openly Fraudulent Johns-Hopkins Iraq Death Toll, Now 655,000 |
| 25 |
162544 | 08/10/2006 | More water well stories from the Raj, but not for the faint of heart. |
| 26 |
142537 | 02/13/2006 | Mind Control by Parasites |
| 27 |
139805 | 01/15/2006 | Cancer Researcher Admits to Faking Data |
| 28 |
139365 | 01/09/2006 | India 'loses aborts 10m female births' |
| 29 |
139104 | 01/06/2006 | Britain sees surge in cirrhosis deaths |
| 30 |
139099 | 01/06/2006 | DR Congo war world's deadliest: report |
| 31 |
129979 | 09/19/2005 | Iraq forces on alert in holy city |
| 32 |
124094 | 07/15/2005 | London Bombers Were Angered by War in Iraq |
| 33 |
123907 | 07/13/2005 | Molly Ivins : I was wrong |
| 34 |
123673 | 07/11/2005 | Debunking 8 Anti-War Myths About Iraq |
| 35 |
122024 | 06/19/2005 | 'Scaremongering' Lancet accused of causing harm to health and wasting millions |
| 36 |
121695 | 06/15/2005 | Embryonic Stem Cell Cures a Long Way Off, Experts Warn |
| 37 |
119159 | 05/14/2005 | Iraqis soldier on without power, water, jobs, sewers |
| 38 |
118895 | 05/11/2005 | Cairo dilemma over prayer calls |
| 39 |
62669 | 04/30/2005 | MSM cover-up? "Smoglodytes" kill 36,000 in Mexico City |
| 40 |
55003 | 01/29/2005 | US and allies 'kill most Iraqis' |
| 41 |
54856 | 01/27/2005 | Researchers Who Rushed Into Print a Study of Iraqi Civilian Deaths Now Wonder Why It Was Ignored |
| 42 |
51516 | 12/17/2004 | Scots eat their pizzas deep fried |
| 43 |
47229 | 10/29/2004 | Study: 100,000 Excess Civilian Iraqi Deaths Since War |
| 44 |
44734 | 09/30/2004 | UK: Vitamins don't block cancers, says study |
| 45 |
43016 | 09/12/2004 | My Kind of Study |
| 46 |
41101 | 08/20/2004 | Professor Accuses Doctors in Iraq Abuse |