Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Mindelheim]]
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='Mindelheim') 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='Mindelheim') 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 | 1060 | 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
NoneK
-
Kühnle, Johann Georg (Honsolgen) , Geistlicher Schüler
L
-
Lader, Martin , Studium
- Lamparter, Johann (Mindelheim) , Studium
- Landherr, Alexander , Studium
- Landsherr, Adam , Geistlicher Studium
- Lang, Johann Michael (1674) (*1674 †1733), Jesuit Studium
- Lechler, Johann Baptist (Mindelheim) , Pfarrer Priester
- Lechner, Melchior (1649) (*1649 †1707), Studium
- Lecker, Sixt , Geistlicher Pfarrer Studium
- Lederle, Franz Xaver Joseph Paulin (*1758 †1832), Geistlicher Kapuziner Mönch
- Leibinger, Balthasar (*1650), Priester Studium
- Leichnamschneider, Franz Ignaz Joseph , Pfarrer Studium
- Leichnamschneider, Georg , Pfarrer
- Leichnamschneider, Johann Baptist , Priester Studium
- Leichnamschneider, Johann Sebastian , Pfarrer Studium
- Leinauer, Martin , Geistlicher Pfarrer
- Leinhart, Paul , Studium
L Fortsetzung
-
Leinsle, Franz Ignaz , Geistlicher
- Leister, Magnus , Studium
- Leonhard, Joseph Karl (*1762 †1837), Geistlicher Priester
- Lerchenmüller, Maximilian , Priester
- Leutescher, Johann Michael (*1757 †1822), Geistlicher Priester Studium
- Leuz, Aegidius , Priester
- Leuz, Ludwig (*1748 †1814), Pfarrer Priester
- Liks, Erhard Simon , Studium
- Lingauer, Johann Georg Engelbert (*1740 †1775), Kapuziner Mönch
- Lochbühler, Johann ( †1721), Pfarrer Studium
- Loder, Johann Georg (Mindelheim) ( †1690), Pfarrer Priester Studium
- Lotter, Johann (1646) (*1646), Studium
- Lotter, Johann Columban (*1650 †1681), Benediktiner Mönch Pfarrer Studium
- Lotter, Johann Michael , Geistlicher Studium
- Luft, Johann Jakob (*1646), Priester Studium
- Luft, Michael (*1652), Priester Studium
- Lusser, Aurelius (*1741), Franziskaner Guardian Mönch
L Fortsetzung
-
Lutzenberger, Johann Karl (Mindelheim) , Pfarrer Studium
- Luxenhofer, Andreas ( †1649), Geistlicher Pfarrer Studium
- Luxenhofer, Johann (*1620 †1681), Chorvikar Pfarrer Studium
- Luxenhofer, Johann Baptist ( †1765), Kanoniker Studium
- Luxenhofer, Johann Georg , Priester
- Luxenhofer, Johann Michael (Mindelheim) , Priester
- Luxenhofer, Paternus (*1691 †1724), Franziskaner Mönch
- Löhle, Franz Anton Stanislaus (*1722), Geistlicher Studium
- Lüchtlin, Konrad ( †1490 JL), Lizentiat Pfarrer Studium
M
-
Manz, Ferdinand (1614) (*1614 †1647), Jesuit Jesuitengymnasium Studium
- Manz, Heinrich (1615) (*1615 †1645), Jesuit
- Mauries, Maria Johanna (*1720), Franziskanerin Nonne
- Maurus, Candidus (*1717 †1775), Geistlicher Mönch Prämonstratenser
- Maurus, Dismas (*1714 †1785), Franziskaner Mönch
- Maurus, Marcellus (*1711 †1789), Dominikaner
- Meckrich, Jakob , Studium