Thanks but 4 rows is not what I am looking for.
I found a solution, concatenation:
SELECT genres.genres,
(
SELECT group_concat(movie,' ')
FROM
(
SELECT movies.movies||','||name movie
FROM movies
JOIN genres AS movie_genres
ON movies.movies = movie_genres.movies
WHERE movie_genres.genres = genres.genres
ORDER BY movies.name
LIMIT 3
)
)
FROM genres
GROUP BY genres
ORDER BY genres.genres;
Any clue on why LEFT JOIN is so slow when used with genres but not with
larger tables?
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Please-help-me-optimize-this-LEFT-JOIN-query-tp71000p71040.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
