Semantic search

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: [[Resource 1::+]] [[!Category:Building]] [[!Category:Furniture]] [[!Category:Miscellaneous]] [[!Category:Security]] [[!Category:Production]] [[!Category:Floor]]
 |?Production Facility 1
 |?Type
 |?Type2
 |format=table
 |limit=250
 |offset=5
 |sort= Production Facility 1
 |order=asc
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Resource 1::+]] [[!Category:Building]] [[!Category:Furniture]] [[!Category:Miscellaneous]] [[!Category:Security]] [[!Category:Production]] [[!Category:Floor]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1195",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Resource 1::+]] [[!Category:Building]] [[!Category:Furniture]] [[!Category:Miscellaneous]] [[!Category:Security]] [[!Category:Production]] [[!Category:Floor]]

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, idst12.smw_sort
FROM
`mr_smw_object_ids` AS t0
INNER JOIN
(`mr_smw_di_wikipage` AS t2
INNER JOIN
`mr_smw_object_ids` AS t5 ON t2.s_id=t5.smw_id
INNER JOIN
`mr_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id
INNER JOIN
`mr_smw_object_ids` AS t7 ON t2.s_id=t7.smw_id
INNER JOIN
`mr_smw_object_ids` AS t8 ON t2.s_id=t8.smw_id
INNER JOIN
`mr_smw_object_ids` AS t9 ON t2.s_id=t9.smw_id
INNER JOIN
`mr_smw_object_ids` AS t10 ON t2.s_id=t10.smw_id) ON t0.smw_id=t2.s_id
LEFT OUTER JOIN
(`mr_smw_di_wikipage` AS t12
INNER JOIN
`mr_smw_object_ids` AS idst12 ON idst12.smw_id=t12.o_id) ON t0.smw_id=t12.s_id
   AND (t12.p_id=197510)
WHERE
(t2.p_id=191170
   AND (t5.smw_sortkey!='Building')
   AND (t6.smw_sortkey!='Furniture')
   AND (t7.smw_sortkey!='Miscellaneous')
   AND (t8.smw_sortkey!='Security')
   AND (t9.smw_sortkey!='Production')
   AND (t10.smw_sortkey!='Floor')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
idst12.smw_sort ASC
LIMIT
255
OFFSET
5

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t2	ref	s_id, p_id, s_id_2, s_id_3	p_id	4	const	497	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	t5	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	79.94	Using where
1	SIMPLE	t8	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	82.59	Using where
1	SIMPLE	t9	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	95.36	Using where
1	SIMPLE	t7	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	99.37	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	50.01	Using where
1	SIMPLE	t6	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	100.00	Using where
1	SIMPLE	t10	eq_ref	PRIMARY, smw_id, smw_sortkey	PRIMARY	4	rimworld_wiki_new.t2.s_id	1	100.00	Using where
1	SIMPLE	t12	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	s_id_3	8	rimworld_wiki_new.t2.s_id, const	1	100.00	Using index
1	SIMPLE	idst12	eq_ref	PRIMARY, smw_id	PRIMARY	4	rimworld_wiki_new.t12.o_id	1	100.00

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:7
Query-Depth:1

Errors and Warnings

None

	Production Facility 1	Type	Type2
Crib		Building	Furniture
Mini-turret		Building	Security
Large stele		Building	Misc
Standing lamp		Building	Furniture
Long-range mineral scanner		Building	Misc
Power conduit		Building	Power
Wooden hand		Medical Items	Body Parts
Door		Building	Structure
Totemic slab (medium)		Building	Floor
Hex carpet		Floor
Subcore encoder		Building	Biotech (Buildings)
Uranium slug turret		Building	Security
Biosculpter pod		Building	Ideology (Buildings)
Brewery		Building	Production
Mech booster		Building	Biotech (Buildings)
Small nature shrine		Building	Misc
Autodoor		Building	Structure
Dresser		Building	Furniture
Steel tile		Floor
Ship structural beam		Building	Ship
Rustic rug (broad)		Building	Floor
Silver tile		Floor
Bioferrite shaper		Building	Anomaly (Buildings)
Mortar		Building	Security
Morbid stone tile		Floor
Firefoam popper		Building	Misc
Growth vat		Building	Biotech (Buildings)
Loudspeaker		Building	Ideology (Buildings)
Drug lab		Building	Production
Deathrest accelerator		Building	Biotech (Buildings)
Sacrificial flag		Building	Ideology (Buildings)
Billiards table		Building	Recreation
Rocketswarm launcher		Building	Security
Passive cooler		Building	Temperature
Mechband dish		Building	Biotech (Buildings)
Stellic crown		Gear	Clothing
Bed		Building	Furniture
Hex tile		Floor
Animal sleeping box		Building	Furniture
Bookcase		Building	Furniture
Chemfuel powered generator		Building	Power
Pen marker		Building	Misc
Geothermal generator		Building	Power
Large altar		Building	Ideology (Buildings)
Game-of-Ur board		Building	Recreation
Lightball		Building	Ideology (Buildings)
Plant pot		Building	Furniture
Large mech gestator		Building	Biotech (Buildings)
Royal bed		Building	Furniture
Concrete		Floor
Transport pod		Building	Misc
IED tox trap		Building	Security
Ship cryptosleep casket		Building	Ship
Ship landing beacon		Building	Misc
Bonsai pot		Building	Furniture
Electric smithy		Building	Production
Toy box		Building	Furniture
Mindbend carpet		Floor
Sleep accelerator		Building	Ideology (Buildings)
Wind turbine		Building	Power
Large nature shrine		Building	Misc
Double bedroll		Building	Furniture
Rustic rug (medium)		Building	Floor
Gold tile		Floor
Ship computer core		Building	Ship
Spikecore stone tile		Floor
Fueled stove		Building	Production
Gene extractor		Building	Biotech (Buildings)
Shard inhibitor		Building	Anomaly (Buildings)
Spike trap		Building	Security
Pew		Building	Ideology (Buildings)
Stool		Building	Furniture
Psychofluid pump		Building	Biotech (Buildings)
Waterproof conduit		Building	Power
Pyre		Building	Ideology (Buildings)
Vent		Building	Temperature
Mech gestator		Building	Biotech (Buildings)
Ship reactor		Building	Ship
Animalist slab (broad)		Building	Floor
Animal bed		Building	Furniture
Small bookcase		Building	Furniture
Wood-fired generator		Building	Power
Animal flap		Building	Structure
Medium altar		Building	Ideology (Buildings)
Gene bank		Building	Biotech (Buildings)
Holding platform		Building	Anomaly (Buildings)
Bridge		Building	Structure
Grand stele		Building	Misc
Lectern		Building	Ideology (Buildings)
Ship engine		Building	Ship
Deep drill		Building	Production
Flagstone		Floor
Nutrient paste dispenser		Building	Production
Kneel sheet		Building	Ideology (Buildings)
Pod launcher		Building	Misc
Dining chair		Building	Furniture
Couch		Building	Furniture
Wood floor		Floor
Darklight brazier		Building	Furniture
Electric stove		Building	Production
Baby decoration		Building	Furniture
Wall		Building	Structure
Spikecore plates		Floor
Subcore softscanner		Building	Biotech (Buildings)
Neural supercharger		Building	Ideology (Buildings)
Tube television		Building	Recreation
Bedroll		Building	Furniture
Art bench		Building	Production
Darktorch		Building	Furniture
Table (2x2)		Building	Furniture
Hand tailor bench		Building	Production
Battery		Building	Power
Spikecore floor-star (broad)		Building	Floor
Sterile tile		Floor
Stonecutter's table		Building	Production
Totemic stone tile		Floor
Hi-tech research bench		Building	Production
Gene assembler		Building	Biotech (Buildings)
Proximity detector		Building	Anomaly (Buildings)
Drum		Building	Ideology (Buildings)
Hospital bed		Building	Furniture
Mech recharger		Building	Biotech (Buildings)
Barricade		Building	Security
Grand meditation throne		Building	Furniture
Horseshoes pin		Building	Recreation
Fine stone tile		Floor
Hydroponics basin		Building	Production
Animalist slab (medium)		Building	Floor
Tool cabinet		Building	Misc
Table (1x2)		Building	Furniture
Straw matting		Floor
Orbital trade beacon		Building	Misc
Small altar		Building	Ideology (Buildings)
Pollution pump		Building	Biotech (Buildings)
Bioferrite generator		Building	Power
Meditation throne		Building	Furniture
Reliquary		Building	Ideology (Buildings)
Butcher table		Building	Production
Ground-penetrating scanner		Building	Misc
Hemopump		Building	Biotech (Buildings)
Peg leg		Medical Items	Body Parts
Kneel pillow		Building	Ideology (Buildings)
Power switch		Building	Power
Mechband antenna		Building	Biotech (Buildings)
IED EMP trap		Building	Security
IED trap		Building	Security
Wall torch lamp		Building	Furniture
Poker table		Building	Recreation
Egg box		Building	Misc
Fungus darktorch		Building	Furniture
Electric crematorium		Building	Production
School desk		Building	Furniture
Stone tile		Floor
Totemic boards		Floor
Shelf		Building	Furniture
Solar generator		Building	Power
Ideogram		Building	Ideology (Buildings)
Flatscreen television		Building	Recreation
Slab bed		Building	Furniture
Small shelf		Building	Furniture
Table (2x4)		Building	Furniture
Electric tailor bench		Building	Production
Spikecore floor-star (medium)		Building	Floor
Torch lamp		Building	Furniture
Sarcophagus		Building	Misc
Gene processor		Building	Biotech (Buildings)
Atmospheric heater		Building	Anomaly (Buildings)
Skullspike		Building	Ideology (Buildings)
Cooler		Building	Temperature
Large mech recharger		Building	Biotech (Buildings)
Campfire		Building	Temperature
Fine carpet		Floor
Hopper		Building	Production
Morbid slab (broad)		Building	Floor
Multi-analyzer		Building	Misc
Electric inhibitor		Building	Anomaly (Buildings)
Table (3x3)		Building	Furniture
Paved tile		Floor
Cannibal platter		Building	Ideology (Buildings)
Toxifier generator		Building	Power
Watermill generator		Building	Power
Brazier		Building	Furniture
Styling station		Building	Ideology (Buildings)
Fermenting barrel		Building	Production
Hemogen amplifier		Building	Biotech (Buildings)
Hidden conduit		Building	Power
Wooden foot		Medical Items	Body Parts
Incense shrine		Building	Ideology (Buildings)
Band node		Building	Biotech (Buildings)
IED firefoam trap		Building	Security
Slab double bed		Building	Furniture
IED incendiary trap		Building	Security
Wall lamp		Building	Furniture
Fence		Building	Structure
Comms console		Building	Misc
Christmas tree		Building	Ideology (Buildings)
Simple research bench		Building	Production
Blackboard		Building	Furniture
Autocannon turret		Building	Security
Sandbags		Building	Security
Subcore ripscanner		Building	Biotech (Buildings)
Sleep suppressor		Building	Anomaly (Buildings)
Sun lamp		Building	Furniture
Burnbong		Building	Ideology (Buildings)
IED smoke trap		Building	Security
End table		Building	Furniture
Column		Building	Structure
Electric smelter		Building	Production
Totemic slab (broad)		Building	Floor
Moisture pump		Building	Misc
Serum lab		Building	Anomaly (Buildings)
Biofuel refinery		Building	Production
Machining table		Building	Production
Morbid carpet		Floor
Autobong		Building	Ideology (Buildings)
Heater		Building	Temperature
Deathrest casket		Building	Biotech (Buildings)
Cryptosleep casket		Building	Misc
Carpet		Floor
Morbid slab (medium)		Building	Floor
Vitals monitor		Building	Misc
Bioferrite harvester		Building	Anomaly (Buildings)
Hoopstone ring		Building	Recreation
Fueled smithy		Building	Production
Wastepack atomizer		Building	Biotech (Buildings)
Fabrication bench		Building	Production
Drape		Building	Furniture
Gibbet cage		Building	Ideology (Buildings)
Double bed		Building	Furniture
Glucosoid pump		Building	Biotech (Buildings)
Bioferrite plate		Floor
Effigy		Building	Ideology (Buildings)
Chess table		Building	Recreation
Foam turret		Building	Security
IED antigrain warhead trap		Building	Security
Terror sculpture	Art bench	Art
Small sculpture	Art bench	Art
Void sculpture	Art bench	Art
Grand sculpture	Art bench	Art
Large sculpture	Art bench	Art
Ceremonial hood	Bioferrite shaper	Gear	Clothing
Revenant vertebrae	Bioferrite shaper	Medical Items	Body Parts
Shard shock lance	Bioferrite shaper	Gear	Utility
Shard animal pulser	Bioferrite shaper	Artifact
Shard insanity lance	Bioferrite shaper	Gear	Utility
Nerve spiker	Bioferrite shaper	Equipment	Weapons
Biomutation lance	Bioferrite shaper	Gear	Utility
Incinerator	Bioferrite shaper	Equipment	Weapons
Deadlife shell	Bioferrite shaper	Crafted resources	Mortar shell
Ghoul barbs	Bioferrite shaper	Medical Items	Body Parts

Semantic search

Query log

Navigation menu

Search