---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(21564, 21340, 21530, 21321, 21336, 21342, 20191, 21328, 21492, 21309, 21339, 21329, 261, 21128, 20995, 21346, 21245, 20454, 20471, 21343, 21267, 21345, 21348, 21349, 21072, 21243, 21347, 20116, 21609, 21323, 21344, 21363, 20036, 23940, 20834, 21365, 21364, 21350, 21373, 21381, 21374, 21282, 21433, 21396, 21380, 21291, 21228, 21262, 25063, 21126, 21272, 21071, 21367, 21234, 20983, 20799, 21378, 21384, 21216, 21377, 22368, 21672, 21379, 21320, 21190, 21034, 21574, 21334, 21419, 21420, 25183, 21333, 21337, 21411, 21520, 21409, 21405, 21406, 21404, 21407, 21430, 21385, 21423, 21372, 21450, 21575, 21425, 6621, 21427, 21382, 21162, 22489, 21353, 21127, 21431, 21341, 21434, 21424, 21422, 21477, 21445, 21625, 21454, 21447, 21366, 21449, 21448, 21455, 21415, 21383, 18352, 17722, 21456, 21629, 21084, 20187, 21466, 21482, 21457, 21475, 21468, 21462, 21481, 21070, 21532, 21360, 21428, 21469, 21368, 21371, 21369, 21361, 21461, 21463, 21465, 21129, 21459, 21460, 21464, 21304, 21514, 21508, 21218, 21306) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---