---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(8746, 8353, 8419, 10435, 8035, 7796, 7980, 7601, 7952, 7726, 7896, 7960, 7871, 7944, 7797, 22596, 8674, 7875, 7982, 7985, 7995, 7981, 7961, 8929, 7914, 7297, 7830, 7994, 7874, 28813, 17742, 8007, 8312, 5831, 24885, 8182, 7728, 7751, 7976, 7940, 8040, 8039, 7939, 7988, 8038, 7989, 7740, 7494, 8049, 7795, 7967, 8514, 8075, 8069, 8059, 8070, 7963, 7964, 15982, 8309, 4437, 8228, 8224, 8227, 8222, 8221, 8226, 12151, 6062, 8304, 7983, 4820, 14723, 7937, 8096, 7848, 22500, 11255, 7717, 8055, 7878, 8300, 8032, 8311, 7997, 7998, 8301, 8307, 8000, 8306, 25600, 22600, 7999, 8119, 9286, 8043, 8177, 8041, 8125, 8320, 8044, 8042, 8124, 8310, 8051, 7984, 8233, 8157, 8218, 7876, 8058, 8097, 7951, 7877, 7716, 8143, 8146, 8144, 8066, 8145, 8147, 13698, 8232, 8230, 9921, 24505, 8203, 8231, 8229, 8165, 8130, 7922, 8316, 8297, 8302, 8207) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---