SELECT IMG.*,CONCAT('/private/mmadcatz','/',url_key) as url_key,(SELECT COUNT(ID) FROM image_statistics WHERE image_statistics.image_id=IMG.ID) AS views FROM `image_category` AS CTGI LEFT JOIN `images` AS IMG ON IMG.ID=CTGI.image_id WHERE CTGI.category_id='6' AND im_width>im_height and IMG.display=1 ORDER BY adddate DESC LIMIT 3 [nativecode=145 ** Table './viter_viter/image_statistics' is marked as crashed and should be repaired]
SELECT *,(SELECT COUNT(ID) FROM image_statistics WHERE image_id=TAB_1.ID) AS views,IF(LENGTH(image_file),CONCAT('photos','/',image_file),'') AS image,IF(LENGTH(image_file),CONCAT('photos/thumbs','/',image_file),'') AS image_thumb ,DATE_FORMAT(FROM_UNIXTIME(adddate),'%d-%m-%Y') AS date2 ,IF(TAB_1.active,'checked','') AS active_chkd FROM `images` AS TAB_1 LEFT JOIN `image_category` AS TAB_2 ON TAB_1.ID=TAB_2.image_id WHERE TAB_2.category_id='5' AND display=1 AND active=1 ORDER BY ID DESC LIMIT 0,16 [nativecode=145 ** Table './viter_viter/image_statistics' is marked as crashed and should be repaired]