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` = '2024' and `group_id` in ('65', '66', '69') and `convention` = '16'
select `id` from `leagues` where `leagues`.`deleted_at` is null and `year` = '2024' and `group_id` in ('65', '66', '69') and `convention` = '16'
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` in ('140', '141', '142') 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 ('140', '141', '142') and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 30
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '140' 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` = '140' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 30
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '141' 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` = '141' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 30
select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '142' 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` = '142' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 30
select * from `groups` where `groups`.`id` = '66' and `groups`.`id` is not null limit 1
LIMIT
ORDER BY
select * from `groups` where `groups`.`id` = '65' and `groups`.`id` is not null limit 1
select * from `groups` where `groups`.`id` = '69' and `groups`.`id` is not null limit 1
select * from `groups` where `convention` = '16' limit 1