Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Activity]] [[Category:Data]]
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 t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.o_id=596)
)
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
50
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 t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.o_id=596)
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 56 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | ocwiki.t4.s_id | 1 | Using where; Using index | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | ocwiki.t2.o_id | 1 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ocwiki.t4.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (2614).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=2614 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
None[[Taoyuan citizen card]] | ||
In respond to the rapid growth of Taoyuan’s population, the upgrading of government service, the development of industries, and the popularization of urban infrastructure, the card intends to connect the government, businesses, and citizens and integrate service. Business resources are also integrated to create a win-win collaborative model for citizens, businesses, and the government. | ||
[[The Solid Project]] | ||
The Solid project is a decentralized platform for the Web that he and a team of researchers at MIT are developing. The goal of the Solid project is to give people more control over their personal data and how it is used by enabling them to store their data on their own servers or "pods," rather than on centralized servers controlled by companies. | ||
[[U.S. Central Bank Digital Currency]] | ||
The Digital Dollar Project is a partnership between Accenture (NYSE: ACN) and the Digital Dollar Foundation to advance exploration of a United States Central Bank Digital Currency (CBDC). The purpose of the Project is to encourage research and public discussion on the potential advantages of a digital dollar, convene private sector thought leaders and actors, and propose possible models to support the public sector. The Project will moderate programs with interested stakeholders to measure the value of and and establish practical steps that can be taken to establish a digital dollar. | ||
[[UPsouth]] | ||
UPsouth a technology platform that supports Auckland Council connect with young citizens and empower them to become civic entrepreneurs. The Southern Initiative (TSI) is a place-based initiative in South Auckland, New Zealand, that aims to create a prosperous, resilient area where communities thrive. To deliver on its mission, TSI wanted a way to engage with young people in South Auckland. Itsnoon’s civic empowerment platform ‘UPsouth’ enabled young people, of Māori, Pasifika and other ethnic backgrounds, aged 15-24, generate thousands of thoughts, ideas and commentary on important local issues while earning micropayments for their contributions. | ||
[[Urban Platform]] | ||
An easy-to-use platform that allows you to manage your city, whether you are responsible for traffic and mobility, safety, infrastructure or high-level decision making. | ||
[[WiseTown]] | ||
W.I.S.E. Town stands for Web Information Streams Enhancer for your Town. The goal of this solution is to collect information from different streams to identify the issues that affect the city in several areas: urban renewal, garbage collection, public safety, transportation, social services and environmental problems. | ||