---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(27948, 28000, 27945, 27947, 27946, 27951, 15897, 27950, 27997, 28044, 28152, 27954, 27953, 27952, 28105, 28015, 27979, 27862, 27969, 27968, 27766, 27956, 27957, 27971, 27966, 27980, 28394, 27973, 27970, 27982, 27961, 27981, 27983, 27958, 27053, 27962, 27786, 27856, 36569, 27972, 27974, 27996, 27959, 27885, 27960, 27967, 27984, 27964, 27990, 27985, 27986, 33630, 27992, 27991, 27994, 27993, 27998, 26831, 27869, 28005, 28020, 28011, 28021, 28014, 28006, 28094, 28027, 28019, 28013, 28025, 28030, 28031, 28029, 28034, 27705, 27919, 28110, 28004, 27975, 27785, 29592, 28089, 27844, 28022, 28001, 28002, 28003, 28026, 28038, 28437, 28041, 28040, 28921, 28043, 28045, 28046, 28049, 28079, 28051, 28042, 28059, 37431, 28028, 27809, 28069, 28080, 28063, 28086, 28050, 28065, 28066, 28054, 28108, 28056, 28055, 28053, 27648, 28047, 28061, 28060, 27605, 28140, 28064, 27817, 27816, 28070, 28083, 28092, 28919, 28093, 27949, 11719, 27995, 28098, 28138, 28104, 28100, 28102, 28103, 28095, 28285, 28107, 28184, 28155, 28112, 24773, 28120, 28117, 28111, 28145, 28115, 28146, 28132, 28081, 28116, 28109, 27507, 28126, 28114, 28113, 28052, 28121, 28119, 28122, 28137, 28136, 27934, 22230, 28144, 28143) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---