Hi.
I see that links are generated like this:
Movie: La vida futura
Link:
www.sfcult.net/index.php/7-la-vida-futura
Movie: Viaje alucinante
Link:
www.sfcult.net/index.php/5-viaje-alucinante
Where, the number is a field = movie_id, and then the title.
But , i can make a table with this links if its mandatory.
Thanks
By the way my code is :
SELECT
A.title AS Titulo,
A.duration AS Title,
YEAR(A.release_date) AS Year,
AVG(R.rating) AS Points
FROM jos_spmoviedb_movies A INNER JOIN jos_spmoviedb_reviews R
ON R.movieid = A.spmoviedb_movie_id
GROUP BY
A.title
ORDER BY
AVG(R.rating) DESC
