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' and `id` <> '66'
SELECT *
select `id` from `groups` where `convention` = '16' and `grouping` = '23' and `id` <> '66'
select * from `leagues` where `leagues`.`deleted_at` is null and `year` = '2025' and `group_id` in ('65', '69', '84', '85', '86', '87') and `convention` = '16'
select `id` from `leagues` where `leagues`.`deleted_at` is null and `year` = '2025' and `group_id` in ('65', '69', '84', '85', '86', '87') and `convention` = '16'
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` in ('243', '244', '245', '246', '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` in ('243', '244', '245', '246', '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 count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '243' 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` = '243' 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` = '244' 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` = '244' 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` = '245' 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` = '245' 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` = '246' 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` = '246' 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` = '69' and `groups`.`id` is not null limit 1
LIMIT
ORDER BY
select * from `groups` where `groups`.`id` = '84' and `groups`.`id` is not null limit 1
select * from `groups` where `groups`.`id` = '85' and `groups`.`id` is not null limit 1
select * from `groups` where `groups`.`id` = '86' and `groups`.`id` is not null limit 1
select * from `groups` where `groups`.`id` = '87' and `groups`.`id` is not null limit 1
select * from `groups` where `convention` = '16' limit 1
