User:Certes/Reports/Populated subcategories

Populated subcategories of an example parent category

{{Database report

|sql=

SELECT page_title AS Subcat, COUNT(*) AS Pages

FROM categorylinks CLp

JOIN page ON page_namespace=14 AND page_id=CLp.cl_from

JOIN categorylinks CLc ON CLc.cl_type='page' AND CLc.cl_to=page_title

WHERE CLp.cl_type='subcat' AND CLp.cl_to="Aviation_maintenance_categories" /* <== Change the parent category here, using underscores instead of spaces */

GROUP BY Subcat

ORDER BY Subcat

|wikilinks= 1:14

|excerpts=

|comments=

|interval=

|table_style=

|pagination=

|max_pages=

}}

class="wikitable sortable" style="overflow-wrap: anywhere"
scope="col" \| Subcat ! scope="col" \| Pages
Lists of aircraft in default format \| 1
Lists of aircraft in general format \| 19
Lists of aircraft in military current format \| 10
Lists of aircraft in military historical format \| 4
Lists of aircraft in non-standard formats \| 10
Lists of aircraft in role format \| 6

class="wikitable sortable" style="overflow-wrap: anywhere"

scope="col" | Subcat

! scope="col" | Pages

Lists of aircraft in default format

| 1

Lists of aircraft in general format

| 19

Lists of aircraft in military current format

| 10

Lists of aircraft in military historical format

| 4

Lists of aircraft in non-standard formats

| 10

Lists of aircraft in role format

| 6

----

{{Database report/footer|count=6|query_runtime=0.01|last_updated=01:07, 23 October 2024 (UTC)}}