---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(18812, 18869, 18691, 18883, 18621, 21528, 18803, 18861, 19539, 18808, 18862, 18767, 18874, 18827, 18675, 18838, 18810, 18832, 18837, 19580, 18612, 18564, 18674, 18860, 21332, 18792, 17131, 28624, 18813, 18647, 18809, 18715, 18235, 19540, 18857, 18848, 18754, 18847, 18953, 18699, 18872, 18963, 19013, 18954, 18955, 21068, 18964, 18785, 21417, 18824, 18956, 18951, 18950, 18925, 18624, 18858, 18794, 18880, 18839, 19537, 18846, 19536, 18500, 18933, 18521, 18968, 18876, 18743, 19538, 19099, 18952, 27379, 18852, 18828, 18879, 18928, 19270, 18927, 19535, 18700, 18811, 18948, 18871, 18947, 18713, 18573, 18935, 19565, 18799, 18949, 18936, 18870, 18797, 17394, 18632, 18960, 19567, 19563, 18929, 18932, 18945, 19575, 18761, 18595, 19551, 19548, 18566, 19560, 18815, 18973, 18969, 18971, 19555, 18944, 19755, 18658, 17894, 18833, 19581, 23476, 18970, 18878, 18930, 18841, 19546, 18976, 19559, 18967, 19556, 18975, 19557, 19561, 19113, 19558, 19550, 19552, 19554, 19562, 19484, 18769, 18840, 18507, 18755, 18829, 18934, 19017, 18531, 19566, 18453, 19564, 18554, 18801, 18665, 17972, 19004, 18729, 18982, 18983, 18981, 18980, 18684, 18997, 18931, 18439, 18415, 19573, 18985, 19093, 18825, 28134, 18988, 16095, 18946, 18984, 18600, 19011, 18943, 18864, 19157, 18877, 18588, 19098, 19759, 18999, 18581, 19568, 18977, 18885, 18990, 18355, 18989, 18884, 19008, 19006, 18514, 18779, 19135, 18842, 18851, 18746, 18830, 18814, 18845, 18836, 18745, 16963, 18575, 19069) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---