Forbedring af database kald

Hej,

Ka' du hjælpe med at forbedre nedenstående database kald, så det evt. kun er et kald, f. eks. vha. joins?

$query = mysql_query("SELECT id, question FROM polls_questions WHERE starts <= CURDATE() AND ends >= CURDATE()") or die(mysql_error());

if(mysql_num_rows($query) > 0)
{
    while($row = mysql_fetch_assoc($query))
    {
        $id = $row["id"];
        $question = htmlentities($row["question"]);

        $output .= "<form action=\"http://" . $_SERVER["HTTP_HOST"] . "/afstemninger/\" method=\"post\">\n";
        $output .= "<p>" . $question . "";

        $queryInner = mysql_query("SELECT SUM(votes) AS votes FROM polls_answers WHERE questions = '" . $id . "'") or die(mysql_error());

        if(mysql_num_rows($queryInner) > 0)
        {
            while($rowInner = mysql_fetch_assoc($queryInner))
            {
                $votes = $rowInner["votes"];

                $output .= " (" . $votes . " stemmer)</p>\n";
            }
        }

        mysql_free_result($queryInner);

        $output .= "<p>";

        $queryInner = mysql_query("SELECT id, answer FROM polls_answers WHERE questions = '" . $id . "'") or die(mysql_error());

        if(mysql_num_rows($queryInner) > 0)
        {
            while($rowInner = mysql_fetch_assoc($queryInner))
            {
                $aid = $rowInner["id"];
                $answer = $rowInner["answer"];

                $output .= "<input type=\"radio\" name=\"answer\" value=\"" . $aid . "\"> " . $answer . "<br>\n";
            }
        }

        mysql_free_result($queryInner);

        $output .= "</p>\n";
        $output .= "<p><input type=\"submit\" name=\"submit\" value=\"Stem\"></p>\n";
        $output .= "</form>\n";
    }
}

mysql_free_result($query);