---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(34376, 34382, 34386, 34392, 34383, 34395, 34390, 34391, 34415, 34397, 34535, 35589, 34396, 34399, 34401, 34433, 34402, 34404, 34406, 34412, 34423, 34414, 34341, 34457, 34511, 34424, 34422, 34405, 34311, 34408, 34070, 34398, 34413, 32764, 34354, 34435, 34411, 34407, 34434, 34288, 34381, 34403, 33528, 34409, 34421, 34419, 34316, 34773, 34427, 34420, 34418, 34431, 21212, 34426, 34425, 34430, 34436, 38395, 34429, 34455, 34474, 34437, 34442, 34751, 34441, 34439, 34476, 34438, 34417, 34461, 34432, 35160, 34464, 34465, 34445, 34473, 34458, 34472, 34453, 34446, 34450, 34454, 34037, 34267, 34389, 34444, 34459, 34144, 34481, 37804, 34463, 34443, 34447, 35544, 34466, 34448, 35495, 34440, 34451, 34456, 34460, 34663, 34469, 34462, 34475, 34478, 34477, 34470, 34482, 34480, 34483, 34485, 34479, 36451, 34488, 34502, 34580, 34487, 34774, 34776, 34516, 34497, 34524, 35805, 34484, 34471, 34536, 34496, 34506, 34517, 34759, 34510, 36647, 34500, 34582, 34282, 34515, 34512, 34493, 34574, 34501, 35198, 34508, 34943, 34544, 34530, 34495, 34581, 34499, 34514, 34249, 34504, 34523, 34583, 34507, 34579, 34584, 34509, 33614, 34490, 34593, 34498, 37410, 34518, 34519, 34522, 34528, 34521, 34520, 34568, 34529, 34539, 34526, 34567, 34573, 34538, 34531, 34533, 34537, 34534, 34540, 34532, 34527, 34489, 34553, 34555, 34562, 34548, 34566, 14763, 34513, 34452, 34569, 34549, 34766, 34547, 34550, 34552, 34571, 34570, 34554, 34564, 34556, 34551, 34565) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---