Hi all, new here...
I have this, working and is fast.
PHP Code:
SELECT movie.id, movie.title, movie.cat_1,
movie.prod_year, movie.director_1, movie.image, vote.movieid,
ROUND(SUM(vote.vote)/COUNT(vote.vote),2) AS Average
FROM movie, vote WHERE vote.movieid=movie.id
AND movie.image != 'missing.png'
AND movie.prod_year >= '2000'
AND movie.image IS NOT NULL GROUP BY vote.movieid
HAVING Average >= '8'
ORDER BY RAND()
LIMIT 5;
Now I want to add something like this. I want to show the movies with ten votes or more. Can't get it to work
PHP Code:
SELECT movie.id, movie.title, movie.cat_1, movie.prod_year, movie.director_1, movie.image, vote.movieid,
ROUND(SUM(vote.vote)/COUNT(vote.vote),2) AS Average,
COUNT(vote.vote),2) AS Votes
FROM movie, vote
WHERE vote.movieid=movie.id
AND movie.image != 'missing.png'
AND movie.prod_year >= '2000'
AND movie.image IS NOT NULL
GROUP BY vote.movieid
HAVING Average >= '8'
HAVING Votes >= '10'
ORDER BY RAND()
LIMIT 5;
Anyone have an idea?
Best regards
dBforums
>
Dual HAVING on AS
02-13-10, 13:18
Dual HAVING on AS
Linear Mode
