peopleleague

SELECT n.*, (SELECT MIN(params) FROM %s AS nga INNER JOIN %s AS ng ON ng.id = nga.group_id WHERE nga.news = n.id) AS newsparams FROM %s AS n JOIN %s AS nl ON n.id=nl.news AND nl.locale=:locale WHERE n.status="active" AND n.site=:site AND nl.locale=:locale AND ((n.startdate IS NULL OR n.startdate <= CURDATE()) AND (n.starttime IS NULL OR n.starttime <= CURTIME())) AND (n.enddate IS NULL OR n.enddate >= CURDATE()) AND nl.active="1" ORDER BY nl.importance DESC, n.date DESC, nl.time DESC LIMIT 0, 3 peopleleague

A-tasand I

	team	M	P
1	RL. FC Tartu	5	15
2	RL. Lähte United	7	15
3	RL. JK Saare Latte	8	15
4	RL. Fc Tartu Goats	6	13
5	RL. Salme Football Squad	7	12
6	RL. FC Kohvile	5	9
7	RL. Marja FC Statalona	9	9
8	RL. Keila GSE	7	3
9	RL. JK Punane Silm	5	1
10	RL. AFC Eyjafjallajökull	3	0

A-tasand II

	team	M	P
1	RL. FC KUBIK	8	22
2	RL. Kena Jalgpalliklubi	8	19
3	RL. FC Taritu	7	13
4	RL. Haapsalu Leegion	7	12
5	RL. FC Kallaste United	8	7
6	RL. FC Lebo Ülesanne	5	7
7	RL. JK Loo/ FCS.ee	6	6
8	RL. FC Tallinna Deemonid	7	5
9	RL. FC Ankur	4	4
10	RL. JK Ajax Asja	8	3

game_datetime	league	hometeam	VS	awayteam
24.08.2025 time 19:00	A-tasand II	RL. FC Kallaste United	-	RL. FC Lebo Ülesanne
24.08.2025 time 15:00	A-tasand I	RL. FC Tartu	-	RL. FC Kohvile
24.08.2025 time 12:00	A-tasand I	RL. Keila GSE	-	RL. AFC Eyjafjallajökull
23.08.2025 time 14:00	A-tasand II	RL. FC Tallinna Deemonid	-	RL. Kena Jalgpalliklubi
20.08.2025 time 20:30	A-tasand I	RL. Salme Football Squad	-	RL. JK Punane Silm
18.08.2025 time 20:10	A-tasand II	RL. JK Loo/ FCS.ee	-	RL. Haapsalu Leegion