---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(29975, 29998, 30786, 30021, 29977, 29978, 29875, 29985, 29989, 29984, 29987, 29988, 29993, 29997, 29991, 30100, 29992, 29990, 29994, 30018, 29986, 30000, 30045, 30004, 30008, 30041, 38443, 30016, 30014, 30013, 30019, 30005, 30024, 33311, 30055, 29613, 30009, 32386, 30037, 30042, 29996, 30028, 30036, 30029, 30031, 30032, 30043, 30033, 30039, 29906, 30025, 29437, 29995, 30035, 30038, 29672, 30044, 30047, 33368, 30048, 30049, 30053, 30058, 30054, 30134, 30060, 30059, 30084, 30062, 30046, 30070, 30382, 30089, 30088, 30244, 30064, 30086, 30081, 30065, 30083, 30090, 30078, 30082, 30069, 30101, 30074, 30105, 30066, 29828, 31464, 30079, 30068, 30080, 30071, 30067, 30103, 30026, 30085, 30075, 32200, 30077, 30092, 30153, 30104, 34804, 30010, 30011, 30012, 30098, 30099, 30107, 30108, 30118, 30125, 30119, 30095, 30183, 30234, 30128, 30126, 30121, 30123, 30094, 30132, 30133, 30114, 30113, 30130, 30109, 30110, 30124, 30129, 29412, 30122, 30127, 30111, 30112, 30115, 30137, 30135, 30142, 30149, 30182, 30152, 30151, 30154, 30155, 30157, 37507, 31834, 5210, 30174, 30146, 30147, 30177, 30164, 30167, 30180, 30117, 30168, 30181, 30161, 30175, 30170, 30017, 30178, 30193, 30160, 30156, 30172, 30158, 30162, 30179, 30176, 30169, 30166, 30102, 30145, 30163, 30057, 30131, 30184) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---