Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Gerichtsschreiber]]
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Gerichtsschreiber') AND t1.p_id=509)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
500
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Gerichtsschreiber') AND t1.p_id=509)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | index_merge | s_id, o_hash, s_id_2, p_id | o_hash,p_id | 258,262 | 311 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rupp.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneH
-
Hirneis, Wolf Clemens (*1726)
- Hirnschröttel, Michael
- Hirschauer, Johann Otto
- Hirschberger, Johann Jakob ( †1806)
- Hirschhofer, Johann
- Hirschmann, Nikolaus (Richter) ( †1650)
- Hirsensteiner, Georg
- Hirtel, Lukas
- Hitzhofer, Leonhard
- Hoffingott, Alois (*1765 †1855)
- Hoffmann, Joseph (Waldmeister)
- Hofkircher, Bartholomäus
- Hofmeister, Wolf
- Hofmeister, Wolfgang (Tegernbach) ( †1589)
- Hofstetter, Leopold
- Hofstetter, Valentin
- Holderhofer, Johann Peter ( †1786)
H Fortsetzung
- Holzhammer, Stephan ( †1587)
- Holzhauser, Achatius
- Holzhofer, Alexander
- Holzmann, Markus (Gerichtsschreiber) ( †1622)
- Hopf, Johann Augustin ( †1762)
- Hornauer, Andreas
- Hosenmann, Johann Franz Michael Jakob Anicetus
- Hubbauer, Johann ( †1618)
- Huber, Georg (Gerichtsschreiber)
- Huber, Georg Sebastian
- Huber, Johann (1558) (*1558 JL †1605)
- Huber, Johann (Gerichtsschreiber)
- Huber, Johann Joseph (Gerichtsschreiber)
- Huber, Johann Stephan (Schreiber) ( †1769)
- Huber, Kaspar (Feldmoching)
- Huber, Wolf
H Fortsetzung
-
Huber, Wolfgang (1572) (*1572 JL †1601)
- Hufnagel, Thomas (*1625 †1662)
- Hufnagel, Wolfgang (Schulmeister)
- Hug, Heinrich (Calw) ( †1489 JL)
- Hund zu Kleinaign und Schachten, Georg (Gerichtsschreiber) ( †1606)
- Hund zu Kleinaign und Schachten, Johann (1547) (*1547 JL †1627)
- Hund zu Kleinaign und Schachten, Johann (Donaustauf) ( †1620)
- Hund, Sigismund
- Hupfauer, Franz Benno ( †1737)
- Hurter, Johann Friedrich (Pfleger)
- Huter, Franz Xaver (Gerichtsschreiber)
- Huter, Georg (Gerichtsschreiber)
- Huter, Vitus (1608) (*1608 †1659)
- Höchstetter, Johann (Lechhausen)
- Hölzel, Christoph (Gerichtsschreiber) ( †1584)
- Hörl, Georg (Donaustauf) ( †1621)