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::Trap Card]]
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) 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='1787')
  )
  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
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const16134Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t5.s_id1Using where
1SIMPLEt2refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t5.s_id,const,const1Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Property]]
Absolute End絶（ぜっ）体（たい）絶（ぜつ）命（めい）Normal Trap Card
Abyss-scornアビスコーンNormal Trap Card
Abyss-sphereアビスフィアーContinuous Trap Card
Abyss-squallアビスコールNormal Trap Card
Accumulated Fortune積（つ）み上（あ）げる幸（こう）福（ふく）Normal Trap Card
Acid Trap Hole硫（りゅう）酸（さん）のたまった落（お）とし穴（あな）Normal Trap Card
Adhesion Trap Hole粘（ねん）着（ちゃく）落（お）とし穴（あな）Normal Trap Card
Aegis of Gaia女（め）神（がみ）の加（か）護（ご）Continuous Trap Card
Aegis of the Ocean Dragon Lord海（かい）竜（りゅう）神（しん）の加（か）護（ご）Normal Trap Card
Aerial Recharge空中補給（エアリアル・チャージ）Continuous Trap Card
Alchemy Cycleアルケミー・サイクルNormal Trap Card
All-Out Attacks召（しょう）喚（かん）制（せい）限（げん）－猛（もう）突（とつ）するモンスターContinuous Trap Card
Altar for Tribute生（いけ）贄（にえ）の祭（さい）壇（だん）Normal Trap Card
Altar of the Bound Deity縛（しば）られし神（かみ）への祭（さい）壇（だん）Continuous Trap Card
Altergeist Camouflageオルターガイスト・カモフラージュNormal Trap Card
Altergeist Emulatelfオルターガイスト・エミュレルフContinuous Trap Card
Amazoness Archersアマゾネスの弩（ど）弓（きゅう）隊（たい）Normal Trap Card
Amazoness Onslaughtアマゾネスの急（きゅう）襲（しゅう）Continuous Trap Card
Amazoness Shamanismアマゾネス転（てん）生（せい）術（じゅつ）Normal Trap Card
Amazoness Willpowerアマゾネスの意（い）地（じ）Continuous Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"