Semantic search
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_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=1847
AND (t4.p_id=1822)
)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 70 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki.t2.s_id | 1 | 97.42 | Using where |
1 | SIMPLE | t4 | ref | s_id, s_id_2, p_id | s_id | 8 | mediawiki.t2.s_id, const | 1 | 100.00 | Using index; Distinct |
Query-Depth:1
AERONETd: Global Ground-Based Sun Photometer Network Domain: Aerosol | DataType: POINT | Platform:Network | Method:RemoteSens |
AIRNOW: Surface Monitoring Data for PM2.5 and Ozone Domain: Aerosol | DataType: POINT | Platform:Network | Method:FilterSmp |
AMAP G: Dataset Title Domain: Emission | DataType: GRID | Platform:No Platform | Method:Model |
AQS d: AQS_d Domain: Aerosol | DataType: POINT | Platform:Network | Method:Point |
AQS h: AQS_h Domain: Aerosol | DataType: POINT | Platform:Network | Method:Point |
ASOS STI: ASOS Surface Extinction Coefficient by STI Domain: Aerosol | DataType: POINT | Platform:Network | Method:Point |
ASTR FIREd: ASTR_FIREd Domain: Fire | DataType: SeqImage | Platform:Satellite | Method:Point |
ASTR FIREm: ASTR_FIREm Domain: Fire | DataType: SeqImage | Platform:Satellite | Method:Point |
ATADV: ATADV Domain: Aerosol | DataType: TRAJ | Platform:Unknown | Method:RemoteSens |
AVHRR: AVHRR Domain: Aerosol | DataType: POINT | Platform:Satellite | Method:RemoteSens |
Africa Dust: Surface Concentration PM10, Dust Domain: Aerosol | DataType: POINT | Platform:Network | Method:Point |
Astrophoto: The Gateway to Astronaut Photography of Earth Domain: Aerosol | DataType: Image | Platform:Satellite | Method:RemoteSens |
CALIPSO: CALIPSO Lidar Browse Images Domain: Aerosol | DataType: Image | Platform:Satellite | Method:RemoteSens |
CIESIN GPW: Global Population Density Domain: Demographic | DataType: Image | Platform:Count | Method:ContSens |
CIESIN POP: Data Title here Domain: Demographic | DataType: GRID | Platform:Unknown | Method:RemoteSens |
CMAQ Baron G: BAMS CMAQ for CATHALAC Domain: Aerosol | DataType: GRID | Platform:Model | Method:Model |
EDGAR: EDGAR Emission Data Domain: Emission | DataType: GRID | Platform:Emission | Method:RemoteSens |
EDGAR WCS: EDGAR_WCS Domain: Test | DataType: SeqImage | Platform:Model | Method:Model |
EPA AirMarkets: EPA_AirMarkets Domain: Emission | DataType: POINT | Platform:No Platform | Method:RemoteSens |
GASP: GASP Domain: Aerosol | DataType: SeqImage | Platform:Satellite | Method:Model |
GASP tiff: Gasp in GEOtiff Format Domain: Aerosol | DataType: SeqImage | Platform:Satellite | Method:Model |
GDSG Fire: GDSG Fire Domain: Fire | DataType: Image | Platform:Satellite | Method:RemoteSens |
GFED WCS: GFED WCS Domain: Emission | DataType: GRID | Platform:Emission | Method:Model |
GFED8day: GFED8day Domain: Emission | DataType: GRID | Platform:Model | Method:Unknown |
GOCART G OL: Global Chemical Transport Model Domain: Aerosol | DataType: GRID | Platform:Model | Method:Model |
GOES: GOES Satellite Data - Imager Domain: Aerosol | DataType: Image | Platform:Satellite | Method:RemoteSens |
GOES 12: GOES_12 Eastern NAM Domain: Aerosol | DataType: SeqImage | Platform:Satellite | Method:RemoteSens |
GOMEm: GOMEm Domain: Aerosol | DataType: Image | Platform:Emission | Method:RemoteSens |
GSFC NO2 OL: GSFC_NO2_OL Domain: Gases | DataType: GRID | Platform:Satellite | Method:RemoteSens |
MNEI Area: Mexican National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
MNEI Mobile: Mexican National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
MNEI NonRoad: Mexican National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
MNEI Point: Mexican National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Satellite | Method:RemoteSens |
MODIS FIRE: MODIS_FIRE Domain: Fire | DataType: Image | Platform:Satellite | Method:No Method |
MODIS IMG: MODIS_IMG Domain: Aerosol | DataType: Image | Platform:Satellite | Method:No Method |
MODISd G: MODIS/Aqua Atmosphere Daily Global Product Domain: Aerosol | DataType: GRID | Platform:Satellite | Method:RemoteSens |
MODISm G: MODISm_G Domain: Aerosol | DataType: GRID | Platform:Satellite | Method:RemoteSens |
MOPITT Day: MOPITT Domain: Aerosol | DataType: Image | Platform:Model | Method:RemoteSens |
NAAPS GLOBAL: NRL Global Aerosol Model Domain: Aerosol | DataType: Image | Platform:Model | Method:Model |
NAAPS NoAm: NRL Global Aerosol Model Domain: Aerosol | DataType: Image | Platform:Model | Method:Model |
NAAPS sigma: NAAPS_sigma Domain: Aerosol | DataType: GRID | Platform:Model | Method:No Method |
NADP: National Atmospheric Deposition Network Domain: Aerosol | DataType: POINT | Platform:Network | Method:FilterSmp |
NARSTO 5min: NARSTO EPA_SS_ST_LOUIS Air Chemistry, Particulate Matter, and Meteorological Data Domain: Aerosol | DataType: POINT | Platform:Network | Method:Point |
NEI: US National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
NEI Area: US National Emissions Inventory Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
NEI EGU: NEI Electric Generating Utilities Emissions Domain: Emission | DataType: POINT | Platform:Network | Method:FilterSmp |
NEI Mobile: US National Emissions Inventory Mobile Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
NEI Point: US National Emissions Inventory Point Sources Domain: Emission | DataType: POINT | Platform:Emission | Method:Point |
NEXRAD WMS: NEXRAD Domain: Aerosol | DataType: Image | Platform:Unknown | Method:RemoteSens |
NGC CALPUFF: NGC CALPUFF Domain: Fire | DataType: GRID | Platform:Model | Method:Model |