MacBook-Konstantin-Tumalevich:ipups userad$ cat config/development.sphinx.conf
indexer
{
}

searchd
{
  address = 127.0.0.1
  port = 3214
  log = /Users/userad/proj/ipups/log/searchd.log
  query_log = /Users/userad/proj/ipups/log/searchd.query.log
  pid_file = /Users/userad/proj/ipups/log/searchd.development.pid
}

source announce_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = ipups_development2
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `announces`.`id` * 4 + 0 AS `id` , CAST(`announces`.`title` AS CHAR) AS `title`, CAST(`announces`.`content` AS CHAR) AS `content`, `announces`.`id` AS `sphinx_internal_id`, 530628387 AS `class_crc`, '530628387' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`announces`.`title`, '') AS `title_sort` FROM `announces`    WHERE `announces`.`id` >= $start AND `announces`.`id` <= $end GROUP BY `announces`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `announces`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_str2ordinal = title_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `announces` WHERE `id` = (($id - 0) / 4)
}

index announce_core
{
  source = announce_core_0
  path = /Users/userad/proj/ipups/db/sphinx/development/announce_core
  charset_type = utf-8
}

index announce
{
  type = distributed
  local = announce_core
}

source article_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = ipups_development2
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `articles`.`id` * 4 + 1 AS `id` , CAST(`articles`.`title` AS CHAR) AS `title`, CAST(`articles`.`content` AS CHAR) AS `content`, `articles`.`id` AS `sphinx_internal_id`, 3448190970 AS `class_crc`, '3448190970' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`articles`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`articles`.`updated_at`) AS `updated_at` FROM `articles`    WHERE `articles`.`id` >= $start AND `articles`.`id` <= $end GROUP BY `articles`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `articles`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `articles` WHERE `id` = (($id - 1) / 4)
}

index article_core
{
  source = article_core_0
  path = /Users/userad/proj/ipups/db/sphinx/development/article_core
  charset_type = utf-8
}

index article
{
  type = distributed
  local = article_core
}

source contest_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = ipups_development2
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `contests`.`id` * 4 + 2 AS `id` , CAST(`contests`.`title` AS CHAR) AS `title`, CAST(`contests`.`content` AS CHAR) AS `content`, `contests`.`id` AS `sphinx_internal_id`, 3457443113 AS `class_crc`, '3457443113' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`contests`.`title`, '') AS `title_sort` FROM `contests`    WHERE `contests`.`id` >= $start AND `contests`.`id` <= $end GROUP BY `contests`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `contests`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_str2ordinal = title_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `contests` WHERE `id` = (($id - 2) / 4)
}

index contest_core
{
  source = contest_core_0
  path = /Users/userad/proj/ipups/db/sphinx/development/contest_core
  charset_type = utf-8
}

index contest
{
  type = distributed
  local = contest_core
}

source ihelpers_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = ipups_development2
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `ihelpers`.`id` * 4 + 3 AS `id` , CAST(`ihelpers`.`title` AS CHAR) AS `title`, CAST(`ihelpers`.`content` AS CHAR) AS `content`, `ihelpers`.`id` AS `sphinx_internal_id`, 510956077 AS `class_crc`, '510956077' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`ihelpers`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`ihelpers`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`ihelpers`.`updated_at`) AS `updated_at` FROM `ihelpers`    WHERE `ihelpers`.`id` >= $start AND `ihelpers`.`id` <= $end GROUP BY `ihelpers`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `ihelpers`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_str2ordinal = title_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `ihelpers` WHERE `id` = (($id - 3) / 4)
}

index ihelpers_core
{
  source = ihelpers_core_0
  path = /Users/userad/proj/ipups/db/sphinx/development/ihelpers_core
  charset_type = utf-8
}

index ihelpers
{
  type = distributed
  local = ihelpers_core
}