---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(16493, 16547, 16494, 16443, 16394, 16298, 16496, 16521, 16390, 16583, 16415, 16520, 16668, 16522, 16363, 16446, 16486, 19321, 16580, 25568, 16581, 16145, 16567, 7836, 7838, 8823, 7831, 7837, 16482, 16537, 16574, 15019, 16139, 16500, 16571, 16569, 16465, 16515, 16127, 16573, 16397, 16175, 16182, 16491, 16453, 15926, 16579, 16228, 16188, 16212, 16506, 16514, 16499, 16452, 16498, 16575, 16576, 16577, 16177, 16473, 16376, 16292, 13214, 16530, 16470, 16204, 16560, 19308, 26536, 16660, 20906, 16531, 16593, 16444, 16561, 16516, 16692, 16659, 16657, 16658, 16664, 26535, 16480, 16479, 16656, 16458, 16606, 16676, 16625, 16459, 16523, 16717, 16497, 16559, 16370, 16400, 16590, 16191, 16454, 15945, 16694, 16654, 16663, 12585, 16558, 16607, 19204, 16508, 16509, 16324, 16586, 16608, 16466, 26574, 16524, 16655, 16335, 16490, 16669, 16826, 38314, 16611, 16610, 16724, 16433, 16720, 16612, 16723, 16675, 16629, 16725, 16620, 16711, 16631, 16449, 16180, 16504, 16643, 16604, 16398, 16613, 16609, 16728, 16048, 21276, 16231, 16683, 16617, 16255, 16603, 16687, 16431, 16189, 16719, 16358, 16642, 16450, 16718, 16357, 16333, 16592, 16448, 16203, 15747, 16447, 16595, 16727, 16726, 16510, 16529, 16730, 16644, 16419, 15185, 13697, 16757, 17664, 16684, 16714, 16756, 16525, 16754, 16215, 16200, 16517, 16693, 16685, 16651, 16713, 16599, 16715, 16600, 16739, 16712, 16764, 16536, 16416, 16487, 16213, 16455, 16765, 16594, 19307, 16677, 16710, 16230, 16563, 16686, 16671, 16395, 16418, 16605, 16245, 16598, 16129, 16229, 16315, 16755, 16332, 16626, 16667, 27915, 16689, 16435, 16628, 16627, 36895, 16674, 16673, 26644, 16731, 16828, 11726, 16716, 16796, 16830, 16776, 16799, 16596, 11406, 11598, 13995, 13988, 16742, 24684, 16614, 19205, 16391, 16852, 16634, 16589, 16851, 16797, 16386, 16741, 16243, 15837, 7207, 16740, 16829, 13585, 13584, 16849, 16831, 16700, 16798, 16850, 16615, 17399, 16858, 16791, 16331, 16688, 20025, 16801, 16672, 16857, 16800, 14297, 16519, 16661) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---