---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(10242, 9714, 10104, 23738, 25453, 9787, 11698, 9697, 9716, 9713, 9670, 9750, 9715, 9672, 9863, 9671, 9766, 9726, 25457, 9542, 10243, 9731, 9513, 10244, 9668, 11532, 10245, 9491, 9724, 10175, 9667, 9514, 9653, 9701, 12030, 10033, 9666, 8772, 9725, 9543, 9705, 10068, 9703, 10246, 10064, 9995, 9779, 9835, 9997, 9674, 9675, 12029, 10066, 9990, 9998, 9559, 10063, 9994, 10057, 9764, 9309, 9342, 10094, 10256, 9567, 10065, 10067, 7330, 9760, 10994, 10072, 9992, 10091, 9996, 10088, 10093, 9803, 10278, 9704, 10089, 9509, 9796, 25465, 9699, 11128, 9742, 6825, 9800, 9758, 9756, 9757, 9759, 9626, 9790, 9657, 9795, 9763, 9746, 9464, 9298, 9794, 9625, 9707, 9792, 9791, 9050, 9793, 9688, 15401, 9812, 10277, 10092, 9827, 10077, 10174, 10595, 12144, 9807, 9748, 9982, 9325, 9747, 22076, 9784, 10078, 9786, 9797, 9826, 28769, 9654, 9788, 9772, 9739, 9805, 11422, 9806, 10075, 9738, 9743, 9765, 9909, 8799, 9665, 9785, 10260, 9717, 9775, 17687, 9778, 9621, 9541, 9888, 10136, 14902, 9799, 30527, 9798, 9896, 9740, 12418, 9876, 9751, 9813, 9673, 9702, 9912, 10259, 9546, 21103, 9985, 9628, 10076, 9913, 10031, 9875, 9737, 9777, 9917, 9635, 9712, 9079, 9820, 9824, 9898, 9822, 12095, 9904, 9783, 9455, 8469, 10261, 9986, 9808, 10130, 10334, 9925, 9988, 10062, 9993, 9928, 9926, 9782, 9910, 9911, 9905, 9723, 9908, 9915, 9752, 9012, 9978, 9391, 9922, 9975, 9780, 9753, 9980, 9636, 9979, 9958, 9976, 9977, 9973, 10159, 10008, 10007, 28999, 29003, 9972, 10038, 9942, 9948, 9943, 9944, 9941, 9945, 9946, 9947, 10176, 9809, 3546, 8068, 10280, 9686, 10177, 7114, 10163, 9690, 4182, 9983, 9984, 7963, 3677, 9643, 9687, 10162, 9689, 10074, 10168, 10090) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---