---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(17946, 17996, 17997, 17602, 17967, 17981, 17990, 20963, 17973, 18154, 18147, 18146, 28078, 18145, 18007, 18153, 17994, 17923, 18030, 17890, 18151, 18155, 17839, 17450, 17664, 17988, 17833, 17693, 17191, 17894, 17982, 18011, 18009, 17983, 17892, 17719, 17882, 18152, 18050, 18008, 17782, 24483, 17999, 17969, 17921, 17980, 17395, 18031, 17979, 17695, 18520, 17935, 18150, 12463, 18148, 18149, 19268, 19266, 18018, 18017, 21527, 19309, 18020, 18001, 18019, 18032, 18022, 18157, 17974, 17975, 18096, 17597, 18016, 18156, 18025, 18026, 17993, 18159, 19173, 24298, 18041, 17918, 18037, 18158, 18160, 18029, 17998, 18161, 17853, 18038, 18035, 17838, 18002, 17708, 16760, 18028, 18623, 18036, 17877, 18042, 18010, 18039, 18040, 18139, 17857, 17045, 18014, 18015, 18081, 17448, 18076, 18077, 18140, 18043, 18078, 18141, 18144, 17992, 18075, 18143, 18142, 18209, 18162, 18131, 18074, 18082, 18088, 17383, 18132, 17845, 18089, 17700, 17879, 18083, 18049, 17702, 18048, 18072, 17907, 18073, 18047, 17900, 18133, 19779, 375, 17926, 17649, 17825, 18137, 18134, 18135, 33632, 18164, 23408, 18105, 30003, 17609, 23345, 18210, 17991, 18110, 18093, 18136, 18193, 17947, 18910, 17849, 17909, 18106, 17876, 18107, 17989, 17938, 18918, 18090, 17986, 18086, 18138, 17878, 18052, 17584, 17956, 18917, 18585, 18085, 17832, 18046, 18045, 18044, 17603) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---