Semantic search
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_wikipage` AS t4
INNER JOIN
`cutt_smw_di_wikipage` AS t6 ON t4.o_id=t6.s_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='30403'
AND (t4.p_id='30442'
AND (t6.p_id='30373' AND t6.o_id='30376')
))
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
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t6 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 651 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | cuttings_wiki133.t6.s_id | 3 | Using where |
| 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 |
Query-Depth:2
Anniversary party-membership drive, Another Side of Matt Smith, Anthony Ainley, An Appointment with the Doctor, Apps for time travel, Are there any Trekies out there?, Are you a fan of Dr. Who?, Are You A Whovian?, Area fans honor longest-running drama series, Area fans know who's Who, Area fans of Dr. Who, Area fans reflect on BBC's iconic sci-fi series, Arlo and Janis, Art contest keyed to TV show, Art contest winner, Asians cite those who do the balancing act, Attack of the funnybook fanatics, Attention all Doctor Who fans ..., Attention Doctor Who fans, Attention Dr. Who fans, Auction lures science fiction buffs, The Auntie Matter: The Fourth Doctor Adventures, The Authorized Dr. Who 20th Anniversary Celebration, Authors celebrate 'Doctor Who', An Avid Fan, B.B.C. Study Finds U.S. Fare Twice as Violent as British TV, Back to the future, with better FX: A new Doctor is in, The Backlot, Bad Timing, Baker headlines 'Dr. Who' convention, Baker only Dr. Who on Ch. 25, Baker's "Who", Balm for 'Doctor Who' fans, Ban Record, Bargain table yields treasure for this Doctor Who fan, Barrowman, Batman's 'butler' Michael Gough dies at 94, Batman's Batman, BBC back to cult favorite 'Doctor Who', BBC Brands Beyond Britain, BBC finds lost 1960s episodes of 'Doctor Who', The BBC have zapped new life into that most bizarre of geek entertainments, Dr. Who, The BBC lets British viewers download shows, BBC Lionheart Television awards cable TV rights to its classic and popular Doctor Who science-fiction series to the Sci-Fi Channel, BBC plans birthday bash as 'Doctor Who' turns 50, BBC reanimates 'Dr. Who' classic, BBC shows are entering U.S. video market, BBC Stepping Up Its Drama Output (For Webs 1 & 2), BBC Study Claims TV Violence Needed, The BBC Time Lord's Out-Of-This-World Adventures
