Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::Altdorf]]
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='Altdorf') AND t1.p_id=507)
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='Altdorf') AND t1.p_id=507)
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 | 2567 | 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
NoneD
-
Drechsel, Christoph (Nürnberg) ( †1729), Pfarrer Studium
- Drechsel, Hartmann Kaspar , Studium
- Drechsel, Joachim , Studium
- Drechsel, Vitus (Nürnberg) , Studium
- Drechsler, Johann Christian (*1742 †1780), Pfarrer Studium
- Dreher, Georg Achatius , Studium
- Dreispring, Johann Heinrich , Studium
- Dunin Wolski a Wola, Samuel , Studium
- Dunker, Johann Albert , Studium
- Dziertzeky, Johann , Studium
- Döderlein, Abraham (1630) (*1630 †1693), Lehrer Pfarrer Studium
- Döderlein, Abraham (1663) (*1663 †1724), Pfarrer Studium
- Döderlein, Abraham (Weissenburg) ( †1724), Pfarrer Studium
- Döderlein, Johann David (*1669 †1746), Pfarrer Studium
- Döderlein, Johann Jakob Sebastian (*1682 †1734), Arzt Mediziner Studium
- Döderlein, Zacharias (*1660 †1742), Pfarrer Studium
- Döring, Matthäus , Studium
D Fortsetzung
-
Dürnhofer, Leonhard Christoph , Studium
- Dürnhofer, Wolfgang ( †1601), Studium
- Dürr, Johann (1540) (*1540 JL †1621), Geistlicher Pfarrer Studium
- Dürr, Johann Friedrich (1654) (*1654 †1729), Pfarrer Studium
- Dürr, Johann Konrad (*1625 †1672), Professor Studium Theologe
- Dürr, Johann Simon (*1658 †1701), Pfarrer Studium
- Düttel, Philipp Jakob (*1678 †1737), Arzt Mediziner Studium
E
-
Eber, Bartholomäus Wolfgang , Advokat Jurist Studium
- Eber, Johann Adam (*1701 †1708), Sekretär Studium
- Eber, Thomas (1595) (*1595 †1641), Geistlicher Studium
- Ebermeier, Konrad (*1673 †1735), Amtmann Studium
- Ebersberger, Balthasar (*1662 †1732), Pfarrer Studium
- Ebersberger, Johann Matthias (*1700 †1769), Lehrer Studium
- Ebertz, Johann Adam Freiherr von , Pfleger Rat Studium
- Eberwein, August Bernhard (*1680), Studium
- Eberwein, Johann Philipp (*1648 †1702), Jurist Professor Studium
- Ebling, Johann Jakob , Studium
E Fortsetzung
-
Ebner von Eschenbach, Andreas , Militär Soldat Studium
- Ebner von Eschenbach, Johann Wilhelm (*1684 †1723), Armenpfleger Studium
- Ebner, Georg (Altdorf) , Geistlicher Priester Studium
- Ebner, Johann Jakob (*1606 †1668), Pfleger Studium
- Echbeck, Johann Franz Wilhelm von , Rentmeister Studium
- Echbeck, Karl Alois von , Registrator Studium
- Eck, Michael (Nürnberg) ( †1740), Lehrer Studium
- Eck, Otto (Studium, G12367) , Studium
- Eckebrecht, Paul (*1657 †1721), Jurist Rat Studium
- Eckenberger, Johann Christoph (*1644 †1685), Pfarrer Studium
- Eckhart, Christoph (Windsheim) , Studium
- Eckhart, Michael (Altdorf) , Studium
- Eckstein, Jakob , Studium
- Eder, Georg Christoph , Studium
- Eder, Johann (1578) (*1578 JL), Gymnasium illustre Studium
- Eder, Johann (Salzburg) , Gymnasium illustre Studium