Table './myotpusk_db/my_photo_files' is marked as crashed and should be repaired
SELECT f.*,
f.pubdate as fpubdate,
f.album_id as album_id,
IFNULL(r.total_rating, 0) as rating
FROM cms_photo_files f
LEFT JOIN cms_ratings_total r ON r.item_id=f.id AND r.target='photo'
WHERE f.album_id = 1228 AND f.published = 1
GROUP BY f.id
ORDER BY pubdate asc
LIMIT 0, 20 | |