Semantic search
SQLStore debug output
ASK Query
[[Category:Bibliographic Record]]
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='902')
AND 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
1000
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 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='902')
AND 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
1000
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 1048 | Using index; Using temporary; Using filesort |
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
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneBibliographic Record | Total | Status | Abstract | Historical Context | Synopsis | Criticism |
---|---|---|---|---|---|---|
Taylor (Ed.) (1959) | 0 | Stub | 0 | 0 | ||
Terrall (1992) | 0 | Stub | 0 | 0 | ||
Terrall (2002) | 20 | Stub | 0 | 0 | ||
Theiner (2015) | 20 | Stub | 0 | 0 | ||
Theiner and O'Connor (2010) | 20 | Stub | 0 | 0 | ||
Theiner, Allen, and Goldstone (2010) | 20 | Stub | 0 | 0 | ||
Thijssen (2003) | 20 | Needs Editing | 0 | 0 | ||
Thompson (2007) | 20 | Stub | 0 | 0 | ||
Thornton (2016) | 0 | Stub | 0 | 0 | ||
Tollefsen (2004) | 20 | Stub | 0 | 0 | ||
Tresch (2013) | 20 | Stub | 0 | 0 | ||
Turnbull and Machamer (Eds.) (1976) | 0 | Stub | 0 | 0 | ||
Uebel (2016) | 20 | Stub | 0 | 0 | ||
Uzgalis (2016) | 20 | Stub | 0 | 0 | ||
Van Fraassen (1980) | 20 | Needs Editing | 0 | 0 | ||
Van der Eijk (2000) | 0 | Stub | 0 | 0 | ||
Vickers (2014) | 0 | Stub | 0 | 0 | ||
Vosniadou (Ed.) (2008) | 20 | Stub | 0 | 0 | ||
Voss (Ed.) (1993) | 20 | Stub | 0 | 0 | ||
Warren (2005) | 20 | Stub | 0 | 0 | ||
Weber (1946) | 0 | Stub | 0 | 0 | ||
Weinberg (2003) | 20 | Stub | 0 | 0 | ||
Weisberg, Needham, and Hendry (2011) | 4 | Needs Editing | 0 | 0 | ||
Westfall (1980) | 20 | Stub | 0 | 0 | ||
Westfall (1999) | 0 | Stub | 0 | 0 | ||
Westman (Ed.) (1975) | 0 | Stub | 0 | 0 | ||
Wheaton (1983) | 0 | Stub | 0 | 0 | ||
Whewell (1831) | 0 | Stub | 0 | 0 | ||
Whewell (1840) | 0 | Stub | 0 | 0 | ||
White (2015) | 0 | Stub | 0 | 0 | ||
Williams (2002) | 3 | Stub | 0 | 0 | ||
Wilson and Ashplant (1988) | 0 | Stub | 0 | 0 | ||
Wimsatt (2006) | 20 | Stub | 0 | 0 | ||
Wimsatt (2007) | 20 | Stub | 0 | 0 | ||
Winther (2016) | 20 | Stub | 0 | 0 | ||
Wisniak (2004) | 20 | Stub | 0 | 0 | ||
Wiśniewski (1995) | 20 | Needs Editing | 0 | 0 | ||
Woolf (Ed.) (1980) | 0 | Stub | 0 | 0 | ||
Worrall (1988) | 0 | Stub | 0 | 0 | ||
Worrall (1989) | 0 | Stub | 0 | 0 | ||
Wright (2012) | 20 | Stub | 0 | 0 | ||
Wright and Potter (Eds.) (2000) | 20 | Stub | 0 | 0 | ||
Wykstra (1980) | 20 | Needs Editing | 0 | 0 | ||
Yan, Tsai, and Huang (2022) | 20 | Needs Editing | 0 | 0 | ||
Zabell (2008) | 0 | Stub | 0 | 0 | ||
Zalta (Ed.) (2016) | 20 | Stub | 0 | 0 | ||
Zalta (Ed.) (2017) | 20 | Stub | 0 | 0 | ||
Zhmud (2006) | 0 | Stub | 0 | 0 |