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

aus GenWiki, dem genealogischen Lexikon zum Mitmachen.
Zur Navigation springen Zur Suche springen
Zeile 38: Zeile 38:
|-
|-
| align="right"|      91394
| align="right"|      91394
|}
== find_pages ==
<source lang='bash'>
sqlquery -en genwiki -qp queries.yaml -qn find_pages  --params pattern="{{subpage",limit=10 -f mediawiki
</source>
=== 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 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
</source>
=== result ===
{| class="wikitable" style="text-align: left;"
|+ <!-- caption -->
|-
! align="right"|  SeitenId !! Seite                                                  !! align="right"|          Datum
|-
| align="right"|    1196196 || [[121._Infanterie-Division_(WK1)]]                      || align="right"| 20130304165544
|-
| align="right"|    1952199 || [[16._Landwehr-Division_(WK1)]]                        || align="right"| 20181124134307
|-
| align="right"|    1208619 || [[2._KB_Division_(Alte_Armee)]]                        || align="right"| 20130321191000
|-
| align="right"|    1952208 || [[21._Landwehr-Division_(WK1)]]                        || align="right"| 20181124135019
|-
| align="right"|    1196197 || [[233._Infanterie-Division_(WK1)]]                      || align="right"| 20130304165700
|-
| align="right"|    1196189 || [[236._Infanterie-Division_(WK1)]]                      || align="right"| 20130304164853
|-
| align="right"|    1747350 || [[49._Infanterie-Brigade_(1.Großherzoglich_Hessische)]] || align="right"| 20160930201935
|-
| align="right"|    1567235 || [[59._Landwehr-Infanterie-Brigade]]                    || align="right"| 20150315142835
|-
| align="right"|    2011337 || [[6._(kgl.bayer.)_Infanterie-Brigade]]                  || align="right"| 20191025131444
|-
| align="right"|    810263 || [[Aachen/Adressbuch_1936]]                              || align="right"| 20100417110938
|}
|}

Version vom 20. August 2025, 14:57 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
Abgerufen von „https://genwiki39.genealogy.net/index.php?title=Wiki:Dokumentation/2025-08-20&oldid=2625347“