Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category:Runs]] [[HasGM::Korean_BBQ]] OR [[HasGM::KoreanBBQ]] OR [[HasGM::Korean BBQ]]
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
  `smw_object_ids` AS t0
INNER JOIN
  `t1` AS t1 ON t0.smw_id=t1.id
WHERE
  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
  10
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1ALLPRIMARY26Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4mediawiki_db.t1.id1Using where
Auxilliary Tables
  • Temporary table t1
      INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_fpt_inst` AS t3 INNER JOIN `smw_di_blob` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=3330 AND ((t5.o_hash='Korean_BBQ') AND t5.p_id=3012)
      INSERT IGNORE INTO `t1` SELECT DISTINCT t7.s_id FROM `smw_di_blob` AS t7 WHERE (t7.o_hash='KoreanBBQ') AND t7.p_id=3012
      INSERT IGNORE INTO `t1` SELECT DISTINCT t9.s_id FROM `smw_di_blob` AS t9 WHERE (t9.o_hash='Korean BBQ') AND t9.p_id=3012
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
NameGMMetaplotDate of RunTeam
Hostile HighwayKorean_BBQ22 June 2081The Hot-Rodder from Hell
Flyboy
Windsong
Roadie
It Belongs in a MuseumKorean_BBQThe Cutter's Curator21 June 2081Ice Cube
Rasputin
Roadie
Catseye
It Belongs in a Museum 2: Archaic Boogaloo!Korean_BBQThe Cutter's Curator28 June 2081Dr.Trauma
Slinger
Koi
Roadie
It Belongs in a Museum 3: Half-LivedKoreanBBQThe Cutter's Curator8 August 2081Trash Panda
Flyboy
Moth
Strawberry
Looking Out For the Little GuyKorean_BBQ11 August 2081Riot
Captain Boomerang
Boom Poom
Strawberry
Moore Ware from the BourgeoisKorean_BBQChromaggia24 August 2081Flyboy
Moth
Hydro
Jenny Glitz
Pirates of Elliott BayKorean BBQ16 August 2081Rabbit
Flyboy
Scurvy
Put Your Dreams AwayKorean BBQIt's Always Wednesday in Seattle26 August 2081Southpaw
Flak
Beuford "Saint' Mcgill
Storming the CastleKorean_BBQ28 July 2081Trash Panda
Quickdraw
Kost
Century
Street Fighting In The MoonlightKorean_BBQ16 July 2081Century
Trixie
Pollux
Roadkill (Inactive)
Super Summoning Sensei!Korean_BBQThe Narcotic Menagerie31 July 2081Pell
Messenger 7
Itako
The Butler's BurialKorean_BBQ24 July 2081Wild Star
Murderbot
WHO LET THE DOGS OUT!Korean_BBQThe Narcotic Menagerie4 July 2081Wildman
Pell
Beakman
Century
Wednesday Night BluesKorean BBQIt's Always Wednesday in Seattle8 July 2081Evans Doyle
Century
Wednesday Night WashKorean_BBQIt's Always Wednesday in Seattle2 August 2081Trash Panda
Reiko
Strawberry
Relay
Who Let the Pets into the Damn NovacokeKorean_BBQThe Narcotic Menagerie26 June 2081Good Boy
Pell
Bunga raya