---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(10452, 10958, 10504, 10917, 10922, 11104, 26402, 26458, 10642, 10803, 9655, 10792, 10830, 10900, 10831, 10898, 10082, 10326, 10727, 10899, 10791, 10790, 10205, 10756, 10897, 10641, 10605, 10757, 10896, 10670, 8333, 10251, 10845, 10954, 10817, 16518, 10772, 10637, 10933, 10952, 10597, 10867, 11098, 10881, 10312, 10728, 10911, 10587, 10147, 7202, 10916, 10102, 10951, 10248, 10860, 10779, 10598, 10406, 11243, 10777, 10702, 8357, 10915, 25188, 12059, 10929, 13146, 36671, 10989, 10557, 10985, 10745, 10759, 10774, 10984, 10703, 10983, 10559, 10974, 10775, 9067, 10990, 10781, 10800, 11026, 10980, 10972, 10913, 10935, 10901, 11197, 10978, 10284, 10726, 10671, 10914, 10981, 10619, 10861, 21816, 10934, 24964, 11024, 11030, 10977, 11029, 11028, 11027, 19804, 11001, 11010, 11008, 11007, 11099, 10965, 11025, 10926, 12911, 10945, 11420, 10563, 10986, 10604, 10957, 10135, 19911, 10707, 10706, 10607, 11033, 10827, 10963, 10953, 10950, 10739, 10947, 11019, 11011, 11036, 11076, 11077, 11078, 11079, 11075, 11080, 11074, 11309, 10780, 11105, 11012, 10636, 11073, 11032, 11064, 11043, 10859, 10912, 11059, 11013, 11066, 10987, 11014, 11037, 10970, 11020, 10672, 10789, 11006, 11057, 11050, 11042, 11058, 10564, 11176, 10776, 10988, 11003, 11056, 11015, 11072, 10942, 11070, 11071, 11069, 10943, 11052, 11179, 10591, 8839, 11616, 10932, 10769) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---