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'