Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::Augsburg (Diözese)]]
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='Augsburg (Diözese)') 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='Augsburg (Diözese)') 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 | 15556 | 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
-
Biechel, Markus , Priester
- Biechel, Sebastian , Priester
- Biechler, Anton (Hausen) , Priester
- Biechler, Christian (Messkirch) , Jesuitengymnasium Pfarrer Priester Studium
- Biechler, Franz Benno , Geistlicher
- Biechler, Franz Xaver (*1774 †1834), Pfarrer Priester Studium
- Biechler, Johann Georg (Neuburg) , Geistlicher Schüler Studium
- Biechler, Johann Joseph , Geistlicher
- Biechler, Johann Melchior (*1625), Priester Schüler
- Biechler, Johann Michael ( †1756), Pfarrer Priester Schüler Studium
- Biechler, Johann Simon (*1642 †1695), Geistlicher Priester Studium
- Biechler, Joseph Marquard (*1768 †1835), Domdekan Domkapitular Priester Schüler
- Biechler, Lorenz , Priester
- Biechler, Matthias (Landsberg) , Priester Schüler Studium
- Biechler, Melchior (*1615), Pfarrer Priester Studium
- Biechler, Peter (1783) (*1783 †1865), Pfarrer Priester
- Bieg, Johann Evangelist (*1774 †1836), Pfarrer Priester Studium
B Fortsetzung
-
Bier, Johann Alois (*1763), Geistlicher Priester
- Bieringer, Johann (*1662), Priester Studium
- Bieringer, Peter , Priester
- Bieringer, Sebastian , Pfarrer Priester Studium
- Bierle, Johann Joseph (Ingolstadt) , Pfarrer Priester Schüler
- Bierle, Thomas (Ingolstadt) , Geistlicher
- Bildstein, Johann Joachim (Lauingen) , Priester
- Bimmel, Georg , Geistlicher
- Binder, Anton , Priester
- Binder, Matthäus (Minderoffingen) , Priester Studium
- Binknus, Georg (Wallerstein) , Geistlicher Pfarrer Priester Studium
- Binknus, Johann Simon (*1645 †1672), Pfarrer Priester Studium
- Binzer, Johann (Krumbach) , Priester
- Birk, Franz Anton (*1758 †1814), Geistlicher Priester Studium
- Birk, Franz Xaver (Gerbishofen) , Geistlicher Studium
- Birkel, Franz Joseph Xaver , Priester Schüler
- Birker, Georg (Biberbach) , Priester Studium
B Fortsetzung
-
Birkhofer, Johann Franz Xaver , Priester Studium
- Birkler, Johann Georg , Priester Studium
- Birst, Johann Sebastian (*1622), Geistlicher Pfarrer Priester Studium
- Bischel, Lorenz , Priester Studium
- Bischeldorfer, Johann Michael (*1730 †1803), Pfarrer Priester Studium
- Bischetsrieder, Melchior (*1639), Geistlicher Studium
- Bischof, Bernhard (1786) (*1786 †1847), Pfarrer Priester
- Bischof, Johann (Risstissen) , Priester
- Bischof, Johann Georg (1680) (*1680), Geistlicher Studium
- Bischof, Johann Georg (Augsburg) , Geistlicher Priester Studium
- Bischof, Philipp (*1751 †1825), Geistlicher Pfarrer
- Bischof, Ulrich (Glöttweng) , Geistlicher
- Bissinger, Anton (1753) (*1753 †1826), Pfarrer Priester Studium
- Bissinger, Ignaz (*1631), Pfarrer Priester Studium
- Bissinger, Matthäus (Günzburg) , Geistlicher Studium
- Bissinger, Melchior (*1641), Geistlicher Pfarrer Priester Studium