---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(8833, 9130, 9209, 9569, 8732, 8511, 9318, 8733, 8448, 9093, 9090, 8834, 7648, 8894, 8737, 8900, 9078, 9097, 9100, 9077, 8823, 8862, 9087, 9128, 9207, 8607, 8209, 8409, 28756, 8596, 8822, 8821, 9101, 8738, 8739, 8527, 8806, 8824, 8483, 9167, 8826, 8825, 8820, 5564, 8827, 8411, 8594, 9177, 9166, 9150, 9182, 9145, 9149, 9156, 9873, 9192, 9178, 9060, 9171, 9054, 9194, 8816, 9151, 9123, 9140, 26505, 16568, 9831, 9085, 9045, 8354, 3288, 9146, 9147, 9153, 9176, 1571, 9215, 9186, 9110, 8779, 9184, 8776, 8778, 8788, 10848, 8800, 8797, 8798, 8819, 8799, 8926, 8780, 8777, 9208, 8818, 22435, 9201, 9190, 8586, 8792, 23286, 8795, 8522, 8462, 9043, 8555, 8796, 8554, 9047, 8863, 8785, 8805, 8793, 8561, 8557, 8681, 7931, 8558, 8804, 8803, 8828, 8936, 8794, 8789, 8556, 8790, 8929, 8560, 8552, 8559, 8769, 8553, 8532, 8570, 8434, 8671, 8791, 8930, 8946, 9211, 9213, 9191, 9195, 9203, 9217, 9343, 8945, 9199, 24913, 2644, 9108, 8356, 8937, 28897, 9220, 8839, 8601, 9119, 8957, 8853, 9074, 8852, 8985, 8854, 9049, 28843, 15385, 9197, 9159, 8740, 8855, 28701, 9251, 8672, 9046, 8983, 8917, 8472, 8998, 8962, 8981, 8542, 8770, 8856, 8997, 8944, 9099, 8987, 8976, 9869, 13171, 7847, 8996, 8171, 8741, 8531, 8950, 9092, 9212, 8978, 8339, 8961, 8710, 8529, 8980, 8441, 9044, 8851, 9109, 9079, 8782, 9005, 28889, 9474, 9105, 8435, 9084, 8807, 26368, 8537, 8960, 9091, 9112, 9132, 9174, 9205, 9210, 9048, 7948, 8988, 8136, 8991, 8625, 8993, 10146, 8986, 9017, 9016, 8989, 584, 8802, 8801, 9051, 8992, 9221, 9218, 9223, 9216, 8973, 9020, 8689, 8538, 6766, 8762, 8690, 8965, 8994, 9032, 8963, 8974, 8964, 9055, 10247, 9007, 9066, 9113, 9094, 9115, 8959, 9104, 9219, 8600, 8832, 9998, 9076, 24485, 9036, 9227, 9038, 9039, 9015, 8967, 9114, 9206, 9344, 9248, 8924, 8784, 9014, 2164, 8925, 8923, 9031, 9407, 9042, 9418, 8971, 9436, 8040, 9000, 9424, 9335, 9345, 9320, 25554, 9322, 9321, 9411, 9355, 8916, 9350, 9381, 9354, 8966, 9125, 9200, 9181, 9152, 9214, 4975, 9068, 9127, 9131, 9170, 8931, 9089, 9056, 9164, 9107, 9103, 9188, 9187, 9121, 9111, 9106, 9129, 8882, 9196, 8979, 9095, 8984, 9141, 9148, 9118, 9144, 9082, 9224, 9189, 9185, 8970, 9193, 9136, 9160, 9162, 8933, 9157, 9083, 9168, 9163, 9155, 8927, 8982, 9143, 4162, 9180, 9116, 9173, 8830, 9098, 9139, 9179, 9165, 9096, 9222, 9142, 9027, 8883, 9086, 9169, 9175, 9172, 9080, 9124, 9088, 8968, 9075, 9154, 9133, 9117, 9198, 9183, 9102, 9126, 9204, 9202, 9161) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---