---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(17582, 17583, 17561, 17623, 17792, 17191, 17560, 17581, 17580, 17562, 17572, 17549, 17577, 17579, 17587, 17550, 17563, 17647, 17769, 17470, 17632, 17633, 17768, 17586, 17502, 17767, 21388, 17596, 17770, 17766, 17765, 17764, 17088, 17762, 17532, 17462, 17087, 27874, 17269, 17057, 17369, 15816, 17585, 17463, 17400, 17399, 17630, 17484, 17642, 17495, 17595, 17593, 17763, 19752, 16890, 17522, 17559, 17436, 16615, 17250, 17143, 17433, 17663, 17509, 17590, 17516, 17760, 17761, 17524, 17677, 23262, 17759, 19787, 17758, 17628, 17709, 17458, 17602, 17576, 17554, 17675, 17661, 17545, 17666, 17469, 17567, 17626, 17447, 17552, 17297, 17513, 17565, 16135, 17668, 17523, 17667, 17473, 17697, 17472, 17696, 17713, 17714, 17720, 17783, 17548, 17784, 17605, 17785, 17604, 17692, 17774, 17360, 17727, 17294, 17285, 17379, 17446, 17698, 23807, 17370, 17711, 17712, 17204, 16682, 17468, 17665, 17776, 17578, 17574, 17662, 23113, 22314, 27744, 17546, 17670, 17510, 17395, 17786, 16882, 17638, 17601, 17413, 18176, 17726, 17787, 17715, 17434, 17788, 17789, 18174, 17520, 17592, 17840, 17591, 17606, 18177, 17607, 17790, 17796, 17826, 16621, 17775, 17445, 17398, 17643, 17823, 17573, 17537, 17716, 18170, 17382, 17699, 16760, 17334, 17621, 17538, 17671, 18171, 18175, 17710, 18178, 15102, 18173, 17378, 18727, 17089, 17725) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---