Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Page type::Article]]
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=17834 AND t1.o_id=17877)
AND 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
600
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=17834 AND t1.o_id=17877)
AND 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
600
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 881 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ispda_en_mw.t1.s_id | 1 | 50.04 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneArticle | Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. |
---|---|
Prayer | 15 April 2013 18:11:41 |
Preference for concentrated effects | 29 August 2019 19:09:52 |
Privilege | 13 August 2017 16:38:43 |
Privilege blindness | 16 July 2022 16:52:09 |
Profit | 3 July 2013 02:10:45 |
Project Veritas | 13 January 2022 20:30:23 |
Propaganda | 18 February 2020 14:36:51 |
Protestant fundamentalism | 29 April 2014 01:26:32 |
Pseudoposition | 27 January 2022 16:32:39 |
Psychopathy | 22 March 2014 17:13:16 |
Public endangerment | 14 December 2021 15:03:28 |
Pulse Massacre | 20 June 2016 23:05:53 |
Racism | 7 July 2016 20:28:34 |
Range voting | 14 September 2020 13:35:49 |
Raquel Nelson homicide conviction | 27 July 2011 15:39:55 |
Rates of violence against women vs. trans | 26 October 2020 17:53:10 |
Rates of violence by cis women vs. trans women | 26 October 2020 17:58:25 |
RationalWiki | 15 April 2014 01:40:51 |
Rationality | 20 June 2015 19:57:17 |
Reality | 18 February 2013 22:19:44 |
Reality-based thinking | 16 December 2014 00:56:12 |
Red Thread Studios | 19 May 2021 16:17:51 |
Regovernance | 2 June 2012 15:17:09 |
Religion | 19 May 2015 01:33:13 |
Religious fundamentalism | 9 November 2019 20:30:50 |
Resource exhaustion denial | 13 February 2015 13:28:52 |
Rett Newton | 17 May 2022 00:19:13 |
Reverse bigotry | 19 December 2019 13:53:01 |
Reverse racism | 19 December 2019 13:20:03 |
Rhetoric | 3 August 2021 12:44:41 |
Rhetorical deception | 12 December 2016 11:24:19 |
Rhetorical distraction | 3 August 2021 12:30:58 |
Richard D. Wolff | 17 April 2016 13:26:58 |
Richard Mellon Scaife | 25 April 2017 00:14:22 |
Right to employment | 19 April 2014 16:20:10 |
Right wing | 7 October 2020 15:11:54 |
Right-to-work law | 19 April 2014 16:22:51 |
Rittenhouse verdict | 28 November 2021 22:32:10 |
Robert Colon | 17 May 2022 00:09:29 |
Robert F. Kennedy, Jr. | 24 July 2023 12:33:44 |
Rocky Anderson | 10 May 2012 22:07:27 |
Ron Paul | 26 July 2013 18:30:39 |
Ronald Reagan | 18 May 2022 21:29:56 |
Roy Spencer | 7 May 2014 01:38:44 |
Rudy Giuliani | 19 November 2019 12:58:28 |
Russia | 16 May 2022 16:23:27 |
Ruth Bader Ginsburg | 19 September 2020 19:47:18 |
SJWiki | 29 July 2020 12:33:46 |
Saddam Hussein | 6 June 2013 14:59:52 |
Schrödinger's joke | 7 October 2020 14:14:02 |