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 'thiers_voltige.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/162/sdb/a/b/thiers.voltige/galerie/comments.php on line 306
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 'thiers_voltige.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/162/sdb/a/b/thiers.voltige/galerie/comments.php on line 357 Photos de Thiers Voltige Equestres:Commentaires utilisateurs