Handbook
Policies
Procedures
People
Finance
Other
Roll of Honour
Mini-Soccer (U7-U10)
9-a-Side (U11-U12)
11-a-Side (U13-U21)
club
subview
teams
playersWanted
othersWanted
fullPage
obLevel
__env
app
errors
select * from `club` where `club`.`deleted_at` is null and `club`.`id` = '1422' limit 1
SELECT *
LIMIT
ORDER BY
select * from `ground` where `ground`.`deleted_at` is null and `ground`.`id` in ('')
select `ground`.*, `clubground`.`club_id` as `pivot_club_id`, `clubground`.`ground_id` as `pivot_ground_id`, `clubground`.`notes` as `pivot_notes` from `ground` inner join `clubground` on `ground`.`id` = `clubground`.`ground_id` where `ground`.`deleted_at` is null and `clubground`.`club_id` in ('1422') order by `name` asc
select * from `v_ClubOfficials` where `v_ClubOfficials`.`club_id` in ('1422')
select * from `v_Teams` where `club_id` = '1422' and `is_hidden` <> '1' order by `agegroup_sortorder` asc
select * from `wanted` inner join `agegroup` on `wanted`.`agegroup_id` = `agegroup`.`id` where `club_id` = '1422' and `agegroup_id` is not null order by `agegroup`.`sortorder` asc
select * from `wanted` where `club_id` = '1422' and `role` is not null
select * from `v_ClubOfficials` where `v_ClubOfficials`.`club_id` = '1422' limit 1