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
550
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
550
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 | 8593 | 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
Nonearticle | date of article | publication |
---|---|---|
The best series have their virtues | 1968-05-23 | The Stage and Television Today |
The best thing about Dr Who | 1980-10-11 | Reading Evening Post |
Better Hide Your Wallet, Cause the Daleks are Coming | 1964-11-21 | Austin American-Statesman Los Angeles Times The Pottstown Mercury The Kansas City Times Albuquerque Journal |
Beware Cyborg terror! | 2010-11-25 | Daily Star |
Beware the cybermen | 1994-11-18 | The Pink Paper |
Beyond our ken | 2010-04-03 | The Spectator |
Beyond Star Trek | 1995-10-01 | Tuff Stuff's Collect! |
BG's TARDIS to be shown off at stroll | 2011-11-13 | Nashua Telegraph |
Bi and proud with Pearl Mackie | 2021-11-01 | Diva |
Bianchi Aviation Film Services | 1980-01-09 | Variety |
A Big (W)hooray | 1983-06-01 | Fine Tuning (Milwaukee) |
Big changes in store as Doctor leaves the BBC | 1990-01-15 | The Canberra Times |
Big day for Time Lords | 2003-06-10 | Edinburgh Evening News |
Big DVD | 2008-01-22 | The Province |
Big event: Doctor Who: The Doctor, The Widow and The Wardrobe | 2011-12-19 | Regina Leader-Post Postmedia News |
Big hooray for Who from Colin | 1984-03-22 | The Mirror |
Big night for Dr Who fans as Timelord's companion makes her 'emotional departure' | 2012-09-29 | Western Mail |
Big numbers tune in Piper exit on 'Who' | 2006-07-11 | The Hollywood Reporter |
Big Screen Barbara | 2013-06-01 | Gay Times |
Big Screen Break: Fans Want A Dr Who Time Traveller Movie | 2008-08-25 | The Herald (Ireland) |
Big show stars beat the Tardis | 1986-11-09 | The Mail on Sunday |
Big thank-Who for Hannah | 2012-11-17 | South Wales Echo |
The big TV event this week is the return of Doctor Who | 1996-05-25 | TV Times |
Big value jigsaw puzzles | 1966-09-01 | Toys International |
Bigger on the Inside | 2014-10-01 | Library Journal |
Bigger on the Inside: Royals Visit 'Doctor Who' | 2013-07-04 | The New York Times |
Bigscreen Hears A 'Who' | 2011-11-15 | Daily Variety |
Bill Sellars | 2019-01-15 | The Times |
Bill Strutton | 2004-04-01 | Science Fiction Chronicle |
Bill Strutton obituary | 2003-12-04 | The Times |
Bill Strutton obituary (The Stage) | 2004-01-08 | The Stage and Television Today |
Billed as "X Files meets This Life" | 2006-09-21 | The Pink Paper |
Billie and Chris MkII | 2004-11-10 | The Sun |
Billie and I have on-screen chemistry | 2005-03-21 | New! |
Billie Bardot | 2005-03-13 | Sunday Express |
Billie bounces back | 2008-07-21 | The Mirror |
Billie in the bad ol' days | 2004-09-22 | Daily Star |
Billie is first £100m TV babe | 2006-04-15 | Daily Star |
Billie on Doctor Who... | 2018-09-27 | Metro (England) |
Billie Pins Down Celeb Wrestlers | 2005-04-13 | Daily Star |
Billie Piper | 2006-09-07 | The Stage and Television Today |
Billie Piper is 'dynamic' new Dr Who assistant | 2004-05-25 | Irish Independent |
Billie plots return to pop | 2005-03-09 | The Sun |
Billie Quits Show | 2005-11-12 | The Mirror |
Billie the kid | 2005-03-19 | The Times |
Billie to be first female Doctor Who? | 2006-05-09 | Daily Star |
Billie will do Who series 3 | 2006-03-30 | The Sun |
Billie's a real doll | 2005-08-01 | Daily Star |
Billie's a waste of time | 2006-04-23 | The Mail on Sunday |
Billie's big comeback? | 2005-03-19 | TV Quick |