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
150
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
150
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 | 8578 | 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. |
|---|---|---|---|
| Dr. Who fan club being organized | 1986-06-24 | The Journal Tribune | 2023-07-28T00:53:42 |
| Dr. Who on the road in Maine | 1986-08-15 | Morning Sentinel | 2023-07-27T23:31:23 |
| Time to change history (again) ... it's the new face of Dr Who | 2022-05-09 | Daily Mail | 2023-07-21T20:13:35 |
| Doctor woo-hoo... Ncuti ecstatic to be 14th Time Lord | 2022-05-09 | Daily Express | 2023-07-21T20:11:24 |
| Who goes there? (Leicester Mercury) | 2022-04-23 | Leicester Mercury | 2023-07-21T20:08:44 |
| Who's Who of Doctor Who | 2022-04-18 | The Mirror | 2023-07-21T19:25:06 |
| The Doctor Who Convention | 1979-11-30 | LA Weekly | 2023-07-21T19:15:11 |
| Prepare to have your swashes buckled and your timbers shivered | 2022-04-16 | TV Times | 2023-07-03T17:53:27 |
| Speak of the Devils! | 2022-04-16 | TV Times | 2023-07-03T17:51:20 |
| Dr Who in kilt Scot my vote | 2005-04-24 | Sunday World | 2023-07-03T17:34:32 |
| Dr. Who is Here! | 1979-04-09 | Greensboro News & Record | 2023-07-03T17:23:29 |
| Balm for 'Doctor Who' fans | 1985-06-06 | The Roanoke Times | 2023-07-02T19:05:38 |
| I am a fairly large fan of Dr. Who | 1989-01-08 | The Fresno Bee | 2023-07-02T18:58:24 |
| Ex-Dr Whos' tribute to Jon Pertwee | 1996-05-21 | Birmingham Mail | 2023-07-02T18:52:28 |
| The Five Doctors (Advance) | 1986-03-01 | Advance | 2023-06-27T23:55:18 |
| Doctor Who National Tour Comes to Iowa Public Television Broadcast Center August 1 and 2 | 1987-07-01 | Advance | 2023-06-27T23:38:48 |
| Just Who do you think they are kidding, Doctor? | 1997-04-03 | The Dorking and Leatherhead Advertiser | 2023-06-11T04:17:16 |
| Treasure and terror | 2022-04-16 | TV & Satellite Week | 2023-06-11T03:45:21 |
| Win a Dr Who Battle for the Universe | 1990-10-25 | Saffron Walden Weekly News | 2023-05-27T12:23:13 |
| It has been 38 years since the Doctor last encountered the amphibious Sea Devils | 2022-04-16 | Radio Times | 2023-05-27T12:11:54 |
| A Swashbuckling Swansong | 2022-04-16 | Radio Times | 2023-05-27T12:09:26 |
| Here come the Sci-Fi world's Whovians' and Joel Ossar | 1984-02-26 | The Manhattan Mercury | 2023-05-25T18:04:37 |
| Guess who's on their way? | 1998-10-28 | Hoylake & West Kirby News | 2023-05-14T23:22:42 |
| Good-lord! Who raises £100 | 1989-04-11 | Thanet Times | 2023-05-14T23:18:22 |
| A Time Lord with jet lag | 1988-10-05 | Hull Daily Mail | 2023-05-14T23:12:34 |
| BBC in court over Dr Who | 1997-02-15 | Heartland Evening News | 2023-05-14T22:59:41 |
| Dr Who's Time Is Up | 1996-12-07 | Daily Record | 2023-05-14T22:58:42 |
| Clive's trapped in a parallel universe | 1996-08-08 | Birmingham Mail | 2023-05-14T22:57:09 |
| EX-TOR-TION-ATE! (1993) | 1993-09-09 | Chelsea News and General Advertiser | 2023-05-14T22:55:25 |
| A career of stages | 1992-08-22 | East Cambridge Town Cryer | 2023-05-14T22:53:37 |
| Jodie's Doctor to come clean about crush on female chum | 2022-04-12 | Daily Mail | 2023-05-14T21:31:01 |
| June Brown | 2022-04-05 | The Times | 2023-05-14T21:29:52 |
| Jenny - Still Running: The Doctor's Daughter, Series 2 | 2022-04-01 | Audiofile | 2023-05-14T21:28:00 |
| Hugh's Who | 2022-03-20 | The Sunday Mirror | 2023-05-14T21:26:17 |
| Who's Next? (Yours Retro) | 2022-03-01 | Yours Retro | 2023-05-03T23:31:29 |
| Ch. 15's 'Dr. Who' has limited audience appeal | 1984-11-03 | The Roanoke Times | 2023-05-01T02:27:02 |
| She changed television for ever | 2022-02-26 | Radio Times | 2023-04-20T14:27:45 |
| Beryl Vertue | 2022-02-16 | The Times | 2023-04-20T14:20:27 |
| Attention Doctor Who fans | 1985-03-01 | Nine (St. Louis) | 2023-04-12T01:19:19 |
| You can't continue to show the episodes in the wrong order | 1985-03-01 | Nine (St. Louis) | 2023-04-12T00:45:00 |
| Tardiscon '88 | 1988-08-01 | Nine (St. Louis) | 2023-04-09T17:08:56 |
| Where and When is Who? | 1991-09-01 | Nine (St. Louis) | 2023-04-09T17:03:30 |
| Troughton Scholarship | 1987-07-01 | Nine (St. Louis) | 2023-04-08T22:07:32 |
| Every issue of Nine brings good news | 1987-04-01 | Nine (St. Louis) | 2023-04-08T22:00:20 |
| I thoroughly enjoy Channel 9's programs, especially Doctor Who | 1986-11-01 | Nine (St. Louis) | 2023-04-08T14:19:39 |
| I would like to propose the following suggestions | 1986-02-01 | Nine (St. Louis) | 2023-04-08T14:12:38 |
| I would like to express my thanks | 1985-08-01 | Nine (St. Louis) | 2023-04-08T14:08:15 |
| Who's next? (Nine) | 1985-01-01 | Nine (St. Louis) | 2023-04-08T03:13:39 |
| New Who (The Dial) | 1984-09-01 | The Dial (St. Louis) | 2023-04-08T03:05:42 |
| See Who in September? | 1984-06-01 | The Dial (St. Louis) | 2023-04-08T03:01:18 |
