---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(38541, 38595, 38578, 38581, 38579, 38580, 38583, 38582, 38586, 38607, 38585, 38589, 38588, 38587, 38594, 38602, 38598, 38591, 38597, 38592, 38608, 38600, 37992, 38605, 37812, 38593, 38603, 38606, 38601, 38596, 38609, 38612, 38611, 38613, 38618, 38571, 38576, 38616, 38614, 38626, 38634, 38706, 38672, 38078, 38642, 38630, 38628, 38343, 38109, 38636, 37679, 38490, 38650, 38620, 38651, 38488, 38639, 38638, 38647, 38624, 38633, 38617, 38637, 38635, 38629, 38627, 38641, 38644, 38640, 38649, 38646, 38648, 38661, 38643, 38625, 38660, 38656, 38652, 38657, 38658, 38659, 38663, 38691, 38662, 38668, 38671, 38682, 38673, 38619, 38678, 38667, 38654, 38670, 38690, 38664, 38677, 38674, 38669, 38653, 38705, 38676, 38665, 38666, 38248, 38702, 38655, 38694, 38195, 38685, 38688, 38695, 38698, 38703, 38704, 38701, 38700, 38707, 38699, 38709, 38710, 38681, 38715, 38711, 38716, 38708, 38714, 38721, 38713, 38260, 38621, 38720, 38409, 38722, 38717, 38724, 38561, 38562, 38718, 38442, 38306) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---