Semantic search
From The Doctor Who Cuttings Archive
Jump to navigationJump to searchSQLStore debug output
ASK Query
[[Category:Articles]] [[Has DatePublished::+]]
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 t2
INNER JOIN
`cutt_smw_di_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='30403'
AND (t4.p_id='30419')
)
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 t2
INNER JOIN
`cutt_smw_di_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='30403'
AND (t4.p_id='30419')
)
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 | t4 | ref | s_id,p_id,p_id_2,s_id_2 | p_id | 4 | const | 4297 | Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id_2 | 9 | cuttings_wiki133.t4.s_id,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | cuttings_wiki133.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- 300 Daleks die as their H.Q. burns (Has DatePublished: 17 April 1965)
- 3D Dr Who goes east for charity (Has DatePublished: 27 October 1993)
- 4,000-plus 'Who' fans come out (Has DatePublished: 6 August 1984)
- 46 years on, look Who's invading St Paul's again... (Has DatePublished: 21 July 2014)
- 5 good reasons to watch Doctor (Has DatePublished: 1 August 2005)
- 5.15 Disney Time (Has DatePublished: 23 August 1975)
- 50 anos de 'Doctor Who' (Has DatePublished: 22 November 2013)
- 50 Daleks to be won (Has DatePublished: 11 December 1964)
- 50 Lat Doktora Who (Has DatePublished: 1 September 2012)
- 50 Years of Ice (Has DatePublished: 10 June 2017)
- 50 years of intrigue (Has DatePublished: 22 November 2013)
- 6 Questions We Asked... (Has DatePublished: 24 October 2014)
- 60 Second Interview: Mark Gatiss (Has DatePublished: 6 January 2005)
- 60's Heroes (Has DatePublished: 1 March 1993)
- 60,000 Expected At Radio Show (Has DatePublished: 12 October 1964)
- 600 sci-fi fanatics make annual trek to convention for close encounters (Has DatePublished: 3 February 1985)
- 6ft ant is BBC's latest TV monster (Has DatePublished: 6 January 1965)
- 7 Questions with... Bonnie Langford (Has DatePublished: 14 February 2019)
- 7,000,000 to Sing "Happy Birthday" to "Doctor Who" (Has DatePublished: 1 July 1983)
- 77 millions de téléspectateurs ont vu l’épisode spécial de Doctor Who (Has DatePublished: 27 November 2013)
- 7th Doctor Who to visit Urbana (Has DatePublished: 1 July 1987)
- 8 million greet Dr Who return (Has DatePublished: 28 May 1996)
- 8m (Has DatePublished: 2 April 2007)
- 8mm Film Sales (Has DatePublished: 23 December 1977)
- 950-year-old alien with two hearts lands in S.F.! Only time will tell his fate (Has DatePublished: 14 May 1996)
- A la recherche du Doctor Who (Has DatePublished: 2 November 2013)
- A partir de diciembre, Peter Capaldi será el nuevo Dr. Who (Has DatePublished: 5 August 2013)
- A trabajar sin parar (Has DatePublished: 16 April 2014)
- The A-Z of Doctor Who (Has DatePublished: 19 March 2005)
- Aaaaaaaargh! It's the Cybermen! (Has DatePublished: 11 November 2005)
- Aargh! Who's that evil Parson? (Has DatePublished: 28 May 1989)
- Abominable Snowman upsets the Underground (Has DatePublished: 1 March 1968)
- About Doctor Who (Has DatePublished: 24 February 1979)
- About Peter Davison, KUED 7's new Doctor Who (Has DatePublished: 1 August 1985)
- About time (Has DatePublished: 18 September 2003)
- About time (Chicago Tribune) (Has DatePublished: 19 October 1993)
- About time (Empire) (Has DatePublished: 1 September 2014)
- About time (The Guardian) (Has DatePublished: 18 July 2017)
- About Time Lord (Has DatePublished: 15 December 2017)
- About time! (Has DatePublished: 20 July 2018)
- About time, lord: Dr Who has gay No 2 (Has DatePublished: 1 April 2017)
- About time, too (Has DatePublished: 14 June 2000)
- About time: Jodie is the first female Doctor Who (Has DatePublished: 17 July 2017)
- Absolutely fabulous alien role (Has DatePublished: 16 November 2006)
- An absurd ruling takes the fun out of Doctor Who (Has DatePublished: 16 May 2005)
- Academic to deliver course on Dr. Who (Has DatePublished: 12 November 2014)
- Accumulate! Accumulate! (Has DatePublished: 5 July 1991)
- Ace ... she's driving me mad (Has DatePublished: 30 September 1989)
- Ace style of Doctor Who's girl (Has DatePublished: 13 September 1989)
- Acme Design replicates TARDIS (Has DatePublished: 28 November 2016)