Wiki:Dokumentation/2025-08-20

sqlquery -en genwiki -qp queries.yaml -qn user_count -f mediawiki

user_count

query

select count(*) from user;

result

count(*)
17403

table_count

sqlquery -en genwiki -qp queries.yaml -qn table_count  --params table=image -f mediawiki

query

select count(*) from image;

result

count(*)
91394

sqlquery -en genwiki -qp queries.yaml -qn find_pages --params pattern="{{subpage",limit=10 -f mediawiki

find_pages

query

SELECT 
   t.old_id AS SeitenId,
   CONCAT('[[', p.page_title, ']]') AS Seite,
   r.rev_timestamp AS Datum
FROM text t
JOIN content c ON t.old_id = c.content_id
JOIN slots s ON c.content_id = s.slot_content_id
JOIN revision r ON s.slot_revision_id = r.rev_id
JOIN page p ON r.rev_page = p.page_id
WHERE t.old_text LIKE "%{{subpage%"
LIMIT 10

result

SeitenId	Seite	Datum
1712843	14._Feldartillerie-Brigade	20170618060813
1158679	19._Division_(Alte_Armee)	20130829150656
1286537	2._KB_Division_(Alte_Armee)	20140420164716
1442888	36._Infanterie-Brigade	20150228140717
1379876	4._Landwehr-Division_(WK1)	20141028235948
1379724	45._Landwehr-Infanterie-Brigade	20141028184706
1887051	6._IR_(KB)	20191025143735
1887034	7._(kgl.bayer.)_Infanterie-Brigade	20191025125909
1739774	9._Kavallerie-Division_(WK1)	20170730063039
724838	Aachen/Adressbuch_1887	20100613113426