---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(10421, 10694, 10695, 10949, 10691, 10696, 10600, 10722, 10601, 10718, 10693, 10508, 10675, 10650, 10700, 10673, 10544, 9923, 10761, 10649, 8570, 10513, 10620, 10697, 10501, 10720, 10699, 10771, 10698, 10759, 10731, 10783, 10744, 10976, 11808, 10704, 10719, 10520, 10787, 10765, 10738, 21483, 10737, 10793, 10813, 10702, 10640, 10502, 10519, 10466, 10746, 9359, 10611, 10592, 10812, 10634, 10758, 10811, 10788, 11061, 10629, 9391, 10801, 10628, 10560, 10763, 10764, 10770, 7960, 26400, 10807, 10558, 10808, 10809, 10810, 10623, 10674, 10484, 10359, 10835, 10862, 10760, 10568, 10233, 10593, 10440, 10279, 10756, 10009, 10137, 10602, 10507, 10669, 10361, 10565, 10973, 12233, 10806, 9236, 10730, 7623, 10870, 10766, 10729, 10717, 10589, 10606, 10794, 10762, 10874, 12389, 10795, 10774, 10709, 10711, 10782, 10754, 10294, 10873, 10855, 10710, 10362, 10805, 10713, 10420, 10516, 10829, 13369, 10515, 10796, 10281, 11887, 10778, 10814, 10588, 10319, 10864, 10924, 10844, 10804, 10828, 10866, 10833, 10834, 10865, 10832, 10785, 10784, 10882, 10624, 10767, 10923, 10877, 10869, 10875, 10872, 10878, 10876, 10879, 10665, 10871) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---