---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(35397, 35395, 35406, 35409, 35407, 35408, 35415, 35410, 35414, 35411, 35412, 35422, 35423, 35416, 35435, 35417, 35511, 35441, 35455, 35462, 35370, 35402, 35419, 35427, 35461, 35420, 35512, 35448, 35311, 35460, 35425, 35432, 35428, 35440, 35430, 35433, 35464, 35473, 35454, 35472, 35467, 35418, 35431, 35436, 35421, 35424, 35439, 35452, 35445, 35450, 35446, 35447, 35465, 35458, 35457, 35470, 35466, 35471, 35469, 35459, 35481, 35475, 35482, 35498, 38207, 34696, 34449, 35484, 35493, 35499, 35504, 35480, 35476, 35492, 35474, 35500, 35507, 35379, 36677, 35489, 35478, 35477, 35488, 35491, 35506, 35510, 35508, 35517, 35387, 35479, 35490, 35505, 35485, 35494, 35463, 35497, 35502, 35501, 35552, 35503, 35553, 35389, 35514, 35523, 35516, 35519, 35521, 35546, 35703, 35522, 35525, 35326, 35562, 35558, 35564, 35487, 35534, 35524, 35518, 35528, 35560, 34206, 35527, 35563, 35532, 35536, 34940, 35568, 35526, 35537, 34204, 35648, 35559, 35538, 35530, 35545, 35565, 35548, 35531, 34943, 35529, 35535, 35566, 35571, 35540, 35567, 35142, 35366, 35603, 36401, 35547, 35549, 35550, 35317, 35554, 35551, 35686, 35456, 35515, 35578, 35572, 35576, 35581, 35579, 35760, 35580, 35582, 35583, 35587, 35588, 35586, 35589, 35597, 35731, 35575, 35591, 35627, 35623, 35625, 35626, 35598, 35605, 35606, 35614, 35604, 35602, 35620, 35596, 35590, 35593, 35585, 35584, 36245, 35599, 35595, 35533, 35594, 35573, 35621, 35608, 35607) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---