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:CG cards]] [[Password::+]]
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 t8
INNER JOIN
  (`smw_di_blob` AS t4
INNER JOIN
  `smw_di_blob` AS t6 ON t4.s_id=t6.s_id) ON t8.s_id=t4.s_id) ON t0.smw_id=t8.s_id
WHERE
  (t8.p_id='520'
   AND (
   ((t4.o_hash='OCG') OR (t4.o_hash='TCG')
  ) AND t4.p_id='599'
   AND (
   (t6.o_hash='Card page') AND t6.p_id='880')
  ))
  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_hash,s_id_2,p_idp_id4const55592Using index condition; Using temporary; Using filesort
1SIMPLEt8refs_id,s_id_2,p_ids_id8ygowiki.t4.s_id,const1Using index
1SIMPLEt6refs_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
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]Password
"A" Cell Breeding Device「Ａ（エー）」細（さい）胞（ぼう）増（ぞう）殖（しょく）装（そう）置（ち）Spell CardContinuous Spell Card34541863
"A" Cell Incubator「Ａ（エー）」細（さい）胞（ぼう）培（ばい）養（よう）装（そう）置（ち）Spell CardContinuous Spell Card64163367
"A" Cell Recombination Device「Ａ（エー）」細（さい）胞（ぼう）組（く）み換（か）え装（そう）置（ち）Spell CardQuick-Play Spell Card91231901
"A" Cell Scatter Burst「Ａ（エー）」細（さい）胞（ぼう）散（さん）布（ぷ）爆（ばく）弾（だん）Spell CardQuick-Play Spell Card73262676
"Infernoble Arms - Almace"『焔（えん）聖（せい）剣（けん）－アルマス』Spell CardEquip Spell Card98319530
"Infernoble Arms - Durendal"『焔（えん）聖（せい）剣（けん）－デュランダル』Spell CardEquip Spell Card37478723
"Infernoble Arms - Hauteclere"『焔（えん）聖（せい）剣（けん）－オートクレール』Spell CardEquip Spell Card64867422
"Infernoble Arms - Joyeuse"『焔（えん）聖（せい）剣（けん）－ジョワユーズ』Spell CardEquip Spell Card90861137
The 13th Grave１３人（にん）目（め）の埋（まい）葬（そう）者（しゃ）Monster Card00032864
1st Movement Solo独（どく）奏（そう）の第（だい）１楽（がく）章（しょう）Spell CardNormal Spell Card44256816
3-Hump LacoodaみつこぶラクーダMonster Card86988864
30,000-Year White Turtle３万（まん）年（ねん）の白（しろ）亀（カメ）Monster Card11714098
4-Starred Ladybug of Doom死（し）の４つ星（ほし）てんとう虫（ムシ）Monster Card83994646
7７（セブン）Spell CardContinuous Spell Card67048711
7 Colored Fishレインボー・フィッシュMonster Card23771716
7 Completed７（セブン）カードSpell CardEquip Spell Card86198326
8-Claws Scorpion八（や）つ手（で）サソリMonster Card14261867
A-Assault CoreＡ（エー）－アサルト・コアMonster Card30012506
A-Team: Trap Disposal Unitトラップ処（しょ）理（り）班（はん） ＡチームMonster Card13026402
A-to-Z Energy LoadＡｔｏＺ（エートゥズィ）エナジーロードTrap CardNormal Trap Card75926389
A-to-Z-Dragon Buster CannonＡｔｏＺ（エートゥズィ）－ドラゴン・バスターキャノンMonster Card65172015
The A. Forces連（れん）合（ごう）軍（ぐん）Spell CardContinuous Spell Card00403847
A.I. Challenge You果（は）たし－Ａｉ（アイ）－Trap CardContinuous Trap Card28645123
A.I. ContactＡｉ（アイ）－コンタクトSpell CardNormal Spell Card10493654
A.I. Love FusionＡｉ（アイ）ラブ融（ゆう）合（ごう）Spell CardNormal Spell Card59332125
A.I. Meet Youめぐり－Ａｉ（アイ）－Spell CardNormal Spell Card06552971
A.I. ShadowＡｉ（アイ）シャドーTrap CardContinuous Trap Card77421977
A.I.'s RitualＡｉ（アイ）の儀（ぎ）式（しき）Spell CardRitual Spell Card85327820
A.I.'s ShowＡｉ（アイ）－ＳＨＯＷ（ショウ）Trap CardNormal Trap Card54374642
A.I.dle RebornＡｉ（アイ）ドリング・ボーンSpell CardQuick-Play Spell Card22933016
A.I.QＡｉ（アイ）－Ｑ（キュー）Trap CardContinuous Trap Card69381150
A/D ChangerＡ（エー）Ｄ（ディー）チェンジャーMonster Card96146814
Abaki暴（あば）鬼（き）Monster Card12694768
Abare Ushioni暴（あば）れ牛（うし）鬼（おに）Monster Card89718302
ABC-Dragon BusterＡ（エー）Ｂ（ビー）Ｃ（シー）－ドラゴン・バスターMonster Card01561110
Abominable Chamber of the Unchained破（は）械（かい）雙（そう）極（きょく）Trap CardNormal Trap Card80801743
Abominable Unchained Soul雙（そう）極（きょく）の破（は）械（かい）神（しん）Monster Card01966438
Abomination's Prison雙（そう）王（おう）の械（かせ）Spell CardNormal Spell Card27412542
Absolute Crusaderレアル・クルセイダーMonster Card70832512
Absolute End絶（ぜっ）体（たい）絶（ぜつ）命（めい）Trap CardNormal Trap Card27744077
Absolute King - Megaplunder絶（ぜっ）対（たい）なる王（おう）者（じゃ）－メガプランダーMonster Card27553701
Absolute King Back Jack絶（ぜっ）対（たい）王（おう） バック・ジャックMonster Card60990740
Absolute Powerforceアブソリュート・パワーフォースSpell CardQuick-Play Spell Card51779204
Absorb Fusion吸光融合（アブソープ・フュージョン）Spell CardNormal Spell Card71422989
Absorbing JarアブソーブポッドMonster Card03900605
Absorbing Kid from the Sky吸（きゅう）収（しゅう）天（てん）児（じ）Monster Card49771608
Absorouter Dragonアブソルーター・ドラゴンMonster Card67748760
Abyss Actor - Comic Relief魔（ま）界（かい）劇（げき）団（だん）－コミック・リリーフMonster Card15308295
Abyss Actor - Curtain Raiser魔（ま）界（かい）劇（げき）団（だん）カーテン・ライザーMonster Card44179224
Abyss Actor - Evil Heel魔（ま）界（かい）劇（げき）団（だん）－デビル・ヒールMonster Card52240819
Retrieved from "https://yugipedia.com/wiki/Special:Ask"