Tabelle Landesliga 2

= CURDATE() GROUP BY liga_daten_id ) latest ON ldc.id = latest.max_id LEFT JOIN liga_daten ld ON ldc.liga_daten_id = ld.id LEFT JOIN liga ON ld.liga_id = liga.id LEFT JOIN liga_team ht ON ld.heim_team_id = ht.id LEFT JOIN liga_team gt ON ld.auswaerts_team_id = gt.id LEFT JOIN team_daten h ON ht.team_id = h.id LEFT JOIN team_daten g ON gt.team_id = g.id LEFT JOIN verein hv ON h.verein_id = hv.id LEFT JOIN verein gv ON g.verein_id = gv.id WHERE ld.heim_team_id IS NOT NULL AND ld.auswaerts_team_id IS NOT NULL AND ld.heim_goals IS NULL AND ld.auswaerts_goals IS NULL AND (h.md_ID > 15000 OR g.md_ID > 15000) AND ld.spiel_datum NOT LIKE '%23:59:00' ORDER BY ldc.change_date DESC"; $neuansetzungen = $sfdb->query($neuansetzungendb); $i = 0; if ($neuansetzungen->num_rows > 0) { $content = ''; while ($row = $neuansetzungen->fetch_assoc()) { $changedate = $row['change_date']; $aenderungsdatum = date("d.m.Y", strtotime($row['change_date'])); if (!empty($row['liga_id'])) { $ligaid = $row['liga_id']; global $wpdb; $ligadb = $wpdb->get_results("SELECT * FROM liga WHERE liga_id = $ligaid"); foreach ($ligadb as $ligadb1) { $liganame = $ligadb1->liga_name; } } else { $ligaid = NULL; $liganame = $row['liga_kurzname']; } $ligaurl = $row['liga_link']; $spieltag = $row['runde']; $heimid = $row['heim_id']; $gastid = $row['gast_id']; $spieldatum = $row['spiel_datum']; $datum = date("d.m.", strtotime($spieldatum)); $zeit = date("H:i", strtotime($spieldatum)); global $wpdb; $heimdb = $wpdb->get_results("SELECT * FROM team WHERE team_id = $heimid"); foreach ($heimdb as $heimdb1) { $heimname = $heimdb1->team_kurzname; $heimblogid = $heimdb1->team_blogid; } global $wpdb; $gastdb = $wpdb->get_results("SELECT * FROM team WHERE team_id = $gastid"); foreach ($gastdb as $gastdb1) { $gastname = $gastdb1->team_kurzname; $gastblogid = $gastdb1->team_blogid; } if ($currentblogid == $heimblogid and $currentblogid == $gastblogid and $i < 3) { $content .= ''; $i++; } } $content .= ''; $content .= '

' . $liganame . ', ' . $spieltag . '. Spieltag: ' . getWeekday($spieldatum) . '., ' . $datum . ', um ' . $zeit . ' Uhr: '; if ($heimid > 15000) { $content .= ''; } $content .= $heimname; if ($heimid > 15000) { $content .= ''; } $content .= ' - '; if ($gastid > 15000) { $content .= ''; } $content .= $gastname; if ($gastid > 15000) { $content .= ''; } $content .= '

Alle Neuansetzungen

'; } $sfdb->close(); echo $content; ?>