---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(30394, 30454, 30392, 30453, 30391, 30396, 33633, 30401, 30400, 30405, 30452, 30417, 29479, 29710, 30445, 31279, 30434, 30441, 30418, 30413, 30442, 30424, 30409, 30415, 30410, 30431, 30398, 30444, 30435, 30426, 30439, 30432, 30440, 23067, 23066, 30443, 30039, 30395, 30416, 30423, 30427, 30451, 30887, 30412, 30411, 30406, 30437, 30421, 30408, 30414, 30422, 30740, 30487, 30430, 30402, 30360, 30447, 30448, 30403, 30399, 30450, 30534, 1412, 29486, 4191, 30460, 30458, 30488, 30468, 30467, 30457, 30381, 30463, 30456, 30475, 30473, 30480, 30323, 29270, 30486, 30348, 29269, 30465, 30472, 30324, 30485, 30469, 30478, 30459, 30051, 30471, 30470, 28316, 30188, 30466, 30464, 30479, 30476, 30589, 30484, 30489, 30300, 30647, 12128, 30495, 1557, 30493, 30494, 30535, 30533, 30500, 30532, 30501, 30517, 512, 30525, 30506, 30420, 30518, 30502, 30490, 30522, 29271, 30508, 30255, 30531, 30503, 30510, 30528, 30509, 30526, 30419, 29484, 30523, 30505, 30524, 30514, 29673, 30519, 30516, 30513, 30515, 30507, 30504, 30143, 30455, 30521, 30530, 30340, 30545, 30548, 30539, 30541, 30542, 30547, 30540, 33646, 30546, 30570, 30553, 30554, 30551, 30549, 30562, 30550, 30579, 30552, 30571, 30511, 30563, 30559, 30564, 30567, 30560, 30569, 29880, 30573, 30594, 29483, 30561, 30474, 30572, 30241, 30566, 30491, 30565, 30578, 30497, 30558, 30574, 30568, 30425, 30576, 30581, 29995, 30577, 30580, 30499, 30557, 30363, 30575, 30593, 30702, 30592, 30591, 30584) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---