Clever Geek Handbook

Sphinxを使用して、異種データ間で関連する検索を整理する

現在のプロジェクトの1つで、さまざまな種類のデータを検索するタスクが発生しました。これは、実績のあるSphinx検索エンジンの助けを借りて正常に解決されましたが、最初に最初に行う必要があります。

問題の声明



プロジェクトには現在2つのゾーンがあります。
  1. Googleマップに基づいて実装された地理的領域。ユーザーが地図上に配置した地理的特徴（マーカー、ルート、および領域）を表示します。
  2. 情報ゾーン。これは、情報資料を含む階層的に構成された大きなディレクトリです。
地理オブジェクト、情報ゾーンカテゴリ、情報ゾーン資料の3種類のオブジェクトによる同時テキスト検索の問題を解決する必要がありました。オブジェクトの公開日と関連するカテゴリでフィルタリングする機能が必要です。



問題解決



ソリューション全体は、PHP5（Symfony）、MySQL、Sphinxの束について説明されています。 Sphinxのインストール方法については説明しません。この情報は公式Webサイトで読むことができます。 Mac OS Xではmacportsを使用して簡単にインストールできるとしか言えません。

いくつかのレコードのセットを備えたこのようなデータベースモデルがあります（ポイントに近づくように単純化しました）。

検索結果のインデックス作成と表示のためにsphinxを構成します。

#articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  1. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  2. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  3. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  4. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  5. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  6. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  7. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  8. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  9. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  10. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  11. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  12. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  13. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  14. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  15. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  16. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  17. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  18. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  19. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  20. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  21. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  22. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  23. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  24. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  25. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  26. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  27. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  28. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  29. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  30. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  31. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  32. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  33. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  34. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  35. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  36. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  37. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  38. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  39. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  40. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  41. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  42. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  43. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  44. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  45. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  46. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  47. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  48. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  49. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  50. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  51. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  52. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  53. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  54. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  55. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  56. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  57. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  58. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  59. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  60. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  61. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  62. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  63. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  65. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  66. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  67. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  68. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  69. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  70. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



  71. #articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .



#articles source article { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = ili_lv sql_sock = /tmp/mysql/mysql.sock sql_query_range = SELECT MIN (id), MAX (id) FROM article sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 1 as id, category_id, 1 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM article WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM article WHERE id = ($id - 1) / 10 } #categories source category { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM category sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 2 as id, tree_parent as category_id, 2 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM category WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM category WHERE id = ($id - 2) / 10 } #geo_objects source geo_object { # #... sql_query_range = SELECT MIN (id), MAX (id) FROM geo_object sql_range_step = 500 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT id * 10 + 3 as id, 0 as category_id, 3 as row_type,\ UNIX_TIMESTAMP(created_at) as created_at, title, descr \ FROM geo_object WHERE id >= $ start AND id <= $ end sql_attr_uint = category_id sql_attr_uint = row_type sql_attr_timestamp = created_at sql_query_info = SELECT title, descr \ FROM geo_object WHERE id = ($id - 3) / 10 } index site_search { source = category source = geo_object source = article path = /var/ data /sphinx/site_search docinfo = extern morphology = stem_en, stem_ru html_strip = 0 charset_type = utf-8 min_word_len = 2 } * This source code was highlighted with Source Code Highlighter .





設定オプションについてもう少し。 ソースセクションは、その名前が示すように、Sphinxインデックス付き情報が取得されるデータストアを指定します。 このようなリポジトリは、データベース、テキストファイル、htmlファイル、xml、さらにはメールボックスです。 このセクションでは、どのストレージフィールドにインデックスが作成されるか、どの形式のインデックス作成が実行されるか（単一またはバッチサンプリング）、およびその他の多くのパラメーターについても説明します。 私の場合、3つのソースが記述されており、それらはすべて同じMySQLデータベースにつながりますが、異なるテーブルにつながります。

構成フォーマットは似ています。 ソース記事を説明します 。





  1. sql_query_range = SELECT MIN （id）、 MAX （id） FROM article
  2. sql_range_step = 500
*このソースコードは、 ソースコードハイライターで強調表示されました。
これらの行を使用して、インデックス作成中に過度の負荷が発生しないように、Sphinxが全選択ではなく500レコードの部分ごとにテーブルから選択するように「伝えます」。







  1. sql_query = \
  2. SELECT id * 10 + 1 は id、category_id、1 は row_type、\
  3. UNIX_TIMESTAMP（created_at）created_at、title、descr \
  4. FROM記事WHERE id> = $ start AND id <= $ end
*このソースコードは、 ソースコードハイライターで強調表示されました。
これは、データのインデックス作成時にSphinxによって送信されるリクエストのマスクです。 ここでは3つのポイントが重要です。



以下は、フィルターとして使用できる属性の説明です。




  1. sql_attr_uint = category_id
  2. sql_attr_uint = row_type
  3. sql_attr_timestamp = created_at
*このソースコードは、 ソースコードハイライターで強調表示されました。


さて、最後のパラメーターはリクエストマスクで、見つかったIDによって必要な情報を取得します。




  1. sql_query_info = SELECTタイトル、descr \
  2. FROM geo_object WHERE id =（$ id-1）/ 10
*このソースコードは、 ソースコードハイライターで強調表示されました。


さらに、構成ファイルで最も重要なものが記述されています- インデックスセクションの助けを借りて、示されたソースのインデックスパラメータ。




  1. ソース=カテゴリ
  2. ソース= geo_object
  3. ソース=記事
*このソースコードは、 ソースコードハイライターで強調表示されました。


