---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(18798, 18882, 19019, 18502, 18849, 18850, 19026, 19025, 18873, 19020, 19024, 19101, 19100, 19572, 19035, 26209, 18705, 18942, 18859, 19761, 18856, 18494, 18759, 19577, 18835, 19027, 18661, 4541, 24100, 19056, 19029, 19112, 18734, 19907, 18662, 18992, 19030, 19016, 19136, 18058, 19037, 19138, 19036, 19139, 18831, 19084, 19131, 14592, 19129, 19571, 19130, 38197, 28305, 19063, 19061, 18758, 18740, 18639, 18864, 19065, 19066, 19034, 19057, 18561, 19757, 18844, 19570, 19161, 18977, 19107, 19544, 19132, 18775, 18774, 18773, 19080, 19033, 19542, 19073, 18800, 19077, 19076, 18757, 18994, 18221, 19074, 19021, 18714, 19000, 19053, 18596, 18998, 19097, 21493, 19075, 18646, 23865, 18779, 19058, 18685, 19082, 18941, 19124, 19079, 19128, 19085, 19087, 19125, 19147, 19319, 19114, 19283, 19152, 19149, 19055, 19142, 24344, 18993, 18807, 19054, 19096, 19143, 18854, 19049, 19160, 18530, 19758, 18833, 18870, 18574, 18881, 19578, 18701, 18834, 9295, 10187, 19148, 19110, 18995, 18843, 19022, 19127, 18853, 19095, 18255, 18702, 19133, 19108, 18959, 19119, 17584, 19031, 19500, 19044, 18806, 18514, 18855, 18752, 19111, 19072, 19071, 19064, 18735, 19120, 19121, 19003, 19187, 18716, 19353, 18886, 19105, 19178, 19140, 19188, 19331, 19059, 19541, 19047, 19060, 19015, 19018, 18867, 19118, 19193, 19189, 19052, 18371, 18755, 19062, 18742, 19002, 19185, 19190, 19177, 32710, 18926, 19109, 18572, 18728, 18777, 19078, 18841, 18560, 18748, 18749, 18766, 18699, 18796, 18747, 18631) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---