---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(14291, 14059, 14254, 14056, 13910, 14223, 14224, 14230, 14248, 14127, 13894, 14229, 14177, 14245, 13890, 14225, 14226, 14244, 14258, 14028, 13836, 14210, 14287, 6377, 14247, 14211, 14286, 13948, 15254, 13730, 14032, 13681, 13305, 13306, 13849, 14312, 18361, 14030, 14235, 14175, 14243, 14259, 28452, 13778, 14029, 13858, 14324, 14208, 14209, 14037, 14050, 13928, 13892, 14017, 25690, 14106, 14825, 19414, 14020, 14260, 14019, 14288, 14192, 14276, 14261, 14350, 22890, 14450, 14369, 14289, 14314, 14339, 14262, 14045, 14088, 14313, 14319, 14318, 14317, 14315, 14316, 14256, 14255, 13079, 14271, 14171, 14016, 14264, 14099, 14265, 15441, 14027, 14087, 14263, 14300, 14351, 14308, 14307, 14046, 14184, 14220, 13899, 13927, 13965, 14102, 14295, 14327, 13649, 13845, 13900, 14310, 14311, 14328, 14266, 14205, 13901, 14026, 15463, 13909, 13978, 14241, 14274, 13984, 14309, 14236, 14296, 11834, 14187, 14275, 14599, 14214, 14128, 14159, 14219, 14216, 14217, 14232, 14206, 14356, 14218, 14239, 14272, 21444, 16653, 14273, 14338, 14156, 14304, 12913, 14355, 25681, 14354, 13918, 13951, 14322, 14352, 14095, 14303, 13982, 13922, 14025, 13804, 14342, 13902, 14353, 14302, 14190, 14280, 14118, 14015, 14267, 13285, 14269, 13606, 13874, 14345, 14386, 14293, 14294, 14284, 14705, 13307, 13308, 13924, 14183, 14176, 14191, 14385, 13096, 14400, 14384, 14331, 14330, 14329, 23040, 14360, 14382, 21758, 11989, 14097, 14372, 14380, 14381, 14323, 14292, 14242, 14373, 14367, 14268, 14379, 14376, 14414, 14160, 14409, 14332, 14388, 14362, 14387, 14172, 15240, 14186, 14178, 14234, 14410, 14238, 14422, 14117, 14164) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---