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, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id='1168')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  30
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1refs_id,o_id,s_id_2,o_id_2o_id_25const110Using index; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4specnext_wiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
 NumberReadableWritableDescription
Expansion Bus Control Register$81truetrueExpansion bus controls
Expansion Bus Decoding b0-7 Register$86truetrueWhen expansion bus is enabled: Internal ports decoding mask
Expansion Bus Decoding b16-23 Register$88truetrueWhen expansion bus is enabled: Internal ports decoding mask
Expansion Bus Decoding b24-31 Register$89truetrueWhen expansion bus is enabled: Internal ports decoding mask
Expansion Bus Decoding b8-15 Register$87truetrueWhen expansion bus is enabled: Internal ports decoding mask
Expansion Bus Enable Register$80truetrueExpansion bus enable/config
Expansion Bus I/O Propagate Register$8AtruetrueMonitoring internal I/O or adding external keyboard
Extended Keys 0 Register$B0truefalseRead Next keyboard compound keys separately
Extended Keys 1 Register$B1truefalseRead Next keyboard compound keys separately
Global Transparency Register$14truetrueSets the "transparent" colour for Layer 2, ULA and LoRes pixel data.
Internal Port Decoding b0-7 Register$82truetrueEnabling internal ports decoding
Internal Port Decoding b16-23 Register$84truetrueEnabling internal ports decoding
Internal Port Decoding b24-31 Register$85truetrueEnabling internal ports decoding
Internal Port Decoding b8-15 Register$83truetrueEnabling internal ports decoding
Keymap High Address Register$28truetruePS/2 Keymap address MSB, read (pending) first byte of palette colour
Keymap High Data Register$2AfalsetrueHigh data to PS/2 Keymap (MSB of data in bit 0)
Keymap Low Address Register$29falsetruePS/2 Keymap address LSB.
Keymap Low Data Register$2BfalsetrueLow eight LSBs of PS/2 Keymap data.
Layer 2 Control Register$70truetrueLayer 2 resolution, palette offset
Layer 2 RAM Page Register$12truetrueSets the bank number where Layer 2 video memory begins.
Layer 2 RAM Shadow Page Register$13truetrueSets the bank number where the Layer 2 shadow screen begins.
Layer 2 X Offset MSB Register$71truetrueSets the pixel offset used for drawing Layer 2 graphics on the screen.
Layer 2 X Offset Register$16truetrueSets the pixel offset used for drawing Layer 2 graphics on the screen.
Layer 2 Y Offset Register$17truetrueSets the Y offset used when drawing Layer 2 graphics on the screen.
LoRes Control Register$6AtruetrueLoRes Radastan mode
LoRes X Offset Register$32truetruePixel X offset (0..255) to use when drawing LoRes Layer.
LoRes Y Offset Register$33truetruePixel Y offset (0..191) to use when drawing LoRes Layer.
Machine ID Register$00truefalseIdentifies TBBlue board type. Should always be 10 on Next.
Machine Type Register$03truetrueIdentifies timing and machine type.
Memory Mapping Register$8EtruetrueControl classic Spectrum memory mapping
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).
Next Reset Register$02truetrueIdentifies type of last reset. Can be written to force reset.
Palette Index Register$40truetrueChooses an palette element (index) to manipulate with
Palette Value Register$41truetrueUse to set/read 8-bit colours of the ULANext palette.
Peripheral 1 Register$05truetrueSets joystick mode, video frequency and Scandoubler.
Peripheral 2 Register$06truetrueEnables CPU Speed key, DivMMC, Multiface, Mouse and AY audio.
Peripheral 3 Register$08truetrueABC/ACB Stereo, Internal Speaker, SpecDrum, Timex Video Modes, Turbo Sound Next, RAM contention and [un]lock 128k paging.
Peripheral 4 Register$09truetrueSets scanlines, AY mono output, Sprite-id lockstep, reset DivMMC mapram and disable HDMI audio.
Peripheral 5 Register$0AtruetrueMouse buttons and DPI config
Pi GPIO Output Enable Register$90-$93truetrueEnables GPIO pins output
Pi GPIO Register$98-$9BtruetrueGPIO pins mapped to Next Register
Pi I2S Audio Control Register$A2truetruePi I2S controls
Pi I2S Clock Divide Register$A3truetruePi I2S clock divide in master mode.