---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(21914, 21895, 21915, 21815, 21889, 21913, 21874, 21901, 21918, 21948, 21923, 21900, 21924, 21943, 21934, 21955, 21944, 21946, 21657, 21939, 21933, 21936, 21832, 21957, 21652, 21954, 21937, 21770, 21899, 21882, 19041, 21938, 20519, 21693, 21538, 21953, 19893, 21867, 21790, 21956, 21932, 21907, 21942, 21916, 21919, 21550, 21917, 21716, 22473, 21952, 21909, 21600, 29901, 21767, 21820, 21947, 21418, 21840, 21506, 21649, 21663, 21935, 21548, 21912, 21961, 22050, 21862, 21861, 21926, 21960, 21974, 21978, 21983, 21892, 27661, 21990, 21973, 21734, 21818, 21437, 22106, 21650, 21971, 21986, 21162, 21772, 21871, 21962, 21265, 21904, 21981, 21903, 21984, 17255, 17146, 17147, 21989, 21963, 21689, 22001, 21965, 21964, 21995, 26728, 21880, 21996, 21959, 21879, 22031, 22002, 22048, 22003, 22014, 22015, 21713, 21872, 21723, 21774, 22193, 22026, 21905, 22006, 22013, 21994, 21987, 21648, 14098, 21991, 21360, 22011, 21836, 22012, 21908, 21719, 22004, 22010, 21998, 21941, 21958, 21940, 21750, 21968, 22005, 22009, 21646, 21999, 21972, 22110, 22109, 22108, 22111, 22007, 21819, 21796, 4381, 22038, 22037, 23067, 22024, 22032, 30276, 22033, 22078, 22121, 22049, 22053, 22054, 22058, 22018, 22060, 22092, 22055, 21851, 21813, 22063, 21969, 22052, 22072, 24183, 21967, 22061, 21698, 22020, 21985, 21977, 22437, 22062, 21805, 22074, 21877, 22065, 21615) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---