Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:Moon Mage titles]] [[Title:+]]
 |?Title requirement
 |format=table
 |limit=50
 |offset=100
 |link=all
 |sort=
 |order=asc
 |headers=show
 |mainlabel=Title
 |searchlabel=... further results
 |class=sortable wikitable smwtable
}}

Results 101 – 150 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Moon Mage titles]] [[Title:+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0362",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Moon Mage titles]] [[Title:+]]

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 t2
INNER JOIN
`smw_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=497247
   AND (t4.smw_namespace=116)
  )
  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
100

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	417	Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t2.s_id	1	Using where
1	SIMPLE	t4	eq_ref	PRIMARY, smw_id, smw_namespace	PRIMARY	4	drwiki.t2.s_id	1	Using where; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:0

Errors and Warnings

None

Title	Title requirement
Lecanomancer	Must be a member of the Prophets of G'nar Peth Must have performed 100 predictions
Legendary Moon Mage	Must be at least circle 100
Light Weaver	At least 300 in Perception skill At least 400 in Warding skill Must know the Dazzle spell Must know the Burn spell Must know the Cage of Light spell
Lightcrafter	At least 850 in highest magic skill At least 720 in Astrology skill Must know the Dazzle spell Must know the Burn spell Must know the Moonblade spell Must know the Cage of Light spell
Lightwielder	At least 200 in highest Weapon skill At least 200 in Targeted Magic skill Must know the Moonblade spell Must know the Burn spell Must know the Cage of Light spell
Logarithmancer	At least 200 in Scholarship skill At least 100 in Astrology skill Must have performed 100 predictions
Logician	At least 300 in Scholarship skill
Luckbringer	At least 15 in Astrology skill Must have performed 10 predictions
Lucky (Moon Mage)	Must have performed 1 prediction
Luminary	At least 870 in Astrology skill At least 1030 in highest magic skill
Lunar Mage	At least 100 in highest magic skill At least 90 in Astrology skill
Lunar Magician	At least 100 in highest magic skill At least 90 in Astrology skill
Lunarian	At least 640 in highest magic skill At least 540 in Astrology skill
Manipulator	At least 40 in Charisma At least 380 in highest magic skill At least 320 in Astrology skill Must know the Hypnotize spell
Mantic	At least 160 in Astrology skill Must have performed 400 predictions
Master Moon Mage	Must be at least circle 60
Master of Fate	Must be a member of Fortune's Path At least 700 in Augmentation skill At least 700 in Athletics skill
Master of Shadows	Must be a member of the Progeny of Tezirah At least 700 in Stealth skill At least 700 in Arcana skill
Mathematician	At least 40 in Astrology skill At least 80 in Scholarship skill
Medium	At least 15 in Astrology skill At least 20 in highest magic skill
Mentalist	At least 60 in highest magic skill At least 50 in Astrology skill Must know the Calm spell
Mesmerist	At least 80 in highest magic skill At least 70 in Astrology skill Must know the Calm spell
Meteorologist	At least 20 in Astrology skill At least 40 in Scholarship skill
Mindflayer	Must know the Shear spell At least 200 in highest Weapon skill At least 200 in Targeted Magic skill Must know the Mental Blast spell
Mistress of Shadows	Must be a member of the Progeny of Tezirah At least 700 in Stealth skill At least 700 in Arcana skill
Monk (Moon Mage)	Must be a member of the Monks of the Crystal Hand At least 100 in Appraisal skill At least 100 in Attunement skill
Moon Mage	Must be at least circle 30
Moromancer	At least 50 in Charisma At least 300 in Astrology skill At least 500 in Perception skill At least 300 in Appraisal skill
Mystic	At least 100 in Astrology skill Must have performed 200 predictions
Mystic Aegis	Must know the Cage of Light spell At least 100 in highest armor skill
Mystic Artisan	Must know the Imbue spell Must know the Unleash spell
Mystic Blade	Must know the Seer's Sense spell At least 200 in highest Weapon skill At least 200 in highest Armor skill
Nemesis (Moon Mage)	At least 300 in Targeted Magic skill At least 300 in Warding skill At least 200 in Evasion skill At least 200 in highest armor skill At least 200 in highest weapon skill
Nomad	Must be a member of the Nomads of the Arid Steppe
Novus	At least 195 in highest magic skill At least 170 in Astrology skill Must know the Dazzle spell Must know the Burn spell
Numinist	At least 100 in Astrology skill At least 200 in Scholarship skill
Observer	At least 25 in Perception skill Must know the Clear Vision spell
Occultist (Moon Mage)	At least 220 in highest magic skill At least 190 in Astrology skill Must know 1 spells from the Stellar Magic spellbook
Omen	At least 275 in Astrology skill Must have performed 1500 Predictions
Omen Speaker	At least 400 in Astrology skill Must have performed 5000 predictions
Orcris a Ilet Epato Sarbu	At least 1750 in highest Magic skill At least 1470 in Astrology skill
Ossomancer	Must be a member of the Nomads of the Arid Steppe Must have performed 100 predictions
Palm Reader	At least 10 in Astrology skill Must have performed 5 predictions
Pattern Seeker	Must be a member of Fortune's Path At least 400 in Augmentation skill At least 400 in Athletics skill
Philosopher (Moon Mage)	At least 75 in Astrology skill At least 150 in Scholarship skill
Photomancer	Must be a member of the Monks of the Crystal Hand Must have performed 1000 predictions
Planeswalker	At least 1500 in Attunement skill At least 1000 in Astrology skill Must know how to use The Ways
Politician	Must be a member of the Celestial Compact At least 100 in Astrology skill At least 100 in Scholarship skill
Portent	At least 450 in Astrology skill Must have performed 6500 predictions
Portent Seeker	At least 375 in Astrology skill Must have performed 4000 predictions

Semantic search

Query log

Navigation menu

Search