非常に重要なポイント-インデックスは複数のソースから作成できます。 上記のように、3つのテーブルのデータはインデックスにマージされます。 データベースを使用してこのような検索を整理するために汗をかかなければならないことを想像してください！ ここでは、ランク付けされた結果を受け取りながら、このインデックスにリクエストを行うことができます。



行





  1. パス = / var / data / sphinx / site_search
  2. docinfo = extern
*このソースコードは、 ソースコードハイライターで強調表示されました。
インデックスとそのフルパスを保存するためのパラメータが示されています。



もう1つのSphinxの魅力は、英語とロシア語の「すぐに使える」形態をサポートし、クエリ語を通常の形式に変換できることです。 必要に応じて、この機能を拡張できます 。




  1. 形態= stem_en、stem_ru
*このソースコードは、 ソースコードハイライターで強調表示されました。


残りの3つのパラメーターは、それぞれhtmlタグ、インデックスエンコーディング、最小単語長を切り取る役割を果たします。



さらに、インデックス作成を開始するだけです。




  1. muxx：〜muxx $ sudo searchd --stop
  2. Sphinx 0.9.8.1-リリース（r1533）
  3. 著作権（c）2001-2008、Andrew Aksyonoff
  4. 設定ファイル 「/usr/local/etc/sphinx.conf」 を使用して ...
  5. 停止：SIGTERM を pid 5677に正常に送信しました
  6. muxx：〜muxx $ sudoインデクサー- すべて
  7. Sphinx 0.9.8.1-リリース（r1533）
  8. 著作権（c）2001-2008、Andrew Aksyonoff
  9. 設定ファイル 「/usr/local/etc/sphinx.conf」 を使用して ...
  10. インデックス作成インデックス 'site_search' ...
  11. 収集された759ドキュメント、0.0 MB
  12. ソートされた0.0 Mhits、100.0％完了
  13. 合計759ドキュメント、22171バイト
  14. 合計0.028秒、785871.25バイト/秒、26903.45ドキュメント/秒
  15. muxx：〜muxx $ sudo searchd
  16. Sphinx 0.9.8.1-リリース（r1533）
  17. 著作権（c）2001-2008、Andrew Aksyonoff
  18. 設定ファイル 「/usr/local/etc/sphinx.conf」 を使用して ...
  19. 127.0.0.1:3312にサーバーソケットを作成
  20. muxx：〜muxx $複雑なクエリを検索
  21. Sphinx 0.9.8.1-リリース（r1533）
  22. 著作権（c）2001-2008、Andrew Aksyonoff
  23. 設定ファイル 「/usr/local/etc/sphinx.conf」 を使用して ...
  24. インデックス 'site_search' ：クエリ'my complex query' ：合計0.000秒で 0の一致が 0個返されました
  25. 言葉：
  26. 1. 'mo' ：0ドキュメント、0ヒット
  27. 2. 'hard' ：0ドキュメント、0ヒット
  28. 3. 「リクエスト」 ：0ドキュメント、0ヒット
  29. muxx：〜muxx $
*このソースコードは、 ソースコードハイライターで強調表示されました。


上記のリストでは、実行中のデーモンを最初に停止します。 次に、インデックス作成を実行します。 Sphinxのインデックス作成速度がどれほど速いかがわかります。



//コメントは、 sudoインデクサー--rotate --allコマンドでデーモンを停止せずにインデックスを作成できることを示唆しています。



次に、デーモンを実行し、テスト要求を実行します。 Sphinxは、クエリを分割し、その中の単語を正規化する方法を示します。 私の例では、うまくいきましたが、何も見つかりませんでした:)



デーモンが動作していることを確認したら、SymfonyからSphinxを操作できます。

sfSphinxPluginプラグインをインストールし、設定で接続します：





  1. $ this-> enablePlugins（ array （ 'sfSphinxPlugin' ））;
*このソースコードは、 ソースコードハイライターで強調表示されました。


デーモンに小さなリクエストの例を書きます：




  1. $ sphinx = new sfSphinxClient（$オプション）;
  3. //数値フィルタを設定します（設定されている場合）
  4. if （$ request-> getParameter（ 'category_id' ））
  5. $ sphinx-> setFilter（ 'category_id' 、array（$ request-> getParameter（ 'category_id' ）））;
  6. if （$ request- > getParameter（ 'row_type' ））
  7. $ sphinx-> setFilter（ 'row_type' 、array（$ request- > getParameter（ 'row_type' ）））;
  8. $ dateRange = $ request-> getParameter（ 'date' ）;
  9. if （$ dateRange [ 'from' ] || $ dateRange [ 'to' ]）
  10. {
  11. $ sphinx-> setFilterRange（ ' created_at ' 、
  12. ！empty（$ dateRange [ 'from' ]）？ strtotime（$ dateRange [ 'from' ]）： '' 、
  13. ！empty（$ dateRange [ 'to' ]）？ strtotime（$ dateRange [ 'to' ]）： '' ）;
  14. }
  15. $ this-> results = $ sphinx-> Query（$ request-> getParameter（ 's' ）、 'site_search' ）;
  16. if （$ this-> results === false ）
  17. {
  18. $ this- > message = 'Request failed：' 。 $ sphinx-> GetLastError（）;
  19. }
  20. 他に
  21. //すべてが妨げられている場合、インデックスのIDに関する情報を取得します
  22. //そしてテンプレートに出力します
  23. $ this-> items = $ this-> retrieveResultRows（$ this-> results）;
*このソースコードは、 ソースコードハイライターで強調表示されました。


私の説明から、Sphinxのすべての魅力を理解できることを願っています。すべての機能については説明しませんでした。



PS：十分なカルマを持っている人へのリクエスト-Sphinxブログを作成し、そこに記事を転送します。



PS2：みんなありがとう！ ブログが作成され、トピックがそこに移動します。


More articles:


All Articles