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::Anime]] [[Concept:Non-monster cards]] [[Support::Link Monster]]
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,
  t0.smw_title,
  t0.smw_subobject
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_di_blob` AS t2
INNER JOIN
  (`smw_di_wikipage` AS t5
INNER JOIN
  `t7` AS t7 ON t5.o_id=t7.id) ON t2.s_id=t5.s_id
INNER JOIN
  `smw_di_wikipage` AS t18 ON t2.s_id=t18.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   (t2.o_hash='Anime') AND t2.p_id='599'
   AND (t5.p_id='596')
   AND (t18.p_id='552' AND t18.o_id='94901')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC,
  t0.smw_title ASC,
  t0.smw_subobject ASC
LIMIT
  25
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt7ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t7.id,const11
1SIMPLEt2refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t5.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t5.s_id1Using where
1SIMPLEt18refs_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
  • Temporary table t7
      INSERT IGNORE INTO `t7` (id) VALUES ('1329')
      INSERT IGNORE INTO `t7` (id) VALUES ('1787')
      INSERT IGNORE INTO `t7` (id) VALUES ('87260')
      INSERT IGNORE INTO `t7` (id) VALUES ('70265')
      INSERT IGNORE INTO `t7` (id) VALUES ('2881')
      INSERT IGNORE INTO `t7` (id) VALUES ('77217')
      INSERT IGNORE INTO `t7` (id) VALUES ('769993')
      INSERT IGNORE INTO `t7` (id) VALUES ('72320')
      INSERT IGNORE INTO `t7` (id) VALUES ('0')
      INSERT IGNORE INTO `t7` (id) VALUES ('38099')
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
English name (linked)Japanese name[[Card type]][[Property]]
Limit Codeリミット・コードTrap CardContinuous Trap Card
Link Atrocityリンク・アトロシティSpell CardNormal Spell Card
Link Backリンク・バックSpell CardNormal Spell Card
Link Burstリンク・バーストSpell CardNormal Spell Card
Link CancelリンクキャンセルTrap CardNormal Trap Card
Link Coinリンク・コインSpell Card???
Link Driveリンク・ドライブSpell CardContinuous Spell Card
Link Fire's Returnリターン・オブ・リンクファイアSpell CardNormal Spell Card
Link Pressureリンク・プレッシャーSpell CardQuick-Play Spell Card
Link Processing Failureリンク・プロセッシング・フェイルアーSpell CardContinuous Spell Card
Link Protectionリンク・プロテクションSpell CardContinuous Spell Card
Link Rationリンク・レーションTrap CardNormal Trap Card
Link Recoveryリンク・リカバリーSpell CardNormal Spell Card
Link Restartリンク・リスタートTrap CardCounter Trap Card
Link Rushリンク・ラッシュTrap CardNormal Trap Card
Link Satelliteリンク・サテライトSpell CardContinuous Spell Card
Link Surge Counterリンク・サージ・カウンターTrap CardNormal Trap Card
Link Turretリンク・デス・ターレットTrap CardContinuous Trap Card
Linkage Holeリンケージ・ホールSpell CardNormal Spell Card
Love Gravity零重力ラブ・グラヴィティTrap CardNormal Trap Card