$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.