---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(25195, 24454, 24070, 24444, 24071, 24069, 24446, 24073, 24445, 24072, 24228, 24706, 24487, 24341, 24426, 24449, 24465, 24451, 24581, 24514, 24453, 24365, 24484, 24452, 24525, 24425, 24366, 24456, 24455, 21870, 24409, 24491, 24315, 24470, 24464, 24562, 23181, 24461, 25080, 10099, 24511, 24462, 24467, 24135, 24092, 24469, 24493, 24074, 24254, 24472, 24478, 24466, 24486, 24460, 24459, 24438, 24468, 24463, 25046, 24501, 24708, 24428, 25311, 25310, 24517, 25258, 24519, 24516, 24537, 24191, 24037, 24705, 24146, 24538, 24535, 24542, 35413, 24391, 24458, 25414, 24263, 20197, 24524, 24386, 24529, 24196, 24427, 24448, 24545, 24035, 24574, 24424, 24513, 24619, 24532, 24531, 24530, 24539, 24563, 24522, 24518, 24536, 24533, 24534, 24271, 24429, 24376, 24273, 24541, 24521, 24549, 24550, 24568, 24567, 24625, 24609, 24560, 24559, 24564, 24565, 24570, 24640, 24573, 24569, 24571, 24572, 24255, 24577, 24471, 24597, 23553, 24544, 24592, 24551, 24599, 24579, 24584, 24580, 24610, 24527, 24585, 24582, 24607, 24252, 24450, 24515, 24523, 24227, 24258, 24594, 24576, 24583, 24512, 24586, 24593, 24595, 24596, 24400, 24221, 24598, 24600, 24591, 24396, 24528, 24589, 24209, 24719, 24588, 24590, 24587, 24328, 24329, 24578, 24192, 24617, 24480, 24622, 24608, 25478, 24621, 24620, 24660, 24447, 24626, 24629, 24543, 27943, 24624, 24630, 23854, 27937, 24421, 25130, 24623, 24844, 24843, 24628, 24627, 24078, 24080, 24646, 24338, 24633, 23523, 24631, 24641, 24647, 24552, 24652, 24635, 24636, 24869, 24637, 23939, 24634, 24747, 24659, 24575, 24658, 24847, 24670, 24679, 24264, 24683, 24668, 24256, 24681, 24672, 24540, 24440, 24793, 24686, 24671, 23823, 24676, 24566, 24618, 24791, 24510, 24663, 24680, 24692, 24669, 24687, 24797, 24675, 24664, 24673, 24674, 24678, 24709, 23678, 24632, 24682, 23579, 24691, 24689, 29196, 24688, 24690, 23970, 24702, 24701, 24703, 23848, 24704) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---