---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(20708, 20710, 20709, 27891, 20479, 26643, 21358, 20716, 20628, 20658, 21359, 20724, 20742, 20723, 28702, 20711, 20733, 17606, 19435, 24851, 20730, 20328, 19151, 6008, 17701, 20425, 20462, 20519, 20347, 20731, 20344, 20426, 20732, 20345, 20552, 15690, 20729, 20564, 20721, 20468, 22281, 20681, 20680, 29376, 20717, 20727, 19436, 20924, 15549, 20668, 20726, 20719, 20780, 36166, 20778, 20713, 20712, 20790, 18424, 20728, 24907, 20682, 18676, 20343, 20802, 20718, 20635, 20775, 20734, 3138, 20788, 20800, 20784, 20633, 20805, 20661, 20787, 20789, 20766, 20801, 20737, 20808, 20807, 20791, 20786, 20793, 20803, 20771, 20804, 20779, 20656, 20977, 20781, 20796, 20785, 20735, 20833, 20835, 20837, 20765, 20840, 20773, 28017, 20838, 20832, 20346, 20356, 20848, 20932, 20846, 8210, 20876, 20504, 20842, 20678, 20847, 19957, 20978, 20576, 20764, 20670, 19821, 20228, 21687, 31505, 20831, 19499, 20794, 20850, 20864, 20866, 20836, 20865, 20887, 20880, 20886, 20769, 20895, 20477, 24520, 20621, 20868, 19895, 19996, 20852, 20905, 20514, 20877, 20851, 20883, 20703, 20505, 20885, 20830, 20878, 20888, 20828, 20795) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---