---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(28153, 28154, 28180, 28996, 28162, 28158, 28161, 28159, 28163, 28170, 28164, 28165, 28187, 28178, 28106, 28177, 28171, 28142, 28141, 28057, 28058, 20021, 28175, 28185, 28182, 28189, 28176, 28188, 28039, 28179, 28174, 28181, 28464, 28183, 28186, 28192, 28209, 28221, 28212, 28218, 36169, 27845, 28210, 28211, 28216, 28256, 28220, 28219, 28217, 28167, 28245, 28283, 28228, 28237, 27989, 28236, 28194, 28240, 28234, 28248, 28224, 28160, 28226, 28233, 25693, 28230, 28157, 28232, 28238, 28235, 28097, 28242, 28243, 21086, 23428, 28523, 18434, 28247, 28253, 28250, 28269, 28917, 28254, 28252, 28268, 28284, 28270, 28265, 28279, 28260, 29733, 28262, 28275, 23748, 28287, 20282, 23209, 28272, 28227, 28289, 28193, 28290, 28282, 28293, 28310, 28286, 28156, 28292, 28280, 28307, 28296, 28291, 28288, 28294, 28267, 28264, 28172, 28277, 382, 28255, 28281, 30640, 28303, 28271, 28341, 28312, 28309, 28314, 28315, 28313, 28316, 28321, 28342, 28322, 28325, 28326, 28324, 28323, 26261, 28317, 28276, 28355, 28350, 29107, 28334, 28266, 28336, 28278, 21541, 28123, 28229, 28333, 28332, 28328, 28348, 28330, 26258, 28327, 28244, 28320, 28329, 27605, 28331, 28337, 28335, 28338, 28339, 28463, 28918, 28222, 28402, 28401, 28347, 28259, 28414, 28349, 28353, 28352, 28357, 28356, 28451, 28354, 28358, 28387, 27337, 28361, 28398, 28388, 28380, 28371, 28382, 28369, 28340, 28359, 28383, 28375, 28391, 28920, 28392, 28363, 28435, 28370, 28373, 28372, 28379, 28345, 28366, 28367, 28381, 28399, 28378, 28246, 28362, 27583, 28377, 28389, 28365, 27860) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---