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

aus GenWiki, dem genealogischen Lexikon zum Mitmachen.
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
Abgerufen von „https://genwiki39.genealogy.net/index.php?title=Wiki:Dokumentation/2025-08-20&oldid=2625340“