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 (26,61,84,87,92,93,94,95,96,97,111,130,131,132,133,134,135,136,137,138,155,156,157,158,159,160,161,162,163,164,165,169,170,173,213,214,217,218,220,266,272,320,327,348,350,351)
;
[mysql error 1146] Table 'www_retrosexy.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/115/sdb/e/4/www.retrosexy/gallerie/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 (26,61,84,87,92,93,94,95,96,97,111,130,131,132,133,134,135,136,137,138,155,156,157,158,159,160,161,162,163,164,165,169,170,173,213,214,217,218,220,266,272,320,327,348,350,351)
GROUP BY comment_id
ORDER BY date DESC
LIMIT 0,5
;
[mysql error 1146] Table 'www_retrosexy.phpwebgallery_comments' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/115/sdb/e/4/www.retrosexy/gallerie/comments.php on line 360 Retrosexy:Users comments