Giema is a populated place in Southern Province, Sierra Leone. It has an elevation of 49 meters above sea level. It is also known as Giema. Information correct as at Wednesday 3rd December 2014.
///readjusted.hacker.scoutmaster. Near Gandorhun, Southern Province
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` = 2408823 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 ='SL.03.' ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 35 | |
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` < 2408823 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` >= 2408822 AND `Record`.`id` != 2408823 ORDER BY `Record`.`id` ASC LIMIT 2 | 2 | 2 | 1 |