SELECT id_post,judul,
(SELECT judul FROM web_post_data s1
WHERE s1.id_post < s.id_post AND s1.tipe ='event'
ORDER BY id_post DESC LIMIT 1) as previous_judul,
(SELECT id_post FROM web_post_data s1
WHERE s1.id_post < s.id_post AND s1.tipe ='event'
ORDER BY id_post DESC LIMIT 1) as previous_id_post,
(SELECT judul FROM web_post_data s2
WHERE s2.id_post > s.id_post AND s2.tipe ='event'
ORDER BY id_post ASC LIMIT 1) as next_judul,
(SELECT id_post FROM web_post_data s2
WHERE s2.id_post > s.id_post AND s2.tipe ='event'
ORDER BY id_post ASC LIMIT 1) as next_id_post
FROM web_post_data s
WHERE s.id_post = :id_post AND s.tipe ='event' IAGI (Ikatan Ahli Geologi Indonesia)
Pada tanggal 1 Juni 2020 bersamaan dengan keluarnya Surat Keputusan Nomor : SK/54/PP-IAGI/VI/in-2020tentang "Penetapan Komite Pemilihan Umum Ikatan Ahli Geologi Indonesia 2020" sudah dilakukan Kick Off Meeting secara daring dalam rangka persiapan teknis dan administrasi Pemilihan Umum IAGI 2020.
