---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(19284, 17561, 19134, 25259, 19012, 19328, 19179, 19180, 19181, 19323, 19182, 19390, 19329, 19326, 19183, 19335, 33428, 20059, 19438, 20058, 19104, 20060, 20061, 19336, 18733, 19106, 18686, 19435, 19065, 19449, 19153, 19347, 19756, 19150, 19318, 18753, 19151, 18581, 18987, 19582, 19050, 19001, 18940, 19189, 19330, 19348, 19437, 18826, 19045, 18680, 19137, 19044, 19317, 19356, 19421, 19422, 19007, 19532, 19639, 19352, 19464, 19346, 19351, 19660, 18875, 18979, 19448, 19345, 19760, 19445, 19457, 18939, 18612, 12930, 18687, 19192, 19010, 18269, 19094, 19454, 19451, 19444, 18978, 19332, 19102, 19158, 18776, 19460, 19144, 19014, 19021, 19708, 19450, 19350, 19590, 19146, 27892, 872, 19116, 19117, 17144, 19456, 19459, 18772, 18991, 19354, 19505, 19494, 19495, 19493, 19518, 19640, 19507, 19506, 19515, 19516, 19442, 19533, 19520, 19465, 25187, 19196, 18815, 19514, 21327, 19517, 18574, 19519, 19424, 19579, 19122, 18564, 19524, 19497, 19443, 19103, 19193, 19453, 19613, 17908, 19316, 18972, 18756, 19588, 18804, 19440, 19439, 19522, 19043, 1765, 19523, 19513, 25783, 19525, 19530, 17680, 19510, 19508, 19509, 19610, 38493, 19611, 20381, 20382, 20383, 19612, 19616, 19826, 19621, 19619, 19441, 19052, 19512, 25421, 28089, 19845, 19844, 19620, 19436, 19847, 20249, 18969, 19662, 19605, 18994, 19765, 19614, 19843, 19841, 19840, 17255, 17146, 17147, 18790, 18789, 19355) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---