---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(15147, 15207, 14890, 14625, 15210, 15090, 14718, 15219, 15205, 15127, 15208, 15216, 15045, 14452, 26607, 14795, 15015, 15237, 14911, 15217, 14497, 15253, 14725, 14864, 15220, 14755, 15218, 14789, 15098, 15116, 15255, 15106, 15351, 15202, 15352, 17718, 15256, 15360, 15199, 15227, 15277, 23003, 15353, 15231, 15230, 15354, 15163, 15223, 15257, 15355, 15000, 15004, 21841, 14891, 15235, 15215, 15238, 15182, 14618, 14986, 14978, 14909, 14503, 15986, 14942, 15175, 15096, 14846, 14453, 15110, 26184, 15020, 15356, 14979, 15151, 14454, 14299, 14270, 15092, 15229, 7947, 15311, 14865, 14774, 15222, 15095, 14678, 14492, 14704, 15276, 15299, 15056, 15055, 15309, 15057, 15363, 15179, 15243, 15242, 15244, 15292, 15273, 15272, 15370, 14624, 15174, 15876, 15225, 14168, 15369, 15286, 15275, 15297, 15287, 15189, 14892, 15173, 15312, 26079, 15298, 15313, 15330, 15188, 15187, 15371, 15241, 15288, 16310, 15344, 15289, 15359, 15574, 15314, 15274, 15341, 14607, 14639, 13116, 15036, 15037, 15031, 15027, 15108, 15032, 15030, 15021, 16052, 14493, 15329, 15024, 15022, 15028, 15033, 15034, 15185, 15025, 15029, 15026, 14640, 15023, 15340, 28794, 15278, 15428, 14502, 15635, 14499, 14841, 15212, 15280, 14638, 15214, 15186, 15475, 16458, 15323, 15058, 15317, 15232, 15094, 15334, 3601, 15291, 15633, 15308, 15290, 15430, 15324, 15339, 23157, 15133, 15346, 15442, 28591, 15476, 15348, 15459, 15337, 15347, 15634, 15146, 15271, 15440, 15336, 15321, 15318, 15320, 15316, 15319, 15461, 14306, 15203, 15087, 15088) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---