SELECT Album.id FROM Album FORCE INDEX(released_on_idx) WHERE (((Album.country_bundle_id IS NULL) OR ((Album.default_country_policy = 'ALLOW') AND ((Album.country_bundle_id = 0) OR (Album.country_bundle_id NOT IN (1,3,5,7,9,11,13,15,17,23,25,27,29,33,35,37,41,43,45,47,51,57,59,61,63,65,71,73,75,77,81,83,85,87,89,91,95,97,99,101,103,113,115,117,123,127,129,131,133,135,139,141,143,145,149,151,153,157,163,165,169,171,173,175,179,185,187,195,199,201,205,207,209,217,219,223,225,227,229,237,239,247,249,251,253,255,257,259,261,263,265,267,269,273,275,277,279,285,287,289,291,295,297,301,307,309,315,317,325,327,331,333,335,339,341,343,345,347)))) OR ((Album.default_country_policy = 'DENY') AND (Album.country_bundle_id IN (1,3,5,7,9,11,13,15,17,23,25,27,29,33,35,37,41,43,45,47,51,57,59,61,63,65,71,73,75,77,81,83,85,87,89,91,95,97,99,101,103,113,115,117,123,127,129,131,133,135,139,141,143,145,149,151,153,157,163,165,169,171,173,175,179,185,187,195,199,201,205,207,209,217,219,223,225,227,229,237,239,247,249,251,253,255,257,259,261,263,265,267,269,273,275,277,279,285,287,289,291,295,297,301,307,309,315,317,325,327,331,333,335,339,341,343,345,347))))) AND (Album.status IN ('NORMAL')) AND (EXISTS (SELECT * FROM AlbumGenre ag WHERE ag.album_id = Album.id AND ag.genre_id in (56,57,143) AND ag.for_lists = 1)) AND (EXISTS (SELECT * FROM AlbumGenre ag WHERE ag.album_id = Album.id AND ag.genre_id in (143) AND ag.for_lists = 1)) AND (Album.price >=  '0.01' ) ORDER BY Album.released_on DESC LIMIT 40,21