---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(18477, 18320, 18200, 18201, 18321, 18336, 18337, 18319, 16416, 19208, 17519, 19209, 18461, 18286, 18227, 18302, 18296, 18764, 18006, 18234, 18322, 18315, 18343, 18000, 19204, 18197, 17920, 17961, 18066, 18294, 18058, 18087, 22279, 3744, 18314, 21232, 19203, 25247, 18354, 18122, 18385, 18360, 19217, 18305, 18304, 18363, 18242, 18270, 19220, 18329, 18345, 18069, 17934, 18342, 18068, 18258, 19216, 17846, 18364, 18365, 18326, 18347, 19215, 18216, 17951, 26471, 28202, 19212, 18250, 18368, 18251, 18352, 18377, 18375, 18374, 18378, 18379, 18340, 33419, 18383, 20722, 18306, 18303, 18231, 18393, 18386, 18380, 18417, 18367, 18205, 18071, 18091, 18279, 18348, 18398, 18117, 31611, 18359, 18411, 18003, 18332, 33418, 18479, 18409, 18412, 18413, 13341, 18410, 18478, 18381, 18308, 18396, 18293, 18400, 18369, 18389, 18394, 20057, 18399, 18370, 18291, 18395, 18407, 18405, 18404, 18403, 18401, 18406, 18402, 18311, 18310, 22533, 18408, 18425, 18203, 13259, 18092, 27382, 18426, 19410, 17144, 18390, 18260, 18428, 18252, 18449, 18435, 18445, 18316, 18442, 18438, 18095, 18446, 19223, 23406, 19224, 18307, 17554, 18424, 3060, 18418, 18064, 18218, 19225, 18391, 18443, 18247, 18414, 18244, 18245, 18239, 18346, 18432, 18460, 18067, 18256, 18492, 18392, 19214, 18466, 18229, 19213, 19067, 19167) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---