---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(11622, 11560, 11672, 11274, 10608, 11100, 11759, 12242, 11762, 12038, 11772, 11779, 11691, 11671, 7990, 11760, 11567, 25182, 11562, 11673, 28890, 11732, 11496, 11676, 11674, 20489, 11603, 11531, 11604, 11854, 11667, 22996, 11682, 11553, 11568, 11474, 12327, 11744, 11201, 11910, 11467, 11824, 11853, 11753, 11750, 11752, 10566, 11751, 11785, 11734, 11741, 11662, 11852, 11939, 11784, 6749, 11938, 11783, 11804, 11826, 11627, 11835, 11606, 11535, 11778, 11823, 11729, 11846, 11844, 11629, 11628, 11566, 11943, 11813, 11713, 11930, 11802, 11044, 11721, 11727, 11497, 11587, 11712, 11733, 11738, 11711, 11926, 11508, 11851, 11554, 11493, 11942, 11825, 11585, 11159, 11857, 11927, 11929, 11920, 11706, 11924, 11891, 11858, 11925, 11928, 11890, 11856, 11798, 11642, 11799, 11797, 11892, 11814, 11843, 11758, 11860, 11771, 11678, 11882, 11767, 11893, 11763, 11895, 11894, 10895, 11896, 11815, 11889, 11901, 11801, 11757, 21357, 11899, 11900, 11841, 11903, 11904, 11905, 11906, 11907, 11670, 11591, 11718, 11782, 11592, 10982, 11871, 11855, 11789, 11716, 11748, 11936, 11714, 11780, 11675, 11872, 11879, 11790, 11887, 11897, 11593, 11781, 11886, 11880, 11761, 12077, 11845, 12094, 12096, 11873, 12098, 11884, 12076, 11875, 16822, 11773, 11796, 11150, 11795, 11677, 26211, 11953, 21577, 11719, 11792, 11831, 11794, 11793, 11874) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---