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
40
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
40
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>. |
---|---|
Minimum wage/revenue-based | 29 August 2011 17:31:40 |
Libertarianism/American | 9 June 2015 18:40:19 |
Equating wealth and worth | 1 August 2017 12:33:25 |
Religious faith | 8 December 2014 22:13:52 |
Vote themselves largesse | 13 March 2013 01:32:48 |
God/arguments for | 29 April 2014 12:02:56 |
There is only one politically serious explanation... | 19 March 2013 14:56:14 |
Lolcow.wiki | 6 December 2018 21:19:47 |
Progressive tax | 9 August 2017 00:21:50 |
So what | 7 October 2015 18:43:00 |
Job demand | 9 February 2014 23:00:04 |
Blake's Law | 11 August 2015 15:04:07 |
Impeaching credibility | 2 March 2015 11:16:41 |
Address the content | 27 February 2016 01:58:07 |
Trump-Pence administration/week 03 | 28 March 2017 23:12:10 |
Trump-Pence administration/week 02 | 13 February 2017 01:04:07 |
AIDS is just retribution for improper sexual conduct | 14 January 2013 13:05:10 |
Trump-Pence administration/week 07 | 30 March 2017 23:09:20 |
Emotional wedge | 10 September 2017 12:13:36 |
Trust parasite | 11 July 2018 11:58:06 |
Bible/canon | 28 May 2017 18:45:53 |
Socially useless production | 30 December 2013 12:00:21 |
Dominance mandate | 27 November 2013 02:51:04 |
Eucharist wafer | 17 August 2011 12:00:26 |
Trump-Pence administration/week 12 | 17 April 2017 23:51:46 |
The Urban Farming Guys | 18 July 2011 02:41:18 |
Trump-Pence administration/week 05 | 12 March 2017 13:21:27 |
Ernie and Bert are gay | 30 June 2013 02:33:47 |
UN World Constitution | 30 August 2011 21:16:22 |
Moral rule | 20 May 2012 13:30:18 |
James Madison/quotes | 3 December 2012 22:26:12 |
Argument by characterization | 11 October 2011 01:08:09 |
Trump-Pence administration/week 08 | 1 April 2017 18:04:56 |
The Bullock Pulpit | 16 July 2011 01:37:13 |
US/gov/budget/debt/alarmism | 24 August 2014 15:25:36 |
Fossil fuel addiction | 21 January 2015 21:34:07 |
Confederate flag | 28 June 2015 00:56:03 |
Trump-Pence administration/week 09 | 30 March 2017 23:12:57 |
Appeal to invisible garments | 27 June 2013 22:10:43 |
Trump-Pence administration/week 11 | 17 April 2017 23:50:41 |
Both sides do it | 20 October 2012 16:34:16 |
Hidden provocation | 7 March 2019 16:09:22 |
Visible minority | 21 June 2017 12:12:22 |
Perception-based thinking | 17 March 2015 21:15:59 |
Trump-Pence administration/week 00 | 11 February 2017 01:10:13 |
Trump-Pence administration/week 06 | 12 March 2017 13:22:15 |
Trump-Pence administration/week 01 | 11 February 2017 01:10:54 |
Trump-Pence administration/week 04 | 6 March 2017 23:54:38 |
Intellectual sabotage | 1 December 2015 16:10:51 |
Artificial scarcity | 27 December 2013 20:04:22 |