---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(21677, 22025, 22023, 22024, 22066, 22082, 22070, 22068, 22069, 22084, 22067, 22085, 22059, 22090, 22091, 22093, 22088, 22087, 22097, 22039, 21872, 22017, 22105, 22120, 21899, 22101, 21906, 22051, 22083, 22100, 22099, 22016, 22080, 22098, 22096, 21341, 22387, 21940, 21512, 22116, 23560, 22104, 22102, 22124, 21970, 21966, 22119, 22103, 22107, 21877, 22460, 21878, 21274, 31146, 22129, 22123, 22130, 22156, 22128, 22133, 22135, 22134, 22089, 22155, 22131, 22143, 22161, 22142, 22144, 22138, 22145, 22153, 22126, 21713, 22000, 21982, 22151, 22194, 22077, 22150, 22022, 22175, 21621, 22075, 21888, 22159, 28969, 22152, 22028, 21867, 22146, 21772, 22125, 22095, 22113, 22158, 22148, 22149, 22147, 21752, 22081, 22073, 22166, 22168, 22057, 22021, 22167, 22244, 22906, 22189, 22173, 21945, 22114, 22180, 23897, 21699, 22027, 21975, 21976, 22185, 22086, 21186, 22179, 22178, 22181, 36304, 22174, 21863, 21907, 22118, 22112, 22183, 22137, 22157, 22079, 22132, 21549, 22169, 21548, 22182, 22184, 22186, 22177, 22208, 22190, 22216, 22207, 22211, 22154, 26187, 22213, 24079, 22219, 22214, 22220, 36173, 36163, 36168, 22136, 22210, 22222, 22221, 22195, 22122, 25198, 21428, 22224, 22071, 22019, 36160, 22223, 22212, 21799, 22029, 22196, 22197, 22262, 22230, 21551, 23139, 22127, 23787, 22198, 22296, 22405, 21865, 22268, 22269, 22274, 22270, 22267, 22273, 22271, 22140, 22139) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---