---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(31469, 31353, 31428, 31454, 38444, 31434, 31357, 25036, 31610, 31435, 31436, 32456, 31441, 31229, 31461, 31445, 31447, 31457, 31453, 31476, 31433, 31443, 31463, 31465, 31460, 31345, 31500, 31462, 31423, 31452, 31295, 31459, 31451, 31444, 31474, 31478, 31440, 31439, 31458, 31446, 31442, 31466, 31468, 31467, 31471, 31473, 31470, 31477, 31483, 31392, 31514, 31487, 31448, 31488, 31304, 31868, 31495, 31502, 31481, 31270, 31493, 31491, 31509, 31506, 31498, 31449, 31492, 31393, 31485, 31497, 31486, 31494, 31504, 31490, 31513, 31501, 31499, 31791, 31507, 31508, 31578, 31510, 31515, 31519, 31516, 31518, 32155, 31511, 31521, 31524, 4417, 31539, 31083, 31535, 31530, 31484, 31529, 31533, 31512, 31545, 31543, 31532, 33291, 31431, 31531, 31520, 31432, 31425, 31450, 31526, 37154, 31540, 31536, 31534, 31527, 31538, 31528, 32567, 31246, 31541, 31577, 31522, 31542, 31547, 31525, 31552, 31559, 31553, 37153, 37152, 31561, 31557, 31564, 31558, 31555, 31573, 31581, 31583, 31582, 31585, 31572, 31554, 31579, 31609, 31588, 31438, 31546, 31576, 31565, 31570, 31580, 31605, 31562, 31569, 31567, 31575, 31586, 31594, 31335, 30933, 31574, 31566, 31568, 31563, 31523, 31589, 31593, 31596, 31385) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---