| |
|
|
|
|
Database error: Invalid SQL:
SELECT DISTINCT
A.article_id,
COUNT(D.article_id) AS click_count,
B.title,
IF((C.username IS NULL OR C.username = 'anonymous'),
IF(A.cp_name = '' OR A.cp_name IS NULL, 'Anonym', A.cp_name),
C.username)
AS username,
IFNULL(C.firstname, '') AS firstname,
IFNULL(C.surname, '') AS surname,
F.status
FROM
article A,
article_desc B,
auth_user C,
article_count D,
folder_article E LEFT JOIN folder_inactive F
ON E.folder_id = F.folder_id
WHERE
A.article_id = B.article_id
AND A.public = 'TRUE'
AND (A.expire IS NULL OR A.expire = '0000-00-00' OR TO_DAYS(A.expire) >= TO_DAYS(NOW()))
AND UNIX_TIMESTAMP(A.activate) <= UNIX_TIMESTAMP()
AND B.lang_id = 1
AND A.article_id = E.article_id
AND A.author_id = C.user_id
AND TO_DAYS(D.datum) > TO_DAYS(NOW())-30
AND A.article_id = D.article_id
AND F.status IS NULL
GROUP BY
D.article_id, E.folder_id
ORDER BY
click_count DESC,
A.activate DESC
LIMIT 10
MySQL Error: 144 (Table './zadarmo/article_count' is marked as crashed and last (automatic?) repair failed)
Session halted. |
