3 query'er til 1

hej...

kan dette laves på en anden måde så der kun skal køres en query?

<?
foreach($list_arr['list'] as $party_id)
{
    $get = mysql_query("SELECT added, time_start, name, area FROM $DB.party WHERE id=$party_id");
    $row = mysql_fetch_array($get);
   
    if(($TIME - 432000) < $row['added']) $new = '<img src="gfx/party_new.gif">';
    else $new = '&nbsp;';
   
    $get2 = mysql_query("SELECT * FROM $DB.party_music WHERE party_id=$party_id");
    while($row2 = mysql_fetch_array($get2)) $party_music[] = $MUSIC[$row2['music']];
    asort($party_music);
    foreach($party_music as $value) $music .= "$value<br>";
    $music = substr($music, 0, -4);
   
    $get2 = mysql_query("SELECT * FROM $DB.user_party WHERE party_id=$party_id");
    $users = mysql_num_rows($get2);
?>
  <tr valign="top">
    <td class="list" style="padding: 0px; padding-top: 11px;"><?=$new?></td>
    <td class="list" style="padding-left: 0px;"><?=time2date($row['time_start'], 1, 1)?><br><a class="headline" href=""><?=sql2txt($row['name'])?></a><br><?=$AREA[$row['area']]?></td>
    <td class="list"><?=$music?></td>
    <td class="list" align="right"><br><?=$users?></td>
  </tr>
<?
    unset($party_music, $music);
}
?>