🔎 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 U19 Australia WA

18 players

Sort Player Age Rating
Cameron BANCROFT 🧢
33 · U19 WA
Rating 100
Joel Paris 🧢
33 · U18 WA
Rating 100
Marcus Stoinis 🧢
37 · U17 WA
Rating 100
Mitch Marsh 🧢 ⭐
35 · U19 WA
Rating 99
Teague Wyllie ⭐
22 · U19 WA
Rating 96
Cooper Connolly 🧢
23 · U15 WA
Rating 92
Aaron Hardie 🧢
27 · U17 WA
Rating 90
Samuel Fanning ⭐
26 · WA
Rating 89
Mahli Beardman 🧢 ⭐
21 · U19 WA
Rating 87
William Bosisto
33 · U19 WA
Rating 86
Jhye Richardson 🧢 ⭐
30 · U19 WA
Rating 84
Brooke Guest ⭐
29 · U17 WA
Rating 80
Clinton Hinchliffe
30 · U17 WA
Rating 77
Corey Wasley ⭐
21 · U19 WA
Rating 75
Tom Beaton
35 · U15 WA
Rating 64
Will Malajczuk ⭐
19 · U19 WA
Rating 62
Kyle Gardiner ⭐
29 · U17 WA
Rating 43
Jaron Morgan ⭐
31 · U19 WA
Rating 37
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" from "players" as "p" 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 "p"."u19_australia" = true and "p"."state" = 'WA' order by coalesce(p.overall_rating, 0) desc, "p"."name" asc limit 100 offset 0