---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(31030, 31029, 31386, 31028, 31012, 31025, 31026, 31011, 31024, 31043, 31038, 31032, 31039, 31041, 31031, 31034, 31036, 31035, 31055, 31064, 31074, 31065, 31054, 31047, 31066, 31045, 31067, 31060, 31052, 31059, 31075, 31053, 31080, 31050, 3239, 31056, 31057, 31058, 31051, 31082, 31049, 31063, 31061, 31044, 31046, 31022, 31076, 31068, 31434, 31109, 31077, 31070, 31086, 31071, 31078, 31084, 31073, 31072, 31404, 31088, 31089, 31079, 31128, 31091, 31090, 31096, 31101, 31098, 31106, 31122, 31107, 31113, 31121, 31105, 31062, 31097, 31118, 31085, 31099, 31112, 31119, 31133, 31110, 31111, 31102, 31103, 31116, 31123, 31108, 31115, 31117, 31124, 32127, 31140, 31100, 30970, 31120, 29736, 31137, 31048, 31104, 31135, 31136, 30583, 31158, 29712, 31143, 30360, 31141, 31139, 31147, 30403, 31093, 31170, 31145, 31163, 31154, 31161, 31156, 31172, 31114, 31095, 31164, 31148, 31151, 31138, 31149, 31150, 31153, 30034, 31134, 31152, 31155, 31033, 31160, 31021, 31173, 31218, 31174, 31179, 31176, 31348, 31181, 31182, 25202, 31183, 30582, 29491, 31180, 31185, 30997, 31125, 31200, 31210, 31207, 31205, 31204, 31202, 31199, 31196, 31201, 31208, 31198, 31193, 31212, 31219, 31184, 31214, 31157, 31177, 31206, 31194, 31192, 31209, 31216, 31189, 31197, 31211, 31167, 31213, 31168, 34161, 31191, 31237, 31195, 31223, 31217, 31203, 31166, 31187, 31188, 31171, 31169, 31190, 31215) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---