League Table

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR `away_team` = ) AND DATEDIFF(NOW(), `date`) <= 0 ORDER BY `date` ASC' at line 1]
SELECT `group`, `home_team`, `away_team`, DATE_FORMAT(`date`, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(`date`, '%e') AS day, DATE_FORMAT(`date`, '%c') AS month, DATE_FORMAT(`date`, '%Y') AS year, DATE_FORMAT(`date`, '%H') AS `hour`, DATE_FORMAT(`date`, '%i') AS `minutes`, `match_day`, `location`, `league_id`, `home_points`, `away_points`, `winner_id`, `loser_id`, `post_id`, `season`, `id`, `custom` FROM wp_leaguemanager_matches WHERE ( `home_team` = OR `away_team` = ) AND DATEDIFF(NOW(), `date`) <= 0 ORDER BY `date` ASC

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR `away_team` = ) AND DATEDIFF(NOW(), `date`) > 0 ORDER BY `date` DESC LIMIT 0' at line 1]
SELECT `group`, `home_team`, `away_team`, DATE_FORMAT(`date`, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(`date`, '%e') AS day, DATE_FORMAT(`date`, '%c') AS month, DATE_FORMAT(`date`, '%Y') AS year, DATE_FORMAT(`date`, '%H') AS `hour`, DATE_FORMAT(`date`, '%i') AS `minutes`, `match_day`, `location`, `league_id`, `home_points`, `away_points`, `winner_id`, `loser_id`, `post_id`, `season`, `id`, `custom` FROM wp_leaguemanager_matches WHERE ( `home_team` = OR `away_team` = ) AND DATEDIFF(NOW(), `date`) > 0 ORDER BY `date` DESC LIMIT 0,1

Rank
Matches
Won
Tied
Lost
Coach
Website

 

 Matches

Match Score
8 July, 2019
Lundin Sports 2 – David Lloyd 3
4 - 8
8 July, 2019
Glenfarg – Glenrothes
10 - 2
8 July, 2019
Montrose 4 – Arbroath 3
11 - 1
8 July, 2019
Scone 3 – Lundin Sports 3
2 - 10
15 July, 2019
Scone 3 – Glenrothes
7 - 5
15 July, 2019
Montrose 4 – Lundin Sports 2
9 - 3
15 July, 2019
Lundin Sports 3 – Arbroath 3
6 - 6
15 July, 2019
David Lloyd 3 – Glenfarg
8 - 4
22 July, 2019
Arbroath 3 – Glenrothes
10 - 2
22 July, 2019 Rain halted play early
Lundin Sports 3 – Lundin Sports 2
1 - 6
22 July, 2019
David Lloyd 3 – Montrose 4
8 - 4
22 July, 2019
Scone 3 – Glenfarg
4 - 8
29 July, 2019
Lundin Sports 2 – Glenrothes
5 - 7
29 July, 2019
Lundin Sports 3 – Montrose 4
0 - 12
29 July, 2019
Arbroath 3 – Glenfarg
7 - 5
29 July, 2019
Scone 3 – David Lloyd 3
1 - 11
5 August, 2019
Glenfarg – Lundin Sports 2
2 - 10
5 August, 2019 Play halted early because of time limit
Glenrothes – Montrose 4
2 - 7
5 August, 2019 26 August
Arbroath 3 – Scone 3
-:-
5 August, 2019
David Lloyd 3 – Lundin Sports 3
11 - 1
12 August, 2019
Montrose 4 – Glenfarg
9 - 3
12 August, 2019 Both teams had only 4 players
Lundin Sports 2 – Scone 3
6 - 0
12 August, 2019
Glenrothes – Lundin Sports 3
5 - 7
12 August, 2019
David Lloyd 3 – Arbroath 3
10 - 2
19 August, 2019
Montrose 4 – Scone 3
12 - 0
19 August, 2019
Glenfarg – Lundin Sports 3
10 - 5
19 August, 2019
Lundin Sports 2 – Arbroath 3
1 - -1
19 August, 2019
Glenrothes – David Lloyd 3
5 - 6