---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(27568, 27569, 27574, 27546, 27551, 27579, 27577, 27576, 27584, 27603, 27599, 30106, 27572, 28398, 13172, 27455, 27651, 27601, 27608, 27454, 27598, 27650, 27649, 27073, 27600, 27602, 27592, 27604, 27606, 27571, 27586, 27593, 27631, 27653, 27566, 27585, 27605, 27652, 33540, 27609, 27645, 27644, 27614, 27567, 23274, 27617, 27613, 27612, 27641, 27615, 27642, 27637, 27638, 27627, 27636, 27573, 27620, 27621, 27478, 28037, 27607, 27629, 27622, 27624, 27447, 27625, 27619, 27634, 28476, 28477, 27628, 27616, 27358, 27630, 27446, 27307, 27623, 27583, 27611, 27580, 27635, 27588, 27626, 27632, 27433, 27646, 36737, 27664, 27660, 27658, 27662, 27657, 27575, 27663, 27695, 35468, 27665, 31592, 27668, 27666, 27686, 24577, 27670, 27685, 27690, 27680, 27618, 27689, 27669, 27999, 27687, 27693, 27691, 27678, 27698, 27692, 27463, 27683, 27701, 27684, 27677, 28927, 27034, 27682, 27679, 27699, 27681, 27188, 26977, 27673, 27688, 27694, 27539, 27697, 27696, 27719, 27702, 27703, 27720, 27704, 27676, 27736, 27715, 27674, 27741, 27713, 27709, 27718, 27745, 27740, 27710, 27711, 27671, 27734, 27712, 27714, 27735, 27705, 36149, 27721, 27755, 27716, 27717, 27722, 27707, 27672, 27739, 27859, 27858, 27746, 31591, 27942, 27732, 27943, 27937, 27944, 27731, 27940, 27939, 27730, 27374) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---