---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(35401, 7723, 7682, 9566, 7721, 7719, 7720, 7722, 28844, 7845, 20956, 7465, 7507, 7446, 7799, 7468, 7266, 7213, 7684, 7420, 15939, 7820, 7486, 15263, 7609, 7614, 28301, 7638, 7576, 7763, 7718, 7594, 7644, 5448, 7804, 7846, 7628, 22639, 22599, 7822, 7715, 7704, 7701, 8349, 7652, 7653, 7823, 7702, 7703, 7160, 7904, 7694, 7416, 7610, 7551, 7463, 7447, 7727, 7604, 7639, 7534, 7690, 6842, 7529, 11049, 28041, 7668, 7567, 7572, 7669, 7098, 7903, 21393, 7792, 7698, 7699, 7752, 8750, 7827, 8751, 7826, 7603, 8745, 35561, 7943, 23343, 7748, 7602, 7779, 27886, 7745, 7777, 7791, 8100, 7749, 24322, 7533, 7790, 7764, 7600, 7805, 7767, 7825, 7754, 7757, 7778, 7672, 15850, 28678, 7802, 29014, 28764, 8859, 8860, 8861, 19747, 28755, 7855, 7742, 7772, 6421, 7894, 29927, 7009, 29815, 7697, 28838, 29921, 15877, 28687, 29818, 28691, 29004, 28759, 7931, 7724, 28688, 7532, 29017, 29938, 29941, 29931, 29813, 7725, 29946, 29919, 7631, 7641, 7530, 7844, 7709, 7526, 7847, 28894, 7095, 7747, 7543, 7913, 7606, 7906, 7689, 7635, 7905, 7710, 7685, 7785, 7783, 7786, 7705, 7800, 7784, 28898, 28677, 28766, 7717) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---