Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Italien]]
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='Italien') 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
750
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='Italien') 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
750
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 | 2374 | 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
NoneF
-
Ferretti, Hieronymus , Studium
- Fideli, Johann Baptist , Studium
- Figel, Anton (Gorízia) , Studium
- Figel, Sigismund , Studium
- Fin, Franz Bonaventura Freiherr von , Studium
- Fiori, Simon von (*1687), Geistlicher
- Firenz, Andreas , Studium
- Fiscar, Franz , Studium
- Fischer, Rudolph Adalbert , Studium
- Flautini, Johann Benno , Studium
- Fleurioli, Anton , Studium
- Florentin von Valvestino, Florentin , Kapuziner Mönch
- Florentin, Dominik , Studium
- Fodro, Friedrich , Studium
- Fogaroli, Anton (*1638), Studium
- Foglia von Vessanhoff, Florian Joseph von , Studium
- Foich, Georg (*1643), Studium
F Fortsetzung
-
Foliani, Gervasius , Studium
- Foliani, Hieronymus (*1617), Jesuit Studium
- Foliani, Jakob von , Studium
- Foliani, Julius , Studium
- Foliani, Nikolaus , Studium
- Foliani, Paul , Studium
- Fontana, Donata , Studium
- Foppa, Johann Jakob , Priester
- Fopulo, Bartholomäus (*1641), Studium
- Foresta, Hieronymus Franz von , Studium
- Forianschütz, Simon , Studium
- Forli, Anton von ( †1484 JL), Kanoniker
- Formasar, Franz , Studium
- Fornasar, Anton , Priester Studium
- Forni, Paul Franz Reinald Graf von , Studium
- Fortner, Johann Nepomuk von , Studium
- Fortunat von Verona, Fortunat , Guardian Kapuziner Mönch Provinzial
F Fortsetzung
-
Fortunati, Ludwig , Studium
- Fossa, Friedrich , Studium
- Fossato, Julius Caesar , Studium
- Fracarius, Peter (*1566 JL), Jesuit
- Franceschi, Franz von , Studium
- Francesco, Karl , Studium
- Francolanzia, Michael , Studium
- Frangelossi, Johann (*1632), Studium
- Frank, Franz (1666) (*1666 †1744), Jesuit
- Frank, Johann Baptist (Triest) , Studium
- Frank, Joseph Anton , Studium
- Frank, Markus (Studium) , Studium
- Frankowitz, Johann Franz , Studium
- Franz von Bergamo, Franz , Priester
- Franz von Castano, Franz , Kapuziner Mönch Priester
- Franz von Conegliano, Franz (*1569 JL †1623), Guardian Kapuziner Mönch Provinzial