---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(17517, 17842, 17555, 17834, 11367, 22908, 17723, 17721, 17824, 17722, 17840, 18169, 17968, 18555, 17844, 18168, 18167, 17837, 17850, 17829, 17843, 17851, 18172, 17730, 17729, 17830, 17613, 17196, 17874, 18165, 17734, 17707, 17732, 3283, 17635, 28592, 17648, 17609, 17092, 545, 27239, 18166, 17841, 18188, 19169, 18187, 22436, 6005, 17870, 23424, 17854, 17612, 19171, 17717, 17887, 17855, 17868, 17871, 17847, 17858, 17880, 17869, 17886, 18892, 18186, 17899, 17865, 17873, 17939, 18184, 17881, 17896, 18185, 17893, 18182, 17502, 21522, 17888, 18183, 17828, 17867, 18908, 17698, 17833, 18180, 17781, 17917, 17862, 17852, 17891, 17669, 17511, 17731, 17694, 17836, 17646, 27801, 17699, 17566, 17846, 17600, 17856, 17885, 17672, 17883, 17538, 17866, 17522, 17584, 17861, 17471, 17821, 17594, 17820, 23197, 18196, 17910, 17569, 17931, 17629, 17644, 18889, 17903, 18888, 18339, 17919, 17906, 17898, 17905, 19170, 19172, 18195, 18891, 18181, 17925, 18194, 17884, 18080, 17450, 17876, 17929, 17700, 17728, 17567, 17496, 17468, 17822, 17437, 17706, 17904, 18909, 17911, 17962, 17705, 18887, 17725, 18895, 17599, 17507, 17926, 17928, 17636, 17932, 17639, 17922, 17913, 5819, 17641, 18904, 17428, 17640, 19166, 19165, 17637, 17780, 17645, 17901, 17933, 17778, 17915, 17914, 18902, 17610, 17863, 18894, 17860, 17963, 17859, 17724, 18896, 11753, 17924, 17875, 17953, 18893, 17937, 17839, 17941, 7036, 17598, 17249, 17701, 17897, 17702, 17940, 17491, 17936, 17611, 16743, 17964, 17966, 17970, 17965, 18903, 17952, 17945, 28984, 18897, 68, 17909, 17902, 17918, 17827, 17848, 17703, 17912, 18642, 17954, 10735, 17615, 17614, 18898, 17943, 11485, 22314, 17777, 17944, 8748, 17956, 17948, 18111, 17949, 18900, 17930, 18899, 17951, 17872, 17957, 19070, 17536) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---