Warning:  [mysql error 145] Table './Photos/piwigo_images' is marked as crashed and should be repaired

SELECT DISTINCT(WEEKDAY(date_available)) as period,
  COUNT(DISTINCT id) as nb_images FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE category_id IN (1,89,109,112,124,165,180,193,200,214)
     AND date_available BETWEEN '2012-01-01' AND '2012-12-31 23:59:59' AND WEEK(date_available, 5)+1=45
  GROUP BY period; in /home/e-smith/files/ibays/piwigo/html/include/dblayer/functions_mysqli.inc.php on line 864