---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(8195, 7934, 8308, 8169, 8299, 7925, 8188, 8033, 318, 8223, 8129, 7922, 8225, 10838, 23733, 8181, 8053, 8030, 8031, 7987, 8327, 8166, 7962, 8303, 8163, 8372, 8317, 8189, 8190, 10797, 8162, 8184, 9329, 8153, 8154, 8099, 8156, 8155, 8152, 8314, 8657, 8051, 7871, 8187, 8219, 8319, 7927, 8218, 8298, 8193, 8484, 8056, 8080, 8461, 7970, 7928, 10203, 8208, 8194, 7968, 8191, 8628, 8257, 10633, 8305, 8640, 8288, 8091, 8073, 8220, 8057, 8128, 8131, 8047, 8282, 7992, 8318, 9002, 7974, 10435, 8037, 7637, 8103, 8048, 8202, 8476, 8516, 8251, 8204, 21524, 8584, 8252, 8605, 11063, 8296, 8471, 8517, 8142, 8264, 8244, 8247, 8295, 8292, 8351, 8338, 8141, 8151, 35438, 8330, 8253, 8331, 8258, 8034, 8286, 7921, 8137, 8276, 7617, 8095, 8248, 8262, 8246, 8054, 8250, 8938, 8939, 8260, 8350, 8150, 8149, 8713, 8254, 8518, 8328, 8234, 8332, 8368, 8370, 8333, 8140, 8086, 8076, 8052, 8366, 8297, 8215, 8045, 8291, 8371, 8359, 8130, 7978, 24613, 8336, 8243, 8337, 8592, 8322, 8293, 8367, 8087, 8175, 8364, 8402, 8873, 7625, 8427, 8508, 8477, 8842, 8643, 19745) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---