Template:Card query

From Yugipedia
Jump to: navigation, search
SQLStore debug output
ASK Query
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
WHERE
  t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-redi'
  AND t0.smw_iw!=':smw-border'
  AND t0.smw_iw!=':smw-intprop'
ORDER BY
  t0.smw_sort ASC,
  t0.smw_title ASC,
  t0.smw_subobject ASC
LIMIT
  55
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt0ALLsmw_iw,smw_iw_23510628Using where; Using filesort
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:0
Query-Depth:0
Errors and Warnings
The query description has an empty condition.

The query description has an empty condition.

  • #ask query:
  • $cq_query:
  • $cq_query_lc:
  • $cq_medium:
  • $cq_medium_query:
  • $cq_query_medium:
  • $cq_card_type:
  • $cq_card_type_query:
  • $cq_col_card_type: ?Card type =
  • $cq_col_primary_type:
  • $cq_col_secondary_type:
  • $cq_col_attribute:
  • $cq_col_type:
  • $cq_col_stars:
  • $cq_col_scale:
  • $cq_col_link_rating:
  • $cq_col_atk:
  • $cq_col_def:
  • $cq_col_card_type_st: ?Card type = [[Card type]]
  • $cq_col_property: ?Property = [[Property]]
  • {{{extra_column}}}:
  • {{{extra_label}}}:
  • {{{extra_column2}}}:
  • {{{extra_label2}}}:
  • $cq_col_extra:
  • $cq_col_extra_2:
  • limit: 50
  • $cq_sort: #
  • $cq_order:
  • $cq_default:
  • $cq_count: 0
Template documentation[create]