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"
order by rev_timestamp
SQL

Checking query status...
