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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_fpt_mdat` AS t5 ON t0.smw_id=t5.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
t5.o_sortkey DESC
LIMIT
55
OFFSET
50
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_fpt_mdat` AS t5 ON t0.smw_id=t5.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
t5.o_sortkey DESC
LIMIT
55
OFFSET
50
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 |
1 | SIMPLE | t5 | ref | s_id | s_id | 4 | ispda_en_mw.t1.s_id | 1 | 100.00 |
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>. |
---|---|
Anarcho-Darwinism | 12 October 2022 17:21:53 |
Neoconservatism | 12 October 2022 17:20:30 |
January 6 insurrection | 9 October 2022 15:57:44 |
Ukraine/invasion by Russia | 7 October 2022 15:20:00 |
Courtney Geels | 4 October 2022 16:47:07 |
US/NC/gov | 25 September 2022 18:13:16 |
Donald Trump/self-coup | 25 September 2022 13:41:48 |
Leo Strauss | 21 September 2022 16:38:46 |
Ted Budd | 15 September 2022 12:22:08 |
US/FL/elec/2022/08 | 12 September 2022 14:26:40 |
Laura Loomer | 12 September 2022 14:23:52 |
Book banning | 2 September 2022 19:01:18 |
US/NC | 2 September 2022 12:54:52 |
Art Pope | 1 September 2022 16:49:27 |
Death of Roe | 1 September 2022 16:05:34 |
US/NC/elec/2022/05 | 1 September 2022 13:27:42 |
US/elec/2022/08 | 26 August 2022 16:30:39 |
US/elec/2022 | 25 August 2022 16:53:59 |
Kim Crockett | 25 August 2022 14:19:33 |
Scott Esk | 25 August 2022 13:42:21 |
US/NC/Durham/elec/2020/11 | 23 August 2022 19:22:39 |
US/elec/2022/05 | 20 August 2022 19:10:32 |
Fox News | 16 August 2022 13:03:28 |
US/KS/elec/2022/08 | 15 August 2022 12:21:00 |
5G | 15 August 2022 00:28:14 |
Abortion | 13 August 2022 13:23:07 |
Abortion/recreation | 13 August 2022 13:22:56 |
Hidden premise | 13 August 2022 13:16:19 |
US/AZ/elec/2022/08 | 5 August 2022 15:09:18 |
US/WA/elec/2022/08 | 4 August 2022 00:48:30 |
US/OH/elec/2022/08 | 4 August 2022 00:39:46 |
US/MO/elec/2022/08 | 4 August 2022 00:35:15 |
US/MI/elec/2022/08 | 4 August 2022 00:32:48 |
US/WI/elec/2022/04 | 3 August 2022 17:48:51 |
One America News Network | 21 July 2022 23:06:34 |
Doug Mastriano | 21 July 2022 16:41:31 |
Josh Shapiro | 21 July 2022 16:41:08 |
Death of Roe/minor travel | 19 July 2022 13:15:51 |
Irreversible Damage: The Transgender Craze Seducing Our Daughters | 19 July 2022 01:01:26 |
Leopards ate my face | 16 July 2022 17:20:58 |
Privilege blindness | 16 July 2022 16:52:09 |
Legendary freeloader | 16 July 2022 16:42:28 |
Human life absolutism | 16 July 2022 14:22:36 |
JPMorgan Chase Bank | 13 July 2022 14:03:32 |
Amazon.com | 12 July 2022 13:58:20 |
US/NC/2022/HB/1049 | 11 July 2022 16:13:35 |
Jordan Peterson | 8 July 2022 13:05:24 |
Flat Earth | 5 July 2022 17:57:51 |
Wilmington insurrection | 4 July 2022 18:42:20 |
US/NC/Wilmington | 4 July 2022 18:28:24 |