Handbook
Policies
Procedures
People
Finance
Other
Roll of Honour
Mini-Soccer (U7-U10)
9-a-Side (U11-U12)
11-a-Side (U13-U21)
REMINDER: ONLY USE THE APP for Games which are played to a conclusion -
DO NOT USE THE APP FOR POSTPONED or UNPLAYED GAMES– Instead of the APP - GO TO THE RESULTS PAGE ON THE WEBSITE and use the drop down menu.
thisTag
tags
news
showArchived
obLevel
__env
app
errors
t
n
select 'All' as tag, count(id) as count from news where publish_from <= '2025-04-01T14:21:15+01:00' and publish_to >= '2025-04-01T14:21:15+01:00' and deleted_at is null union select tag.name as tag, count(news.id) as count from news join news_tags on news.id=news_tags.news_id join tag on news_tags.tag_id=tag.id where ((publish_from <= '2025-04-01T14:21:15+01:00' and publish_to >= '2025-04-01T14:21:15+01:00')) and deleted_at is null group by tag.name;
select * from `news` where `news`.`deleted_at` is null and `publish_from` <= '2025-04-01T14:21:15+01:00' and `publish_to` >= '2025-04-01T14:21:15+01:00' order by `publish_from` desc
SELECT *
select `tag`.*, `news_tags`.`news_id` as `pivot_news_id`, `news_tags`.`tag_id` as `pivot_tag_id` from `tag` inner join `news_tags` on `tag`.`id` = `news_tags`.`tag_id` where `news_tags`.`news_id` in ('184')