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

find_pages

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

query

SELECT 
   t.old_id AS SeitenId,
   CONCAT('[[', p.page_title, ']]') AS Seite,
   r.rev_timestamp AS Datum
FROM text t
JOIN revision r ON t.old_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
1196196	121._Infanterie-Division_(WK1)	20130304165544
1952199	16._Landwehr-Division_(WK1)	20181124134307
1208619	2._KB_Division_(Alte_Armee)	20130321191000
1952208	21._Landwehr-Division_(WK1)	20181124135019
1196197	233._Infanterie-Division_(WK1)	20130304165700
1196189	236._Infanterie-Division_(WK1)	20130304164853
1747350	49._Infanterie-Brigade_(1.Großherzoglich_Hessische)	20160930201935
1567235	59._Landwehr-Infanterie-Brigade	20150315142835
2011337	6._(kgl.bayer.)_Infanterie-Brigade	20191025131444
810263	Aachen/Adressbuch_1936	20100417110938