---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(32154, 32156, 32151, 32157, 32160, 32169, 32163, 32161, 32162, 32096, 32167, 32450, 32173, 32172, 31988, 32362, 32171, 32164, 32174, 32165, 32182, 32166, 32363, 32569, 32193, 32198, 32229, 32176, 32324, 32188, 32177, 32099, 32038, 32194, 32199, 32186, 32112, 32365, 32197, 32192, 32191, 32187, 32178, 32189, 31136, 32056, 32196, 32185, 32181, 32361, 32190, 31941, 32240, 32183, 32184, 32175, 32204, 32203, 32170, 32168, 33333, 32207, 32202, 32206, 32210, 32208, 32209, 32205, 32224, 32223, 32327, 32337, 32325, 32212, 32230, 33035, 32214, 32231, 32211, 32225, 32234, 32341, 32179, 17581, 32339, 32237, 32215, 32228, 32242, 32226, 32399, 32042, 32180, 32232, 32268, 32219, 32241, 32213, 32318, 32340, 32220, 32342, 32144, 32235, 32221, 32295, 32338, 32216, 32398, 32217, 32227, 32218, 32244, 32243, 32246, 32247, 32825, 32250, 32260, 32261, 32252, 32262, 32344, 32345, 32256, 32254, 32255, 32336, 32335, 33230, 32257, 32279, 32358, 32276, 32280, 32248, 32282, 32272, 36432, 31940, 32258, 32278, 32274, 32249, 32316, 32267, 32101, 32277, 36153, 32314, 32330, 32286, 32265, 32253, 32315, 32281, 32236, 32271, 32266, 32009, 32263, 32352, 32233, 32313, 32367, 32275, 32264, 32285, 32312, 32357, 32293, 32292, 32290, 32287, 32289, 32291, 32288, 32317, 32308, 32304, 32297, 32296, 32311, 32299, 32300, 32302, 32306, 32301, 32305, 32303, 32307, 32310, 32309, 32320, 32319, 32321, 32346, 32332, 32343, 32334, 32331, 33702, 32333, 32347, 32350, 32349, 32348, 35254, 32329, 32351, 36249) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---