select id,rdate,rbanner from (select * from tbltwar where rdate >= '2019-10-02' and rdate <= '2022-12-30') as y where lower(rquote) like '%socotra%' order by id desc limit 100
| 1 |
653528 | 12/26/2022 | Activist abducted in Socotra archipelago |
| 2 |
650775 | 11/26/2022 | Saudi Arabia and UAE planning new airport runway on occupied Socotra |
| 3 |
649640 | 11/17/2022 | Group of young Yemeni women trained in UAE arrives in occupied Socotra |
| 4 |
649412 | 11/14/2022 | Saudi Arabia transfers Socotra residents for mercenary training in Riyadh
|
| 5 |
647007 | 10/18/2022 | UAE deploys senior intelligence officer to occupied Socotra island |
| 6 |
644346 | 09/18/2022 | UAE occupation recruits 400 new mercenaries in Socotra |
| 7 |
642961 | 09/02/2022 | Zionist entity sends experts to Emirati-occupied Socotra island |
| 8 |
642444 | 08/28/2022 | Emirati occupation force in Socotra to recruit Yemeni women for mercenary training |
| 9 |
640678 | 08/08/2022 | UAE occupation launches campaign of abductions in occupied Socotra |
| 10 |
639236 | 07/23/2022 | Antifa begin feud with Oregon biker gangs |
| 11 |
638923 | 07/20/2022 | UAE occupation launches wave of arrests in occupied Socotra |
| 12 |
636721 | 06/26/2022 | Pro-Saudi commander killed in Ma'rib |
| 13 |
636283 | 06/21/2022 | Severe food crisis hits UAE-occupied Socotra |
| 14 |
636058 | 06/18/2022 | Emirati occupation force Yemenis in Socotra to pay bills in UAE currency |
| 15 |
635721 | 06/14/2022 | UAE-backed mercenaries in Yemen sell large quantities of weapons to unknown party |
| 16 |
634282 | 05/30/2022 | Separatist leader assassinated in Hadhramaut |
| 17 |
633054 | 05/16/2022 | Saudi-led authorities planning to lease Socotra Island to UAE |
| 18 |
632267 | 05/07/2022 | Saudi occupation forces in Socotra attacked by unknown assailants
|
| 19 |
632009 | 05/04/2022 | Several Al-Qaeda members escaped Hadhramaut prison under suspicious circumstances |
| 20 |
631823 | 05/01/2022 | Good Morning |
| 21 |
631750 | 05/01/2022 | Emirati plane carrying foreign military officers arrives in occupied Socotra archipelago
|
| 22 |
621568 | 01/04/2022 | Houthis capture the UAE ship Rwabi |
| 23 |
617370 | 11/13/2021 | Emirates film on Yemen releases Nov. 25th |
| 24 |
581871 | 09/09/2020 | UAE sets up 8 telecom towers, plans to build military base on Yemen’s Socotra |
| 25 |
574954 | 06/22/2020 | Yemen's southern separatists have seized control of the strategic island of Socotra |
| 26 |
568638 | 04/13/2020 | Good afternoon |
| 27 |
568588 | 04/13/2020 | Saudi-backed militants take military camp on Yemen's Socotra island |
| 28 |
566311 | 03/18/2020 | Good evening |
| 29 |
566296 | 03/19/2020 | Civil war rivals vie for Yemen's strategic Socotra island
|
| 30 |
566233 | 03/18/2020 | Security forces seized a UAE container carrying armored personnel carriers and military equipment in the port of Socotra |