Wiki:Dokumentation/2025-08-20: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 38: | Zeile 38: | ||
|- | |- | ||
| align="right"| 91394 | | align="right"| 91394 | ||
|} | |||
sqlquery -en genwiki -qp queries.yaml -qn find_pages --params pattern="{{subpage",limit=10 -f mediawiki | |||
== find_pages == | |||
=== query === | |||
<source lang='sql'> | |||
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 | |||
</source> | |||
=== result === | |||
{| class="wikitable" style="text-align: left;" | |||
|+ <!-- caption --> | |||
|- | |||
! align="right"| SeitenId !! Seite !! align="right"| Datum | |||
|- | |||
| align="right"| 1712843 || [[14._Feldartillerie-Brigade]] || align="right"| 20170618060813 | |||
|- | |||
| align="right"| 1158679 || [[19._Division_(Alte_Armee)]] || align="right"| 20130829150656 | |||
|- | |||
| align="right"| 1286537 || [[2._KB_Division_(Alte_Armee)]] || align="right"| 20140420164716 | |||
|- | |||
| align="right"| 1442888 || [[36._Infanterie-Brigade]] || align="right"| 20150228140717 | |||
|- | |||
| align="right"| 1379876 || [[4._Landwehr-Division_(WK1)]] || align="right"| 20141028235948 | |||
|- | |||
| align="right"| 1379724 || [[45._Landwehr-Infanterie-Brigade]] || align="right"| 20141028184706 | |||
|- | |||
| align="right"| 1887051 || [[6._IR_(KB)]] || align="right"| 20191025143735 | |||
|- | |||
| align="right"| 1887034 || [[7._(kgl.bayer.)_Infanterie-Brigade]] || align="right"| 20191025125909 | |||
|- | |||
| align="right"| 1739774 || [[9._Kavallerie-Division_(WK1)]] || align="right"| 20170730063039 | |||
|- | |||
| align="right"| 724838 || [[Aachen/Adressbuch_1887]] || align="right"| 20100613113426 | |||
|} | |} | ||
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 |
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 |