Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Straubing]]
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='Straubing') AND t1.p_id=503)
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='Straubing') AND t1.p_id=503)
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 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 1612 | Using index condition; 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
-
Habich, Bartholomäus , Studium
- Hafner, Kaspar Felix , Studium
- Hagen, Liberatus (*1723 †1779), Franziskaner Mönch
- Hagenzeller, Johann , Studium
- Hahn, Simon (1636) (*1636), Studium
- Halbmeier, Georg (Straubing) , Geistlicher
- Halbmeier, Michael (Straubing) , Studium
- Halser, Joseph , Arzt Mediziner Studium
- Haltenberger, Christoph Martin , Studium
- Haltmeier, Georg (Straubing) , Studium
- Handel, Melchior , Arzt Mediziner Studium
- Handlas, Georg Gregor , Richter Studium
- Hanold, Bartholomäus (Straubing) , Studium
- Harder von Hardenstein, Servatius , Kanzler Studium
- Harder, Ignaz , Studium
- Harder, Johann Baptist (Straubing) , Studium
- Harder, Servatius (*1658 †1721), Franziskaner Mönch
H Fortsetzung
-
Harlbeck, Ferdinand Karl , Studium
- Harlbeck, Johann Kaspar , Studium
- Harthausen, Johann von , Studium
- Haselbeck, Johann (Straubing) , Studium
- Haselbeck, Joseph Franz Xaver , Studium
- Haselbeck, Philipp Anton , Studium
- Hastreiter, Johann Wolfgang Hyginus (*1712 †1741), Franziskaner Mönch
- Hauenschild, Colomann , Studium
- Hauenschild, Johann (Straubing) , Studium
- Haunold, Christoph Martin , Studium
- Hauzenberger, Erasmus (Straubing) , Studium
- Hauzenberger, Leonhard (Straubing) , Studium
- Heber, Andreas , Studium
- Heber, Franz Kaspar , Kanoniker Studium
- Heber, Johann Ignaz von (*1760), Kanoniker Studium
- Heberle, Joseph Reinhard (*1720 †1788), Kapuziner Mönch
- Hechensteiner, Georg Sigismund Joseph (*1673 †1752), Kanzler Rat Studium
H Fortsetzung
-
Heckel, Andreas (Straubing) , Studium
- Hefel, Franz , Studium
- Hegner, Achatius , Studium
- Heid, Christoph Karl , Studium
- Heidenreich, Jakob (Straubing) , Studium
- Heider, Georg Christoph (Straubing) , Studium
- Heidolf, Alois Wenceslaus von (*1772), Administrator Richter Studium
- Heidolf, Johann Konrad (*1761), Studium
- Heidolf, Maximilian von , Studium
- Heil von Mirskofen, Felix Matthäus ( †1714), Pflegsverwalter Studium
- Heil von Sallach und Lindum, Anton Ortolph , Studium
- Heiling, Nikolaus , Schreiber Studium
- Heim, Johann (Straubing) , Studium
- Heimel, Augustin (*1586), Studium
- Heimerl, Bartholomäus Tertullian (*1702 †1763), Franziskaner Mönch
- Heimerl, Franz Adam , Studium