Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Unterfranken]]
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='Unterfranken') AND t1.p_id=963)
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
1000
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='Unterfranken') AND t1.p_id=963)
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
1000
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 | 40372 | 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
NoneB
-
Beringer, Georg (Treinfeld) , Studium
- Beringer, Georg Bartholomäus , Studium
- Beringer, Georg Philipp , Studium
- Beringer, Heinrich (Markt Bibart) , Studium
- Beringer, Johann Adam , Pfarrer Studium
- Beringer, Johann Bartholomäus , Studium
- Beringer, Johann Bartholomäus Adam ( †1738), Arzt Mediziner Professor Studium
- Beringer, Johann Franz (Würzburg) , Studium
- Beringer, Johann Georg (Oberschwarzach) , Studium
- Beringer, Johann Joseph Bernhard , Studium
- Beringer, Johann Magnus Anton (*1699 †1730), Jesuit Studium
- Beringer, Johann Peter Joseph , Studium
- Beringer, Johann Sigismund , Studium
- Beringer, Johann Simon (Münnerstadt) , Studium
- Beringer, Joseph (*1745 †1807), Jesuit
- Beringer, Konrad (1691) (*1691 †1723), Jesuit
- Beringer, Lorenz (Königshofen) , Studium
B Fortsetzung
-
Beringer, Nikolaus (Essfeld) , Studium
- Beringer, Paul (Königshofen) , Studium
- Beringer, Sebald (*1747), Jesuit
- Berle, Johann (Kitzingen) , Studium
- Berle, Pankraz , Studium
- Berlin, Johann (Würzburg) ( †1572 JL), Domvikar Geistlicher Studium Vikar
- Berlipsin, Gunther , Studium
- Bermann, Andreas , Studium
- Bermann, Johann (Hassfurt) , Benediktiner Mönch Studium
- Bermiger, Johann , Studium
- Bernardi, Franz Adam , Studium
- Bernbeck, Bernhard , Studium
- Bernbeck, Philipp (Kitzingen) , Studium
- Bernbeck, Sebastian , Studium
- Bernecker, Johann (Kitzingen) , Studium
- Bernecker, Konrad , Studium
- Berner, Kaspar Eberhard , Studium
B Fortsetzung
-
Berner, Peter , Studium
- Bernet, Andreas , Studium
- Bernhard, Andreas (1635) (*1635), Jesuit
- Bernhard, Balthasar (1742) (*1742), Jesuit
- Bernhard, Franz Wilhelm , Studium
- Bernhard, Georg (1725) (*1725), Jesuit
- Bernhard, Johann (1737) (*1737), Jesuit
- Bernhard, Johann (Birnfeld) , Studium
- Bernhard, Johann (Königshofen) , Studium
- Bernhard, Johann (Rodenbach) , Jesuit
- Bernhard, Johann Kaspar (Birnfeld) ( †1727), Jurist Kanoniker Professor Rat
- Bernhard, Johann Philipp , Studium
- Bernhard, Kilian , Studium
- Bernhard, Valentin ( †1569 JL), Pfarrer Studium
- Bernhardi, Hermann , Studium
- Bernheim, Peter von , Studium