СПЕЦИАЛЬНОСТЬ
File: /var/www/abv-med.dev.net-page.ru/public_html/bitrix/modules/search/classes/general/search.php
Line: 256
MySQL Query Error:
SELECT
stags2.NAME
,COUNT(DISTINCT stags2.SEARCH_CONTENT_ID) as CNT
,MAX(sc.DATE_CHANGE) DC_TMP
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y') as DATE_CHANGE
FROM b_search_tags stags2
INNER JOIN b_search_content sc ON (stags2.SEARCH_CONTENT_ID=sc.ID)
INNER JOIN b_search_content_site scsite ON (sc.ID=scsite.SEARCH_CONTENT_ID AND stags2.SITE_ID=scsite.SITE_ID)
WHERE
((
EXISTS (
SELECT 1
FROM b_search_content_right scg
WHERE sc.ID = scg.SEARCH_CONTENT_ID
AND scg.GROUP_CODE = 'G2'
)))
AND (1=1)
AND (
(
scsite.SITE_ID = 's1'
AND (
(
(sc.DATE_FROM IS NULL)
OR sc.DATE_FROM <= '2024-04-16 20:09:36'
)
AND (
(sc.DATE_TO IS NULL)
OR sc.DATE_TO >= '2024-04-16 20:09:36'
)
))
AND(
(
sc.MODULE_ID = 'iblock'
AND sc.PARAM1 = 'news'
AND sc.PARAM2 = '1'
))
)
GROUP BY
stags2.NAME
ORDER BY CNT DESC
LIMIT 20[[3] Error writing file '/tmp/MYS1zGYI' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|
