groups_id
nav_on
matches
leagues
yyyy
groups
groupings
default_period
obLevel
__env
app
errors
page_title
year
group
__empty_1
league
__empty_2
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` = '2025' and `group_id` = '87' and `convention` = '16'
select `id` from `leagues` where `leagues`.`deleted_at` is null and `year` = '2025' and `group_id` = '87' and `convention` = '16'
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '87' 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` = '87' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 0
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '247' 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` = '247' 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 `groups`.`id` = '87' and `groups`.`id` is not null limit 1
LIMIT
ORDER BY
select * from `groups` where `convention` = '16' limit 1
