---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(29249, 28913, 28884, 28907, 28852, 28912, 28908, 28906, 28914, 28915, 28924, 37432, 28925, 28870, 28943, 28940, 28926, 28939, 28931, 28929, 28986, 27961, 28923, 28826, 28932, 28937, 28930, 28861, 28936, 28215, 28214, 28928, 28788, 29098, 28938, 28951, 28945, 28949, 28950, 28959, 28957, 28956, 28960, 28961, 28958, 28963, 28970, 28968, 28967, 28997, 28981, 5601, 28983, 28989, 28975, 28988, 28985, 28486, 28942, 28987, 28979, 28213, 29031, 28977, 28800, 28971, 28992, 28980, 28496, 28978, 28973, 33937, 29025, 28991, 29027, 28966, 29028, 29119, 29029, 29040, 29036, 29038, 29035, 29037, 29039, 29047, 29057, 28563, 28982, 23535, 29061, 29108, 29044, 29056, 29034, 29042, 29043, 29022, 29023, 28777, 29726, 28568, 29069, 29063, 29055, 29046, 29060, 28972, 29030, 29045, 29032, 29050, 29049, 29052, 29059, 29136, 29051, 29053, 29041, 29064, 29068, 29081, 29118, 29071, 29077, 29073, 28747, 29072, 29082, 29033, 28955, 29076, 29084, 29080, 29058, 29024, 28974, 29048, 29124, 29095, 29092, 29088, 29089, 29078, 29099, 29094, 29114, 29083, 29096, 29097, 29109, 29102, 29086, 28976, 28994, 29087, 29093, 29085, 29112, 29111, 29113, 29100, 29054, 29193, 29103) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---