---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(29750, 33305, 29777, 29756, 29752, 29622, 29741, 29742, 29760, 29754, 29740, 29759, 31556, 29755, 29751, 29753, 29736, 29739, 29761, 29768, 29762, 29824, 29793, 30745, 29772, 29780, 29771, 29776, 29798, 29788, 29804, 29781, 29787, 29791, 29778, 29803, 29796, 29797, 29786, 29593, 29792, 27494, 29790, 29794, 29802, 29801, 29784, 29789, 21915, 29472, 29352, 29652, 29783, 29519, 29782, 5401, 29785, 29821, 15815, 29673, 29974, 29805, 23482, 26802, 19493, 13350, 29800, 29353, 18053, 29799, 29829, 29795, 29884, 29822, 29954, 29823, 29664, 29830, 29825, 29831, 29832, 29836, 29833, 29827, 29839, 29838, 29871, 29835, 2517, 29844, 29843, 29841, 29770, 29737, 29857, 29853, 29861, 29847, 29961, 29851, 29284, 29862, 29979, 29980, 29773, 29852, 30073, 29869, 29854, 29774, 29834, 29842, 29855, 29866, 29860, 29864, 29840, 29858, 29868, 29850, 29846, 29769, 29313, 29870, 29849, 29672, 29865, 29856, 29867, 29863, 29877, 29710, 29712, 29709, 29876, 29708, 29883, 29882, 29879, 29881, 29885, 29887, 29859, 29886, 29982, 30192, 29948, 29888, 29889, 29898, 29904, 29913, 29848, 29914, 29894, 29550, 29981, 29893, 29983, 29895, 29677, 29905, 29908, 29903, 29950, 29891, 29899, 22197, 29897, 29902, 29907, 29896, 29949, 29892, 29959, 29900, 29911, 29915, 29890, 29917, 29918, 29976, 29874, 29953, 29909, 29951, 29962, 29963, 29806, 29910, 29955, 29969, 29967, 29968, 29971, 29972, 29970, 29973, 30002, 29999) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---