I make a query to find the last 24 results from three different tables.
The query is :
FROM movie m, tvseries t, games g
GROUP BY m.MovID, t.SerID, g.GamID
GROUP BY is not the problem (at least not the major one).
Th real problem is that you selecting data from 3 tables without joining them. This part of your query:
from movie m , tvseries t , games g
meanss all combinations of every row of the 1st table with every row of the 2nd with every row of the 3rd table. Is that what you want?
FROM movie m CROSS JOIN tvseries t CROSS JOIN games g
Most probably you want to
JOIN the 3 tables:
FROM movie m INNER JOIN tvseries t ON t.someColumn = m.someColumn INNER JOIN games g ON g.someOtherColumn = m.someOtherColumn