Semantische Suche
Aus Wien Geschichte Wiki
Debug output SQLStore
ASK Query
[[Beruf::Fotograf]]OR[[Beruf::Fotografin]]OR[[Beruf::Photographin]]OR[[Beruf::Photograph]]OR[[Beruf::Photograf]]OR[[Beruf::Photografin]]OR[[Beruf::Kunstfotograf]]OR[[Beruf::Kunstfotografin]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
15
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
15
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 80 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | semwiki.t1.id | 1 | 50.00 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 WHERE (t2.o_hash='Fotograf') AND t2.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_blob` AS t4 WHERE (t4.o_hash='Fotografin') AND t4.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t6.s_id FROM `smw_di_blob` AS t6 WHERE (t6.o_hash='Photographin') AND t6.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t8.s_id FROM `smw_di_blob` AS t8 WHERE (t8.o_hash='Photograph') AND t8.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t10.s_id FROM `smw_di_blob` AS t10 WHERE (t10.o_hash='Photograf') AND t10.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t12.s_id FROM `smw_di_blob` AS t12 WHERE (t12.o_hash='Photografin') AND t12.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t14.s_id FROM `smw_di_blob` AS t14 WHERE (t14.o_hash='Kunstfotograf') AND t14.p_id=1523270
INSERT IGNORE INTO `t1` SELECT DISTINCT t16.s_id FROM `smw_di_blob` AS t16 WHERE (t16.o_hash='Kunstfotografin') AND t16.p_id=1523270
Query Metrics
Query-Size:16Query-Depth:1
Errors and Warnings
None- Conny de Beauclair (*: 1952)
- Dora Philippine Kallmus (*: 1881, †: 1963)
- Edith Tudor-Hart (*: 1908, †: 1973)
- Eduard Cramolini (*: 1807, †: 1881)
- Elfie Semotan (*: 1941)
- Elfriede Mejchar (*: 1924, †: 2020)
- Emil Mariot (*: 1825, †: 1891)
- Emil Mayer (*: 1871, †: 1938)
- Erich Lessing (*: 1923, †: 2018)
- Ernest Richter (*: 1938)
- Ernst Haas (*: 1921, †: 1986)
- Erwin Karl Meyer (*: 1913, †: 1991)
- Eugen Schöfer (*: 1862, †: 1912)
- Eva Völkel (*: 1943)
- Francis G. Mayer (*: 1891, †: 1971)
- Franz Hubmann (*: 1914, †: 2007)
- Franz Josef Böhm (*: 1874, †: 1938)
- Fritz Benesch (*: 1868, †: 1949)
- Georg Friedl (*: 1887, †: 1968)
- Georg Riha (*: 1951)
- Hans Makart der Jüngere (*: 1870, †: 1946)
- Hans Mayr (Fotograf) (*: 1926, †: 1993)
- Hans Walter Hannau (*: 1904, †: 2001)
- Harry Weber (*: 1921, †: 2007)
- Hedwig Rosenbaum (*: 1908, †: 1994)
- Hermann Klee (*: 1820, †: 1894)
- Hilde Schmölzer (*: 1937)
- Hugo Henneberg (*: 1863, †: 1918)
- Hugo Hinterberger (*: 1868, †: 1943)
- Ilse Pisk (*: 1892, †: 1942)
- Inge Morath (*: 1923, †: 2002)
- Irene Messner (*: 1888, †: 1975)
- Johann Evangelist Schopf (*: 1834, †: 1904)
- Josef Hommolatsch (*: 1812, †: 1888)
- Josef Székely (*: 1838, †: 1901)
- Joseph Mutterer (*: 1834, †: 1908)
- Julius Hoffmann (*: 1840, †: 1913)
- Karin Mack (*: 1940)
- Kurt Apfel (*: 1927, †: 2009)
- Kurt Franz Hubert Husnik (*: 1908, †: 1994)
- Kurt Klagsbrunn (*: 1918, †: 2005)
- Lee Miller (*: 1907, †: 1977)
- Lillian Barylli-Fayer (*: 1917, †: 2015)
- Lisette Model (*: 1901, †: 1983)
- Lisl Ponger (*: 1947)
- Lothar Rübelt (*: 1901, †: 1990)
- Lotte Hahn (*: 1906, †: 2002)
- Lucca Chmel (*: 1911, †: 1999)
- Ludwig Schrank (*: 1828, †: 1905)
- Man Ray (*: 1890, †: 1976)