SELECT DISTINCT c.id AS comment_id
  FROM phpwebgallery_comments AS c
     , phpwebgallery_image_category AS ic
  WHERE c.image_id = ic.image_id
    AND c.validation_date > ''
    AND c.validation_date <= '2025-07-27 03:23:11'
    AND category_id NOT IN (-1)
;
[mysql error 1054] Unknown column 'c.validation_date' in 'where clause'