---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(16237, 16147, 16352, 16236, 16296, 16098, 16235, 16312, 15724, 15705, 16351, 16862, 16350, 16393, 16349, 16361, 16373, 16387, 16145, 16101, 16250, 16366, 23956, 16253, 16388, 15747, 16252, 15616, 15617, 16374, 16239, 16362, 16140, 16364, 15866, 16421, 16319, 16903, 16226, 16403, 16404, 16401, 16402, 16181, 16422, 16423, 16297, 16413, 16410, 16378, 16377, 16461, 16424, 16369, 16545, 16327, 16082, 16420, 16244, 15019, 16483, 16389, 16381, 16194, 16367, 16511, 16127, 16314, 16368, 16212, 16382, 16321, 16544, 16451, 14914, 16058, 16371, 16425, 16697, 16238, 16587, 16427, 16670, 16442, 16543, 16441, 16146, 16178, 16179, 16491, 13214, 16542, 16503, 16445, 16541, 15662, 16411, 16462, 15713, 16251, 16103, 16457, 15242, 17163, 16383, 16384, 16395, 16385, 16216, 16110, 37760, 16175, 16324, 16538, 16217, 16301, 16546, 16372, 8591, 21779, 16107, 16294, 16540, 16539, 15952, 16870, 16094, 16871, 16550, 16930, 16097, 16256, 16468, 16476, 16307, 16467, 16469, 16549, 16548, 16481, 16471, 26573, 16409, 16478, 16426, 16691, 16504, 16355, 16326, 16487, 17754, 16477, 16241, 16497, 28221, 16356, 16440, 26464, 16464, 16189, 18258, 16240, 16230, 38187, 16408, 16489, 16397, 15910, 16463, 15960, 16206, 8078, 16407, 16485, 16406, 16430, 16582, 16396, 16701, 16207, 16405, 15884, 15507, 15794, 16428, 16472) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---