deploy@staging:~/apps/tapeonline/current/config$ cat staging.sphinx.conf
indexer
{
}

searchd
{
  listen = 127.0.0.1:9312
  log = /home/deploy/apps/tapeonline/releases/20100310192302/log/searchd.log
  query_log = /home/deploy/apps/tapeonline/releases/20100310192302/log/searchd.query.log
  pid_file = /home/deploy/apps/tapeonline/releases/20100310192302/log/searchd.staging.pid
}

source content_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = *******
  sql_pass = ******
  sql_db = *****_staging
  sql_query_pre = UPDATE `contents` SET `delta` = 0 WHERE `delta` = 1
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `contents`.`id` * 2 + 0 AS `id` , `contents`.`title` AS `title`, `contents`.`description` AS `description`, `contents`.`content` AS `content`, GROUP_CONCAT(DISTINCT IFNULL(`questions`.`value`, '0') SEPARATOR ' ') AS `questions_value`, GROUP_CONCAT(DISTINCT IFNULL(`questions`.`answer`, '0') SEPARATOR ' ') AS `questions_answer`, `contents`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`contents`.`type`,'')), 829950261) AS UNSIGNED) AS `class_crc`, '684805311,3448190970,3023575326,829950261' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `contents`    LEFT OUTER JOIN `questions` ON questions.faq_page_id = contents.id  WHERE `contents`.`id` >= $start AND `contents`.`id` <= $end AND `contents`.`delta` = 0 GROUP BY `contents`.`id`, `contents`.`type`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `contents` WHERE `contents`.`delta` = 0
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `contents` WHERE `id` = (($id - 0) / 2)
}

index content_core
{
  source = content_core_0
  path = /home/deploy/apps/tapeonline/releases/20100310192302/db/sphinx/staging/content_core
  charset_type = utf-8
  min_infix_len = 3
}

source content_delta_0 : content_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = *******
  sql_pass = ******
  sql_db = *****_staging
  sql_query_pre =
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `contents`.`id` * 2 + 0 AS `id` , `contents`.`title` AS `title`, `contents`.`description` AS `description`, `contents`.`content` AS `content`, GROUP_CONCAT(DISTINCT IFNULL(`questions`.`value`, '0') SEPARATOR ' ') AS `questions_value`, GROUP_CONCAT(DISTINCT IFNULL(`questions`.`answer`, '0') SEPARATOR ' ') AS `questions_answer`, `contents`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`contents`.`type`,'')), 829950261) AS UNSIGNED) AS `class_crc`, '684805311,3448190970,3023575326,829950261' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `contents`    LEFT OUTER JOIN `questions` ON questions.faq_page_id = contents.id  WHERE `contents`.`id` >= $start AND `contents`.`id` <= $end AND `contents`.`delta` = 1 GROUP BY `contents`.`id`, `contents`.`type`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `contents` WHERE `contents`.`delta` = 1
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `contents` WHERE `id` = (($id - 0) / 2)
}

index content_delta : content_core
{
  source = content_delta_0
  path = /home/deploy/apps/tapeonline/releases/20100310192302/db/sphinx/staging/content_delta
}

index content
{
  type = distributed
  local = content_delta
  local = content_core
}

source product_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = *******
  sql_pass = ******
  sql_db = *****_staging
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `products`.`id` * 2 + 1 AS `id` , `products`.`id` AS `id`, `products`.`model` AS `model`, `products`.`part_number` AS `part_number`, `products`.`markup_description` AS `markup_description`, `products`.`invoice_description` AS `invoice_description`, `products`.`text_description` AS `text_description`, `products`.`internal_reference` AS `internal_reference`, `products`.`state` AS `state`, GROUP_CONCAT(DISTINCT IFNULL(CONCAT_WS(' ', `descriptor_options`.`value`, `units`.`name`), '0') SEPARATOR ' ') AS `specification_descriptor_value`, `brands`.`name` AS `brand`, `classifications`.`name` AS `classification`, GROUP_CONCAT(DISTINCT IFNULL(`categories`.`name`, '0') SEPARATOR ' ') AS `category`, `products`.`id` AS `sphinx_internal_id`, 485965105 AS `class_crc`, '485965105' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`brands`.`name`, '') AS `brand_sort`, IFNULL(`classifications`.`name`, '') AS `classification_sort` FROM `products`    LEFT OUTER JOIN `categorizations` ON (`products`.`id` = `categorizations`.`product_id`)  LEFT OUTER JOIN `specifications` ON (`specifications`.`categorization_id` = `categorizations`.`id`)   LEFT OUTER JOIN `descriptor_options` ON `descriptor_options`.id = `specifications`.descriptor_option_id   LEFT OUTER JOIN `units` ON `units`.id = `descriptor_options`.unit_id   LEFT OUTER JOIN `brands` ON `brands`.id = `products`.brand_id   LEFT OUTER JOIN `classifications` ON `classifications`.id = `products`.classification_id   LEFT OUTER JOIN `categorizations` categories_products_join ON (`products`.`id` = `categories_products_join`.`product_id`)  LEFT OUTER JOIN `categories` ON (`categories`.`id` = `categories_products_join`.`category_id`)  WHERE `products`.`id` >= $start AND `products`.`id` <= $end GROUP BY `products`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `products`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_str2ordinal = brand_sort
  sql_attr_str2ordinal = classification_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `products` WHERE `id` = (($id - 1) / 2)
}

index product_core
{
  source = product_core_0
  path = /home/deploy/apps/tapeonline/releases/20100310192302/db/sphinx/staging/product_core
  charset_type = utf-8
  min_infix_len = 3
}

index product
{
  type = distributed
  local = product_core
}