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
[[Release::Yu-Gi-Oh! Duel Links]] [[Card type::Monster Card]] [[Summoning::Can be Synchro Summoned]]
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 t2
INNER JOIN
  `smw_di_wikipage` AS t5 ON t2.s_id=t5.s_id
INNER JOIN
  `smw_di_wikipage` AS t8 ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.p_id='1149' AND t2.o_id='46579'
   AND (t5.p_id='596' AND t5.o_id='1389')
   AND (t8.p_id='555' AND t8.o_id='82901')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  25
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt8refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const892Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t8.s_id1Using where
1SIMPLEt2refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t8.s_id,const,const1Using index; Distinct
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t8.s_id,const,const1Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:6
Query-Depth:1
Errors and Warnings
None
NameJapanese namePrimary typeSecondary type[[Attribute]][[Type]][[Level]][[ATK]][[DEF]]
Accel Synchronアクセル・シンクロンSynchro MonsterTuner monsterDARKMachine55002100
Ally of Justice CatastorA・O・Jアーリー・オブ・ジャスティス カタストルSynchro MonsterDARKMachine522001200
Ally of Justice Decisive ArmorA・O・Jアーリー・オブ・ジャスティス ディサイシブ・アームズSynchro MonsterDARKMachine1033003300
Ally of Justice Field MarshalA・O・Jアーリー・オブ・ジャスティス フィールド・マーシャルSynchro MonsterDARKMachine929002600
Ally of Justice Light GazerA・O・Jアーリー・オブ・ジャスティス ライト・ゲイザーSynchro MonsterDARKMachine824001600
Altergeist Dragvirionオルターガイスト・ドラッグウィリオンSynchro MonsterDARKSpellcaster622001200
Ancient Fairy Dragonエンシェント・フェアリー・ドラゴンSynchro MonsterLIGHTDragon721003000
Ancient Flamvell Deityエンシェント・ゴッド・フレムベルSynchro MonsterFIREPyro72500200
Ancient Pixie Dragonようせいりゅう エンシェントSynchro MonsterDARKDragon721003000
Ancient Sacred Wyvernエンシェント・ホーリー・ワイバーンSynchro MonsterLIGHTFairy721002000
Angel of Zeraゼラのてん使Synchro MonsterLIGHTFairy828002300
Arcanite Magicianアーカナイト・マジシャンSynchro MonsterLIGHTSpellcaster74001800
Archfiend Zombie-Skullアンデット・スカル・デーモンSynchro MonsterDARKZombie625001200
Archfiend's CallデーモンのしょうらいSynchro MonsterDARKFiend625001200
Armades, Keeper of BoundariesげんそうしゅしゃアルマデスSynchro MonsterLIGHTFiend523001500
Armory Armアームズ・エイドSynchro MonsterLIGHTMachine418001200
Aromaseraphy Rosemaryアロマセラフィ-ローズマリーSynchro MonsterLIGHTPlant52000900
Ascension Sky DragonてんきゅうりゅうドラゴアセンションSynchro MonsterLIGHTDragon10?3000
Assault Blackwing - Chidori the Rain Sprinklingアサルト BFブラックフェザーなみだあめのチドリSynchro MonsterDARKWinged Beast726002000
Assault Blackwing - Onimaru the Divine Thunderアサルト BFブラックフェザー神立がんだちのオニマルSynchro MonsterDARKWinged Beast1230002000