Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Polen]]
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='Polen') AND t1.p_id=963)
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
550
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='Polen') AND t1.p_id=963)
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
550
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 | 1892 | 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
NoneH
-
Hermanovski, Johann , Studium
- Herwart, Albert , Studium
- Herzog, Johann (Obernissa) , Studium
- Hess, Maximilian von , Studium
- Hessler, Daniel (*1592), Studium
- Heuemann, Heinrich (Danzig) , Mediziner Studium
- Heuemann, Heinrich (Danzig, Mediziner) , Mediziner Studium
- Heugel, Andreas (Breslau) , Studium
- Heugnow, Johann , Studium
- Hieronymus, Felix , Studium
- Hiers, Kaspar , Studium
- Hilcemer, Balthasar ( †1634), Pfarrer Professor Studium
- Hildebrand, Balthasar (Grodków) , Studium
- Hildebrand, Georg (Grottkau) , Studium
- Hildebrand, Johann (Grottkau) , Mediziner Studium
- Hildebrand, Johann (Studium) , Studium
- Hildebrand, Kaspar (Grodków) , Studium
H Fortsetzung
-
Hildebrand, Michael (Grottkau) , Jurist Studium
- Hildesheim, Franz von , Studium
- Hildesheim, Konstantin von , Studium
- Hill, Urban , Studium
- Hillner von Rosenbach, Martin , Kanoniker Studium
- Hillner von Rosenbach, Michael , Studium
- Hilscher, Michael , Studium
- Hincza, Martin , Studium
- Hinneck, Andreas , Studium
- Hintermarkt, Philipp , Studium
- Hirschfeld, Georg , Studium
- Hitanius, Melchior , Studium
- Hoffmann, Ambrosius (Marienburg) , Mediziner
- Hoffmann, Ambrosius (Rössel) , Studium
- Hoffmann, David (Brieg) , Studium
- Hoffmann, Dominik (Schweinitz) , Mediziner Studium
- Hoffmann, Georg (Mewe) , Studium
H Fortsetzung
-
Hoffmann, Gregor (Guttstadt) , Studium
- Hoffmann, Heinrich (Elbing) , Studium
- Hoffmann, Lorenz (Heilsberg) , Studium
- Hoffmann, Peter (Heilsberg) , Lehrer Rektor Studium
- Holz, Michael , Studium
- Hopp, Georg (Elbing) , Studium
- Hopp, Martin , Studium
- Hornaeus, Thomas , Jurist Studium
- Hornig von Weigwitz, Karl , Studium
- Horodinsky, Theodor , Studium
- Horsky, Stanislaus , Studium
- Hortensius, Christoph , Jurist Priester Studium
- Huchser, Hermann , Studium
- Hugavitius, Samuel , Studium
- Huldenreich, Johann (Glatz) , Studium
- Hulewcz, Samuel von , Studium