---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(8423, 25031, 8422, 8148, 11141, 8440, 8375, 7848, 8138, 8174, 8139, 8364, 28423, 8643, 8585, 8238, 8427, 8249, 8412, 8205, 8379, 8110, 8413, 8376, 8259, 8243, 8322, 8294, 8415, 8170, 8341, 8791, 8516, 8640, 8478, 8729, 8677, 8940, 8633, 25077, 8717, 7969, 8641, 8430, 8431, 8678, 8716, 22945, 8474, 8659, 8321, 8727, 24653, 8255, 8649, 8449, 8495, 8060, 8136, 8242, 8134, 8135, 8214, 8475, 8463, 8462, 8637, 8720, 8197, 8624, 8428, 8089, 8656, 10133, 8421, 8418, 8520, 8627, 8192, 8410, 8090, 8630, 8168, 8417, 8452, 8648, 8176, 8708, 8432, 8517, 8626, 8646, 8328, 8441, 8635, 8357, 8470, 8723, 8651, 8632, 8726, 13372, 8718, 8533, 8703, 8700, 8715, 8709, 8706, 8846, 7886, 9872, 7807, 8870, 8725, 8501, 8764, 8765, 8282, 8680, 8724, 8735, 8754, 8645, 9286, 8442, 8661, 8500, 8326, 8290, 8363, 28739, 8289, 8639, 8453, 8436, 8506, 8631, 8869, 8361, 8400, 8437, 8505, 8507, 8459, 8457, 8455, 8458, 8052, 8629, 8256, 8468, 8245, 8628, 8668, 8454, 8362, 8438, 8647, 8467, 7926, 8489, 8488, 8490, 8287, 8456, 8198, 8699, 8638, 8460, 8281, 8323, 8340, 8466, 8941, 8942, 8429, 8874, 8642, 8652, 8650, 8847, 8667, 8574, 8094, 8654, 8534, 22542, 8644, 7181, 7180, 7179, 11038, 8583, 8899, 8707, 22541, 8660, 8719, 8569, 8572, 8509, 8473, 8324, 8365, 8239, 8521, 8571, 655, 8213, 8132, 8209, 8494, 8137, 8487, 8582, 8325, 8492, 8524, 8464, 8663, 8510, 8503, 3024, 8408, 8568, 8237, 23352, 8634, 8676, 8675, 8879, 8653, 5905, 8666, 15198, 8670, 8636, 8679, 8396, 8662, 8722, 8714, 1614, 8721, 8283) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---