groups_id
nav_on
matches
leagues
yyyy
groups
groupings
default_period
obLevel
__env
app
errors
page_title
year
group
__empty_1
select * from `groups` where `convention` = '16' and `grouping` = '23'
SELECT *
select `id` from `groups` where `convention` = '16' and `grouping` = '23'
select * from `leagues` where `leagues`.`deleted_at` is null and `year` = '2024' and `group_id` = '86' and `convention` = '16'
select `id` from `leagues` where `leagues`.`deleted_at` is null and `year` = '2024' and `group_id` = '86' and `convention` = '16'
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '86' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1
select * from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '86' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 0
select * from `groups` where `convention` = '16' limit 1
LIMIT
ORDER BY
