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
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, 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
100
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- Across the Tellyverse (Has DatePublished: 22 June 2006)
- Action ext-erminate ... Dr Who faces dreaded Daleks (Has DatePublished: 1 September 1979)
- The action is more cerebral than Flash Gordon (Has DatePublished: 24 October 1992)
- Action Line (Has DatePublished: 6 June 1983)
- Action Line (Tulsa World) (Has DatePublished: 9 December 1987)
- Action! (Has DatePublished: 3 February 1979)
- El actor australiano Ray Barrett murió a los 82 años (Has DatePublished: 8 September 2009)
- Actor divorced (Has DatePublished: 31 March 1976)
- Actor dons Doctor Who cloak (Has DatePublished: 19 July 2005)
- Actor killed (Has DatePublished: 20 June 1973)
- Actor known for his long-running role as the Brigadier in Doctor Who (Has DatePublished: 26 February 2011)
- Actor Roger Delgado, alias Master in TVs "Dr. Who" series (Has DatePublished: 1 December 1972)
- Actor saying fond farewell to iconic role (Has DatePublished: 27 July 2013)
- Actor set to quit role as Dr. Who (Has DatePublished: 28 July 1983)
- Actor who starred opposite five Doctor Whos as Brigadier Lethbridge-Stewart (Has DatePublished: 24 February 2011)
- Actor William Hartnell dies at 67 (Has DatePublished: 25 April 1975)
- An actor with big 'Who' shoes to fill (Has DatePublished: 9 March 2009)
- Actor's piglet goes to a zoo (Has DatePublished: 30 September 1968)
- Actor's tears as she bows out of Doctor Who (Has DatePublished: 20 December 2017)
- Actors wins fight for annuity (Has DatePublished: 20 February 1975)
- Actress Katy Manning at the Dr Who national convention in Perth (Has DatePublished: 6 February 1988)
- Actress lands roles in Dr Who and Sherlock (Has DatePublished: 2 January 2014)
- Actress Rebecca Thornhill (Has DatePublished: 24 February 1989)
- Actress says little girls need sci-fi role models (Has DatePublished: 25 May 1987)
- Actress Sophie Aldred from Greenwich (Has DatePublished: 29 August 1996)
- Actress Susan Jameson was to have started work this month (Has DatePublished: 3 February 1971)
- Adam Richard, Doctor Who nut (Has DatePublished: 22 December 2011)
- An addiction to Dr. Who's world (Has DatePublished: 21 August 1985)
- Adelantadas a su tiempo y sin reconocimiento (Has DatePublished: 5 February 2021)
- Adelphi (Has DatePublished: 16 December 1974)
- Admit it, Billie there's something going on with you and Dr Who (Has DatePublished: 27 September 2004)
- Adoring world, the Doctor will see you now (Has DatePublished: 24 August 2014)
- Adults Only for Dr Who (Has DatePublished: 24 January 1980)
- An advance dose of 'Dr. Who' (Has DatePublished: 27 August 2012)
- Advanced technology has arrived on the Christmas show scene (Has DatePublished: 27 December 1974)
- The Adventure Begins (Has DatePublished: 16 November 2013)
- Adventures in Space and Time (Has DatePublished: 1 October 1995)
- Adventures in Space and Time: Kate Orman (Has DatePublished: 1 March 1996)
- The adventures of Dr Who took a new twist (Has DatePublished: 7 January 1988)
- Adventurous movie lovingly salutes sci-fi underdog (Has DatePublished: 21 November 2013)
- Affirmative, new mistress! (Has DatePublished: 7 February 1979)
- An African Dr Who (Has DatePublished: 1 July 2022)
- After 50 years of creaky sets and floppy hair, it's time Doctor Who died (Has DatePublished: 17 November 2013)
- After All The Hype, Mr Potty Mouth Had Better Be Good (Has DatePublished: 5 August 2013)
- After all this time, our hero is seen off by a Womble (Has DatePublished: 2 January 2010)
- After Davison's Doctor—Who's Next? (Has DatePublished: 6 October 1983)
- After Dr Who... (Has DatePublished: 2 June 1969)
- After October, the Doctor is gone!! (Has DatePublished: 1 February 1989)
- After Pertwee, who's next for Dr Who? (Has DatePublished: 9 February 1974)
- After the Daleks a new horror— VOORDS (Has DatePublished: 9 April 1964)