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, t0.smw_sort
FROM
`cutt_smw_object_ids` AS t0
INNER JOIN
`cutt_smw_fpt_inst` AS t1 ON t0.smw_id=t1.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
t0.smw_sort ASC
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, t0.smw_sort
FROM
`cutt_smw_object_ids` AS t0
INNER JOIN
`cutt_smw_fpt_inst` AS t1 ON t0.smw_id=t1.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
t0.smw_sort ASC
LIMIT
55
OFFSET
50
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 | 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 |
|---|---|---|
| 300 Daleks die as their H.Q. burns | 1965-04-17 | Daily Express |
| 3D Dr Who goes east for charity | 1993-10-27 | The Herald (Ireland) |
| 4,000-plus 'Who' fans come out | 1984-08-06 | Peninsula Times Tribune |
| 46 years on, look Who's invading St Paul's again... | 2014-07-21 | Daily Mail |
| 5 good reasons to watch Doctor | 2005-08-01 | Odyssey (Virgin Atlantic) |
| 5.15 Disney Time | 1975-08-23 | Radio Times |
| 50 anos de 'Doctor Who' | 2013-11-22 | Metro Brazil |
| 50 Daleks to be won | 1964-12-11 | Daily Express |
| 50 Lat Doktora Who | 2012-09-01 | Film (Poland) |
| 50 Years of Ice | 2017-06-10 | Radio Times |
| 50 years of intrigue | 2013-11-22 | Herald Sun |
| 6 Questions We Asked... | 2014-10-24 | The Bookseller |
| 60 Second Interview: Mark Gatiss | 2005-01-06 | Metro (England) |
| 60's Heroes | 1993-03-01 | Vox |
| 60,000 Expected At Radio Show | 1964-10-12 | Belfast Telegraph |
| 600 sci-fi fanatics make annual trek to convention for close encounters | 1985-02-03 | The Miami Herald |
| 6ft ant is BBC's latest TV monster | 1965-01-06 | The Daily Telegraph |
| 7 Questions with... Bonnie Langford | 2019-02-14 | Waitrose Weekend |
| 7,000,000 to Sing "Happy Birthday" to "Doctor Who" | 1983-07-01 | Facts Figures & Film |
| 77 millions de téléspectateurs ont vu l’épisode spécial de Doctor Who | 2013-11-27 | Le Journal de Québec |
| 7th Doctor Who to visit Urbana | 1987-07-01 | Herald & Review |
| 8 million greet Dr Who return | 1996-05-28 | London Evening Standard |
| 8m | 2007-04-02 | Irish Independent |
| 8mm Film Sales | 1977-12-23 | Harrow Observer |
| 950-year-old alien with two hearts lands in S.F.! Only time will tell his fate | 1996-05-14 | The San Francisco Examiner |
| A la recherche du Doctor Who | 2013-11-02 | The Guardian |
| A partir de diciembre, Peter Capaldi será el nuevo Dr. Who | 2013-08-05 | Publimetro (Mexico) |
| A trabajar sin parar | 2014-04-16 | Publimetro (Mexico) |
| The A-Z of Doctor Who | 2005-03-19 | The Daily Telegraph |
| Aaaaaaaargh! It's the Cybermen! | 2005-11-11 | The Times |
| Aargh! Who's that evil Parson? | 1989-05-28 | News of the World |
| Abominable Snowman upsets the Underground | 1968-03-01 | London Transport Magazine |
| About Doctor Who | 1979-02-24 | Ottawa Citizen |
| About Peter Davison, KUED 7's new Doctor Who | 1985-08-01 | Dial (Salt Lake City) |
| About time | 2003-09-18 | The Age |
| About time (Chicago Tribune) | 1993-10-19 | Chicago Tribune |
| About time (Empire) | 2014-09-01 | Empire Empire (Australia) |
| About time (The Guardian) | 2017-07-18 | The Guardian |
| About Time Lord | 2017-12-15 | The Mirror |
| About time! | 2018-07-20 | Entertainment Weekly |
| About time, lord: Dr Who has gay No 2 | 2017-04-01 | The Times |
| About time, too | 2000-06-14 | The Guardian |
| About time: Jodie is the first female Doctor Who | 2017-07-17 | Metro (England) |
| Absolutely fabulous alien role | 2006-11-16 | Kentish Times |
| An absurd ruling takes the fun out of Doctor Who | 2005-05-16 | The Times |
| Academic to deliver course on Dr. Who | 2014-11-12 | Edmonton Journal |
| Accumulate! Accumulate! | 1991-07-05 | New Statesman |
| Ace ... she's driving me mad | 1989-09-30 | Radio Times |
| Ace style of Doctor Who's girl | 1989-09-13 | The Sun |
| Acme Design replicates TARDIS | 2016-11-28 | The Courier-News (Elgin, IL) |
