Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Wemding]]
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='Wemding') 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='Wemding') 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 | 822 | 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
NoneR
-
Rancho, Franz Anton von , Schüler
- Rancho, Johann Georg von , Schüler
- Rasch, Matthäus , Studium
- Rauch, Kaspar (Wemding) , Pfarrer Studium
- Rehm, Emmeran , Studium
- Reichard, Emmeran , Studium
- Reichard, Georg Michael (*1658), Priester Studium
- Reichard, Heinrich (1660) (*1660 †1728), Benediktiner Mönch Pfarrer Studium
- Reichard, Johann (1638) (*1638), Pfarrer Schüler Studium
- Reichard, Leonhard , Studium
- Reichenbach, Christoph (Wemding) , Geistlicher Studium
- Reichenbach, Emmeran , Geistlicher Studium
- Reichenbacher, Johann (Wemding) , Studium
- Reichherzer, Christoph (*1650), Studium
- Reichherzer, Johann Andreas Joseph (*1730), Dominikaner Schüler
- Reichherzer, Johann Gallus , Studium
- Reichlin, Johann Matthias (*1473 JL †1538 JL), Abt Benediktiner Mönch Studium
R Fortsetzung
-
Reimbold, Joseph Anton (*1752), Studium
- Reimbold, Vitus , Studium
- Reinbold, Erasmus , Studium
- Reinbold, Johann (Wemding) , Schreiber
- Reinle, Johann (Wemding) , Studium
- Reinwolt, Emmeran , Studium
- Rembold, Blasius (1546) (*1546 JL), Pfarrer
- Rembold, Johann (Wemding) , Studium
- Renner, Georg (Wemding) , Studium
- Renner, Johann Georg (Wemding) , Studium
- Renner, Konrad (Wemding) , Schüler Studium
- Resle, Johann Georg (Wemding) , Priester
- Resle, Johann Leonhard (*1696), Studium
- Richard, Leonhard , Studium
- Richter, Georg Balthasar Aretius (*1743 †1812), Guardian Kapuziner Mönch
- Richter, Johann Emmeran (*1680), Schüler
- Richter, Johann Jakob (*1697 †1765), Pfarrer Studium
R Fortsetzung
-
Richter, Joseph (Wemding) , Schüler Studium
- Riederer, Johann (Wemding) , Studium
- Riedinger, Georg (Wemding) , Studium
- Riedle, Joseph Anton (*1739), Schüler Studium
- Riel, Johann Evangelist (*1757 †1823), Geistlicher Pfarrer Priester
- Riepp, Georg , Studium
- Ritter, Andreas (Wemding) , Studium
- Ritter, Bernhard (Wemding) , Studium
- Ritter, Bernhard (Wemding, Studium) , Studium
- Ritter, Johann (Wemding)
- Ritter, Thaddäus Bartholomäus , Studium
- Roit, Johann , Studium
- Roncho, Franz Anton von , Studium
- Roser, Adam , Studium
- Rosner, Emmeran , Studium
- Rot, Kaspar (Wemding) ( †1714), Geistlicher Priester