---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(15367, 17177, 17237, 16908, 17172, 17171, 16832, 17267, 17210, 18412, 17189, 17187, 17175, 17134, 17121, 17183, 17181, 17211, 17184, 17182, 17235, 17331, 19285, 17252, 17194, 17193, 17995, 17253, 19772, 17679, 17207, 17236, 16945, 17199, 16505, 17115, 17190, 17254, 17026, 17125, 21662, 17300, 17301, 17302, 17303, 17676, 16837, 16840, 16654, 17010, 16984, 17202, 17209, 16915, 17063, 17208, 17518, 17304, 17025, 17201, 16484, 16807, 16893, 16892, 16891, 16639, 17200, 17345, 17028, 17135, 17220, 17136, 17228, 17305, 17306, 17212, 17271, 17310, 17139, 17314, 17319, 17318, 17214, 17309, 17307, 17321, 17316, 17311, 17308, 17320, 17270, 17290, 14067, 10452, 17116, 16523, 16894, 17098, 16557, 16513, 17273, 17218, 17322, 16950, 17059, 16904, 16975, 17178, 4610, 17299, 17298, 12010, 10637, 17287, 17323, 17295, 17479, 2710, 17165, 17291, 16802, 17251, 17047, 17198, 17043, 16946, 17173, 17186, 17275, 17293, 5597, 5695, 17335, 16362, 17223, 10030, 17274, 17332, 17313, 17324, 17325, 17260, 17326, 17406, 18622, 17501, 17262, 17222, 17261, 17328, 17481, 17480, 17338, 17192, 17203, 17366, 28257, 17257, 17164, 17367, 17137, 17060, 17155, 5819, 17264, 17265, 17327, 18190, 17363, 705, 38309, 17062, 17039, 17500, 17330, 17168, 4129, 17344, 17205, 15861, 17066, 17620, 17180, 17179, 17278, 17340, 17482, 17655, 17654, 17277, 17483, 17375, 17374, 17656, 18452, 21391, 17387, 17401, 17118, 17653, 17216, 18839, 17215, 17117, 17120, 17364, 17282, 17227, 17619, 16369, 17385, 17388, 17266, 17133, 17280, 17658, 17625, 17279, 17392, 17393, 17384, 17386, 2360, 17276, 17451, 17217, 17660, 17659, 17657, 17377, 18373, 17499, 18760, 17361, 17283, 17414, 17369, 17368, 17682, 16812, 16591, 17122, 18805) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---