SELECT `s`.`id` AS `s__id`, `s`.`name` AS `s__name`, `s`.`application` AS `s__application`, `s`.`area_id` AS `s__area_id`, `s`.`default_area_id` AS `s__default_area_id`, `s`.`is_active` AS `s__is_active`, `s`.`datacentre` AS `s__datacentre`, `s`.`is_single_area` AS `s__is_single_area`, `s`.`hostname` AS `s__hostname`, `s`.`operating_store_id` AS `s__operating_store_id`, `s`.`site_group_id` AS `s__site_group_id`, `s`.`company_id` AS `s__company_id`, `s`.`type` AS `s__type` FROM `site` `s` WHERE (`s`.`hostname` = ?) LIMIT 1