Diaodagoushang is a populated place in Jilin, China. It has an elevation of 688 meters above sea level. It is also known as Diaodagoushang, diao da gou shang, 吊打沟上. Information correct as at Saturday 21st January 2012.
///lampposts.flammable.thresholds. Near Linjiang, Jilin
Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` = 7546190 LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Record`.`id`, `Record`.`asciiname` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE district_id ='CN.05.' ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 109 | |
| 3 | SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` < 7546190 ORDER BY `Record`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
| 4 | SELECT `Record`.`id`, `Record`.`name`, `Record`.`asciiname`, `Record`.`alternatenames`, `Record`.`latitude`, `Record`.`longitude`, `feature class`, `Record`.`feature_id`, `Record`.`country_id`, `Record`.`cc2`, `admin1 code`, `admin2 code`, `Record`.`area_id`, `Record`.`district_id`, `admin3 code`, `admin4 code`, `Record`.`population`, `Record`.`elevation`, `Record`.`dem`, `Record`.`timezone_id`, `modification date`, `Record`.`description`, `Record`.`what3words`, `Record`.`what3words_place`, `Country`.`id`, `Country`.`name`, `Country`.`alpha-3`, `Country`.`country-code`, `Country`.`iso_3166-2`, `Country`.`region`, `Country`.`sub-region`, `Country`.`intermediate-region`, `Country`.`region-code`, `Country`.`sub-region-code`, `Country`.`intermediate-region-code`, `Feature`.`id`, `Feature`.`summary`, `Feature`.`description`, `Area`.`id`, `Area`.`name`, `Area`.`asciiname`, `Area`.`code`, `District`.`id`, `District`.`name`, `District`.`asciiname`, `District`.`code`, `Timezone`.`id`, `Timezone`.`CountryCode`, `Timezone`.`GMToffset`, `Timezone`.`DSToffset`, `Timezone`.`rawOffset` FROM `places`.`records` AS `Record` LEFT JOIN `places`.`countries` AS `Country` ON (`Record`.`country_id` = `Country`.`id`) LEFT JOIN `places`.`features` AS `Feature` ON (`Record`.`feature_id` = `Feature`.`id`) LEFT JOIN `places`.`areas` AS `Area` ON (`Record`.`area_id` = `Area`.`id`) LEFT JOIN `places`.`districts` AS `District` ON (`Record`.`district_id` = `District`.`id`) LEFT JOIN `places`.`timezones` AS `Timezone` ON (`Record`.`timezone_id` = `Timezone`.`id`) WHERE `Record`.`id` >= 7546189 AND `Record`.`id` != 7546190 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 1 |