118119120121122123124
+ " group by artist_id" + ") pc on pc.artist_id = a.id where true " + artistNameCriteria + hasAlbumsCriteria + " order by last_invocation_time desc offset ? limit ?"; return jdbcTemplate.query(sql, args.toArray(), new ArtistRecommendationRowMapper()); }
148149150151152153154
+ " from library.playcount pc" + userCriteria + " group by artist_id" + ") pc on pc.artist_id = a.id" + artistNameCriteria + " order by cnt desc offset ? limit ?"; return jdbcTemplate.query(sql, args.toArray(), new ArtistRecommendationRowMapper()); }
160161162163164165166
+ " inner join music.artist a on a.id = ai.artist_id" + " inner join library.artist la on la.artist_id = a.id" + (onlyAlbumArtists ? " where la.hasalbums" : "") + " order by random() limit " + limit; return jdbcTemplate.query(sql, new ArtistRecommendationRowMapper()); }
187188189190191192193
+ " inner join library.artist la on la.artist_id = a.id" + " inner join library.starredartist sa on sa.artist_id = la.artist_id" + userTable + " where true" + userCriteria + artistNameCriteria + " order by sa.added desc offset ? limit ?"; return jdbcTemplate.query(sql, args.toArray(), new ArtistRecommendationRowMapper()); }
70717273747576
+ " order by rank" + " offset ? limit ?"; return jdbcTemplate.query(sql, new Object[]{user.getLastFmUsername(), period.getDays(), offset, limit}, new ArtistRecommendationRowMapper()); }
26272829303132
+ " inner join music.artistrelation ar on ar.target_id = ma.id" + " where ar.source_id = " + artistId + (onlyAlbumArtists ? " and la.hasalbums" : "") + " order by weight desc limit " + amount; return jdbcTemplate.query(sql, new ArtistRecommendationRowMapper()); }
61626364656667
+ " ) tag on tag.artist_id = ma.id and tag.tag_count > 25" + (onlyAlbumArtists ? " where la.hasalbums" : "") + " order by (tag.tag_count-1)/10 desc, ai.listeners desc" + " limit " + length + " offset " + offset; return jdbcTemplate.query(sql, new Object[]{tagName}, new ArtistRecommendationRowMapper()); }
93949596979899
+ (onlyAlbumArtists ? " and la.hasalbums" : "") + " order by rank offset ? limit ?"; return jdbcTemplate.query(sql, new Object[]{lastFmUsername, offset, limit}, new ArtistRecommendationRowMapper()); }
126127128129130131132
+ (onlyAlbumArtists ? " and la.hasalbums" : "") + " order by gwac.playcount desc offset ? limit ?"; return jdbcTemplate.query(sql, new Object[]{lastFmGroupName, offset, limit}, new ArtistRecommendationRowMapper()); }