---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(16436, 16786, 16597, 16699, 16811, 16745, 16809, 16700, 16810, 16855, 16856, 16781, 16808, 16854, 16780, 8599, 16636, 16733, 16456, 16865, 16232, 16202, 16698, 16863, 16439, 16696, 16853, 16647, 16527, 16744, 16709, 16646, 16460, 16705, 16528, 16648, 16417, 16635, 16632, 16789, 16790, 16843, 26473, 16785, 16902, 16753, 20026, 16662, 16859, 16860, 16932, 16601, 16666, 16711, 16415, 16795, 30230, 16940, 22260, 16939, 23341, 17103, 16828, 16429, 16715, 16641, 16929, 16476, 16933, 16876, 16935, 16957, 16844, 16818, 16842, 16526, 16513, 16878, 16762, 16938, 16784, 16845, 16886, 16258, 16747, 16793, 16763, 16702, 16533, 16703, 16817, 16873, 16385, 16418, 16941, 16816, 16872, 16777, 28346, 16535, 15731, 17005, 16792, 16695, 16787, 16619, 16823, 16874, 16931, 16964, 16794, 16936, 15972, 16788, 16195, 16965, 16909, 16966, 16949, 16937, 16888, 17329, 16884, 16885, 16880, 16911, 16967, 16683, 16970, 16971, 16968, 16906, 16960, 16961, 16969, 16752, 16973, 16972, 16955, 16952, 16953, 16956, 16954, 16974, 16330, 16962, 16564, 16690, 16821, 16920, 16919, 16922, 16921, 16927, 16928, 16905, 16847, 16329, 16815, 19205, 16914, 16913, 16813, 16806, 16375, 16748, 16887, 16640, 16502, 16735, 16958, 16556, 16881, 16848, 16820, 16566, 16802, 14810, 17019, 17020, 16918, 16912, 16595, 16917, 6752, 16645, 16469, 16959, 16803, 16978, 16883, 15732, 17021, 16861, 17022, 16977, 17023, 16963, 16901, 16981, 16926, 16900, 16899, 17024, 17002, 16875, 16948, 17006, 17015, 16665, 16707, 17076, 16951, 16557, 16637, 16869, 16638, 16950, 13363, 16633, 10203, 16999, 16681, 16804, 16758, 16992, 15864, 16998, 16898, 17004, 17012, 17000, 16334, 16706, 6794, 17013, 16732, 16495, 16562, 16767, 16210) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---