We organize relevant search across heterogeneous data using Sphinx

In one of the current projects, there was a problem of searching for data of different types, which was successfully solved with the help of the proven search engine Sphinx , but first things first.

Formulation of the problem

The project currently has 2 zones:

geographical area implemented on the basis of Google Maps, which displays geographic objects plotted by users on the map (markers, routes and areas);
information zone, which is a large hierarchically organized catalog containing information materials.

It was necessary to solve the problem of simultaneous text search by 3 types of objects: geographical objects, categories of the information zone and materials of the information zone - with the ability to filter by the date of publication of the objects and the categories to which they belong.

The solution of the problem

The entire solution is described for PHP5 (Symfony), MySQL, Sphinx. How to put Sphinx , I will not describe, this information can be read on the official site. Let me just say that under Mac OS X it is easy to install using macports .
We have such a database model (I simplified it so that it was closer to the point) with some set of records:

Configuring sphinx to index and display search results:

#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .
#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 .

A little more detail about the configuration options. The source sections, as the name implies, define the data warehouses from which the information indexed by Sphinx will be retrieved. Such storages can be databases, text files, html-files, xml and even mailboxes. This section also describes which storage fields will be indexed, in which format indexing will be performed (one-time or portion-sampling) and a number of other parameters. In my case 3 source is described, they all lead to the same MySQL database, but to different tables.
Configuration formats are similar, I will describe the source article .

sql_query_range = SELECT MIN (id), MAX (id) FROM article
sql_range_step = 500
* This source code was highlighted with Source Code Highlighter .

With these lines, we “tell” Sphinx to make a selection from a table not with a full select, but in portions of 500 records in order not to create an excessive load during indexing.

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
* This source code was highlighted with Source Code Highlighter .

This is the request mask sent by Sphinx when indexing data. Here 3 points are important:

The set of fields for indexing is determined, in our case these are id, text fields and filter fields;
The first field is used by Sphinx as id in the generated index. Because id from different tables can match, then this method of forming a unique id is applied;
The row_type field allows you to determine what type each of the saved records in the Sphinx index is.

Next comes a description of attributes that can be used as filters.

sql_attr_uint = category_id
sql_attr_uint = row_type
sql_attr_timestamp = created_at
* This source code was highlighted with Source Code Highlighter .

Well, the last parameter is the request mask, which will retrieve the information we need by the found id:

sql_query_info = SELECT title, descr \
FROM geo_object WHERE id = ($ id - 1) / 10
* This source code was highlighted with Source Code Highlighter .

Next, the most important thing in the configuration file is the indexing parameters of the sources we specified using the index section.

source = category
source = geo_object
source = article
* This source code was highlighted with Source Code Highlighter .

A very important point - the index can be formed from several sources. As shown above, the data from the three tables is merged into the index. Imagine how you would have to sweat to organize such a search using the database! Here we can just make a query to a given index, while getting its ranked results.

By lines

path = / var / data / sphinx / site_search
docinfo = extern
* This source code was highlighted with Source Code Highlighter .

specify the storage parameters of the index and the full path to it.
')
What is another feature of Sphinx - it “out of the box” supports English and Russian morphology, allowing you to bring the query words to normal form. If necessary, this functionality can be expanded .

morphology = stem_en, stem_ru
* This source code was highlighted with Source Code Highlighter .

The remaining three parameters are responsible for cutting html-tags, the encoding of the index and the minimum word length, respectively.

Then it remains only to start the indexing.

muxx: ~ muxx $ sudo searchd --stop
Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf' ...
stop: succesfully sent SIGTERM to pid 5677
muxx: ~ muxx $ sudo indexer - all
Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf' ...
indexing index 'site_search' ...
collected 759 docs, 0.0 MB
sorted 0.0 Mhits, 100.0% done
total 759 docs, 22171 bytes
total 0.028 sec, 785871.25 bytes / sec, 26903.45 docs / sec
muxx: ~ muxx $ sudo searchd
Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf' ...
creating server socket on 127.0.0.1:3312
muxx: ~ muxx $ search my complex query
Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf' ...
index 'site_search' : query 'my complex query' : returned 0 matches of 0 total in 0.000 sec
words:
1. 'mo' : 0 documents, 0 hits
2. 'complex' : 0 documents, 0 hits
3. 'request' : 0 documents, 0 hits
muxx: ~ muxx $
* This source code was highlighted with Source Code Highlighter .

In the listing above, we first stop the daemon in case it is running. Then we perform indexing. You can see how fast the indexing rate of Sphinx is.

// The comments suggested that you can index without stopping the daemon with sudo indexer --rotate --all .

Then we start the daemon and perform a test request. Sphinx shows how it breaks a query and normalizes words in it. In my example, it worked fine, but did not find anything :)

Once you have verified that the daemon is working, you can work with Sphinx from symfony.
Install the sfSphinxPlugin plugin, connect it in the configurations:

$ this-> enablePlugins ( array ( 'sfSphinxPlugin' ));
* This source code was highlighted with Source Code Highlighter .

and write a small example of the request to the daemon:

$ sphinx = new sfSphinxClient ($ options);
// set numeric filters if they are set
if ($ request-> getParameter ( 'category_id' ))
$ sphinx-> setFilter ( 'category_id' , array ($ request-> getParameter ( 'category_id' )));
if ($ request-> getParameter ( 'row_type' ))
$ sphinx-> setFilter ( 'row_type' , array ($ request-> getParameter ( 'row_type' )));
$ dateRange = $ request-> getParameter ( 'date' );
if ($ dateRange [ 'from' ] || $ dateRange [ 'to' ])
{
$ sphinx-> setFilterRange ( 'created_at' ,
! empty ($ dateRange [ 'from' ])? strtotime ($ dateRange [ 'from' ]): '' ,
! empty ($ dateRange [ 'to' ])? strtotime ($ dateRange [ 'to' ]): '' );
}
$ this -> results = $ sphinx-> Query ($ request-> getParameter ( 's' ), 'site_search' );
if ($ this -> results === false )
{
$ this -> message = 'Request failed:' . $ sphinx-> GetLastError ();
}
else
// if everything is by, then we get information on the index id
// and output it to the template
$ this -> items = $ this -> retrieveResultRows ($ this -> results);
* This source code was highlighted with Source Code Highlighter .

I hope, from my description, you can appreciate all the delights of Sphinx, I didn’t talk about all of its capabilities;

PS: A request to those who have enough karma - create a blog Sphinx, I would transfer the article there.

PS2: Thank you everyone! Blog created, topic moved there.

Source: https://habr.com/ru/post/47908/

All Articles

We organize relevant search across heterogeneous data using Sphinx

Formulation of the problem

The solution of the problem

More articles: