Warning:  [mysql error 145] Table './Photos/piwigo_images' is marked as crashed and should be repaired
SELECT DAYOFMONTH(date_creation) as period,
              COUNT(DISTINCT id) as count FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE category_id IN (193)
     AND date_creation BETWEEN '2017-11-01' AND '2017-11-30 23:59:59'
    GROUP BY period
    ORDER BY period ASC in /home/e-smith/files/ibays/piwigo/html/include/dblayer/functions_mysqli.inc.php on line 864