Error Number: 145
Table './lolof/posts' is marked as crashed and should be repaired
SELECT SQL_CALC_FOUND_ROWS *, SUM(num_points) AS num_points, COUNT(vote_id) AS num_votes, (SUM(num_points)-0)/COUNT(vote_id) AS stars, WEEK(posts.created_date) AS week, MONTH(posts.created_date) AS month, posts.created_date AS created_date FROM (`posts`) JOIN `languages` ON posts.language_id=languages.language_id LEFT JOIN `posters` ON posters.poster_id=posts.poster_id LEFT JOIN `votes` ON votes.post_id=posts.id WHERE `is_adult` = 'false' AND `is_visible` = 'true' AND `type` IN ('pictures') AND (language IN ('en') OR is_intl='true') AND `is_approved` = 'true' GROUP BY `id` ORDER BY `stars` desc, `num_votes` desc, posts.created_date desc LIMIT 20