[CODE]SEL ECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.TITLE ,sc.TAGS
,sc.BODY ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FR OM ,sc.DATE_TO ,sc.URL
,sc.CUSTOM_RANK ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as
FULL_DATE_CHANGE ,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE
,sc.LID ,sc.SEARCHABLE_CONTENT ,if(locate('Бензиновые',
upper(sc.TITLE)) > 0, 1, 0) + if(locate('генераторы',
upper(sc.TITLE)) > 0, 1, 0) as TITLE_RANK ,scsite.URL as SITE_URL
,scsite.SITE_ID ,1 as RANK
FR
b_search_content sc
INNER JOIN b_search_content_site scsite ON sc.ID = scsite.SEARCH_CONTENT_ID
WH
((1=1))
AND (( (sc.searchable_content LIKE '%Бензиновые%') AND
(sc.searchable_content LIKE '%генераторы%') )) AND scsite.SITE_ID in
('s1', 's2')
ORDER BY
CUSTOM_RANK DESC, TITLE_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC
LIMIT 500 [/CODE]