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=6354 AND t1.o_id=6355)
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
100
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=6354 AND t1.o_id=6355)
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
100
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 | 5 | const | 384 | 17.24 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id | s_id | 4 | htyp_mw.t1.s_id | 1 | 100.00 | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | htyp_mw.t1.s_id | 1 | 83.76 | 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>. |
---|---|
Watts Grocery | 9 October 2019 15:10:37 |
US/NC/Durham/Shrimp Boats | 9 October 2019 14:51:59 |
Sitar India Palace | 9 October 2019 14:49:27 |
Rev.com | 9 October 2019 14:45:07 |
501 Diner | 5 October 2019 14:09:41 |
The Athens Observer | 5 October 2019 13:48:59 |
Friendica | 5 October 2019 13:30:23 |
Slack | 2 October 2019 14:31:44 |
delimiter-prefixed string | 28 September 2019 23:11:21 |
Patreon | 22 September 2019 21:34:08 |
Failed to save website options : Missing or invalid website documents sub-directory | 20 September 2019 19:47:03 |
GitLab | 13 September 2019 13:01:16 |
digital goods marketplace | 8 September 2019 12:30:31 |
Mozilla Thunderbird | 6 September 2019 21:40:54 |
web hosting | 6 September 2019 13:26:23 |
web hosting/virtual | 6 September 2019 13:23:27 |
VbzCart | 17 August 2019 22:43:05 |
Akaunting | 9 August 2019 00:16:23 |
.env.production | 9 July 2019 14:17:40 |
Frontier Communications | 18 April 2019 22:07:17 |
Mattermost | 7 April 2019 13:08:45 |
Autism Speaks | 4 April 2019 14:42:28 |
self-governance software | 29 March 2019 19:16:57 |
realtime chat | 25 March 2019 13:04:49 |
social computing/federated | 22 February 2019 19:19:45 |
merchant card processing | 18 September 2018 09:43:12 |
OpenTable | 31 July 2018 00:31:40 |
WebAssembly | 23 July 2018 17:58:26 |
GitHub | 10 July 2018 19:13:04 |
Windows Internet Name Service | 26 June 2018 10:53:30 |
Samba | 25 June 2018 18:54:05 |
Pleroma | 22 June 2018 13:34:08 |
Angular | 18 June 2018 10:42:54 |
QuickBooks | 11 June 2018 22:59:46 |
.deb | 3 May 2018 15:04:07 |
GNU/screen | 28 April 2018 10:25:21 |
Jolly Roger Oceanfront Motel & Pier | 29 March 2018 12:40:53 |
Home Port Restaurant & Pub | 29 March 2018 12:39:18 |
software/Matrix | 25 March 2018 18:48:41 |
Now You're Gone | 6 January 2018 16:30:02 |
GNU | 5 January 2018 21:14:21 |
Atlantic City Friends School | 22 November 2017 12:57:43 |
The Motorcycle Song | 22 November 2017 12:44:54 |
gender dysphoria | 8 November 2017 10:50:29 |
The Forest at Duke | 4 November 2017 20:48:32 |
Ford | 13 October 2017 18:45:49 |
HP/Pavilion/DV6 | 12 October 2017 14:52:47 |
Chrysler/Pacifica | 10 October 2017 18:03:31 |
Chrysler | 10 October 2017 18:00:30 |
Steve Schewel | 23 September 2017 19:17:41 |