Semantic search

Help

This page or action requires JavaScript to work, please enable JavaScript in your browser or use a browser where this is supported so that functionality can be served and is 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:RLSH Directory]] [[Status::Active]]
 |?Image
 |?Location
 |?Status
 |?Geographic coordinates
 |format=table
 |limit=50
 |offset=5
 |sort=
 |order=asc
 |mainlabel=
}}

Results 6 – 55 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:RLSH Directory]] [[Status::Active]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0552",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:RLSH Directory]] [[Status::Active]]

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
`mwg1_smw_object_ids` AS t0
INNER JOIN
(`mwg1_smw_fpt_inst` AS t2
INNER JOIN
`mwg1_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`mwg1_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   ((t4.o_hash='Active') AND t4.p_id=1200)
  )
  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
5

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	ref	s_id, o_hash, s_id_2, p_id	o_hash	258	const	122	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	admin_wiki.t4.s_id	1	Using where
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	4	admin_wiki.t4.s_id	3	Using where; Using index; Distinct
1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	admin_wiki.t2.o_id	1	Distinct

Auxilliary Tables

Temporary table t3
Recursively computed hierarchy for element(s) (518).
SELECT s_id FROM `mwg1_smw_fpt_subc` WHERE o_id=518 LIMIT 1

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Location	Status	Geographic coordinatesThis property is a special property in this wiki.
Army Brat	Dallas, Texas	Active	32° 46' 34.58" N, 96° 47' 48.68" W
Batman of San Jose	San Jose, California	Active	37° 20' 10.20" N, 121° 53' 26.13" W
The Beacon	Champaign, Illinois	Active	40° 6' 59.34" N, 88° 14' 35.13" W
Berylvale	Brooklyn, New York, USA	Active	40° 39' 9.36" N, 73° 56' 59.00" W
Bone Fist	Peterborough, Ontario, Canada	Active	44° 18' 17.28" N, 78° 19' 11.82" W
Bones	Brooklyn, New York, USA	Active	40° 39' 9.36" N, 73° 56' 59.00" W
Brennan	Ontario, Canada	Active	50° 0' 2.44" N, 86° 0' 3.52" W
Brick	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Canadian Justice	Windsor, Ontario, Canada	Active	42° 19' 0.26" N, 83° 2' 14.42" W
Captain Australia	Brisbane, Australia	Active	27° 28' 8.28" S, 153° 1' 24.60" E
Captain Black	New Orleans, Louisiana, USA	Active	29° 58' 33.59" N, 90° 4' 41.57" W
Catman	McMinnville, Tennessee, USA	Active	35° 41' 0.25" N, 85° 46' 11.94" W
Citizen Tiger	Huntington, Indiana, USA	Active	40° 48' 2.98" N, 85° 30' 6.66" W
Clean Panther	Nagoya, Japan	Active	35° 11' 6.38" N, 136° 53' 59.44" E
Crimson Fist	Oakland, California, USA	Active	37° 48' 16.04" N, 122° 16' 16.88" W
D3V1L	Brooklyn, New York, USA	Active	40° 39' 9.36" N, 73° 56' 59.00" W
DangerMan (Roger Tinsley)	Los Angeles, California, USA	Active	34° 3' 13.29" N, 118° 14' 33.96" W
DangerWoman	Stone Mountain, Georgia, USA	Active	33° 48' 22.38" N, 84° 8' 44.70" W
Dark Defender	Knoxville, Tennessee, USA	Active	35° 57' 37.42" N, 83° 55' 15.69" W
Dark Jacker	Tokyo, Japan	Active	35° 40' 52.56" N, 139° 45' 27.55" E
Discordia	Chattanooga, Tennessee, USA	Active	35° 2' 44.60" N, 85° 18' 34.16" W
Dusk Citizen	Staten Island, New York, USA	Active	40° 35' 0.44" N, 74° 8' 58.58" W
E0N	Biloxi, Mississippi, USA	Active	30° 24' 2.75" N, 88° 53' 21.78" W
Earths Guardian	Dallas, Texas	Active	32° 46' 34.58" N, 96° 47' 48.68" W
Edgerunner	San Diego, California	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Fallenboy	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Flame	Oita, Japan	Active	33° 10' 55.16" N, 131° 25' 37.28" E
Geist	Rochester, Minnesota, USA	Active
Good Samaritan	Saint Petersburg, Florida, USA	Active	27° 46' 12.17" N, 82° 38' 9.27" W
Green Peace	Osaka, Japan	Active	34° 37' 11.57" N, 135° 29' 25.29" E
Green Swordsman	Portland, Oregon, USA	Active	45° 31' 12.89" N, 122° 40' 27.10" W
Grey Shadow	East Lothian And Edinburgh, Scotland	Active	55° 58' 9.81" N, 2° 57' 46.41" W
Halo	Orlando, Florida	Active	28° 32' 31.60" N, 81° 22' 44.51" W
Happy Man	Osaka, Japan	Active	34° 39' 41.86" N, 135° 29' 59.74" E
Haunter	Wichita, Kansas, USA	Active	37° 41' 32.05" N, 97° 20' 15.16" W
Hawt Flash	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Hombre Obscuro	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Impact	Saint Petersburg, Florida, USA	Active	27° 46' 13.37" N, 82° 40' 10.23" W
Jaguar	Clearwater, Florida, USA	Active	27° 57' 57.07" N, 82° 48' 0.37" W
Joshua Bartley	North Carolina, USA	Active	35° 40' 22.67" N, 79° 2' 21.45" W
Justice Johnson	Dallas, Texas	Active	32° 46' 34.58" N, 96° 47' 48.68" W
Justin Service	Seattle, Washington, USA	Active	47° 36' 13.80" N, 122° 19' 48.22" W
Kevlar Cat	Santa Barbara, California	Active	34° 25' 19.68" N, 119° 42' 9.60" W
King Owl	Brooklyn, New York, USA	Active	40° 39' 9.36" N, 73° 56' 59.00" W
The Knight	Savannah, Georgia, USA	Active	32° 3' 23.25" N, 81° 5' 42.46" W
KnightVigil	Tampa Bay, Florida, USA	Active	27° 41' 19.11" N, 82° 34' 20.35" W
Knightfox	St. Louis, Missouri, USA	Active	38° 37' 40.90" N, 90° 11' 27.65" W
Lightfist	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W
Lord Chain	Palm Coast, Florida, USA	Active	29° 33' 14.91" N, 81° 13' 14.76" W
Mdm Moxie	San Diego, California, USA	Active	32° 43' 2.71" N, 117° 9' 45.98" W