You are not currently logged in. Are you accessing the unsecure (http) portal? Click here to switch to the secure portal. |
Do you have permission to re-use this image? Just because scans appear on Wiktenauer does not mean that they are free to use. Wiktenauer is a 501(c)(3) nonprofit, and many of the scans we host are only licensed for nonprofit use. In other cases, the scans have no standard license and Wiktenauer has received special permission to host them (and can't grant that permission to anyone else). The license terms appear in the Copyright and License Terms box at the bottom of the page that sent you here. When in doubt, always check with the museum or library that owns a manuscript before publishing or otherwise reusing its scans. |
Semantic search
Jump to navigation
Jump to search
Query-Depth:0
SQLStore debug output
ASK Query
[[Category:Treatises]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t4.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t4.p_id='49820')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
50
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t4.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t1
INNER JOIN
`t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t4.p_id='49820')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 4 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | wiktenauer.t2.id | 46 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wiktenauer.t1.s_id | 1 | Using where |
1 | SIMPLE | t4 | ref | s_id,p_id,s_id_2 | s_id | 8 | wiktenauer.t1.s_id,const | 1 |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) ('50075').
SELECT s_id FROM `smw_fpt_subc` WHERE o_id='50075' LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None[[|150x150px|center|link=Kölner Fechtregeln (MS Best.7020 (W*)150)]] |
[[|150x150px|center|link=Falkner Turnierbuch ()]] |
[[|150x150px|center|link=The Poem of the Pel (Ashmole MS 45 Ⅱ)]] |
[[|150x150px|center|link=Pirckheimer's Fechtbuch (Pirkh. Papp. 353)]] |
[[|150x150px|center|link=The Poem of the Pel (Cotton MS Titus A ⅹⅹⅲ)]] |
[[|150x150px|center|link=Ludwig von Eyb Kriegsbuch (MS B.26)]] |
[[|150x150px|center|link=Hans Medel Fechtbuch (Cod.Ⅰ.6.2º.5)]] |
[[|150x150px|center|link=Talhoffer Fechtbuch (MS 26.236)]] |
[[|150x150px|center|link=Fechtbuchleinn (Cod.Guelf.1074.Novi)]] |
[[|150x150px|center|link=Talhoffer Fechtbuch (Cod.Ser.Nov.2978)]] |
[[|150x150px|center|link=Anonimo Riccardiano (MS Ricc.2541)]] |
[[|150x150px|center|link=Johan Liechtnawers Fechtbuch geschriebenn (MS Dresd.C.487)]] |
[[|150x150px|center|link=Das Solothurner Fechtbuch (Cod.S.554)]] |
[[|150x150px|center|link=Libro del exercicio de las armas (MS a.Ⅳ.23)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Anonimo Bolognese (MSS Ravenna M-345/346)]] |
[[|150x150px|center|link=Berlin Picture Book (Libr.Pict.A83)]] |
[[|150x150px|center|link=Oplodidaskalia sive Armorvm Tractandorvm Meditatio Alberti Dvreri (MS 26-232)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Albrecht Dürers Fechtbuch (Sloane MS No.5229)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Ein Hausbuch des mittelalterlichen Wissens (BJ Rkp. Przyb. 35/64)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Vechtboek (MS BPL.3281)]] |
[[|150x150px|center|link=Jörg Wilhalm Hutters kunst zu Augspurg (Cod.Ⅰ.6.2º.3)]] |
[[|150x150px|center|link=Jörg Wilhalm Hutters kunst zu Augspurg (Cod.Ⅰ.6.4º.5)]] |
[[|150x150px|center|link=Jörg Wilhalm Hutters kunst zu Augspurg (Cgm 3711)]] |
[[|150x150px|center|link=Wilhalm/Sollinger Fechtbuch (Cod.Ⅰ.6.2º.2)]] |
[[|150x150px|center|link=Liber Quodlibetarius (MS B.200)]] |
[[|150x150px|center|link=Las nueve reglas de la espada de dos mano (MS 2790)]] |
[[|150x150px|center|link=Jörg Breu's Draftbook (Cod.Ⅰ.6.2º.4)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Gregor Erhart Fechtbuch (MS E.1939.65.354)]] |
[[|150x150px|center|link=Goliath Fechtbuch (MS germ. quart. 2020)]] |
[[|150x150px|center|link=Ledall Roll (Additional MS 39564)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Thůrnẙer und Scharpfrennen (Cod.I.6.4º.1)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Über die Fechtkunst und den Ringkampf (MS 963)]] |
[[|150x150px|center|link=Wassmannsdorff's Fechtbuch (Location unknown)]] |
[[|150x150px|center|link=Ringer Kunst (2º Col.MS.Philos.62)]] |
[[|150x150px|center|link= ()]] |
[[|150x150px|center|link=Monomachia ovvero Arte di Scherma (MS L.V.23)]] |
[[|150x150px|center|link=Monomachia ovvero Arte di Scherma (MS Ⅱ.ⅲ.315)]] |
[[|150x150px|center|link=Opus Amplissimum de Arte Athletica (MSS Dresd.C.93/C.94)]] |
[[|150x150px|center|link=Opus Amplissimum de Arte Athletica (Cod.icon. 393)]] |
[[|150x150px|center|link=Codex Amberger ()]] |