---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(6667, 8378, 6665, 6666, 22232, 22205, 7027, 6765, 10818, 6579, 19219, 6999, 6650, 7156, 6706, 6770, 6689, 6560, 6583, 8001, 6690, 6711, 6713, 6664, 6869, 6759, 6601, 6630, 30279, 6631, 28076, 14440, 5607, 8092, 6710, 9394, 8793, 7806, 6797, 8749, 6708, 6695, 6820, 17652, 6739, 6620, 6776, 7118, 7119, 7258, 6694, 12861, 6693, 7034, 29106, 6610, 6709, 6839, 15383, 6841, 22030, 7835, 7054, 6986, 6764, 6773, 22201, 6774, 6725, 23250, 6862, 7831, 7832, 7833, 7834, 6761, 6701, 6640, 6702, 6673, 7114, 6743, 32353, 6576, 11460, 6793, 6726, 6606, 6783, 6769, 6700, 6632, 6827, 6768, 8497, 7186, 7996, 26461, 6609, 6652, 6651, 6607, 22203, 6593, 6746, 7036, 7483, 6425, 7059, 6608, 6781, 7067, 6790, 5322, 6707, 6794, 7040, 9360, 6767, 22683, 14278, 22482, 22483, 26621, 26506, 12200) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---