---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(11382, 11432, 11499, 11527, 11561, 11484, 11485, 11278, 11742, 11886, 10944, 10995, 11081, 11598, 10823, 11464, 11597, 11705, 10919, 11433, 11452, 11521, 11477, 25999, 11284, 11118, 11528, 11387, 11305, 11473, 11183, 11493, 11494, 11351, 11480, 11127, 11000, 276, 11542, 11431, 11475, 11501, 11337, 11503, 11596, 11529, 11534, 11408, 11407, 11092, 11359, 11550, 11412, 11405, 11619, 11952, 11369, 22064, 7640, 11940, 26299, 11316, 11160, 11595, 11380, 11472, 11471, 11466, 11483, 11517, 21307, 11555, 11470, 11469, 11467, 11450, 11594, 19873, 11360, 11511, 11451, 11285, 11524, 10767, 11537, 11525, 11087, 11522, 11190, 11579, 11556, 11536, 11523, 11338, 11453, 11590, 11468, 11526, 11530, 11618, 11666, 19417, 11634, 11600, 11457, 11656, 11617, 11661, 11608, 20380, 11541, 11294, 11340, 11476, 11626, 11565, 11272, 11274, 10405, 11551, 11398, 11512, 11184, 11576, 11516, 11631, 11580, 11389, 11505, 8400, 11649, 11563, 11478, 11506, 10802, 11641, 11658, 11632, 9058, 11703, 11581, 28888, 14042, 38307, 11647, 11653, 11657, 11702, 11211, 11620, 11652, 11669, 11786, 11687, 11547, 10895, 11599, 11701, 11557, 11651, 11700, 29573, 11646, 11696, 11458, 11507, 11514, 11625, 11624, 11623, 11288, 11695, 11571, 11609, 35151, 11679, 11574, 11743, 11310, 11121, 11659, 11515, 11531, 11164, 11558, 11589, 10041, 11737, 11575, 11564, 11694, 11209, 19239, 11546, 11605, 11913, 13788, 11690, 11680, 11643, 11644, 11210, 11723, 11562, 11645, 11573, 11681, 11572, 11158, 11747, 11545, 11654, 11640, 11509, 11428, 11724, 11725, 11648, 11202, 11342, 11638, 11708, 11660, 11462, 11349, 11602, 11639, 11570, 11739, 11082, 11083, 10927, 11740, 11465, 12711, 11266, 11720, 11788, 12710, 12712, 11745, 11842, 11251, 11510, 11481, 10080, 11721, 11603, 10925, 11650, 11800, 11500, 11569, 11861, 11697, 11693, 11692, 11787, 14121, 11686, 11424, 11684, 11559, 11685, 11384, 11383, 11273) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---