---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(17352, 17405, 17739, 17455, 17409, 17402, 17339, 17539, 17403, 15442, 17683, 19306, 17356, 17359, 17358, 17336, 17337, 17357, 17498, 17404, 17684, 16832, 17258, 17422, 17133, 17224, 17415, 17686, 17342, 17423, 17688, 17169, 17380, 16682, 17371, 17578, 17685, 18112, 17286, 17416, 17410, 17689, 21390, 21389, 17142, 17083, 17741, 17681, 17174, 17365, 15529, 17691, 17617, 17624, 17439, 17453, 17440, 17456, 17441, 17348, 17411, 17460, 17454, 17458, 23844, 19627, 17125, 17459, 17747, 17292, 17745, 17746, 17412, 17464, 17465, 17466, 17457, 17733, 17452, 17738, 17467, 17438, 17044, 15145, 17419, 16905, 17430, 17531, 17249, 17195, 17427, 17737, 17463, 17736, 17390, 17094, 17678, 17042, 17435, 17476, 17396, 1516, 17031, 17377, 17413, 17289, 17744, 16976, 17448, 17474, 17831, 17743, 17492, 17429, 17206, 17407, 17488, 17225, 16590, 17493, 17486, 17408, 17487, 17489, 17525, 17478, 17226, 17519, 17497, 17690, 17490, 17508, 17494, 17526, 17527, 17618, 17341, 17381, 17060, 17105, 17514, 17631, 17503, 18911, 17571, 17475, 17740, 17491, 17528, 17170, 17035, 17259, 17221, 17512, 16819, 17250, 17397, 18938, 17530, 17421, 17534, 17432, 17504, 17793, 17535, 17515, 17389, 17376, 17529, 17757, 17544, 17756, 17543, 17431, 17547, 17772, 17753, 17754, 17755, 17541, 16867, 17791, 17542, 17748, 17533, 17362, 17627, 16609, 17087, 17126, 17141, 17426, 17613, 17540, 17750, 17204, 17771, 17752, 17449, 17749, 17425, 14760, 17505, 16229, 16946, 17275, 17461, 17477, 17506, 17507, 38308, 17622, 17424, 17343, 19908, 17268, 17061, 17634, 18721, 17556, 17551, 17557, 17558, 16622, 16623, 16624, 17462, 17053, 17444, 17443, 17442, 16985) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---