🔎 Ask

Ask a question

Type it the way you would say it. The words are read against this site's own vocabulary — age groups, competitions, states, roles, weekends and statistics — and turned into one query. Whatever is not understood is listed rather than quietly dropped, and the SQL is shown.

Understood as Players U16 this season Weekend of 7 Nov 2026 Wicketkeeper-Batter Female

0 players

Show the SQL
select "p"."id", "p"."name", "p"."state", "p"."age_group", "p"."overall_rating", "p"."is_div1_rep", "p"."is_international", "p"."date_of_birth", "p"."born_on_or_after", "pr"."role", "pr"."rating", "pr"."national_rank", "wf"."id" as "fixture_id", "wf"."grade_name", "wf"."organisation_name", "wf"."local_date", "wf"."starts_at", "wf"."venue_name", "wf"."venue_suburb", "wf"."venue_state", "wf"."latitude", "wf"."longitude", "wf"."standard", "wf"."home_team_name", "wf"."away_team_name", "ws"."team_id", "ws"."roles" as "squad_roles" from "weekend_selections" as "ws" inner join "weekend_fixtures" as "wf" on "wf"."id" = "ws"."match_id" inner join "players" as "p" on "p"."id" = "ws"."player_id" left join "player_ranks" as "pr" on "pr"."player_id" = "p"."id" where "p"."name"::text not like '%********%' and "p"."name"::text not like 'Unknown Player_%' and not exists (select * from "player_merge_members" as "pmm" inner join "player_merges" as "pm" on "pm"."id" = "pmm"."merge_id" where "pmm"."player_id" = "p"."id" and "pmm"."player_id" != "pm"."master_id") and "wf"."local_date" between '2026-11-06' and '2026-11-09' and "ws"."is_placeholder" = false and (("p"."date_of_birth" > '2010-09-01' and "p"."date_of_birth" <= '2011-09-01') or ("p"."date_of_birth" is null and "p"."born_on_or_after" > '2009-09-01' and "p"."born_on_or_after" <= '2010-09-01')) and "pr"."role" in ('Wicketkeeper-Batter') and "p"."gender" = 'F' order by "wf"."standard" desc, "wf"."starts_at" asc, "p"."name" asc limit 100 offset 0