---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(24177, 24179, 24185, 24178, 24180, 24181, 24188, 34209, 24189, 24134, 24190, 24320, 24199, 24418, 24202, 24201, 24203, 24142, 24186, 24210, 24097, 24222, 24211, 24212, 24250, 24036, 24241, 24205, 24217, 24208, 24133, 23981, 24155, 24204, 24216, 24115, 22984, 23937, 24187, 24035, 24213, 24221, 24219, 23894, 24218, 24226, 24223, 24209, 23990, 23945, 23946, 24207, 24206, 24220, 24151, 23890, 24076, 24215, 24214, 24137, 24251, 24229, 24242, 24277, 24248, 24249, 24253, 24260, 24288, 24289, 33670, 28473, 22804, 24281, 24264, 24280, 24195, 24184, 24077, 24193, 24282, 24269, 24011, 23905, 24169, 24168, 24279, 24196, 24227, 24278, 24292, 24274, 24270, 24057, 24262, 24283, 24327, 25061, 24290, 24284, 24224, 24276, 24275, 24272, 24285, 24294, 24367, 24295, 24307, 24243, 24194, 24348, 24349, 24308, 24310, 24311, 24309, 24246, 23808, 24247, 24317, 24326, 24318, 24330, 24334, 24345, 24347, 24346, 24314, 24342, 24343, 24351, 24355, 24293, 25804, 24354, 23975, 24359, 24352, 24358, 24363, 24353, 24350, 24030, 23847, 24306, 24019, 24357, 24259, 24335, 24012, 24362, 24364, 24360, 24312, 24291, 24060, 24356, 24361, 24392, 24313, 24412, 24378, 24375, 24381, 24383, 24380, 24384, 24379, 24385, 24387, 24394, 24411, 24382, 24389, 24390, 24388, 29403, 24812, 24395, 24422, 24479, 24561, 24257, 24397, 24197, 24404, 24457, 24406, 24315, 24443, 24488, 24419, 24413, 24399, 24442, 24410, 24340, 24398, 24417, 24408, 24377, 24286, 24400, 24420, 24128, 24403, 23705, 24421, 23929, 24407, 24287, 24416, 24402, 24401, 23974, 24706, 24414, 24423, 27238, 24431, 24261) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---