---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(15322, 15368, 15446, 15439, 15452, 15445, 15246, 15447, 15172, 15472, 15572, 15010, 14960, 15132, 15437, 14841, 15159, 15520, 15040, 15458, 15131, 12014, 15327, 14805, 14795, 15053, 15457, 19126, 14306, 15049, 15454, 15443, 15451, 15249, 15456, 15448, 14575, 15455, 15541, 15540, 15522, 18940, 15521, 15538, 15539, 15466, 15523, 15449, 15535, 15537, 15527, 15453, 17523, 15326, 15364, 15536, 15912, 14986, 15042, 15310, 15548, 15283, 15504, 15365, 15349, 15468, 15151, 15269, 15168, 15306, 15547, 15325, 15129, 15214, 15367, 15211, 14975, 15333, 15753, 14469, 15518, 15433, 15525, 14626, 15444, 15654, 14976, 15054, 15471, 19415, 14547, 15528, 14170, 15300, 15245, 15623, 15580, 15550, 17889, 15581, 16475, 15579, 15562, 15470, 15561, 15335, 14638, 15284, 15130, 15450, 15174, 15115, 15578, 15517, 14453, 15431, 15200, 15058, 15236, 14985, 15462, 15022, 15570, 15266, 15636, 15519, 15248, 15557, 15486, 15571, 15556, 15577, 15672, 15554, 15637, 15638, 19413, 15524, 14910, 15280, 15658, 15328, 15553, 13935, 15594, 15593, 30185, 15160, 15307, 15233, 15152, 13456, 15543, 15091, 15551, 15652, 15653, 15474, 15609, 15209, 15473, 15281, 15282, 15599, 15606, 15608, 15213, 15603, 15093, 13764, 15270, 15754, 15226, 19790, 15611, 14729, 15011, 15591, 15612, 15639, 19789, 15757, 15756, 15604, 19786, 15843, 24059, 15755, 15559, 15558, 15552, 15544, 15560, 14371, 15700, 15565, 15644, 15643, 15436, 14608, 15315, 15510, 15651, 15650, 15663, 15656, 15509, 15342, 15308, 15657, 16062, 15614, 14510, 15655, 15583, 15590, 15620, 15759, 15596, 15597, 15649, 15758, 15661, 15526, 15285, 15188, 15187, 15505, 15632, 15569, 15511, 15600, 15748, 15362, 15465) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---