Semantic search
Jump to navigation
Jump to search
Query-Depth:0
SQLStore debug output
ASK Query
[[Category:Author]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_fpt_inst` AS t1
INNER JOIN
`mw_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_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
505
OFFSET
500
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_fpt_inst` AS t1
INNER JOIN
`mw_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_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
505
OFFSET
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 4 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | i1921525_mw1.t2.id | 50 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | i1921525_mw1.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) ('505').
SELECT s_id FROM `mw_smw_fpt_subc` WHERE o_id='505' LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneAuthor | Total | Status | Date of Birth | Summary | Historical Context | Major Contributions | Criticism |
---|---|---|---|---|---|---|---|
Elliott R. Sober | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Antonio Spadafora | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Andreas Spath | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
James Spedding | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Kyle Stanford | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Gem Stapleton | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Thomas B. Steel | 1 | Stub | 25 | 0 | 0 | 0 | 0 |
Friedrich Steinle | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Alan Stewart | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Jack Stillinger | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Stephen Stitch | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Edward Strong | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Roger H. Stuewer | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
David Stump | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John J. Sullivan | 1 | Stub | 25 | 0 | 0 | 0 | 0 |
Frederick Suppe | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Fredrick Suppe | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Koji Tanaka | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Alfred Tarski | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Calvin Walker Taylor | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Jacqueline Taylor | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Mary Terrall | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Georg Theiner | 10 | Stub | 0 | 96 | 0 | 0 | 0 |
Johannes M. M. H. Thijssen | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Evan Thompson | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Stephen Thornton | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Sam Tippelt | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Deborah Tollefsen | 10 | Stub | 0 | 100 | 0 | 0 | 0 |
Stephen Toulmin | 15 | Stub | 100 | 100 | 0 | 0 | 0 |
John Tresch | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John D. Trout | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Meng-Li Tsai | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Colin Turbayne | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Robert Turnbull | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Thomas Uebel | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William Uzgalis | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Bas Van Fraassen | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John Hasbrouck Van Vleck | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Phillip J. Van der Eijk | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Petrucio Viana | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Brian Vickers | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John Vickers | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John Von Neumann | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Stella Vosniadou | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Stephen Voss | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Maria Wakely | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Felix Walpole | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William Warren | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Marx W. Wartofsky | 1 | Stub | 25 | 0 | 0 | 0 | 0 |
Stephen Watt | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Max Weber | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Zachary Weber | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Marcus Weigelt | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Steven Weinberg | 3 | Stub | 25 | 19 | 0 | 0 | 0 |
Michael Weisberg | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Richard Westfall | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Robert Westman | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Bruce R. Wheaton | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William Whewell | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Roger White | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Richard Whitley | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Jennifer Whyte | |||||||
Philip Wiener | 6 | Stub | 100 | 0 | 0 | 2 | 0 |
Bernard Williams | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Adrian Wilson | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William C. Wimsatt | 15 | Stub | 100 | 100 | 0 | 0 | 0 |
Rasmus Winther | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Jaime Wisniak | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Alexandra Witze | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Andrzej Wiśniewski | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Nadezhda Woinowsky-Krieger | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William Wood | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Harry Woolf | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
Steve Woolgar | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John Worrall | 5 | Stub | 100 | 0 | 0 | 0 | 0 |
John Wright | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
John P. Wright | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
William Wright | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Brendan Wu | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Stephen Wykstra | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Gideon Yaffe | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Karen Yan | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Neo Yin | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Hong Yu Wong | 10 | Stub | 0 | 100 | 0 | 0 | 0 |
Sandy L. Zabell | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Elie Zahar | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Edward Zalta | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Yichen Zhang | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Yifang Zhang | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Kevin Zheng | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Leonid Zhmud | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Nora Zolfaghari | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Amna Zulfiqar | 0 | Stub | 0 | 0 | 0 | 0 | 0 |
Henk de Regt | 0 | Stub | 0 | 0 | 0 | 0 | 0 |