---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(22561, 22426, 22302, 21873, 22464, 22470, 22467, 22463, 22403, 22587, 22471, 22507, 22462, 22469, 22475, 22425, 22388, 22545, 22461, 22478, 22071, 22335, 22228, 22227, 22170, 21811, 23008, 21550, 22362, 22141, 21985, 21977, 22132, 22476, 22466, 22493, 22428, 22427, 22501, 22498, 22499, 22494, 22295, 22530, 22505, 22955, 22516, 22506, 22513, 22511, 22454, 22514, 22521, 21031, 22503, 22345, 22344, 20925, 22272, 22544, 23555, 22553, 22226, 22519, 22304, 22319, 22340, 22401, 22217, 22517, 21772, 22523, 22528, 22518, 22385, 27078, 21704, 22163, 22389, 22479, 22520, 22171, 22477, 23201, 22423, 22502, 22527, 22522, 22492, 22547, 22571, 22574, 22548, 22491, 22512, 22550, 22549, 22554, 22570, 22546, 22569, 22614, 22615, 22543, 22558, 22559, 22557, 22560, 25297, 25296, 22572, 22576, 22581, 22551, 22555, 22575, 21774, 22602, 22077, 22578, 22579, 22580, 22440, 22566, 22565, 22474, 22582, 22525, 6742, 22586, 22573, 22577, 22584, 22225, 23594, 22585, 22524, 22592, 22147, 22552, 22229, 22627, 22607, 22603, 22563, 22562, 22609, 22655, 22617, 22613, 22455, 22618, 22456, 22608, 22626, 22526, 22180, 22622, 21895, 22610, 22445, 22531, 22621, 21863, 22616, 22504, 22510, 22160, 22628, 21689, 22604, 22612) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---