Semantic search
From The Doctor Who Cuttings Archive
Jump to navigationJump to searchSQLStore debug output
ASK Query
[[Category:Articles]]
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, t4.o_sortkey
FROM
`cutt_smw_object_ids` AS t0
INNER JOIN
`cutt_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`cutt_smw_fpt_cdat` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id='30403')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
25
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, t4.o_sortkey
FROM
`cutt_smw_object_ids` AS t0
INNER JOIN
`cutt_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`cutt_smw_fpt_cdat` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id='30403')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
25
OFFSET
100
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 | 5 | const | 8573 | Using temporary; Using filesort |
| 1 | SIMPLE | t4 | ref | s_id | s_id | 4 | cuttings_wiki133.t1.s_id | 1 | |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | cuttings_wiki133.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None| article | date of article | publication | date added"Creation date" is a predefined property that corresponds to the date of the first revision of a subject and is provided by Semantic MediaWiki. |
|---|---|---|---|
| The sands of time | 1996-02-17 | Daily Record | 2023-12-24T02:13:23 |
| My time's up Doc | 1989-08-13 | Birmingham Weekly Mercury | 2023-12-24T01:57:49 |
| Back in time with Dr Who | 1985-03-13 | Reading Evening Post | 2023-12-24T00:13:46 |
| Calling Dr. Who for fund-raising prescription | 1985-03-08 | The News-Press | 2023-12-23T21:43:15 |
| If you blinked you missed it, but a fun time was had by all | 1998-05-29 | Seattle Gay News | 2023-12-23T19:41:09 |
| Time Out! | 2022-10-22 | TV Times | 2023-12-23T19:32:33 |
| A distress call from an intergalactic bullet train | 2022-10-22 | TV Times | 2023-12-23T19:29:54 |
| Objects of Desire | 2010-02-01 | SFX | 2023-12-23T18:20:39 |
| Toymakers, time-traps and more of Mad Uncle Tom | 2010-02-01 | SFX | 2023-12-23T18:18:28 |
| Exit Strategy | 2010-02-01 | SFX | 2023-12-23T18:15:19 |
| The Stranger: Colin Baker redeems himself? | 1995-06-01 | SFX | 2023-12-16T16:13:49 |
| Shakedown: Big battleships and new look Sontarans | 1995-06-01 | SFX | 2023-12-16T16:11:34 |
| Downtime: The Yetis are back! | 1995-06-01 | SFX | 2023-12-16T16:09:46 |
| The Dark Dimensions: The story that almost was... | 1995-06-01 | SFX | 2023-12-16T16:07:55 |
| Whose Who? | 1995-06-01 | SFX | 2023-12-16T16:04:34 |
| It obviously takes someone as devious as the Master to work in the BBC press office | 2022-10-22 | Radio Times | 2023-12-07T19:43:21 |
| Classic Doctor Who | 2022-10-22 | Radio Times | 2023-12-07T19:38:56 |
| The Time of My Life... | 2022-10-22 | Radio Times | 2023-12-07T19:31:50 |
| Tucker's Luck | 2021-01-10 | Best of British | 2023-12-04T00:52:19 |
| This convention promises out-of-this-world excitement | 1992-11-22 | Chicago Tribune | 2023-12-04T00:38:01 |
