Semantische Suche
Debug output SQLStore
ASK Query
[[Studium::Moraltheologie]]
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='Moraltheologie') AND t1.p_id=3107)
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='Moraltheologie') AND t1.p_id=3107)
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 | o_hash | 258 | const | 15376 | Using index condition; Using where; 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
-
Betz, Kaspar (Regensburg) , Studium
- Betz, Nikolaus (1748) (*1748), Studium
- Betzel, Ignaz (*1690 †1737), Geistlicher Studium
- Betzenhamer, Joseph , Arzt Mediziner Studium
- Betzer, Christoph Paulin Rochus (*1689 †1757), Franziskaner Mönch Studium
- Betzer, Johann Franz (*1700 †1770), Pfarrer Studium
- Betzer, Kaspar Ignaz Dominik (*1711 †1754), Geistlicher Priester Studium
- Beuch, Johann Sigismund , Studium
- Beuchat, Daniel , Studium
- Beuerle, Joseph (1705) (*1705), Geistlicher Studim
- Beusch, Franz (*1696), Kanoniker Propst Studium
- Beusch, Johann Jakob (1690) (*1690), Pfarrer Studium
- Beuter, Johann Baptist (*1716), Geistlicher Pfarrer Studium
- Beutinger, Johann Konrad (*1661), Studium
- Beuto, Matthias Matthäus , Studium
- Beuttaler, Gallus , Studium
- Bevellio, Johann , Studium
B Fortsetzung
-
Bevilacqua, Johann Peter , Studium
- Bevilacqua, Joseph Michael , Studium
- Bevilacqua, Salvator (Termenago) , Geistlicher Studium
- Bezio, Peter , Studium
- Bibel, Franz Anton ( †1771), Studium
- Biber, Andreas (1717) (*1717), Geistlicher Pfarrer Studium
- Biber, Johann Kaspar Edmund (*1687 †1739), Augustinereremit Mönch Studium
- Biber, Joseph (Mindelheim) ( †1724), Pfarrer Studium
- Biberacher, Joseph , Studium
- Bichsel, Franz Kaspar Anton , Studium
- Bichsel, Johann Joseph (Weingarten) , Studium
- Bickel, Johann Baptist Michael , Studium
- Bickel, Matthias (Feldkirch) , Studium
- Bickel, Michael (St.Gerold) , Studium
- Biderbosten, Joseph (*1670 †1718), Jesuit Studium
- Bidermann, Georg (Ehingen, Studium) , Studium
- Bidermann, Johann Jakob (Ehingen) ( †1754), Pfarrer Studium
B Fortsetzung
-
Bidermann, Johann Philipp , Studium
- Bidermann, Matthias , Schüler Studium
- Bidermann, Maximus (*1651 †1713), Benediktiner Mönch Pfarrer Studium
- Biechel, Anton Nikolaus ( †1704), Geistlicher Priester Studium
- Biechel, Johann Friedrich , Pfarrer Priester Schüler
- Biechel, Matthäus Anselm ( †1711), Benediktiner Mönch Studium
- Biechele, Nikolaus , Pfarrer Studium
- Biecheler, Johann Eberhard Aemilian (*1614 †1668), Benediktiner Mönch Pfarrer Studium
- Biechler, Christian (Messkirch) , Jesuitengymnasium Pfarrer Priester Studium
- Biechler, Matthias (Landsberg) , Priester Schüler Studium
- Biechler, Vitus (*1670 †1736), Jesuit Studium
- Bieg, Johann Philipp Lorenz (*1731), Studium
- Bieg, Joseph Maximilian , Studium
- Biegler, Johann Georg Anton , Studium
- Biener, Johann Baptist , Studium
- Bierle, Johann Joseph (Ingolstadt) , Pfarrer Priester Schüler