---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(29307, 29311, 29312, 25083, 29314, 29315, 29328, 29316, 29327, 29317, 29360, 29383, 29265, 29319, 29300, 29359, 29310, 29368, 29334, 29323, 29321, 29355, 29399, 29322, 29333, 29088, 29332, 29330, 29284, 29352, 28213, 29361, 29366, 29297, 29253, 29288, 29318, 29331, 29354, 29325, 29378, 29350, 28223, 29353, 29277, 29254, 29324, 29358, 29357, 29382, 29381, 29356, 29271, 29371, 7327, 628, 29270, 29365, 29269, 29406, 29364, 29367, 29370, 29369, 29374, 29336, 29372, 29405, 29340, 29599, 29400, 29402, 29401, 29380, 29404, 29385, 29224, 29337, 29398, 29389, 29388, 29390, 29386, 29982, 29394, 25627, 3796, 29392, 29344, 29375, 30015, 25836, 29395, 29454, 29393, 29391, 29566, 29320, 29298, 29397, 29348, 29408, 32819, 29417, 34083, 29579, 29409, 29411, 29966, 29416, 29439, 29420, 29421, 30001, 29415, 29448, 29427, 29426, 29414, 29434, 29451, 29458, 37557, 29449, 29435, 29443, 29444, 29470, 29433, 29436, 29455, 29430, 29441, 29428, 29442, 29446, 29438, 29456, 29437, 29432, 29431, 29450, 29379, 29445, 15193, 29527, 29453, 29526, 29465, 29466, 29464, 29463, 29480, 29423, 29462, 29479, 29619, 29674, 29471, 29467, 29473, 29468, 29469, 29495, 29481, 29476, 29478, 29477, 29514, 29502, 29503, 29487, 29482, 29878, 29489, 29496, 2023, 29424, 26774, 29498, 29500, 29517, 29492, 29447, 29501, 29507, 29499, 29516, 29506, 29508, 29425, 29493, 29384, 29494, 29491, 29413, 29497, 29504, 24662, 29490, 29505, 29509, 29518, 29521, 29694, 29524, 29528, 29529, 29525, 29532, 29535, 29530, 37595, 29520, 29531, 29533, 29534, 29536, 29538, 29440, 29873, 29301, 29559, 29542, 29418, 29308, 29549, 29557, 29692, 29257, 29523, 29546, 29555, 29545, 29958, 29551, 10183, 29569, 29554, 29429, 29522, 29541, 29556, 29552, 29419, 29564, 29543, 29548, 29553, 29591, 29540, 29544, 29558, 29965, 29607, 33295, 29562, 29757, 29561, 29511, 29137) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---