---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(15575, 12446, 12531, 12529, 12532, 12634, 12542, 12504, 12560, 12534, 12558, 12570, 12541, 12530, 12589, 12764, 12239, 12523, 12580, 12287, 12286, 12234, 12221, 12661, 23041, 11190, 12555, 12522, 12515, 12713, 12629, 12592, 12521, 12765, 12599, 12252, 11546, 12554, 12639, 12561, 12637, 35832, 12641, 12642, 12486, 17355, 12367, 12483, 12469, 12487, 12753, 12654, 12644, 12492, 9594, 12690, 12697, 12598, 12225, 12693, 12474, 12689, 12499, 12571, 12436, 12409, 12278, 12113, 12682, 12636, 12260, 12643, 12366, 12321, 12174, 12681, 12664, 12259, 27799, 12672, 12500, 12711, 12738, 12600, 12710, 12656, 12715, 12716, 12714, 12658, 12671, 12660, 12718, 12739, 13127, 38313, 12717, 12648, 13024, 12657, 12663, 12621, 12647, 13866, 12705, 11155, 12724, 12694, 12670, 15039, 19481, 16285, 12698, 12623, 7902, 12512, 12587, 12496, 12510, 12579, 12591, 12578, 12615, 12614, 12703, 12683, 12566, 12763, 12422, 12216, 12291, 12596, 12577, 12411, 12702, 3053, 12649, 12373, 846, 12413, 12322, 3300, 12847, 13417, 12412, 12254, 11707, 12674, 12853, 12805, 21160, 12588, 14163, 22633, 15822, 7715, 16010, 12752, 22638, 12748, 12846, 12349, 12613, 12652, 12348, 12464, 12347, 12350, 12706, 12519, 12677, 12602, 12754, 12655, 12712, 12605, 12653, 12774, 11710, 20566, 13023, 12727, 12769, 12597, 12277, 12524, 17756, 12773, 12573, 12645, 11798, 10946, 12722, 12804, 24966, 12762, 12852, 30072, 12272, 12638, 11827, 12851, 12749, 11730, 12695, 12673, 12383, 12646, 12740, 12273, 12770, 12788, 12830, 12827, 12863, 12452, 12760, 12696, 12833, 12832, 12546, 12551, 12550, 11482, 12549, 12651) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---