Semantische Suche
Debug output SQLStore
ASK Query
[[Studium::Metaphysik]]
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='Metaphysik') 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='Metaphysik') 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 | 1766 | 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
NoneG
-
Gienger von Grünbichl und Scharnstein, Felix Alois Maria Freiherr von , Studium
- Gienger von Grünbichl, Christoph Ignaz Leopold Freiherr von (*1683 †1747), Kanoniker Pfarrer Studium
- Gienger von Grünbichl, Johann Wolfgang (*1601), Studium
- Gierl, Johann Michael ( †1781), Geistlicher Studium
- Giero, Joseph Ferdinand , Studium
- Gietel, Nikolaus Gregor Franz Xaver von (*1720), Geistlicher Schüler Studium
- Gigel, Simon (Unterschönbach) , Pfarrer Schüler Studium
- Gioggia, Thomas , Studium
- Girardini, Johann Baptist , Studium
- Gislimberti, Alexander Anton (*1702), Studium
- Gislimberti, Johann , Studium
- Gisser, Anton , Studium
- Giuliani, Karl von , Studium
- Glanz, Johann (Rottenburg) , Studium
- Glaser, Johann Georg , Geistlicher Studium
- Gleisser, Johann Georg , Pfarrer Studium
- Glocker, Johann Baptist , Jesuitengymnasium Pfarrer Studium
G Fortsetzung
-
Glöckler, Roman , Studium
- Gnembs, Johann Matthias , Studium
- Golser, Jakob (*1611), Studium
- Gottardis, Johann Valentin von , Studium
- Gottrau, Anton (*1605), Studium
- Graf, Georg Albert (*1615), Mediziner Studium
- Graf, Johann Heinrich (*1673 †1704), Jesuit Studium
- Graser, Johann Adolph ( †1753), Arzt Mediziner Studium
- Grass von Graseck, Matthias Anton Seraphin ( †1771), Franziskaner Mönch
- Grass, Johann Melchior ( †1675), Studium
- Greb, Johann Peter , Geistlicher Studium
- Greber, Johann (1646) (*1646), Pfarrer Priester Studium
- Greifenberg, Karl Joseph von , Priester Studium
- Greising, Kaspar (Studium) , Studium
- Greising, Michael , Pfarrer Studium
- Gretsch, Joseph Franz (*1696 †1748), Geistlicher Studium
- Gretter, Christoph (Luzern) , Priester Studium
G Fortsetzung
-
Gretter, Johann (Luzern) , Priester Studium
- Grieser, Markus , Benediktiner Mönch Studium
- Grieser, Matthias (Reichenau) , Priester Studium
- Gropper, Gallus Heinrich ( †1741), Pfarrer Priester Studium
- Gross, Philipp Anton ( †1744), Pfarrer Priester Schüler Studium
- Grosshofer, Johann Georg , Studium
- Grotti, Johann Abundius , Studium
- Gruber, Joseph Anton Dominik (*1679 †1733), Jesuit Studium
- Gruber, Joseph Macarius (*1672 †1756), Mönch Pfarrer Prämonstratenser Studium
- Gruber, Placidus (1606) (*1606 †1641), Benediktiner Mönch Studium
- Gruber, Placidus (Salzburg) ( †1641), Benediktiner Mönch Studium
- Grundner, Roman , Studium
- Grübel, Bartholomäus , Studium
- Grünerpel, Johann , Studium
- Gschwind, Franz Theobald , Studium
- Guarienti, Felix Anton , Studium