indexer
{
}

searchd
{
  address = 127.0.0.1
  port = 3312
  log = /home/modest/Desktop/infochimps/koko/log/searchd.log
  query_log = /home/modest/Desktop/infochimps/koko/log/searchd.query.log
  pid_file = /home/modest/Desktop/infochimps/koko/log/searchd.development.pid
}

source note_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `notes`.`id` * 7 + 0 AS `id` , CAST(`notes`.`title` AS CHAR) AS `title`, CAST(`notes`.`body` AS CHAR) AS `body`, `notes`.`id` AS `sphinx_internal_id`, 1871664426 AS `class_crc`, '1871664426' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`notes`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`notes`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`notes`.`updated_at`) AS `updated_at` FROM `notes`    WHERE `notes`.`id` >= $start AND `notes`.`id` <= $end GROUP BY `notes`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `notes`
  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 `notes` WHERE `id` = (($id - 0) / 7)
}

index note_core
{
  source = note_core_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/note_core
  morphology = stem_en
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

index note
{
  type = distributed
  local = note_core
}

source category_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre = UPDATE `categories` SET `delta` = 0 WHERE `delta` = 1
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `categories`.`id` * 7 + 1 AS `id` , CAST(`categories`.`title` AS CHAR) AS `title`, `categories`.`id` AS `sphinx_internal_id`, 4282022807 AS `class_crc`, '4282022807' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`categories`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`categories`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`categories`.`updated_at`) AS `updated_at`, `categories`.`datasets_count` AS `datasets_count` FROM `categories`    WHERE `categories`.`id` >= $start AND `categories`.`id` <= $end AND `categories`.`delta` = 0 GROUP BY `categories`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `categories` WHERE `categories`.`delta` = 0
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = datasets_count
  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 `categories` WHERE `id` = (($id - 1) / 7)
}

index category_core
{
  source = category_core_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/category_core
  morphology = stem_en
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

source category_delta_0 : category_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre =
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `categories`.`id` * 7 + 1 AS `id` , CAST(`categories`.`title` AS CHAR) AS `title`, `categories`.`id` AS `sphinx_internal_id`, 4282022807 AS `class_crc`, '4282022807' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`categories`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`categories`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`categories`.`updated_at`) AS `updated_at`, `categories`.`datasets_count` AS `datasets_count` FROM `categories`    WHERE `categories`.`id` >= $start AND `categories`.`id` <= $end AND `categories`.`delta` = 1 GROUP BY `categories`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `categories` WHERE `categories`.`delta` = 1
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = datasets_count
  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 `categories` WHERE `id` = (($id - 1) / 7)
}

index category_delta : category_core
{
  source = category_delta_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/category_delta
}

index category
{
  type = distributed
  local = category_delta
  local = category_core
}

source source_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre = UPDATE `sources` SET `delta` = 0 WHERE `delta` = 1
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `sources`.`id` * 7 + 2 AS `id` , CAST(`sources`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, CAST(`sources`.`main_link` AS CHAR) AS `main_link`, `sources`.`id` AS `sphinx_internal_id`, 1478916677 AS `class_crc`, '1478916677' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`sources`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`sources`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`sources`.`updated_at`) AS `updated_at` FROM `sources`    LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `sources`.id AND `slugs`.sluggable_type = 'Source'  LEFT OUTER JOIN `notes` ON `notes`.item_id = `sources`.id AND `notes`.item_type = 'Source' WHERE `sources`.`id` >= $start AND `sources`.`id` <= $end AND `sources`.`delta` = 0 GROUP BY `sources`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `sources` WHERE `sources`.`delta` = 0
  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 `sources` WHERE `id` = (($id - 2) / 7)
}

