File: /home/admin/web/acropolis.ua/public_html/bitrix/modules/search/classes/general/search.php
Line: 242
MySQL Query Error: SELECT sc.*, sc.RANK + if(rv.TOTAL_VALUE > 0, rv.TOTAL_VALUE/30, if(rv.TOTAL_VALUE < 0, rv.TOTAL_VALUE/30, 0 )) SRANK ,ifnull(rvv.VALUE, 0) RATING_USER_VOTE_VALUE ,sc.ENTITY_TYPE_ID RATING_TYPE_ID ,sc.ENTITY_ID RATING_ENTITY_ID ,rv.TOTAL_VOTES RATING_TOTAL_VOTES ,rv.TOTAL_POSITIVE_VOTES RATING_TOTAL_POSITIVE_VOTES ,rv.TOTAL_NEGATIVE_VOTES RATING_TOTAL_NEGATIVE_VOTES ,rv.TOTAL_VALUE RATING_TOTAL_VALUE FROM ( SELECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.TITLE ,sc.TAGS ,sc.BODY ,sc.PARAM1 ,sc.PARAM2 ,sc.UPD ,sc.DATE_FROM ,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 ,sct.SEARCHABLE_CONTENT ,sc.USER_ID ,scsite.URL as SITE_URL ,scsite.SITE_ID ,1 as RANK ,sc.ENTITY_TYPE_ID, sc.ENTITY_ID FROM b_search_content_text sct INNER JOIN b_search_content sc ON sc.ID = sct.SEARCH_CONTENT_ID INNER JOIN b_search_content_site scsite ON sc.ID = scsite.SEARCH_CONTENT_ID WHERE (( EXISTS ( SELECT 1 FROM b_search_content_right scg WHERE sc.ID = scg.SEARCH_CONTENT_ID AND scg.GROUP_CODE = 'G2' ))) AND (( (sct.searchable_content LIKE '%MIGUEL%') AND (sct.searchable_content LIKE '%J%') AND (sct.searchable_content LIKE '%ALMERIA%') )) AND ( ( scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2020-01-17 23:52:25' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2020-01-17 23:52:25' ) )) AND( ( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'catalog' AND sc.PARAM2 = '3' )) ) ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500 ) sc LEFT JOIN b_rating_voting rv ON rv.ENTITY_TYPE_ID = sc.ENTITY_TYPE_ID AND rv.ENTITY_ID = sc.ENTITY_ID LEFT JOIN b_rating_vote rvv ON rvv.ENTITY_TYPE_ID = sc.ENTITY_TYPE_ID AND rvv.ENTITY_ID = sc.ENTITY_ID AND rvv.USER_ID = 0 ORDER BY CUSTOM_RANK DESC, SRANK DESC, sc.DATE_CHANGE DESC[Out of resources when opening file '/dev/shm/#sql_12c5_1.MAD' (Errcode: 24)]

DB query error.
Please try later.