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
55
OFFSET
0
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
55
OFFSET
0
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 | 8568 | 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
Nonearticle | 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. |
---|---|---|---|
Person of the Month: Pearl Mackie | 2017-05-01 | Diva | 2024-05-17T23:09:00 |
The Doctor will see you now (2016) | 2016-09-15 | Boyz | 2024-05-17T23:06:52 |
FanCon attracts more than 650 diehard fans | 2016-06-23 | Chicago Tribune | 2024-05-17T23:03:27 |
Florence County Library to host 'Doctor Who' party | 2015-09-10 | Florence Morning News | 2024-05-17T22:55:22 |
Doctor Who's mobile theater coming to mall | 1986-11-28 | Florence Morning News | 2024-05-17T11:36:53 |
View from My Sofa: Freema Agyeman | 2023-04-01 | Radio Times | 2024-05-17T00:47:57 |
Arlo and Janis | 2023-03-11 | Newspaper Enterprise Association | 2024-05-17T00:40:31 |
Who's Calling | 2006-04-14 | HX | 2024-05-17T00:28:29 |
Fabulous Fantasy Females | 1980-04-01 | Starburst | 2024-05-17T00:02:18 |
Dr Who's girl gets the axe | 1980-06-01 | The Sunday Telegraph | 2024-05-13T03:02:39 |
ScotsGay Doctor Who | 2005-12-01 | ScotsGay | 2024-05-13T02:35:08 |
Action Line (Tulsa World) | 1987-12-09 | Tulsa World | 2024-05-12T20:37:38 |
Doctor Who fans visit trailer exhibit in Sumter | 1986-12-03 | The Sumter Daily Item | 2024-05-12T19:10:52 |
Dr. Who traveling museum to visit Beaufort | 1986-12-12 | The Beaufort Gazette | 2024-05-12T18:40:31 |
It's just Who coming to town | 1986-11-20 | The Herald (Rock Hill, SC) | 2024-05-12T18:13:18 |
Who's a sexpot now? | 1991-05-09 | The Sun (Brisbane) | 2024-05-11T00:15:12 |
Doctor Who coming to WVIA-TV | 1987-05-08 | The Danville News | 2024-05-10T01:09:51 |
Doctor Who is theme of exhibit | 1987-09-22 | Redding Record Searchlight | 2024-05-10T00:59:18 |
Who's here during a celebration tour | 1987-02-11 | The News-Press | 2024-05-09T23:49:45 |
Dr. Who's coming to Tacoma | 1987-09-09 | Morning News Tribune | 2024-05-09T23:26:33 |
Doctor Who Celebration and Tour coming to Bowling Green June 6-7 | 1987-06-04 | Fulton County Expositor | 2024-05-09T00:11:06 |
The Corridors of Time | 1976-07-01 | TV Sci-Fi Monthly | 2024-05-07T02:23:00 |
Daleks will be back, Dr. Who reveals | 1979-02-13 | The Courier Mail | 2024-05-06T23:53:49 |
Only one problem facing Dr Who | 1979-02-12 | The Daily Telegraph (Australia) | 2024-05-06T23:39:03 |
What's Next for Dr. Who? | 1980-03-09 | Sunday Mail (Adelaide) | 2024-05-05T21:42:16 |
Who's Who? (The Daily Telegraph) | 1980-03-09 | The Sunday Telegraph | 2024-05-05T21:30:24 |
Missing — one space robot: approach with caution | 1980-02-24 | The Sunday Observer | 2024-05-05T01:11:25 |
Adults Only for Dr Who | 1980-01-24 | The Sun (Sydney, NSW) | 2024-05-05T00:28:05 |
Who - the when and the why | 1980-01-04 | The Sun News-Pictorial | 2024-05-04T13:25:45 |
No love for Doctor Who | 1979-09-08 | Scene (Australia) | 2024-05-04T12:58:34 |
Robots greet Dr Who | 1979-02-03 | The Daily Telegraph (Australia) | 2024-05-04T12:42:09 |
Who's girl is home | 1985-10-05 | Truth (Melbourne) | 2024-05-04T00:57:54 |
Who switched off the doc? | 1978-11-04 | Truth (Melbourne) | 2024-05-04T00:48:32 |
Dr Who has got a new partner | 1978-10-16 | The Daily Telegraph (Australia) | 2024-05-04T00:40:32 |
The Dr Who convention: Who? Sometimes specialty conventions are just plain silly - on purpose | 1986-09-08 | Business First (Columbus, OH) | 2024-05-03T03:17:55 |
Alien sharks vs time-tampering Nazis! | 2010-07-01 | SFX | 2024-04-26T21:19:35 |
More bodily possession than Soho | 2010-07-01 | SFX | 2024-04-26T21:17:40 |
Pond and Beyond | 2010-07-01 | SFX | 2024-04-26T21:15:59 |
The Sarah Jane Adventures Season Four | 2010-07-01 | SFX | 2024-04-26T21:13:35 |
Dr. Who play to debut at Pickwick | 1985-12-18 | Des Plaines Times | 2024-04-24T23:03:30 |
Doctor Who: Season Six | 2010-10-01 | SFX | 2024-04-07T22:34:19 |
Never mind the Moroks | 2010-05-01 | SFX | 2024-03-24T20:04:42 |
The First Eleven | 2010-05-01 | SFX | 2024-03-24T20:02:38 |
Not Your Average Jo | 2010-11-01 | SFX | 2024-03-17T20:02:22 |
The Only Good Dalek | 2010-11-01 | SFX | 2024-03-17T19:59:06 |
Mystery diseases, black cats and the return of Mad Tom | 2010-11-01 | SFX | 2024-03-17T19:56:12 |
Objects of Desire (2010) | 2010-11-01 | SFX | 2024-03-17T19:52:20 |
Help save 'Dr. Who' | 1984-02-25 | The Daily News of Johnson County | 2024-03-09T14:49:07 |
Bi and proud with Pearl Mackie | 2021-11-01 | Diva | 2024-03-09T14:43:08 |
Whozat, Doctor? | 2023-02-25 | Radio Times | 2024-03-09T14:37:30 |