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
70
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
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, Stanisław Sobolewski, Ryszard Stecko, Włodzimierz Stanisław Stępiński, Jan Jakub Stock, Włodzimierz Stożek, Zbigniew Strzelecki, Jan Studniarski, Mieczysław Stypa, Marta Adelajda Dorota Suchanek-Kłyszewska, Jan Suchanek, Jerzy Antoni Ślebodziński, Bolesław Karol Świętochowski, Władysław Jan Takliński, Stanisław Takuski, Adam Stefan Trembecki, Henryk Tur, Andrzej Turowicz, Wacław Paweł Trutwin, Jan Alfred Walewski, Zdzisław Karol Wilk, Edward Windakiewicz, Stanisław Tadeusz Mieczysław Wyrobek, Jacek Zabierowski, Feliks Franciszek Zalewski, Jan Zarański, Tadeusz Władysław Zarosły, Józef Jakub Zieliński, Józef Znański, Witold Żabicki