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: [[Concept:Events]] [[Academic Field.Academic Field OECD FOS 2007::Computer And Information Sciences]]
 |?In Event Series=Event Series
 |?Academic Field
 |format=broadtable
 |limit=50
 |offset=0
 |link=all
 |sort=
 |order=asc
 |headers=show
 |mainlabel=
 |searchlabel=... further results
 |class=sortable wikitable smwtable
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Concept:Events]] [[Academic Field.Academic Field OECD FOS 2007::Computer And Information Sciences]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.2328",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Concept:Events]] [[Academic Field.Academic Field OECD FOS 2007::Computer And Information Sciences]]

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 t3
INNER JOIN
(`smw_di_wikipage` AS t5
INNER JOIN
`smw_di_blob` AS t7 ON t5.o_id=t7.s_id) ON t3.s_id=t5.s_id) ON t0.smw_id=t3.s_id
WHERE
(t3.o_id=568
   AND (t5.p_id=538
   AND (
   (t7.o_hash='Computer And Information Sciences') AND t7.p_id=541)
  ))
  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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t7	ref	s_id, o_hash, s_id_2, p_id	o_hash	258	const	473	3.70	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	t5	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id_2	5	wiki.t7.s_id	6	25.92	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	wiki.t5.s_id	1	50.00	Using where
1	SIMPLE	t3	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	wiki.t5.s_id, const	1	100.00	Using index; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:4
Query-Depth:2

Errors and Warnings

None

	Event Series	Academic Field
1. Deutscher Bibliothekartag	BiblioCon	Library Science
1. ORCID DE Outreach Workshop	ORCID DE Workshops	Digital Libraries Information Science Open Science Persistent Identifiers Library Science
1. Österreichischer Bibliothekskongress - "Arbeitswelten – Realitäten und Visionen"	Österreichischer Bibliothekskongress	Library Science Library
10mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
10th Automotive NVH Comfort Conference 2018	Automotive NVH Comfort Conference	Mobility Research Automotive
10th International ACM Sigsoft Conference on the Quality of Software Architectures	QoSA	Software Architecture
10th Working IEEE/IFIP Conference on Software Architecture & 6th European Conference on Software Architecture	WICSA	Software Architecture
11mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
11th International ACM Sigsoft Conference on the Quality of Software Architectures QoSA 2015	QoSA	Software Architecture
12mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
12th International Conference on the Quality of Software Architectures	QoSA	Software Architecture
12th International Workshop on Data Privacy Management	DPM	Data Privacy
13mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
13th Working IEEE/IFIP Conference on Software Architecture & 10th Federated Conference on Component-Based Software Engineering and Software Architecture	WICSA	Software Architecture
14. Wildauer Bibliothekssymposium	Wildauer Bibliothekssymposium	Information Science Library Science
14mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
15mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
15th European Conference on Software Maintenance and Reengineering	CSMR	Software Maintenance
15th International Symposium on Formal Methods 2008	International Symposium on Formal Methods	Software Engineering
16mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
16th European Conference on Software Maintenance and Reengineering	CSMR	Software Maintenance
17mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
17th European Conference on Software Maintenance and Reengineering	CSMR	Software Maintenance
18mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
19mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
1mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
1st International Workshop on "Generalizing knowledge: from Machine Learning and Knowledge Representation to the Semantic Web"	GenSW	Semantic Web
1st International Workshop on Enabling Open Semantic Science	SemSci	Semantic Web
1st Machine Learning Workshop	ICML - International Conference on Machine Learning	Machine Learning
1st Wikidata Workshop	Wikidata Workshop	Information Science Library Science Linked Data
2. Fachkonferenz Kinder- und Jugendbibliotheken	Fachkonferenz Kinder- und Jugendbibliotheken	Education Library Science Literature
2. ORCID DE Workshop - Implementierung	ORCID DE Workshops	Digital Libraries Information Science Open Science Persistent Identifiers Library Science
20mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
21mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
22mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
23mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
24mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
25mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
26mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
27mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
28mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
29mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
2mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
2nd International Conference on Database and Expert Systems Applications	DEXA - International Conference on Database and Expert Systems Applications	Databases
2nd International Workshop on Machine Learning	ICML - International Conference on Machine Learning	Machine Learning
2nd Wikidata Workshop	Wikidata Workshop	Information Science Library Science Linked Data Open Data
3. Fachkonferenz Kinder- und Jugendbibliotheken	Fachkonferenz Kinder- und Jugendbibliotheken	Education Library Science Literature
3. ORCID DE Workshop – Perspektiven und Technik	ORCID DE Workshops	Digital Libraries Information Science Open Science Persistent Identifiers
30mfm	mfm - Manchester Phonology Meeting	Computational Linguistics
39. ASPB TAGUNG	ASpB-Tagung - Fachtagung der Arbeitsgemeinschaft der Spezialbibliotheken	Library Science