Warning:  [mysql error 145] Table './Photos/piwigo_images' is marked as crashed and should be repaired
SELECT CONCAT_WS('-',YEAR(date_available),WEEK(date_available, 5)+1,WEEKDAY(date_available)) AS period FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
    WHERE (category_id NOT IN (127,126,17,105,45,217,79))
AND date_available IS NOT NULL
GROUP BY period in /home/e-smith/files/ibays/piwigo/html/include/dblayer/functions_mysqli.inc.php on line 864