---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(32535, 31995, 31999, 31992, 31994, 31997, 32049, 31998, 32008, 32029, 31940, 32014, 32012, 32048, 31317, 32024, 32031, 32007, 31934, 445, 32010, 32017, 32032, 32020, 32018, 32005, 32021, 32040, 31962, 32025, 32016, 32015, 32030, 32013, 31947, 32019, 32022, 32023, 32026, 32027, 32034, 32028, 32039, 32065, 32046, 32044, 32041, 32051, 32052, 32055, 32035, 32063, 32011, 32064, 32062, 32058, 32053, 31870, 32045, 32074, 32006, 32054, 32066, 32037, 32056, 32059, 32004, 32057, 31941, 32061, 32060, 32069, 32075, 32067, 32068, 32072, 32070, 36457, 32073, 32071, 32078, 32076, 32112, 32082, 32081, 32451, 32080, 32452, 32083, 37440, 32084, 32043, 32131, 32087, 32132, 32298, 32088, 32086, 32097, 32093, 32079, 32114, 32103, 32094, 32129, 32077, 32113, 32101, 32102, 32038, 32110, 32090, 32091, 32096, 32121, 32095, 32111, 32126, 32130, 32092, 32089, 32128, 32100, 32104, 32085, 32098, 34468, 32105, 32106, 33787, 32107, 36714, 32108, 32109, 32116, 32117, 32115, 32118, 32120, 32133, 32124, 32119, 32122, 32123, 32137, 32141, 32136, 32148, 32134, 32135, 32404, 32146, 32147, 31784, 32140, 32195, 32042, 32138, 32159, 32158, 32150, 32403, 31782, 32139, 32368, 31783, 32142, 32143, 32145, 32144) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---