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
[[Category:Next Configuration Registers]]
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, t4.o_hash
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
  `smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
  (t1.o_id='1168')
   AND (t4.p_id='1164')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t4.o_hash ASC
LIMIT
  25
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,s_id_2,p_idp_id4const110Using temporary
1SIMPLEt1refs_id,o_id,s_id_2,o_id_2s_id_29specnext_wiki.t4.s_id,const1Using index
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4specnext_wiki.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
 NumberReadableWritableDescription
Palette Value Register$41truetrueUse to set/read 8-bit colours of the ULANext palette.
Enhanced ULA Ink Color Mask$42truetrueSpecifies mask to extract ink colour from attribute cell value in ULANext mode.
Enhanced ULA Control Register$43truetrueEnables or disables Enhanced ULA interpretation of attribute values and toggles active palette.
Enhanced ULA Palette Extension$44truetrueUse to set 9-bit (2-byte) colours of the Enhanced ULA palette, or to read second byte of colour.
Transparency colour fallback Register$4Atruetrue8-bit colour to be used when all layers contain transparent pixel.
Sprites Transparency Index Register$4BtruetrueIndex into sprite palette (of "transparent" colour).
Tilemap Transparency Index Register$4CtruetrueIndex into Tilemap palette (of "transparent" colour).
Memory management slot 0 bank$50truetrueSelects the 8k-bank stored in 8k-slot 0 (see Memory map).
Memory management slot 1 bank$51truetrueSelects the 8k-bank stored in 8k-slot 1 (see Memory map).
Memory management slot 2 bank$52truetrueSelects the 8k-bank stored in 8k-slot 2 (see Memory map).
Memory management slot 3 bank$53truetrueSelects the 8k-bank stored in 8k-slot 3 (see Memory map).
Memory management slot 4 bank$54truetrueSelects the 8k-bank stored in 8k-slot 4 (see Memory map).
Memory management slot 5 bank$55truetrueSelects the 8k-bank stored in 8k-slot 5 (see Memory map).
Memory management slot 6 bank$56truetrueSelects the 8k-bank stored in 8k-slot 6 (see Memory map).
Memory management slot 7 bank$57truetrueSelects the 8k-bank stored in 8k-slot 7 (see Memory map).
Copper Data$60falsetrueUsed to upload code to the Copper.
Copper Control Low Byte$61truetrueHolds low byte of Copper control bits.
Copper Control High Byte$62truetrueHolds high byte of Copper control flags.
Copper Data 16-bit Write Register$63falsetrueUsed to upload code to the Copper.
Vertical Video Line Offset Register$64truetrueOffset numbering of raster lines in copper/interrupt/active register