On 9/4/2013 10:21 AM, Yuzem wrote:
SELECT genres name,count(genres.movies)
count,substr(group_concat(grouped.movies,' '),1,40)
src,substr(group_concat(grouped.icon_modified,' '),1,80) icon_modified FROM
genres LEFT JOIN (SELECT movies,icon_modified FROM movies WHERE
icon_modified != '') grouped on grouped.movies = genres.movies GROUP BY
genres ORDER BY name"
Try
FROM genres LEFT JOIN movies grouped ON (genres.movies = movies.movies
AND icon_modified != '')
The use of nested SELECT likely prevents SQLite from using the index on
movies(movies).
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
