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)

Event Details