SELECT COUNT(DISTINCT(id))
  FROM phpwebgallery_image_category AS ic
    INNER JOIN phpwebgallery_comments AS com
    ON ic.image_id = com.image_id
  WHERE date > SUBDATE(CURDATE(), INTERVAL 30 DAY)
    AND 1=1
    AND 1=1
    AND 1=1
    AND category_id NOT IN (0)
;
[mysql error 1146] Table 'lefildutemps.phpwebgallery_comments' doesn't exist

SELECT com.id AS comment_id
     , com.image_id
     , ic.category_id
     , com.author
     , com.date
     , com.content
     , com.id AS comment_id
  FROM phpwebgallery_image_category AS ic
    INNER JOIN phpwebgallery_comments AS com
    ON ic.image_id = com.image_id
  WHERE date > SUBDATE(CURDATE(), INTERVAL 30 DAY)
    AND 1=1
    AND 1=1
    AND 1=1
    AND category_id NOT IN (0)
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 0,5
;
[mysql error 1146] Table 'lefildutemps.phpwebgallery_comments' doesn't exist