Wiki:Dokumentation/2025-08-20: Unterschied zwischen den Versionen

aus GenWiki, dem genealogischen Lexikon zum Mitmachen.
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Zeile 44: Zeile 44:
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>
</source>
=== query ===
=== query ===
<source lang='sql'>
<source lang='sql'>
Zeile 51: Zeile 53:
   r.rev_timestamp AS Datum
   r.rev_timestamp AS Datum
FROM text t
FROM text t
JOIN content c ON t.old_id = c.content_id
JOIN revision r ON t.old_id = r.rev_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
JOIN page p ON r.rev_page = p.page_id
WHERE t.old_text LIKE "%{{subpage%"
WHERE t.old_text LIKE "%{{subpage%"
Zeile 65: Zeile 65:
|+ <!-- caption -->
|+ <!-- caption -->
|-
|-
! align="right"|  SeitenId !! Seite                                 !! align="right"|          Datum
! align="right"|  SeitenId !! Seite                                                   !! align="right"|          Datum
|-
|-
| align="right"|    1712843 || [[14._Feldartillerie-Brigade]]         || align="right"| 20170618060813
| align="right"|    1196196 || [[121._Infanterie-Division_(WK1)]]                     || align="right"| 20130304165544
|-
|-
| align="right"|    1158679 || [[19._Division_(Alte_Armee)]]         || align="right"| 20130829150656
| align="right"|    1952199 || [[16._Landwehr-Division_(WK1)]]                         || align="right"| 20181124134307
|-
|-
| align="right"|    1286537 || [[2._KB_Division_(Alte_Armee)]]       || align="right"| 20140420164716
| align="right"|    1208619 || [[2._KB_Division_(Alte_Armee)]]                         || align="right"| 20130321191000
|-
|-
| align="right"|    1442888 || [[36._Infanterie-Brigade]]             || align="right"| 20150228140717
| align="right"|    1952208 || [[21._Landwehr-Division_(WK1)]]                         || align="right"| 20181124135019
|-
|-
| align="right"|    1379876 || [[4._Landwehr-Division_(WK1)]]         || align="right"| 20141028235948
| align="right"|    1196197 || [[233._Infanterie-Division_(WK1)]]                     || align="right"| 20130304165700
|-
|-
| align="right"|    1379724 || [[45._Landwehr-Infanterie-Brigade]]   || align="right"| 20141028184706
| align="right"|    1196189 || [[236._Infanterie-Division_(WK1)]]                     || align="right"| 20130304164853
|-
|-
| align="right"|    1887051 || [[6._IR_(KB)]]                         || align="right"| 20191025143735
| align="right"|    1747350 || [[49._Infanterie-Brigade_(1.Großherzoglich_Hessische)]] || align="right"| 20160930201935
|-
|-
| align="right"|    1887034 || [[7._(kgl.bayer.)_Infanterie-Brigade]] || align="right"| 20191025125909
| align="right"|    1567235 || [[59._Landwehr-Infanterie-Brigade]]                     || align="right"| 20150315142835
|-
|-
| align="right"|    1739774 || [[9._Kavallerie-Division_(WK1)]]       || align="right"| 20170730063039
| align="right"|    2011337 || [[6._(kgl.bayer.)_Infanterie-Brigade]]                 || align="right"| 20191025131444
|-
|-
| align="right"|    724838 || [[Aachen/Adressbuch_1887]]             || align="right"| 20100613113426
| align="right"|    810263 || [[Aachen/Adressbuch_1936]]                             || align="right"| 20100417110938
|}
|}

Version vom 20. August 2025, 14:01 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 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