phpBB.de

Code: Alles auswählen

$sql = "SELECT p.*, u.user_id, u.user_icq, u.username, r.rate_pic_id, r.rate_user_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
		FROM ". ALBUM_TABLE ." AS p
			LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
			LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
			LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
		WHERE u.user_icq = 1 AND p.pic_cat_id = 0 AND NOT r.rate_user_id <> 2
		GROUP BY p.pic_id
        ORDER BY RAND() LIMIT 1";