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: <q>[[Has objectClass::Event]] [[Start::≥2014]] [[Start::<<2015]] OR [[Has objectClass::Event]] [[Start::<<2014]] [[End::≥2014]]</q>
 |?Start
 |?End
 |?Description
 |format=table
 |limit=50
 |offset=100
 |sort=
 |order=asc
 |mainlabel=Event
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Has objectClass::Event]] [[Start::\u22652014]] [[Start::<<2015]] OR [[Has objectClass::Event]] [[Start::<<2014]] [[End::\u22652014]]<\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0867",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Has objectClass::Event]] [[Start::≥2014]] [[Start::<<2015]] OR [[Has objectClass::Event]] [[Start::<<2014]] [[End::≥2014]]

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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_t1` AS t1 ON t0.smw_id=t1.id
WHERE
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	t1	ALL	PRIMARY				116	Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	wikispooks.t1.id	1	Using where

Auxilliary Tables

Temporary table t1
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t3.s_id FROM `mw_smw_di_wikipage` AS t3 INNER JOIN `mw_smw_di_time` AS t6 ON t3.s_id=t6.s_id INNER JOIN `mw_smw_di_time` AS t8 ON t3.s_id=t8.s_id WHERE t3.p_id='2398166' AND t3.o_id='2087' AND ((t6.o_sortkey>='2456658.5') AND t6.p_id='2398177') AND ((t8.o_sortkey<'2457023.5') AND t8.p_id='2398177')
INSERT IGNORE INTO `mw_t1` SELECT DISTINCT t11.s_id FROM `mw_smw_di_wikipage` AS t11 INNER JOIN `mw_smw_di_time` AS t14 ON t11.s_id=t14.s_id INNER JOIN `mw_smw_di_time` AS t16 ON t11.s_id=t16.s_id WHERE t11.p_id='2398166' AND t11.o_id='2087' AND ((t14.o_sortkey<'2456658.5') AND t14.p_id='2398177') AND ((t16.o_sortkey>='2456658.5') AND t16.p_id='2398181')

Query Metrics

Query-Size:12
Query-Depth:1

Errors and Warnings

None

Event	Start	End	Description
Sinking of MV Sewol	16 April 2014 09:00:00	16 April 2014 11:30:00	A ferry sinking which killed hundreds of schoolchildren. Officially, an accident, but information hidden and falsified in investigation.
Strelkov shoot-down post	17 July 2014 13:50:00		Post on VK.com, purporting to be by Igor Strelkov, claiming to have shot down a Ukrainian AN26 transport plane
The Hampstead Cover-Up	2014	2014	Alleged satanic cult activity in North London
UKr BUK on TV	16 July 2014 12:00:00		Ukraine army Buk system footage day before shooting down Flight MH17 - English Subtitles
UN GA vote on Crimea	27 March 2014 00:00:00		UN General Assembly adopts resolution calling upon states not to recognize changes in status of Crimea region
UNSCR 2166 requires truce	21 July 2014 12:53:00		UN Security Council adopts resolution 2166 which, among other things requires a cessation of military action within 20 Km of the crash site
US-EU condemnation chorus	22 August 2014 16:00:00		Chorus of condemnation from Anglo-US-NATO official sources and and media in response to the Russian humanitarian aid convoy crossing into Ukraine without official permission from the Kiev Junta.
Ukr SBU comms intercepts	17 July 2014 01:00:00		Alleged SSU, radio interception of conversations between "terrorists", "Boeing-777" plane crash (YouTube upload time approx)
Ukraine coup 2014/Parliament grants limited self-rule	16 September 2014 12:00:00	16 September 2014 12:00:00	Ukraine's parliament has voted to give the east of the country limited self-rule as part of proposals aimed at ending the deadly separatist insurgency.
Ukraine report to US Congress	18 September 2014 14:50:00		Ukrainian President Petro Poroshenko delivered remarks to a joint meeting of Congress about the situation in his country and the ongoing conflict with Russia.
Ukraine troops leave Crimea	24 March 2014 00:00:00		Ukrainian troops leave Crimea. The pullout follows an order by Ukraine's acting President Olexander Turchynov
Ukraine/2014 presidential election	25 May 2014 00:00:00		Elections for a new president of Ukraine in spite of the fact that the existing President Yanukovitch had not resigned nor been legally removed by due constitutional process
WEF/Annual Meeting/2014	22 January 2014	25 January 2014	2604 guests in Davos considered "Reshaping The World"
Weather conditions	17 July 2014 13:00:00		Map compiled from ICAO weather station data at 13:00 UTC
Yanukovitch deposed	22 February 2014 00:00:00		Verkhovna Rada (The Ukraine Parliament) votes to depose duly elected President Viktor Yanukovitch
Yanukovych statement	12 May 2014 00:00:00		Ousted President Yanukovych issues a statement on the referendums conducted in Eastern Ukraine the previous day

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Misc