SELECT COUNT(DISTINCT(id))
  FROM phpwebgallery_image_category AS ic
    INNER JOIN phpwebgallery_comments AS com
    ON ic.image_id = com.image_id
  WHERE 1=1
    AND validated="true"
    AND  1 = 1
;
[mysql error 1146] Table 'b_defsite.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
     , com.validated
  FROM phpwebgallery_image_category AS ic
    INNER JOIN phpwebgallery_comments AS com
    ON ic.image_id = com.image_id
  WHERE 1=1
    AND validated="true"
    AND  1 = 1
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 0,10
;
[mysql error 1146] Table 'b_defsite.phpwebgallery_comments' doesn't exist