Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[TXMN Completed Exists::false]]
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_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_value=0) AND t1.p_id=18585)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
305
OFFSET
300
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_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_value=0) AND t1.p_id=18585)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
305
OFFSET
300
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | s_id, o_value | 339 | Using where; Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tuxepedia.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneDefault64px | TXMN Type | TXMN Completed | FrontSprite | BackSprite | FaceSprite1 | FaceSprite2 | TXMN Blurb | MainCall | |
---|---|---|---|---|---|---|---|---|---|
Suse | Wood | Missing | Missing | ||||||
Swanfoil | Metal | Missing | Missing | ||||||
Terrex | Earth | Missing | Missing | ||||||
Thumpurn | Fire | Missing | |||||||
Tigrow | Earth Wood | Missing | Missing | ||||||
Titannon | Fire | Missing | Missing | ||||||
Topaspin | Missing | Missing | |||||||
Tophistone | Fire | Missing | Missing | ||||||
Tornicane | Water | Missing | Missing | Missing. | Missing | ||||
Toucanary | Wood | It only has bright feathers because it grew up surrounded by flowers. | Missing | ||||||
Toxiris | Wood | Toxiris is extremely powerful, it violently poisons everything in his way. | Missing | ||||||
Trasto | Missing | Missing | |||||||
Treasurblin | Metal | Missing | Missing | They are very greedy tuxemon, and will often attack those seeking to steal their supply of treasure. Their golden fan is covered in the dust from their gold and shiny treasure. | Missing | ||||
Trojerror | Metal | Missing | TROJERROR is a tuxemon that disguises itself as legitimate code or software. Once inside the network, TROJERRORS are able to carry out any action that a legitimate user could perform (deposit, withdrawn and delete). | Missing | |||||
Tropitouill | Wood | Missing | Missing | ||||||
Tulux | Water | Missing | Missing | Missing | |||||
Tungrub | Metal | Missing | Tungrub have small magnetic ports in their bodies which pull them close to their parent Worbolt to keep them safe. | Missing | |||||
Tuxalo | Water | Missing | Missing | Missing | |||||
Uprout | Wood | When it has grown, its ears peel away to show wings that it uses to fly into the trees above where it grew. | Missing | ||||||
Vadampf | Water | Missing | Missing | Before every session, saunas are to be searched for any Vadampf, this is a legal requirement. | Missing | ||||
Verglasta | Water | Missing | Missing | ||||||
Virware | Metal | VIRWARE is usually dormant until the victim activates it, either through downloading a corrupt app or clicking an infected link. Once activated, VIRWARE may complete any number of tasks. | Missing | ||||||
Voldragon | Fire | Missing | Missing | ||||||
Vulpyre | Fire | Missing | Missing | Missing. | Missing | ||||
Vyking | Metal Water | Missing | Missing | ||||||
Wapuru | Water | Missing | Missing | It has a whirlpool for a tail, which it uses to pedal itself around the ocean. Sometimes the pressure is too strong and it gets stuck, creating a whirlpool. | Missing | ||||
Weastoat | Missing | Missing | |||||||
Weedlantis | Water Wood | It is said an ancient civilization once used WEEDLANTIS as advisors, but it has since disappeared beneath the sea. | Missing | ||||||
Wendigger | Wood | Missing. | Missing | ||||||
Wisturtle | Water | Missing | Missing | Their magic located in their huge shells helps regulate the temperature of the water surronding it. They will often shelter fish tuxemon with their huge fins and underbelly. | Missing | ||||
Witty | Missing | ||||||||
Wizane | Missing | ||||||||
Wizereign | Missing | Missing | Missing | ||||||
Wolololl | Wood | Missing | Missing | ||||||
Worbolt | Metal | Missing | It eats metal fibers to produce its young artificially inside its body. Its bolt-like head can turn a full 360 degrees. | Missing | |||||
Wuppy | Missing | Missing | Missing | ||||||
Xylocarp | Water | Everyone believes it is man-made, but no one admits that they made it. | Missing | ||||||
Yabba | Earth | Missing | It roamed the lands millions of years ago. It's believed they died out due to their poor diet of pebbles. | Missing | |||||
Yamada | Metal | Missing | Missing | Missing |