$result = mysql_query("
                       SELECT
                              media.medium_id,
                              media.name AS media_name, 
                              vcodecs.vcodec_id, 
                              vcodecs.name AS vcodecs_name,
                              movies.*
                       FROM
                            movies
                            LEFT JOIN media USING (medium_id)
                            LEFT JOIN vcodecs USING (vcodec_id)

                       WHERE
                             movies.movie_id = $_GET[movie]");

while($row = mysql_fetch_object($result))
  {
  }

$result2 = mysql_query("
                        SELECT
                               languages.lang_id,
                               languages.name AS lang_name,
                               acodecs.acodec_id,
                               acodecs.name AS acodec_name,
                               achannels.achannel_id,
                               achannels.name AS achannel_name,
                               subformats.subformat_id,
                               subformats.name AS subformat_name,
                               movie_lang.*
                        FROM
                             movie_lang
                             LEFT JOIN languages USING (lang_id)
                             LEFT JOIN acodecs USING (acodec_id)
                             LEFT JOIN achannels USING (achannel_id)
                             LEFT JOIN subformats USING (subformat_id)

                        WHERE
                              movie_lang.movie_id = $_GET[movie]");

while($row2 = mysql_fetch_object($result2))
  {
  }

$result = mysql_query("
                       SELECT
                              media.medium_id,
                              media.name AS media_name, 
                              vcodecs.vcodec_id, 
                              vcodecs.name AS vcodecs_name,
                              movies.*
                       FROM
                            movies
                            LEFT JOIN media USING (medium_id)
                            LEFT JOIN vcodecs USING (vcodec_id)

                       WHERE
                             movies.movie_id = $_GET[movie]");

while($row = mysql_fetch_object($result))
  {
  --hier sind 100 Zeilen Code um die Ergebnisse der Abfrage darzustellen--

  $result2 = mysql_query("
                          SELECT
                                 languages.lang_id,
                                 languages.name AS lang_name,
                                 acodecs.acodec_id,
                                 acodecs.name AS acodec_name,
                                 achannels.achannel_id,
                                 achannels.name AS achannel_name,
                                 subformats.subformat_id,
                                 subformats.name AS subformat_name,
                                 movie_lang.*
                          FROM
                               movie_lang
                               LEFT JOIN languages USING (lang_id)
                               LEFT JOIN acodecs USING (acodec_id)
                               LEFT JOIN achannels USING (achannel_id)
                               LEFT JOIN subformats USING (subformat_id)

                          WHERE
                                movie_lang.movie_id = $_GET[movie]");

  while($row2 = mysql_fetch_object($result2))
    {
    --30 Zeilen für die Ergebnisse der 2ten Abfrage--
    }
  --30 Zeilen für die restlichen Ergebnisse der 1ten Abfrage--
  }