Semantische Suche
Debug output SQLStore
ASK Query
[[Studium::Principia]]
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='Principia') 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='Principia') 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 | p_id | 262 | const, const | 2511 | 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
NoneE
-
Eisenberger, Johann Kaspar (1623) (*1623), Schüler Studium
- Eisenhofer, Johann Nepomuk (*1770), Studium
- Eisenmenger, Jakob (*1792 †1825), Studium
- Elf, Ignaz (*1781), Studium
- Emmer, Franz Xaver , Studium
- Emmert, Wenceslaus Joseph , Schüler
- Emmina, Franz Xaver Maximilian Moritz von , Studium
- Emminger, Martin (*1770 †1846), Geistlicher Priester Studium
- Endhart, Balthasar (*1773 †1814), Geistlicher Priester Studium
- Endres, Anton (1784) (*1784), Studium
- Endres, Basilius , Studium
- Endres, Franz Joseph Anton (*1786), Studium
- Endres, Ignaz (*1714), Registrator Studium
- Endres, Johann Evangelist (1784) (*1784 †1864), Pfarrer Priester Schüler
- Endres, Johann Evangelist (Reicholzried) ( †1864), Pfarrer Priester Schüler
- Endres, Johann Nepomuk (Ottobeuren) , Schüler
- Endres, Konstantin , Schüler
E Fortsetzung
-
Endstrasser, Johann (*1770), Studium
- Engelhard, Andreas (1770) (*1770 †1814), Pfarrer Priester Studium
- Engelhard, Johann Eusebius (*1767), Studium
- Engelhard, Johann Rudolph (1767) (*1767 †1828), Augustinerchorherr Kanoniker Studium
- Engenhard, Joseph , Studium
- Enzberg, Ludwig Nikolaus Freiherr von (*1783), Studium
- Enzenmüller, Cyrinus Cyriakus , Schüler
- Epp, Magnus Anton (*1776 †1847), Geistlicher Priester Schüler
- Epple, Johann Evangelist (1733) (*1733), Geistlicher Schüler Studium
- Epple, Johann Evangelist (Buxheim) , Schüler
- Epple, Leonhard , Schüler
- Erdenreicher, Ignaz (*1783 †1803), Studium
- Erhard, Andreas (1640) (*1640), Schüler
- Erhard, Johann Franz Joseph Anton (*1716), Geistlicher Pfarrer Studium
- Erhard, Johann Michael (1642) (*1642), Schüler
- Erhard, Paul (Neuburg/Do.) , Schüler
- Erhard, Philipp (1648) (*1648), Schüler Studium
E Fortsetzung
-
Erhard, Philipp (Passau) , Schüler Studium
- Erlbeck, Johann Baptist Nepomuk (*1724), Studium
- Erner, Joseph , Studium
- Ernst, Bernhard (Bergen) , Schüler
- Ester, Sebastian , Priester Studium
- Ettenreich, Georg (*1621), Schüler
- Ettinger, Andreas (*1614), Schüler
- Eyb, Franz Xaver Lorenz , Schüler
F
-
Faas, Benedikt (*1781), Studium
- Faas, Dismas (*1780), Studium
- Faber, Johann Martin (*1654), Arzt Mediziner Studium
- Fackler, Joseph Ignaz , Studium
- Fahr, Johann Georg (*1769 †1836), Pfarrer Studium
- Falk, Franz Xaver (Studium) , Studium
- Falkner, Dominik , Studium
- Farnschon, Franz (*1741), Studium