Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::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=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='Straubing') 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 | 778 | 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
NoneP
-
Pelkoven, Johann Nepomuk Freiherr von (*1763), Rat Studium
- Pellet, Karl Joachim von , Mautner Verwalter
- Pembler, Maria Anna Viktoria ( †1729), Nonne Oberin Ursulinerin
- Pentenrieder, Franz Joseph ( †1718), Regimentsrat Studium
- Pentenrieder, Philipp Jakob Leonhard (*1667 †1739), Guardian Kapuziner Mönch
- Pesing , Oberrichter
- Peter (Kastner) , Kastner
- Pettenbeck, Balthasar (1569) (*1569 JL †1636), Pfleger Rat Studium
- Peutinger, Johann Christoph , Jurist Kanoniker Rat
- Pfaber, Christoph Enoch , Schreiber
- Pfaudner, Johann Albrecht , Gerichtsschreiber Pflegsverweser Schreiber
- Pfeffenhausen, Silvester von , Oberrichter
- Pfeiffer, Johann Adam (1591) (*1591 †1641), Kapuziner Mönch
- Pfetten, Johann Oswald von ( †1679), Rat Studium
- Pfister, Michael Gottfried , Unterrichter
- Pfundner, Markus Heinrich (*1611), Richter Stadthauptmann Studium
- Pindl, Joseph Edler von (*1729 †1794), Rat Studium
P Fortsetzung
-
Pinzenau, Johann Friedrich (*1604 †1655), Rat Studium Vizedom
- Pinzenau, Ludwig von (Vizedom) ( †1543 JL), Vizedom
- Pisonet, Anianus Anton , Rat Sekretär Studium
- Pittinger, Kaspar Fabian (*1600 †1632), Kapuziner Mönch Studium
- Plaphart, Friedrich ( †1549 JL), Landgerichtsschreiber Stadtschreiber
- Plattner, Leonhard (Geistlicher, G3690) , Geistlicher
- Poissl, Bonaventura Andreas Deochar Gottlieb Freiherr von , Rat Studium
- Poppel, Georg , Unterrichter
- Poschinger, Johann Alfons (*1599 †1634), Kapuziner Mönch
- Poschinger, Simon , Geistlicher Studium
- Preysing, Alois Bonaventura Freiherr von (*1714 †1774), Kanoniker Propst Studium
- Preysing, Johann Christoph (*1620 †1666), Pfleger Studium Vizedom
- Preysing, Johann Christoph von (Pfleger) , Pfleger
- Preysing, Johann Erdmann Joseph Christoph Adam Freiherr von , Rat Studium
- Preysing, Johann Wahrmund von (*1573 JL †1648), Pfleger Studium Vizedom
R
-
Randeck , Unterrichter
- Ransberg, Heinrich von , Vizedom
R Fortsetzung
-
Ransonet, Franz Joseph , Advokat Studium
- Rasoris, Stephan (Geistlicher) , Geistlicher
- Regnet, Peter , Rentmeister
- Rehlinger, Leopold von ( †1678), Mautner Richter Studium
- Reichland, Johann , Geistlicher
- Reifenstuhl, Andreas Beatus (*1667 †1720), Guardian Kapuziner Mönch Studium
- Reifenstuhl, Quirin (*1616 †1666), Kanzler Rat Studium
- Reindel, Ferdinand (München) ( †1642), Jurist Studium
- Reindel, Georg (Ratsherr) , Ratsherr
- Reindel, Johann Georg Joseph , Rat Studium
- Reindel, Matthias (Schreiber) ( †1644), Schreiber
- Reindel, Michael Maria Joseph Felix (*1700 †1749), Rat Studium
- Reiner, Johann (Pfleger) , Kastner Pfleger
- Reinhard, Jakob Gervasius (*1589 †1656), Kapuziner Mönch
- Reisacher, Wilhelm (*1566 JL †1631), Jurist Rat Studium
- Reisenecker, Franz Anton (*1762), Schreiber Studium