Arroyo La Jaula is a intermittent stream in Aguascalientes, Mexico. It has an elevation of 2228 meters above sea level. It is also known as Arroyo Jaula, Arroyo La Jaula. Information correct as at Sunday 5th August 2012.
///think.landlines.weeklies. Near San Tadeo, Aguascalientes
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` = 4021565 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 ='MX.01.' ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 4 | |
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` < 4021565 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` >= 4021564 AND `Record`.`id` != 4021565 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 0 |