Semantic search

Jump to: navigation, 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
SQLStore debug output
ASK Query
[[Concept:Manga monsters]] [[Actions::Sends from your hand to your Graveyard||Sends from hand to Graveyard for cost||Sends itself from hand to Graveyard||Sends itself from hand to Graveyard for cost]]
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
  (`smw_di_wikipage` AS t10
INNER JOIN
  `t12` AS t12 ON t10.o_id=t12.id
INNER JOIN
  (`smw_di_blob` AS t5
INNER JOIN
  `smw_di_wikipage` AS t7 ON t5.s_id=t7.s_id) ON t10.s_id=t5.s_id) ON t0.smw_id=t10.s_id
WHERE
  (t10.p_id='628'
   AND (
   (t5.o_hash='Manga') AND t5.p_id='599'
   AND (t7.p_id='596' AND t7.o_id='1389')
  ))
  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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt12ALLPRIMARY4Using temporary; Using filesort
1SIMPLEt10refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t12.id,const12
1SIMPLEt5refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t10.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t10.s_id1Using where
1SIMPLEt7refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t10.s_id,const,const1Using index; Distinct
Auxilliary Tables
  • Temporary table t12
      INSERT IGNORE INTO `t12` (id) VALUES ('1809')
      INSERT IGNORE INTO `t12` (id) VALUES ('3686')
      INSERT IGNORE INTO `t12` (id) VALUES ('34265')
      INSERT IGNORE INTO `t12` (id) VALUES ('21839')
Query Metrics
Query-Size:6
Query-Depth:1
Errors and Warnings
None
NameJapanese namePrimary typeSecondary type[[Attribute]][[Type]][[Level]]/
[[Rank]]
[[ATK]][[DEF]]
Amazing Dealerアメイジング・ディーラーEffect MonsterWATERSpellcaster301000
Amazing Dealerアメイジング・ディーラーEffect MonsterWATERSpellcaster301000
Analyze Phlogistonアナライズ・フロギストンEffect MonsterFIREPyro723002300
AromagmabearアロマグマEffect MonsterEARTHPyro36001200
Blackwing - Damascus the Polar NightBFブラックフェザーきょくのダマスカスEffect MonsterDARKWinged Beast31300700
Cladsoul Dragon GaigiasそうごんりゅうガイギアスEffect MonsterDARKDragon725001500
Cosmic String Noodryadコズミックストリング・ヌードルイダスEffect MonsterFIREPyro825001000
Crafter Droneクラフター・ドローンEffect MonsterEARTHMachine310000
Dian Keto the Boogie Masterぎゃくたまかみ ディアン・ケトEffect MonsterLIGHTAqua825001000
DosodonドスオドンEffect MonsterFIREDinosaur411000
The Dragiastarザ☆ドラギアスターEffect Monster
Fusion Monster
LIGHTHigh Dragon933002500
Dragon Merchantドラゴン・マーチャントEffect MonsterLIGHTDragon41000500
FiddlebadourフィドルバドゥールEffect MonsterWINDPsychic11000
Galactiara Eveギャラクティアラ・イヴEffect MonsterLIGHTGalaxy (Type)100
Galactica Tabula Rasaギャラクティカ・タブララサEffect MonsterLIGHTGalaxy (Type)615001600
Gravity Press Dragonグラビティ・プレス・ドラゴンEffect MonsterEARTHDragon615001000
Great Cosmonarchグレート・コスモナークEffect MonsterFIREGalaxy (Type)724001700
Great Multistrike Dragon Dragias Burst [R]だいれんげきりゅうドラギアス・バースト[アールEffect Monster
Maximum Monster
LIGHTDragon715000
Green-Eyes Star Cat緑眼の星猫グリーンアイズ・スターキャットEffect MonsterLIGHTBeast1400200
Hell Grub地獄蛆ヘル・グラップEffect MonsterTuner monster???200
Hydro Cannon Big Bluefin波導砲ハイドロキャノンビッグ・マグロムEffect MonsterWATERFish722002100
Illusion Strike Dragon MiragiasげんげきりゅうミラギアスEffect MonsterDARKDragon725001500
Jackie Jumperジャッキー・ジャンパーEffect MonsterTuner monsterMachine310001200
Jester Puppet Acrobat道化傀儡ジェスター・パペット アクロバートEffect Monster3800800
Jet Synchronジェット・シンクロンEffect MonsterTuner monsterFIREMachine15000
Jointech Arc Scorpioジョインテック・アークスコーピオEffect MonsterEARTHMachine722001600
Junk Anchorジャンク・アンカーEffect MonsterTuner monsterEARTHWarrior200
JunkuribohジャンクリボーEffect MonsterEARTHMachine1300200
Lightbringer Dragonライトブリンガー・ドラゴンEffect Monster???Dragon724001500
Long-Tailed Black HorseながこくEffect MonsterYokai41400800
Machina Cannonマシンナーズ・カノンEffect MonsterMachine802200
Makyura the Destructorしょけいにん-マキュラEffect Monster???416001200
Matsugumi the Ruler's Squadしょうぶんたい まつぐみEffect MonsterEARTHWarrior618000
Maxx "C"ぞうしょくするジーEffect MonsterEARTHInsect2500200
Mystic Dealerミスティック・ディーラーEffect MonsterWATERSpellcaster310000
Nullstrike Dragon ZerogiasれいげきりゅうゼロギアスEffect MonsterDARKDragon725001500
No. 10: IllumiknightNo.ナンバーズ10 しろイルミネーターEffect Monster
Xyz Monster
LIGHTWarrior424002400
Ozone Layerオゾン・ソーEffect MonsterWINDGalaxy (Type)31200900
Ozone Layerオゾン・ソーEffect MonsterWINDGalaxy (Type)31200900
Palace Gargoyleきゅう殿でんのガーゴイルEffect MonsterLIGHTFiend410001200
Patdrone Lampパトドローン・ランプEffect Monster?????????800???
Penguin Soljerseyペンギン・ソルジャージEffect MonsterWATERAqua2800500
Phoenix Dragonフェニックス・ドラゴンEffect MonsterFIREDragon2500500
Phoenix Dragonフェニックス・ドラゴンEffect MonsterFIREDragon2500500
Red OgreあかおにEffect MonsterYokai728002100
Rose Archer薔薇の聖弓手ローズ・アーチャーEffect MonsterEARTHWarrior31000100
Rose Spirit薔薇の精霊ローズ・スピリットEffect Monster???3300800
Royal Rebel's Bluesロイヤルデモンズ・ブルースEffect MonsterLIGHTFiend511000
Royal Rebel's Boogie Woogieロイヤルデモンズ・ブギウギEffect Monster?????????0???
Royal Rebel's Shoutロイヤルデモンズ・シャウトEffect MonsterLIGHTFiend412000