Wyszukiwanie semantyczne
[[Kategoria:Biogramy]] [[Faculty::Wydział Górniczy]] OR[[Unit::Wydział Górniczy]]
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
30
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 109 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | historia.t1.id | 1 | 50.03 | Using where |
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_fpt_inst` AS t3 INNER JOIN `smw_di_wikipage` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=11904 AND (t5.p_id=2657 AND t5.o_id=3164)
INSERT IGNORE INTO `t1` SELECT DISTINCT t8.s_id FROM `smw_di_wikipage` AS t8 WHERE t8.p_id=30877 AND t8.o_id=3164
Query-Depth:1
Aleksandra Jakóbska, Kazimierz Kasiński, Tomasz Klenczar, Kazimierz Jan Kling, Marian Klott de Heidenfeld, Bolesław Kłapkowski, Jadwiga Kłosińska, Stanisław Marian Knothe, Jerzy Kolbe, Stanisław Leopold Korman, Dionizy Korol, Zbigniew Stanisław Kozłowski, Stefan Kreutz, Władysław Krukowiecki, Bolesław Krupiński, Czesław Kuźniar, Zygmunt Kwiecień, Tadeusz Piotr Laskowski, Jerzy Henryk Litwiniszyn, Marian Józef Machowski, Zdzisław Kazimierz Maciejasz, Stanisław Włodzimierz Majewski, Antoni Bronisław Matysik, Stanisław Mazurkiewicz, Antoni Józef Konstanty Meyer, Władysław Józef Michejda, Zygmunt Mitera, Jan Naturski, Oskar Nowotny, Zbigniew Zygmunt Obuchowicz, Tadeusz Ozog, Stanisław Paraszczak, Jan Pawiński, Bronisław Piątkiewicz, Władysław Pilch, Marian Ptak, Wiktor Pudło, Tadeusz Ramza, Tadeusz Reguła, Roman Zygmunt Rieger, Zygmunt Rozen, Czesław Ruebenbauer, Włodzimierz Kazimierz Rymon-Lipiński, Tadeusz Ryncarz, Antoni Lambert Eligiusz Sałustowicz, Julian Michał Samujłło-Sulima, Antoni Schimitzek, Tadeusz Sęk, Stanisław Skoczylas, Marian Skup