---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(31224, 31222, 31221, 31290, 31259, 25523, 31225, 31230, 31227, 31226, 31142, 31231, 31234, 31252, 31235, 31162, 31261, 31228, 31241, 31242, 31244, 31220, 31233, 31238, 31247, 31251, 31239, 31243, 31245, 31232, 31285, 31258, 31248, 31246, 31236, 31284, 31249, 31254, 23852, 12587, 31257, 21624, 31262, 31271, 31279, 31280, 31267, 31309, 31310, 31253, 31314, 31250, 31266, 31273, 31085, 31283, 31308, 31265, 31278, 31331, 31165, 31275, 31277, 31124, 31311, 31276, 31274, 31272, 31269, 31479, 31144, 31264, 31312, 31263, 31313, 31240, 31291, 31288, 31286, 31287, 31292, 31330, 31294, 31293, 31300, 31299, 31297, 31296, 31298, 14297, 31305, 31268, 31301, 31303, 31343, 31390, 31342, 31326, 31307, 31339, 31106, 31340, 31306, 31337, 31320, 31316, 31318, 31315, 31322, 31116, 31289, 31338, 31321, 31334, 31327, 31324, 31325, 31398, 31319, 31323, 31333, 31341, 35797, 31352, 31350, 31349, 31351, 31354, 31363, 25203, 31358, 25522, 28261, 31355, 31362, 31379, 31369, 31382, 31373, 31347, 31375, 31387, 31329, 31371, 31380, 31381, 31367, 31356, 31368, 31365, 31360, 31366, 31364, 31372, 31374, 31370, 31361, 31480, 31336, 31388, 31394, 31389, 31396, 31399, 31395, 31417, 31400, 31344, 31503, 31401, 23851, 31402, 31405, 12140, 31404, 31407, 31456, 31406, 31094, 31426, 31413, 31424, 31409, 31411, 31415, 31328, 31412, 31214, 31403, 31175, 31346, 31427, 31437, 31410, 31420, 31416, 31408, 31430, 31455, 31421) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---