Qiannianzi is a populated place in Jilin, China. It has an elevation of 403 meters above sea level. It is also known as Qiannianzi, qian nian zi, 前碾子. Information correct as at Tuesday 10th November 2015.
///stage.doodled.offends. Near Minzhu, 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` = 10932221 LIMIT 1 | 1 | 1 | 1 | |
| 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 | 85 | |
| 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` < 10932221 ORDER BY `Record`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
| 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` >= 10932220 AND `Record`.`id` != 10932221 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 0 |