gistfile1.txt

root@ip-10-0-0-130:/home/ubuntu/Rails_App/projectx/config# less development.sphinx.conf
indexer
{
}

searchd
{
  listen = 127.0.0.1:9312
  log = C:/Users/CEO/My Documents/Aptana Studio Workspace/ProjectX/log/searchd.log
  query_log = C:/Users/CEO/My Documents/Aptana Studio Workspace/ProjectX/log/searchd.query.log
  pid_file = C:/Users/CEO/My Documents/Aptana Studio Workspace/ProjectX/log/searchd.development.pid
}

source voteled_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = lumpi77
  sql_db = Project_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `voteleds`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `questions`.`question_text` AS `question_title`, `voteleds`.`author` AS `author`, `voteleds`.`publish_status` AS `publish_status`, `voteleds`.`popularity` AS `popularity`, `voteleds`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 939128741 AS `class_crc`, IFNULL('Voteled', '') AS `sphinx_internal_class`, IFNULL(`voteleds`.`popularity`, '') AS `popularity_sort` FROM `voteleds`    LEFT OUTER JOIN `questions` ON questions.voteled_id = voteleds.id  WHERE `voteleds`.`id` >= $start AND `voteleds`.`id` <= $end GROUP BY `voteleds`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `voteleds`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_attr_str2ordinal = sphinx_internal_class
  sql_attr_str2ordinal = popularity_sort
  sql_query_info = SELECT * FROM `voteleds` WHERE `id` = (($id - 0) / 1)
}


index voteled_core
{
  path = C:/Users/CEO/My Documents/Aptana Studio Workspace/ProjectX/db/sphinx/development/voteled_core
  charset_type = utf-8
  source = voteled_core_0
}

index voteled
{
  type = distributed
  local = voteled_core
}