$albumID_1 = mysql_real_escape_string($_GET['album_id1']); //Örneğin 1
$albumID_2 = mysql_real_escape_string($_GET['album_id2']); //Örneğin 4
 
$sql = "Select (Select photo_thumb2 From fusion_photos Where album_id='"  . $albumID_1 . "') as 'a1',(Select photo_thumb2 From fusion_photos  Where album_id='" . $albumID_2 . "') as 'a2' From  fusion_photos order  by album_id asc";

$query = mysql_query($sql) or die (mysql_error());
$rows = mysql_fetch_assoc($query);

foreach($rows['a1'] as $albumID_1_olan):

    echo "album_id'si 1 : " . $rows['photo_thumb2'] . '<br />';

endforeach;


foreach($rows['a2'] as $albumID_4_olan):
 
    echo "album_id'si 4 : " . $rows['photo_thumb2'] . '<br />';
 
endforeach;
Tek query'de bu şekilde halledebilirsin.Denemedim ama çalışacaktır büyük ihtimal.