MySQL Query Error: SELECT DISTINCT U.*, DATE_FORMAT(U.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') TIMESTAMP_X, IF(U.LAST_ACTIVITY_DATE > DATE_SUB(NOW(), INTERVAL 120 SECOND), 'Y', 'N') IS_ONLINE, DATE_FORMAT(U.DATE_REGISTER, '%d.%m.%Y %H:%i:%s') DATE_REGISTER, DATE_FORMAT(U.LAST_LOGIN, '%d.%m.%Y %H:%i:%s') LAST_LOGIN, DATE_FORMAT(U.PERSONAL_BIRTHDAY, '%d.%m.%Y') PERSONAL_BIRTHDAY
, RR3.CURRENT_POSITION IS NULL as RATING_3_ISNULL, RR3.CURRENT_VALUE as RATING_3, RR3.CURRENT_VALUE as RATING_3_CURRENT_VALUE, RR3.PREVIOUS_VALUE as RATING_3_PREVIOUS_VALUE, RR3.CURRENT_POSITION as RATING_3_CURRENT_POSITION, RR3.PREVIOUS_POSITION as RATING_3_PREVIOUS_POSITION
FROM
b_user U
INNER JOIN b_utm_user BUF1 ON BUF1.FIELD_ID = 27 AND BUF1.VALUE_ID = U.ID
INNER JOIN b_utm_user BUF2 ON BUF2.FIELD_ID = 25 AND BUF2.VALUE_ID = U.ID
LEFT JOIN b_rating_results RR3
ON RR3.RATING_ID=3
and RR3.ENTITY_TYPE_ID = 'USER'
and RR3.ENTITY_ID = U.ID
WHERE
(1=1
AND
(
U.ACTIVE='Y'
)
AND
(
(BUF1.VALUE_INT in (63))
AND BUF2.VALUE_INT = 58
)
)
ORDER BY RATING_3_ISNULL ASC, RATING_3 desc LIMIT 0, 32[Got error 122 from storage engine]
DB query error.
Please try later.
|
|
|
