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

prefix:

Control display of namespace in printouts

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Topic::2010/G8]][[Position::Cost item]]
 |?Description
 |?Canadian dollar cost 2010
 |?Procurement Process
 |?Supplier
 |format=broadtable
 |limit=50
 |offset=50
 |sort=Canadian_dollar_cost_2010
 |order=DESC
}}

Results 51 – 82 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Topic::2010\/G8]][[Position::Cost item]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0246",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Topic::2010/G8]] [[Position::Cost item]]

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, t9.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t2
INNER JOIN
`smw_di_wikipage` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_number` AS t9 ON t0.smw_id=t9.s_id
WHERE
(t2.p_id=527 AND t2.o_id=1793
   AND (t5.p_id=535 AND t5.o_id=599)
  )
   AND (t9.p_id=517)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t9.o_sortkey DESC
LIMIT
55
OFFSET
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t2	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id_3	9	const, const	82	Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	mediawiki.t2.s_id	1	Using where
1	SIMPLE	t5	ref\|filter	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	p_id\|o_id	8\|5	const, mediawiki.t2.s_id	1 (12%)	Using where; Using rowid filter
1	SIMPLE	t9	ref	s_id, p_id, p_id_2, s_id_2	s_id_2	8	mediawiki.t2.s_id, const	1	Using index

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:4
Query-Depth:1

Errors and Warnings

None

	Description	Canadian dollar cost 2010	Procurement Process	Supplier
2010/G20 and G8 Budget/Sirens	Sirens	98,225	Sole Source	Mega-Tech
2010/G20 and G8 Budget/Corel Office Standard	Corel Office Standard	81,671	Call up	Corel
2010/G20 and G8 Budget/Transportation - vehicle lease - vans	Transportation - vehicle lease - vans	81,070	Competitive	Enterprise
2010/G20 and G8 Budget/Defibrillators	Defibrillators	74,898	Competitive	R. Nicholls Distributors Inc.
2010/G20 and G8 Budget/Server and software	Server and software	67,095	Sole Source	ESRI Canada
2010/G8/Landscaping	Landscaping	65,000
2010/G20 and G8 Budget/Sofware, licences 3	Sofware, licences	64,239	Call up	Microsoft
2010/G20 and G8 Budget/Siren speakers	Siren speakers	45,009	Sole Source	D&R Electronics
2010/G20 and G8 Budget/Binoculars 4	Binoculars	39,562	Competitive	Marathon Management
2010/G20 and G8 Budget/Dash fireballs	Dash fireballs	39,181	Competitive	R. Nicholls Distributors Inc.
2010/G20 and G8 Budget/Cameras, under-vehicle surveillance detection systems	Cameras, under-vehicle surveillance detection systems	37,265	Competitive	Frontline Robotics Inc.
2010/G20 and G8 Budget/Sofware, licences	Sofware, licences	35,718	Call up	Softchoice Corporation
2010/G20 and G8 Budget/Sofware, licences 4	Sofware, licences	34,148	Call up	Microsoft
2010/G20 and G8 Budget/Lockers, firearms and change room 3	Lockers, firearms and change room	33,101	Competitive	Y&M Manufacturing
2010/G20 and G8 Budget/Flag Poles	Flag Poles	31,390	Competitive	Dominion Regalia Ltd.
2010/G20 and G8 Budget/UPS network management card	UPS network management card	30,174	Call up	Nisha Technologies Inc.
2010/G20 and G8 Budget/Infrared signal light	Infrared signal light	29,180	Competitive	R. Nicholls Distributors
2010/G20 and G8 Budget/Lockers, wireless devices	Lockers, wireless devices	27,705	Competitive	Y&M Manufacturing
2010/G20 and G8 Budget/Generators	Generators	26,801	Competitive	Yamaha Motor Canada Ltd.
2010/G20 and G8 Budget/Fibre nic cards and transceivers 3	Fibre nic cards and transceivers	25,895	Competitive	Sidler Ltd.
2010/G20 and G8 Budget/First-aid kits - leg—thigh—trauma	First-aid kits - leg/thigh/trauma	25,869	Competitive	Canadian Tactical and Operational Medical Solutions Inc.
2010/G20 and G8 Budget/Fibre nic cards and transceivers	Fibre nic cards and transceivers	24,712	Competitive	Ru-Link Computers
2010/G20 and G8 Budget/Event management - G8—G20 events	Event management - G8/G20 events	24,150	Sole Source	Ian Martin Limited (Madeleine Ouellon)
2010/G20 and G8 Budget/Quality assurance — oversight for G8 and G20 high-risk procurement files	Quality assurance / oversight for G8 and G20 high-risk procurement files	23,809	Sole Source	Government procurement consultants
2010/G20 and G8 Budget/Tactical thermal night vision video camera	Tactical thermal night vision video camera	23,100	Competitive	P&R Technology
2010/G20 and G8 Budget/Various hand tools 4	Various hand tools	13,257	Competitive	Tenaquip Ltd.
2010/G20 and G8 Budget/Various hand tools	Various hand tools	9,078	Competitive	Beta Overseas Inc.
2010/G20 and G8 Budget/Various hand tools 3	Various hand tools	7,093	Competitive	Snap-on Tools of Canada Ltd.
2010/G20 and G8 Budget/Binoculars 3	Binoculars	6,010	Competitive	R. Nicholls
2010/G20 and G8 Budget/Lockers, firearms and change room	Lockers, firearms and change room	2,624	Competitive	Mark McClinton operating as: Warehouse Expert
2010/G20 and G8 Budget/Various hand tools 5	Various hand tools	266	Competitive	Zepoli International
2010/G20 and G8 Budget/Various hand tools 6	Various hand tools	58	Competitive	Acklands Grainger Inc.

Semantic search

Query log

Navigation menu

Search