index source_core
{
  source = source_core_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/source_core
  morphology = stem_en
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

source source_delta_0 : source_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre =
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `sources`.`id` * 7 + 2 AS `id` , CAST(`sources`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, CAST(`sources`.`main_link` AS CHAR) AS `main_link`, `sources`.`id` AS `sphinx_internal_id`, 1478916677 AS `class_crc`, '1478916677' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`sources`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`sources`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`sources`.`updated_at`) AS `updated_at` FROM `sources`    LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `sources`.id AND `slugs`.sluggable_type = 'Source'  LEFT OUTER JOIN `notes` ON `notes`.item_id = `sources`.id AND `notes`.item_type = 'Source' WHERE `sources`.`id` >= $start AND `sources`.`id` <= $end AND `sources`.`delta` = 1 GROUP BY `sources`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `sources` WHERE `sources`.`delta` = 1
  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 `sources` WHERE `id` = (($id - 2) / 7)
}

index source_delta : source_core
{
  source = source_delta_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/source_delta
}

index source
{
  type = distributed
  local = source_delta
  local = source_core
}

source dataset_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 2modest2
  sql_db = modest_dev
  sql_port = 3306
  sql_query_pre = UPDATE `datasets` SET `delta` = 0 WHERE `delta` = 1
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `datasets`.`id` * 7 + 3 AS `id` , CAST(`datasets`.`title` AS CHAR) AS `title`, CAST(`datasets`.`subtitle` AS CHAR) AS `subtitle`, CAST(`datasets`.`main_link` AS CHAR) AS `main_link`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, CAST(GROUP_CONCAT(DISTINCT `categories`.`title` SEPARATOR ' ') AS CHAR) AS `category`, CAST(GROUP_CONCAT(DISTINCT `tags`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `sources`.`title` SEPARATOR ' ') AS CHAR) AS `source_title`, `datasets`.`id` AS `sphinx_internal_id`, 2015197260 AS `class_crc`, '2015197260' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`datasets`.`title`, '') AS `title_sort`, GROUP_CONCAT(DISTINCT IFNULL(`categories`.`title`, '') SEPARATOR ' ') AS `category_sort`, GROUP_CONCAT(DISTINCT IFNULL(`tags`.`name`, '') SEPARATOR ' ') AS `name_sort`, GROUP_CONCAT(DISTINCT IFNULL(`sources`.`title`, '') SEPARATOR ' ') AS `source_title_sort`, `datasets`.`cached_score` AS `cached_score`, UNIX_TIMESTAMP(`datasets`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`datasets`.`updated_at`) AS `updated_at` FROM `datasets`    LEFT OUTER JOIN `notes` ON `notes`.item_id = `datasets`.id AND `notes`.item_type = 'Dataset'  LEFT OUTER JOIN `categorizations` ON (`datasets`.`id` = `categorizations`.`dataset_id`)  LEFT OUTER JOIN `categories` ON (`categories`.`id` = `categorizations`.`category_id`)   LEFT OUTER JOIN `taggings` ON (`datasets`.`id` = `taggings`.`taggable_id` AND `taggings`.`taggable_type` = 'Dataset')  LEFT OUTER JOIN `tags` ON (`tags`.`id` = `taggings`.`tag_id`)   LEFT OUTER JOIN `credits` ON (`datasets`.`id` = `credits`.`dataset_id`)  LEFT OUTER JOIN `sources` ON (`sources`.`id` = `credits`.`source_id`)  WHERE `datasets`.`id` >= $start AND `datasets`.`id` <= $end AND `datasets`.`delta` = 0 GROUP BY `datasets`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `datasets` WHERE `datasets`.`delta` = 0
  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_str2ordinal = category_sort
  sql_attr_str2ordinal = name_sort
  sql_attr_str2ordinal = source_title_sort
  sql_attr_float = cached_score
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `datasets` WHERE `id` = (($id - 3) / 7)
}

index dataset_core
{
  source = dataset_core_0
  path = /home/modest/Desktop/infochimps/koko/db/sphinx/development/dataset_core
  morphology = stem_en
  charset_type = utf-8
  min_infix_len %