---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(12314, 14001, 14054, 13384, 13969, 13875, 13813, 13967, 13999, 13995, 13988, 13836, 13776, 13968, 13619, 13919, 12355, 13992, 13611, 13929, 14009, 13987, 14697, 13737, 10563, 14000, 13580, 13850, 13118, 13993, 13990, 13645, 13390, 12372, 13674, 14071, 13574, 13694, 14007, 13847, 13816, 4547, 13806, 13534, 13736, 14083, 25185, 13898, 14080, 13937, 30273, 14072, 13821, 13985, 13880, 14068, 14078, 14077, 12906, 14084, 14120, 14067, 13908, 13728, 13989, 13723, 19689, 14093, 14075, 14036, 13677, 14008, 13984, 14073, 14076, 13950, 13892, 13775, 14021, 13952, 14061, 13575, 2122, 13997, 14069, 13792, 14137, 13715, 14063, 14646, 13542, 14079, 13978, 13970, 13998, 14070, 13986, 14091, 14043, 14145, 14138, 14146, 14040, 14147, 14143, 14141, 14038, 14140, 14144, 14148, 14035, 14041, 14039, 14142, 14139, 21123, 14092, 13630, 13960, 14149, 14154, 14150, 14665, 14155, 14125, 14044, 13143, 13367, 14129, 13972, 14124, 14151, 14114, 14153, 14152, 13603, 14085, 14096, 14131, 14130, 12533, 13729, 13518, 13920, 13959, 14112, 13216, 13588, 14055, 13380, 14168, 13891, 32541, 14034, 13907, 14109, 13547, 14094, 14182, 14132, 13374, 14133, 13791, 13532, 14174, 4589, 6425, 14031, 13961, 13923, 14202, 14126, 13964, 13848, 13772, 12896, 13741, 13962, 14135, 14161, 13956, 14134, 14664, 13445, 14228, 14227, 14166, 14165, 24964, 13996, 14119, 14116, 14180, 14200, 14203, 13966, 28453, 28454, 14198, 13971, 1185, 14199, 13906, 13878, 13948, 11607, 14115, 19909, 13877, 13955, 13804, 14101, 13871, 13979, 14086, 14136, 14197, 14122, 14052, 14429, 14010, 14157, 14167, 13271, 14188, 13470, 14194, 14195, 14196, 14193, 14257, 14285, 14250, 14173, 14277, 6874, 4123, 14189, 13862, 14047, 13864, 14049, 13863, 14290, 14253, 13860, 13859, 13897) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---