---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(11109, 9454, 10968, 11321, 11009, 11320, 11234, 10941, 11205, 11108, 11292, 11206, 9817, 11187, 11127, 11332, 11475, 11081, 11185, 11374, 11002, 11261, 11311, 11373, 11347, 11245, 11372, 11293, 11297, 11298, 11217, 11201, 11282, 11218, 11281, 11037, 11473, 11392, 11338, 11275, 11262, 12192, 11296, 11270, 11315, 28737, 11306, 11271, 11411, 11244, 11335, 13224, 6532, 11441, 11118, 11442, 11371, 11331, 11375, 26606, 11229, 11329, 11341, 12502, 11149, 11276, 11353, 11203, 11318, 11319, 11228, 11313, 10936, 10937, 11294, 10993, 11307, 10622, 10773, 11377, 11295, 11286, 11358, 11053, 10997, 11461, 24649, 11204, 11170, 11087, 11040, 11232, 11036, 11378, 11190, 11231, 11253, 11312, 11046, 11277, 11440, 13925, 11034, 11233, 8432, 11363, 11463, 11370, 12111, 11446, 12380, 11489, 11445, 10895, 11365, 11366, 8406, 8407, 11192, 11189, 11443, 11289, 1014, 11459, 11438, 11317, 11406, 11404, 11354, 11308, 11395, 11454, 11519, 27887, 11364, 11379, 11139, 11323, 10635, 11439, 11324, 11290, 11327, 33586, 11328, 19168, 11396, 11394, 11163, 11325, 14701, 14700, 11381, 11322, 11495, 11361, 11362, 11533, 9122, 11336, 11397, 11186, 25999, 11430, 11423, 11349, 11259, 11447, 11188, 11402, 11340, 10084, 11044, 11401, 11038, 10938, 11487, 11403, 11153, 9770, 11504, 11140, 11544, 11227, 11492, 11113, 11429, 11260, 11202, 11125, 11355, 11350, 10823, 11502, 11452, 11448, 11352, 11538, 11543, 11539, 11540, 11518, 11386, 11385, 11749, 11488, 21402, 11984, 11409, 11601, 13070, 9466) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---