Wiki4HumanRights

SQL

select 
actor_name,page_title,rev_len,
CONCAT(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2), "-",substr(rev_timestamp,7,2)," ",substr(rev_timestamp,9,2)+7,":",substr(rev_timestamp,11,2)) as 'Timestamp'

from revision
join page on rev_page = page_id join actor on rev_actor = actor_id
where page_title = "Hak_konstitusional" or
page_title = "Integritas_tubuh" or
page_title = "Hak_untuk_dilupakan" or
page_title = "Pelanggaran_HAM_berat" or
page_title = "Penghapusan_hukuman_mati" or
page_title = "Hukuman_mati_di_Amerika_Serikat" or
page_title = "Hukuman_mati_di_Arab_Saudi" or
page_title = "Komisi_Eropa_menentang_Rasisme_dan_Intoleransi" or
page_title = "Komite_Eropa_untuk_Pencegahan_Penyiksaan" or
page_title = "Perubahan_iklim_dan_gender" or
page_title = "Kebebasan_pers_di_Indonesia" or
page_title = "Hak_atas_pembangunan" or
page_title = "Hak_atas_privasi" or
page_title = "Definisi_genosida" or
page_title = "Konvensi_Masyarakat_Adat_1957" or
page_title = "Konvensi_Masyarakat_Adat_1989" or
page_title = "Hukuman_fisik_anak" or
page_title = "Kekerasan_di_sekolah" or
page_title = "Hak_moral_dan_hak_legal" or
page_title = "Hak_atas_air" or
page_title = "Hak_atas_sandang" or
page_title = "Hak_tahanan" or
page_title = "Hak_minoritas" or
page_title = "Filsafat_hak_asasi_manusia" or
page_title = "Perlindungan_data" or
page_title = "Bisnis_dan_hak_asasi_manusia" or
page_title = "Pembunuhan_yang_ditargetkan" or
page_title = "Perbudakan_modern" or
page_title = "Pemindahan_penduduk" or
page_title = "Hukum_hak_asasi_manusia_internasional" or
page_title = "Hak_asasi_manusia_dalam_UUD_1945" or
page_title = "Undang-Undang_Republik_Indonesia_Nomor_39_Tahun_1999" or
page_title = "Perkara_genosida_Bosnia" or
page_title = "Evans_v._United_Kingdom" or
page_title = "Miranda_v._Arizona" or
page_title = "Hukuman_mati_di_Jepang" or
page_title = "Penyiksaan_dan_hak_asasi_manusia" or
page_title = "Teknik_interogasi_yang_ditingkatkan" or
page_title = "Prajurit_anak" or
page_title = "Perdagangan_anak" or
page_title = "Wanita_pembela_hak_asasi_manusia" or
page_title = "Hak_reproduksi_dan_seksual" or
page_title = "Deklarasi_Perserikatan_Bangsa-Bangsa_tentang_Penghapusan_Kekerasan_terhadap_Perempuan" or
page_title = "16_Hari_Aktivisme_Melawan_Kekerasan_Berbasis_Gender" or
page_title = "Hukum_pers" or
page_title = "Keselamatan_wartawan" or
page_title = "Hak_asasi_manusia_dan_perubahan_iklim" or
page_title = "Perubahan_iklim_dan_anak-anak"
order by rev_timestamp
SQL

Checking query status...
