source request_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = admin
  sql_db = wlw_development
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `requests`.`id` * 7 + 4 AS `id` , `requests`.`title` AS `title`, `requests`.`short_description` AS `short_description`, GROUP_CONCAT(DISTINCT IFNULL(`roles`.`name`, '0') SEPARATOR ' ') AS `roles`, `requests`.`request_type` AS `request_type`, GROUP_CONCAT(DISTINCT IFNULL(`document_types`.`id`, '0') SEPARATOR ' ') AS `document_types_id`, GROUP_CONCAT(DISTINCT IFNULL(`roles`.`id`, '0') SEPARATOR ' ') AS `roles_id`, GROUP_CONCAT(DISTINCT IFNULL(`roles_users`.`id`, '0') SEPARATOR ' ') AS `user_roles_id`, `requests`.`status` AS `status`, `requests`.`id` AS `sphinx_internal_id`, 4096439811 AS `class_crc`, '4096439811' AS `subclass_crcs`, 0 AS `sphinx_deleted`, GROUP_CONCAT(DISTINCT IFNULL(`document_types`.`id`, '0') SEPARATOR ',') AS `document_types_id`, GROUP_CONCAT(DISTINCT IFNULL(`roles`.`id`, '0') SEPARATOR ',') AS `roles_id`, `requests`.`request_type` AS `request_type`, UNIX_TIMESTAMP(`requests`.`deadline`) AS `deadline` FROM `requests`    LEFT OUTER JOIN `request_roles` ON (`requests`.`id` = `request_roles`.`request_id`)  LEFT OUTER JOIN `roles` ON (`roles`.`id` = `request_roles`.`role_id`)   LEFT OUTER JOIN `request_document_types` ON (`requests`.`id` = `request_document_types`.`request_id`)  LEFT OUTER JOIN `document_types` ON (`document_types`.`id` = `request_document_types`.`document_type_id`)   LEFT OUTER JOIN `users` ON `users`.id = `requests`.user_id   LEFT OUTER JOIN `roles_users` roles_users_join ON (`users`.`id` = `roles_users_join`.`user_id`)  LEFT OUTER JOIN `roles` roles_users ON (`roles_users`.`id` = `roles_users_join`.`role_id`)  WHERE `requests`.`id` >= $start AND `requests`.`id` <= $end GROUP BY `requests`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `requests`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = request_type
  sql_attr_timestamp = deadline
  sql_attr_multi = uint subclass_crcs from field
  sql_attr_multi = uint document_types_id from field
  sql_attr_multi = uint roles_id from field
  sql_query_info = SELECT * FROM `requests` WHERE `id` = (($id - 4) / 7)
}