select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-02-06' and rdate <= '2022-10-04') as y where lower(rquote) like '%al-aqsa foundation%' or lower(rquote) like '%al aqsa foundation%' order by id desc limit 100
| 1 |
321685 | 05/03/2011 | Gaza Flotilla: Holland puts IHH on terror list, freezes local assets |
| 2 |
302923 | 08/08/2010 | South Africa irked US in war on terror |
| 3 |
282389 | 11/03/2009 | Palestinians foil attack on Al-Aqsa worshippers |
| 4 |
280289 | 10/04/2009 | Islamic Movement head: Netanyahu a political madman |
| 5 |
275461 | 07/30/2009 | More Than 200 Jewish Activists Storm al-Asqa Mosque |
| 6 |
176915 | 01/05/2007 | EU: Dutch Group Put on Terror List |
| 7 |
15534 | 06/16/2003 | Australia freezes assets of group linked to Hamas |
| 8 |
14860 | 05/29/2003 | Britain freezes assets of Israeli Arab charity |