---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(7605, 7780, 7732, 7737, 7735, 7799, 7642, 7850, 7731, 7736, 7674, 7734, 7852, 7569, 7820, 7760, 7849, 7781, 7733, 6118, 24321, 7603, 7763, 7711, 7643, 7634, 7007, 7895, 7671, 7824, 7570, 7885, 5520, 7622, 28892, 15417, 28795, 29005, 7746, 7743, 7756, 7744, 7758, 7755, 7865, 10042, 37265, 7775, 8342, 7770, 8618, 7862, 4437, 7900, 7899, 7762, 7884, 8381, 7695, 7696, 7687, 7630, 7675, 7901, 7686, 7902, 7712, 7085, 7853, 7771, 10581, 7739, 7829, 10292, 7539, 7894, 8081, 7782, 8221, 10943, 7864, 10616, 7942, 7866, 7920, 7601, 7631, 7919, 1983, 7941, 14111, 16022, 7761, 7793, 7915, 7714, 7713, 7936, 7918, 7861, 28887, 7600, 7798, 7916, 16650, 28198, 7907, 7730, 7729, 8036, 24303, 9691, 8348, 22431, 7959, 7670, 7676, 7958, 8182, 12458, 7500, 7632, 10732, 7870, 7863, 7979, 7869, 7633, 7635, 17811, 7313, 7708, 7856, 7953, 7636, 7947, 7854, 7880, 7879, 7881, 29065, 7882, 28835, 28696, 8222, 28767, 7647, 19927, 22535, 27412, 7971, 7972, 7860, 7858, 7859, 7990, 7986, 7673, 7991, 7406, 8589, 8276, 8003, 8002, 7750, 7933, 22042, 7932, 7955, 7923, 22595, 8192, 8226, 8373, 37353, 20609, 22597, 7977, 21484, 8722, 9067) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---