Mysql multiple queries from one PHP file
I can't say how the queries should be built for the other 7 that you haven't posted, but I think I've identified enough commonalities in your design intent to exercise the D.R.Y. principle.

While it is always best to minimize total calls to the database, it seems you are struggling to package all of the queries into one.  I'll suggest implementing mysqli_multi_query() for your case with the noticeable benefit being maintainability.  I am assuming that your $datefilter value is 100% validated/secure and is safe to place into your queries (versus being a raw user input).  I should also note that if any of your queries experience a syntax error, the loop will break, the html table will close early, and you will see details about the erring query.

The following method can be modified to allow blank rows and/or group headings withing the html table -- just write that portion between the do{ and if($result... lines.

Untested Code:

// $datefilter MUST be validated/trustworthy as prepared statements are not in use.
$queries['KickOff']="SELECT actualstart AS `Time`,League,'KO' AS Label,HomeTeam,AwayTeam FROM livescores WHERE actualstart&gt;='$datefilter'";
$queries['HalfTime']="SELECT actualhalftime AS `Time`,League,'HT' AS Label,HomeTeam,AwayTeam FROM livescores WHERE actualhalftime&gt;='$datefilter'";
$queries['Fulltime']="SELECT actualft AS `Time`,League,'FT' AS Label,HomeTeam,AwayTeam FROM livescores WHERE actualft&gt;='$datefilter'";
// ... ~7 more queries entries here

echo "&lt;table&gt;";
if(mysqli_multi_query($mysqli,implode(';',$queries))){
    do{
        if($result=mysqli_store_result($mysqli)){
            while($row=mysqli_fetch_assoc($result)){
                echo "&lt;tr&gt;&lt;td&gt;{$row['Time']}&lt;/td&gt;&lt;td&gt;{$row['League']}&lt;/td&gt;&lt;td&gt;{$row['Label}&lt;/td&gt;&lt;td&gt;{$row['HomeTeam']} v {$row['AwayTeam']}&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;";
            }
            mysqli_free_result($result);
        }
    } while(next($queries) &amp;&amp; mysqli_more_results($mysqli) &amp;&amp; mysqli_next_result($mysqli));
}
echo "&lt;/table&gt;";
if($mysqli_error=mysqli_error($mysqli)){
    echo "&lt;div&gt;Error occurred on ",key($queries);
    // echo " Query: ",current($queries),"Syntax Error:&lt;br&gt;$mysqli_error&lt;/div&gt;";  // developer-only details
    echo "&lt;/div&gt;";
}


A link to my previous work that I am leveraging for this answer.