select max(P.img_id), T.img_id, min(N.img_id)
 from images T, images P, images N
 where P.img_id(+) < T.img_id and P.uid(+) = T.uid and P.album_id(+) = T.album_id
   and N.img_id(+) > T.img_id and N.uid(+) = T.uid and N.album_id(+) = T.album_id
   and T.img_id = ? and T.uid = ? and T.album_id = ?
 group by T.img_id