img_id | album_id | uid |     name     | ext  
-------+----------+-----+--------------+------
    38 |      14  |  89 | mypetrat     | jpg  
    39 |      14  |  89 | mypetlemur   | jpg  
    40 |       2  |  12 | vacation_01  | jpg  
    41 |      14  |  89 | mypetvulture | jpg  
    42 |       2  |  12 | vacation_02  | jpg  
    43 |       2  |  12 | vacation_03  | jpg  
    44 |      14  |  89 | mypetcow     | jpg  


##</code><code>##

img_id | album_id | seq_id | uid |     name     | ext  
-------+----------+--------+-----+--------------+------
    38 |      14  |      1 |  89 | mypetrat     | jpg  
    39 |      14  |      2 |  89 | mypetlemur   | jpg  
    40 |       2  |      1 |  12 | vacation_01  | jpg  
    41 |      14  |      3 |  89 | mypetvulture | jpg  
    42 |       2  |      2 |  12 | vacation_02  | jpg  
    43 |       2  |      3 |  12 | vacation_03  | jpg  
    44 |      14  |      4 |  89 | mypetcow     | jpg  

##</code><code>##

select seq_id from TABLE where img_id = $img_id

##</code><code>##

my $p_seq_id = $seq_id - 1;
my $n_seq_id = $seq_id + 1;

"select img_id from TABLE where seq_id in ($p_seq_id, $seq_id, $n_seq_id)"