Wiki:Dokumentation/2025-08-20: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 40: | Zeile 40: | ||
|} | |} | ||
== find_pages == | |||
<source lang='bash'> | |||
sqlquery -en genwiki -qp queries.yaml -qn find_pages --params pattern="{{subpage",limit=10 -f mediawiki | sqlquery -en genwiki -qp queries.yaml -qn find_pages --params pattern="{{subpage",limit=10 -f mediawiki | ||
</source> | |||
=== query === | === query === | ||
<source lang='sql'> | <source lang='sql'> | ||
Version vom 20. August 2025, 13:33 Uhr
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 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 |