---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(21153, 21124, 21256, 21199, 21178, 21177, 21179, 21189, 36171, 21280, 20346, 21128, 20999, 18868, 21080, 21187, 21182, 21186, 21070, 20725, 20882, 20667, 21213, 21181, 21235, 20782, 20843, 20829, 20889, 21086, 21220, 21200, 21152, 21151, 21084, 21221, 30258, 21219, 21222, 21315, 24302, 21223, 21231, 21313, 21314, 21362, 20783, 21233, 19153, 21230, 21183, 21258, 21083, 20795, 21184, 21185, 21252, 21331, 21226, 21255, 21254, 20770, 21376, 21261, 21260, 23047, 21214, 21215, 21225, 20910, 21224, 20841, 21076, 21031, 21229, 20579, 21188, 21052, 21288, 21263, 20853, 20568, 21400, 21399, 21266, 21096, 18787, 21117, 21281, 21253, 20874, 20979, 21273, 21036, 21283, 21284, 21079, 21318, 21037, 21303, 21302, 21290, 17120, 21268, 21312, 21294, 21301, 21287, 21032, 21322, 20995, 21295, 21293, 21305, 21296, 21071, 20903, 21300, 21297, 21033, 21008, 21270, 21292, 21227, 21289, 21104) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---