---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(29154, 29110, 29123, 28944, 29120, 29143, 29122, 29121, 29125, 29126, 29127, 29128, 29160, 29062, 29138, 29104, 29142, 29134, 29155, 29146, 29141, 29148, 29145, 29140, 29129, 29131, 29021, 29147, 29132, 29130, 29153, 29070, 29074, 29168, 29149, 29255, 29151, 28447, 29135, 29133, 29139, 29144, 28712, 29171, 29156, 29159, 29163, 29158, 29166, 29165, 29167, 29177, 29176, 29173, 29174, 29175, 29247, 29179, 29191, 29170, 29172, 29169, 29180, 29161, 29189, 29162, 29187, 29105, 29186, 29184, 29164, 29193, 28267, 29157, 29188, 29182, 29185, 29190, 29181, 29183, 29373, 30888, 29241, 29200, 29198, 29222, 29242, 29199, 29197, 29208, 29212, 29203, 29202, 29213, 29201, 29219, 29225, 29220, 29281, 29218, 29223, 29259, 29214, 29075, 28947, 29226, 29207, 29230, 29239, 29238, 29217, 29237, 23825, 28867, 29233, 29206, 29245, 29216, 29235, 29229, 29232, 29258, 29227, 28948, 28225, 29231, 29236, 29244, 29234, 29228, 29240, 29215, 29192, 29250, 29266, 29251, 29211, 29252, 29272, 29256, 29263, 30257, 29209, 29260, 29294, 29303, 29302, 29295, 29262, 29264, 37441, 29278, 29335, 29268, 29289, 29292, 29276, 29280, 29287, 29291, 29285, 29275, 27339, 28799, 29279, 29283, 29286, 29296, 29282, 29362, 29306, 29290, 29309, 29293, 29301, 29299) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---