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 'tsubasanews.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/154/sda/2/8/tsubasanews/lost_canvas/galerie/comments.php on line 309
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 'tsubasanews.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/154/sda/2/8/tsubasanews/lost_canvas/galerie/comments.php on line 360 Galerie Raw Saint Seiya The Lost Canvas:Commentaires utilisateurs