Semantic search
From Earth Science Information Partners (ESIP)
Debug output SQLStore
ASK Query
[[Category:GEO UserReq Doc]] [[Category:CandidateDoc]]
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
`smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=4704
AND (t4.o_id=4705)
)
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
100
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
`smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=4704
AND (t4.o_id=4705)
)
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
100
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 | 119 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | mediawiki.t4.s_id, const | 1 | 100.00 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki.t4.s_id | 1 | 96.09 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
NoneOrganization | DocumentNumber | DocRegion | DocType | Title | Status | |
---|---|---|---|---|---|---|
Sri Lanka Air Quality Monitoring | Sri Lanka Central Environmental Authority | 71 | Other | ri Lanka Air Quality Monitoring | Unsubmitted | |
State of the Environment Republic of South Africa | Department of Environmental Affairs and Tourism. | 32 | Africa | State of the Environment Republic of South Africa | Unsubmitted | |
State of the Environment in Africa | UN Economic and Social Council | 31 | Africa | Report | State of the Environment in Africa | Submitted |
Survey of Air Quality Monitoring | Committee on Environment and Natural Resources Research (CENR) Air Quality Research Subcommittee (AQRS) | 26 | North America | Survey of Air Quality Monitoring | Submitted | |
Tanzania An Overview Of of Air Pollution in urban areas | G.J. Kombe | 70 | Africa | Other | Tanzania An Overview Of of Air Pollution in urban areas | Unsubmitted |
Thai Air Quality Monitoring Network | THAI DENR | 81 | Thai Air Quality Monitoring Network | Unsubmitted | ||
The Clean Air Initiative Strategy For Latin American And Caribbean Cities 2007-2012. Presentation | Clean Air Initiative | Report | The Clean Air Initiative Strategy For Latin American And Caribbean Cities 2007-2012. Presentation | Unsubmitted | ||
The EMEP monitoring strategy 2004-2009 | NILU | 6 | Europe | The EMEP monitoring strategy 2004-2009 | Submitted | |
The Global Burden of Disease Due to Outdoor Air Pollution | Aaron J. Cohen a; H. Ross Anderson b; Bart Ostro c; Kiran Dev Pandey d; Michal Krzyzanowski e; Nino Knzli f; Kersten Gutschmidt g; Arden Pope h; Isabelle Romieu i; Jonathan M. Samet j; Kirk Smith k | 111 | International | The Global Burden of Disease Due to Outdoor Air Pollution | Unsubmitted | |
The National Ambient Air Monitoring Strategy: Rethinking the Role of National Networks | R. Scheffe et. al. | 27 | North America | The National Ambient Air Monitoring Strategy: Rethinking the Role of National Networks | Submitted | |
Tunisai to monitor air quality | Science and Development Network | 68 | Other | Tunisia to monitor air Quality | Unsubmitted | |
USWRP Workshop on Air Quality | W. Dabberdt | 45 | North America | USWRP Workshop on Air Quality | Unsubmitted | |
Urban Environment Management and Air Quality in Less Developed Countrie | Danish Development Research Network | International | Report | Urban Environmental Management and Air Quality | Unsubmitted | |
Vietnam Building up Air Pollutio Model in Ho Chi Minh City using GIS and Neutral Network Technologyn Prediction | Bui Ta Long1, Luu Minh Tung1, Le Thi Quynh Ha1, Duong Ngoc Hieu2. | 89 | According to Ho Chi Minh City service of Resources and Environment, currently there | Unsubmitted | ||
WMO SAND AND DUST STORM WARNING ADVISORY AND ASSESSMENT SYSTEM (SDS-WAS): IMPLEMENTATION PLAN 2009-2013 | WMO | 17 | International | WMO SAND AND DUST STORM WARNING ADVISORY AND ASSESSMENT SYSTEM (SDS-WAS): IMPLEMENTATION PLAN 2009-2013 | Unsubmitted | |
Will the Circle Be Unbroken: A History of the U.S. National Ambient Air Quality Standards | Judith C. Chow and John G. Watson, et. al. | 102 | North America | Will the Circle Be Unbroken: A History of the U.S. National Ambient Air Quality Standards | Unsubmitted | |
Workshop REMOTE SENSING OF AIR POLLUTION with a view to EU Air Quality Legislation JRC-IES, Ispra, 28th June 2006 | Europe | Workshop | Workshop REMOTE SENSING OF AIR POLLUTION with a view to EU Air Quality Legislation JRC-IES, Ispra, 28th June 2006 | Unsubmitted | ||
World Bank Ranking of cities by PM10 | World Bank | 98 | International | World Bank Ranking of cities by PM10 | Unsubmitted | |
World Health Report 2002 | WHO | 110 | International | World Health Report 2002 | Unsubmitted |