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
[[Medium::OCG||TCG]] [[Type::Thunder]] [[Attribute::LIGHT]]
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_blob` AS t2
INNER JOIN
  `smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_di_wikipage` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   ((t2.o_hash='OCG') OR (t2.o_hash='TCG')
  ) AND t2.p_id='599'
   AND (t4.p_id='595' AND t4.o_id='1542')
   AND (t7.p_id='594' AND t7.o_id='1535')
  )
  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
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39const,const768Using temporary; Using filesort
1SIMPLEt2refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t4.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t4.s_id1Using where
1SIMPLEt7refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t4.s_id,const,const1Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
 Japanese nameCard typeAttributeTypeStars stringATK stringDEF string
The Accumulatorザ・アキュムレーターMonster CardLIGHTThunder100
ApocatequilアポカテクイルMonster CardLIGHTThunder418001200
The Ascended of Thunder雷（かみなり）仙（せん）神（じん）Monster CardLIGHTThunder727002400
Batteryman 9-Volt電（でん）池（ち）メン－角（かく）型（がた）Monster CardLIGHTThunder410001000
Batteryman AA電（でん）池（ち）メン－単（たん）三（さん）型（がた）Monster CardLIGHTThunder300
Batteryman AAA電（でん）池（ち）メン－単（たん）四（よん）型（がた）Monster CardLIGHTThunder400
Batteryman C電（でん）池（ち）メン－単（たん）二（に）型（がた）Monster CardLIGHTThunder200
Batteryman Charger充（じゅう）電（でん）池（ち）メンMonster CardLIGHTThunder518001200
Batteryman D電（でん）池（ち）メン－単（たん）一（いち）型（がた）Monster CardLIGHTThunder101900
Batteryman Fuel Cell燃（ねん）料（りょう）電（でん）池（ち）メンMonster CardLIGHTThunder621000
Batteryman Industrial Strength電（でん）池（ち）メン－業（ぎょう）務（む）用（よう）Monster CardLIGHTThunder826000
Batteryman Micro-Cell電（でん）池（ち）メン－ボタン型（がた）Monster CardLIGHTThunder1100100
Batteryman Solar太（たい）陽（よう）電（でん）池（ち）メンMonster CardLIGHTThunder415001500
Batteryman Token電（でん）池（ち）メントークンMonster CardLIGHTThunder100
BrohunderＯＮｉ（オニ）サンダーMonster CardLIGHTThunder4900400
The Calculatorザ・カリキュレーターMonster CardLIGHTThunder2?0
The Calibratorザ・キャリブレーターMonster CardLIGHTThunder415001500
Core of Chaos混沌核（コア・オブ・カオス）Monster CardLIGHTThunder201600
The Creator創世神（ザ・クリエイター）Monster CardLIGHTThunder823003000
CubenキューブンMonster CardLIGHTThunder46001900
Denko Sekka電（でん）光（こう）－雪（せっ）花（か）－Monster CardLIGHTThunder417001000
Diana the Light Spirit光（ひかり）の精（せい）霊（れい） ディアーナMonster CardLIGHTThunder417001000
Electric Snakeエレクトリック・スネークMonster CardLIGHTThunder3800900
Electric Virusエレクトリック・ワームMonster CardLIGHTThunder310001000
Electrode Beast Anion電（でん）極（きょく）獣（じゅう）アニオンMonster CardLIGHTThunder2300100
Electrode Beast Cation電（でん）極（きょく）獣（じゅう）カチオンMonster CardLIGHTThunder2300100
Elemental HERO VolticＥ・ＨＥＲＯ（エレメンタルヒーロー） ボルテックMonster CardLIGHTThunder410001500
Emperor of Lightningエンペラー・オブ・ライトニングMonster CardLIGHTThunder826002600
Gate Guardian of Thunder and Wind雷（らい）風（ふう）魔（ま）神（しん）－ゲート・ガーディアンMonster CardLIGHTThunder925002200
Gold Pride - Star LeonＧＰ（ゴールド・プライド）－スター・リオンMonster CardLIGHTThunder620002000
Guardian Tryceガーディアン・トライスMonster CardLIGHTThunder519001700
Hamon, Lord of Striking Thunder降（こう）雷（らい）皇（おう）ハモンMonster CardLIGHTThunder1040004000
The Immortal of Thunder雷（かみなり）仙（せん）人（にん）Monster CardLIGHTThunder415001300
KurivoltクリボルトMonster CardLIGHTThunder1300200
Lightning Rod Lord避（ひ）雷（らい）神（じん）Monster CardLIGHTThunder41800100
MahunderＯＫａ（オカ）サンダーMonster CardLIGHTThunder41400700
Mementotlan Twin Dragonメメント・ツイン・ドラゴンMonster CardLIGHTThunder728002100
Mithra the Thunder Vassal雷（らい）帝（てい）家（か）臣（しん）ミスラMonster CardLIGHTThunder28001000
Morphtronic RadionＤ（ディフォーマー）・ラジオンMonster CardLIGHTThunder41000900
Otonari ThunderＯＴｏＮａＲｉ（オトナリ）サンダーMonster CardLIGHTThunder45001200
PahunderＯＴｏ（オト）サンダーMonster CardLIGHTThunder41300600
Photon TokenフォトントークンMonster CardLIGHTThunder420000
Plasma Ballプラズマ・ボールMonster CardLIGHTThunder3900900
Rai RiderライライダーMonster CardLIGHTThunder312001400
Rai-JinＲＡＩ（ライ）－ＪＩＮ（ジン）Monster CardLIGHTThunder4?1000
Rai-MeiＲＡＩ（ライ）－ＭＥＩ（メイ）Monster CardLIGHTThunder314001200
Sanga of the Thunder雷（らい）魔（ま）神（しん）－サンガMonster CardLIGHTThunder726002200
ShiivertakeシビレルダケMonster CardLIGHTThunder514000
SishunderＯＮｅ（オネ）サンダーMonster CardLIGHTThunder4900400
Some Summer Summoner常（とこ）夏（なつ）のカミナリサマーMonster CardLIGHTThunder1600
Retrieved from "https://yugipedia.com/wiki/Special:Ask"