searchd
{
	listen      = 9312
	listen      = 9306:mysql41
	pid_file    = f:/sphinx/data/searchd.pid
	log         = f:/sphinx/data/log/log.txt
	query_log   = f:/sphinx/data/log/query_log.txt
	binlog_path = f:/sphinx/data/binlog/

	read_timeout  = 5
	max_children  = 30
	seamless_rotate  = 1
	preopen_indexes  = 1
	unlink_old  = 1
	workers   = threads # for RT to work
}

common{
	lemmatizer_base = f:/projects/book24/search/sphinx/data/dicts/
}

indexer{
	# Максимальный лимит используемой памяти RAM
	mem_limit = 512M
}

source book24{
	# Параметры подключения к БД
	type = mysql
	sql_host = localhost
	sql_user = root
	sql_pass =
	sql_db = b24
	sql_port = 3306

	# Установим кодировку для работы с БД
	sql_query_pre = SET NAMES utf8
	sql_query_pre = SET CHARACTER SET utf8

	# Запрос выборки данных для индексации
	sql_query = SELECT \
ELEMENT.ID as ID,\
ELEMENT.ID as ELEMENT_ID,\
ELEMENT.NAME as ELEMENT_NAME,\
(SELECT GROUP_CONCAT(b_iblock_section_element.IBLOCK_SECTION_ID) FROM b_iblock_section_element  WHERE b_iblock_section_element.IBLOCK_ELEMENT_ID=ELEMENT.ID) as IBLOCK_SECTION_ID_COMB,\
ELEMENT_SECTION.NAME as ELEMENT_IBLOCK_SECTION_NAME,\
ELEMENT_SECTION.CODE as ELEMENT_IBLOCK_SECTION_CODE,\
ELEMENT.DETAIL_TEXT as ELEMENT_DETAIL_TEXT,\
ELEMENT.PREVIEW_TEXT as ELEMENT_PREVIEW_TEXT,\
ELEMENT.CODE as ELEMENT_CODE,\
ELEMENT.XML_ID as ELEMENT_XML_ID,\
ELEMENT.TAGS as ELEMENT_TAGS,\
ELEMENT_PRICE.PRICE as ELEMENT_PRICE,\
ELEMENT.DETAIL_PICTURE as ELEMENT_DETAIL_PICTURE,\
AUTHOR_TITLE_PROP.VALUE as AUTHOR_TITLE,\
SERIES_PROP_ID.VALUE as SERIES_ID,\
SERIES_ELEMENT.NAME as SERIES_NAME,\
SERIES_ELEMENT.CODE as SERIES_CODE,\
PUBL_PROP_ID.VALUE as PUBL_ID,\
PUBL_ELEMENT.NAME as PUBL_NAME,\
PUBL_ELEMENT.CODE as PUBL_CODE,\
AVAILABLE_PROP.VALUE as AVAILABLE_VALUE_ID,\
PREDZAKAZ_PROP.VALUE as PREDZAKAZ_VALUE_ID,\
FRAGMENT_PROP.VALUE as FRAGMENT_VALUE_ID,\
SELECTIONS.IBLOCK_ELEMENT_ID as SELECTIONS_ELEMENT_ID,\
SELECTIONS_ELEMENT.NAME as SELECTIONS_ELEMENT_NAME,\
NOMCODE.VALUE as NOMCODE,\
SALE_CLOSE_PROP.VALUE as SALE_CLOSE_VALUE,\
SALELEADER_PROP.VALUE as SALELEADER_VALUE_ID,\
SPECIALOFFER_PROP.VALUE as SPECIALOFFER_VALUE_ID,\
AUTOGRAPH_PROP.VALUE as AUTOGRAPH_VALUE_ID,\
CRC32(AGE_LIMIT_PROP.VALUE) as AGE_LIMIT_CRC32,\
AGE_LIMIT_PROP.VALUE as AGE_LIMIT,\
FOR_KIDS_PROP.VALUE as FOR_KIDS_VALUE_ID,\
EXAM_PROP.VALUE as EXAM_VALUE_ID,\
(SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property  WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=24 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as AUTHOR_ID_COMB,\
(SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property  WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=61 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as GRADE_VALUE_COMB,\
(SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property  WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=62 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as SUBJECT_VALUE_COMB,\
MATERIAL_TYPE_PROP.VALUE as MATERIAL_TYPE_VALUE_ID,\
UMK_PROP.VALUE as UMK_VALUE_ID,\
PROD_TEXT_PROP.VALUE as PROD_TEXT_VALUE,\
ISBN_PROP.VALUE as ISBN,\
RAITING_PROP.VALUE as RAITING,\
COVER_PROP.VALUE as COVER \
FROM b_iblock_element as ELEMENT \
 LEFT JOIN b_iblock_element_property as AUTHOR_TITLE_PROP ON AUTHOR_TITLE_PROP.IBLOCK_PROPERTY_ID=25 AND AUTHOR_TITLE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as SALELEADER_PROP ON SALELEADER_PROP.IBLOCK_PROPERTY_ID=10 AND SALELEADER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as NOMCODE ON NOMCODE.IBLOCK_PROPERTY_ID=4 AND NOMCODE.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as SERIES_PROP_ID ON SERIES_PROP_ID.IBLOCK_PROPERTY_ID=182 AND SERIES_PROP_ID.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element as SERIES_ELEMENT ON SERIES_ELEMENT.ID=SERIES_PROP_ID.VALUE \
 LEFT JOIN b_iblock_element_property as PUBL_PROP_ID ON PUBL_PROP_ID.IBLOCK_PROPERTY_ID=30 AND PUBL_PROP_ID.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element as PUBL_ELEMENT ON PUBL_ELEMENT.ID=PUBL_PROP_ID.VALUE \
 LEFT JOIN b_iblock_element_property as AVAILABLE_PROP ON AVAILABLE_PROP.IBLOCK_PROPERTY_ID=8 AND AVAILABLE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as PREDZAKAZ_PROP ON PREDZAKAZ_PROP.IBLOCK_PROPERTY_ID=22 AND PREDZAKAZ_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_section as ELEMENT_SECTION ON ELEMENT_SECTION.IBLOCK_ID=1 AND ELEMENT_SECTION.ID=ELEMENT.IBLOCK_SECTION_ID \
 LEFT JOIN b_iblock_element_property as FRAGMENT_PROP ON FRAGMENT_PROP.IBLOCK_PROPERTY_ID=178 AND FRAGMENT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_catalog_price as ELEMENT_PRICE ON ELEMENT_PRICE.CATALOG_GROUP_ID=1 AND ELEMENT_PRICE.PRODUCT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as SELECTIONS ON SELECTIONS.IBLOCK_PROPERTY_ID=110 AND SELECTIONS.VALUE=ELEMENT.XML_ID \
 LEFT JOIN b_iblock_element as SELECTIONS_ELEMENT ON SELECTIONS_ELEMENT.ID=SELECTIONS.IBLOCK_ELEMENT_ID \
 LEFT JOIN b_iblock_element_property as SPECIALOFFER_PROP ON SPECIALOFFER_PROP.IBLOCK_PROPERTY_ID=11 AND SPECIALOFFER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as AUTOGRAPH_PROP ON AUTOGRAPH_PROP.IBLOCK_PROPERTY_ID=13 AND AUTOGRAPH_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as AGE_LIMIT_PROP ON AGE_LIMIT_PROP.IBLOCK_PROPERTY_ID=19 AND AGE_LIMIT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as SALE_CLOSE_PROP ON SALE_CLOSE_PROP.IBLOCK_PROPERTY_ID=39 AND SALE_CLOSE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as FOR_KIDS_PROP ON FOR_KIDS_PROP.IBLOCK_PROPERTY_ID=55 AND FOR_KIDS_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as EXAM_PROP ON EXAM_PROP.IBLOCK_PROPERTY_ID=60 AND EXAM_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as MATERIAL_TYPE_PROP ON MATERIAL_TYPE_PROP.IBLOCK_PROPERTY_ID=63 AND MATERIAL_TYPE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as UMK_PROP ON UMK_PROP.IBLOCK_PROPERTY_ID=64 AND UMK_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as PROD_TEXT_PROP ON PROD_TEXT_PROP.IBLOCK_PROPERTY_ID=47 AND PROD_TEXT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as ISBN_PROP ON ISBN_PROP.IBLOCK_PROPERTY_ID=32 AND ISBN_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as RAITING_PROP ON RAITING_PROP.IBLOCK_PROPERTY_ID=67 AND RAITING_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 LEFT JOIN b_iblock_element_property as COVER_PROP ON COVER_PROP.IBLOCK_PROPERTY_ID=41 AND COVER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
 WHERE ELEMENT.IBLOCK_ID = 1

sql_attr_uint = ELEMENT_ID
sql_field_string = ELEMENT_NAME
sql_field_string = RAITING
sql_attr_multi = uint IBLOCK_SECTION_ID_COMB from field
sql_attr_multi = uint GRADE_VALUE_COMB from field
sql_attr_multi = uint SUBJECT_VALUE_COMB from field
sql_attr_multi = uint AUTHOR_ID_COMB from field
sql_field_string = ELEMENT_IBLOCK_SECTION_NAME
sql_field_string = ELEMENT_IBLOCK_SECTION_CODE
sql_field_string = ELEMENT_DETAIL_TEXT
sql_field_string = ELEMENT_PREVIEW_TEXT
sql_field_string = ELEMENT_CODE
sql_field_string = ELEMENT_XML_ID
sql_field_string = ELEMENT_TAGS
sql_attr_uint = ELEMENT_PRICE
sql_field_string = AUTHOR_TITLE
sql_attr_uint = SERIES_ID
sql_field_string = SERIES_NAME
sql_field_string = SERIES_CODE
sql_attr_uint = PUBL_ID
sql_field_string = PUBL_NAME
sql_field_string = PUBL_CODE
sql_attr_uint = AVAILABLE_VALUE_ID
sql_attr_uint = PREDZAKAZ_VALUE_ID
sql_attr_uint = FRAGMENT_VALUE_ID
sql_field_string = SELECTIONS_ELEMENT_ID
sql_field_string = SELECTIONS_ELEMENT_NAME
sql_field_string = NOMCODE
sql_field_string = SALE_CLOSE_VALUE
sql_attr_uint = SALELEADER_VALUE_ID
sql_attr_uint = SPECIALOFFER_VALUE_ID
sql_attr_uint = AUTOGRAPH_VALUE_ID
sql_attr_uint = AGE_LIMIT_CRC32
sql_field_string = AGE_LIMIT
sql_attr_uint = FOR_KIDS_VALUE_ID
sql_attr_uint = EXAM_VALUE_ID
sql_attr_uint = MATERIAL_TYPE_VALUE_ID
sql_attr_uint = UMK_VALUE_ID
sql_field_string = PROD_TEXT_VALUE
sql_field_string = ISBN
sql_field_string = COVER
}

source author_v2{
	# Параметры подключения к БД
	type = mysql
	sql_host = localhost
	sql_user = root
	sql_pass =
	sql_db = b24
	sql_port = 3306

	# Установим кодировку для работы с БД
	sql_query_pre = SET NAMES utf8
	sql_query_pre = SET CHARACTER SET utf8

	sql_query           = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, PREVIEW_PICTURE, DETAIL_PICTURE, ID as author_id, NAME as author_name,  CODE as author_code, PREVIEW_TEXT as author_preview_text, DETAIL_TEXT as author_detail_text, PREVIEW_PICTURE as author_preview_picture, DETAIL_PICTURE as author_detail_picture, (select GROUP_CONCAT(b_iblock_element_prop_m2.VALUE) from b_iblock_element_prop_m2 where b_iblock_element_prop_m2.IBLOCK_ELEMENT_ID=a.ID) as best_book, (select GROUP_CONCAT(mp1.VALUE) from b_iblock_element_prop_m1 as mp1 where mp1.IBLOCK_PROPERTY_ID = 14 and mp1.IBLOCK_ELEMENT_ID IN (select mp2.IBLOCK_ELEMENT_ID from b_iblock_element_prop_m1 as mp2 where mp2.IBLOCK_PROPERTY_ID = 24 and mp2.VALUE = a.ID)) as quotes, author_prop.PROPERTY_241 as author_anounce from b_iblock_element as a left join b_iblock_element_prop_s2 as author_prop on author_prop.IBLOCK_ELEMENT_ID=a.ID where a.IBLOCK_ID = 2

    sql_attr_uint       = author_id
    sql_attr_string     = author_name
    sql_attr_string     = author_code
    sql_attr_string     = author_anounce
    sql_attr_string     = author_preview_text
    sql_attr_string     = author_detail_text
    sql_attr_string     = author_preview_picture
    sql_attr_string     = author_detail_picture
    sql_attr_multi      = uint best_book from field;
    sql_attr_multi      = uint quotes from field;
}

index author_v2
{
    source              = author_v2
    path                = f:/sphinx/data/index/author_v2
    docinfo             = extern
    morphology = lemmatize_ru_all, lemmatize_en_all
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
	ignore_chars = U+002E
	index_exact_words=1
	dict=keywords
	min_prefix_len = 3
}


source serie_v2{
	# Параметры подключения к БД
	type = mysql
	sql_host = localhost
	sql_user = root
	sql_pass =
	sql_db = b24
	sql_port = 3306

	# Установим кодировку для работы с БД
	sql_query_pre = SET NAMES utf8
	sql_query_pre = SET CHARACTER SET utf8

	sql_query           = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, ID as serie_id, NAME as serie_name, CODE as serie_code from b_iblock_element where IBLOCK_ID = 11
    sql_attr_uint       = serie_id
    sql_attr_string     = serie_name
    sql_attr_string     = serie_code
}

index serie_v2
{
    source              = serie_v2
    path                = f:/sphinx/data/index/serie_v2
    docinfo             = extern
    morphology = lemmatize_ru_all, lemmatize_en_all
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
	ignore_chars = U+002E
	index_exact_words=1
	dict=keywords
	min_prefix_len = 3
}

source publisher_v1{
	# Параметры подключения к БД
	type = mysql
	sql_host = localhost
	sql_user = root
	sql_pass =
	sql_db = b24
	sql_port = 3306

	# Установим кодировку для работы с БД
	sql_query_pre = SET NAMES utf8
	sql_query_pre = SET CHARACTER SET utf8

	sql_query           = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, PREVIEW_PICTURE, DETAIL_PICTURE, ID as publisher_id, NAME as publisher_name,  CODE as publisher_code, PREVIEW_TEXT as publisher_preview_text, DETAIL_TEXT as publisher_detail_text, PREVIEW_PICTURE as publisher_preview_picture, DETAIL_PICTURE as publisher_detail_picture, (select GROUP_CONCAT(mp1.VALUE) from b_iblock_element_prop_m1 as mp1 where mp1.IBLOCK_PROPERTY_ID = 14 and mp1.IBLOCK_ELEMENT_ID IN (select mp2.IBLOCK_ELEMENT_ID from b_iblock_element_prop_s1 as mp2 where mp2.PROPERTY_30  = a.ID)) as quotes from b_iblock_element as a where a.IBLOCK_ID = 8
    sql_attr_uint       = publisher_id
    sql_attr_string     = publisher_name
    sql_attr_string     = publisher_code
    sql_attr_string     = publisher_preview_text
    sql_attr_string     = publisher_detail_text
    sql_attr_string     = publisher_preview_picture
    sql_attr_string     = publisher_detail_picture
    sql_attr_multi      = uint quotes from field;
}

index publisher_v1
{
    source              = publisher_v1
    path                = f:/sphinx/data/index/publisher_v1
    docinfo             = extern
    morphology 			= lemmatize_ru_all, lemmatize_en_all
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
	ignore_chars = U+002E
	index_exact_words=1
	dict=keywords
	min_prefix_len = 3
}

index b24_v20
{
	type            = rt
    path            = f:/sphinx/data/index/b24_v25
	morphology 		= lemmatize_ru_all, lemmatize_en_all
	wordforms  		= f:/projects/book24/search/sphinx/data/wordforms/wordforms.txt
	charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
	ignore_chars 	= U+002E
	index_exact_words=1
	dict=keywords
	min_prefix_len = 3
	rt_mem_limit   = 8192M

    rt_field        = name
    rt_field        = section_name
    rt_field 		= author_name
    rt_field		= serie_name
    rt_field		= publisher_name
    rt_field		= detail_text
    rt_field		= prod_text
    rt_field		= seo_text
    rt_field		= tags
    rt_field		= author_alias_name
    rt_field		= material_type
    rt_field		= naznachenie
    rt_field		= isbn
    rt_attr_string  = name
    rt_attr_string	= author_alias_name
    rt_attr_string  = section_name
    rt_attr_string  = author_name
    rt_attr_string 	= serie_name
    rt_attr_string 	= publisher_name
    rt_attr_string 	= brand_name
    rt_attr_string 	= isbn
    rt_attr_string  = nomcode
    rt_attr_string  = rdc
    rt_attr_string  = nom_folder
    rt_attr_uint    = exam_attr
    rt_attr_string  = element_code
    rt_attr_bool	= available_attr
    rt_attr_bool	= newproduct_attr
    rt_attr_bool	= saleleader_attr
    rt_attr_bool	= specialoffer_attr
    rt_attr_bool	= popular_attr
    rt_attr_bool	= autograph_attr
    rt_attr_bool	= ast_predzakaz_attr
    rt_attr_bool	= predzakaz_attr
    rt_attr_bool	= gift_attr
    rt_attr_bool	= free_delivery_attr
    rt_attr_bool	= gift_exclusive_attr
    rt_attr_bool	= gift_calendar_attr
    rt_attr_bool	= book_cover_attr
    rt_attr_bool	= fragment_attr
    rt_attr_uint	= umk_attr
    rt_attr_uint	= date_attr
    rt_attr_uint    = element_id
    rt_attr_uint    = serie_id_attr
    rt_attr_uint    = sort
    rt_attr_uint    = sort_ast
    rt_attr_uint    = sort_df
	rt_attr_uint    = age_limit_attr
	rt_attr_uint    = publisher_id_attr
	rt_attr_uint    = brand_id_attr
    rt_attr_uint    = material_type_attr
    rt_attr_uint    = naznachenie_attr
    rt_attr_uint    = literature_age_attr
	rt_attr_uint    = price
	rt_attr_uint    = price_group_10
	rt_attr_uint    = price_group_11
	rt_attr_uint    = price_group_12
	rt_attr_uint    = price_group_13
	rt_attr_uint    = price_discount
	rt_attr_multi   = gift_collection_attr
	rt_attr_multi   = grade_attr
	rt_attr_multi   = subject_attr
	rt_attr_multi   = gift_present_attr
	rt_attr_multi   = gift_interest_attr
	rt_attr_multi   = gift_event_attr
	rt_attr_multi   = section_id
	rt_attr_multi   = section_id_attr
	rt_attr_multi   = author_id_attr
}