---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(22646, 22658, 22647, 22648, 30228, 22652, 22675, 22737, 23170, 22651, 22442, 21723, 22623, 22666, 22649, 22531, 22694, 22642, 22884, 22644, 22664, 21908, 22669, 23881, 22653, 22564, 22444, 22665, 22625, 22605, 22266, 22905, 22660, 22687, 22645, 22738, 22689, 22691, 22690, 22742, 22700, 22724, 22701, 22735, 21851, 28841, 22445, 22716, 22306, 23739, 22707, 22706, 22663, 18422, 22713, 22715, 22712, 22714, 22711, 22705, 22708, 22704, 22656, 22591, 22468, 22743, 22650, 22717, 22736, 22733, 22686, 23295, 22718, 22739, 22756, 22909, 22750, 22744, 22741, 22740, 22766, 22752, 22751, 22807, 21895, 22674, 22767, 22673, 22771, 22774, 22762, 28249, 22772, 22640, 22775, 22764, 22755, 22776, 22676, 22720, 22671, 22761, 22770, 22709, 22672, 22335, 22365, 22692, 22760, 22529, 22117, 22618, 22641, 22029, 22779, 22780, 7905, 22768, 22568, 22619, 22773, 22769, 22670, 22589, 22777, 22784, 22797, 22798, 22795, 22907, 22796, 22799, 21933, 8293, 22806, 22833, 22388, 22858, 22819, 22835, 22910, 22610, 22844, 22719, 22830, 22843, 22822, 22821, 22217, 22820, 22842, 22590, 22808, 22840, 22826, 22829, 22838, 22668, 22825, 22827, 22510, 22839, 22698, 22515, 22710, 22734, 22661, 22824, 22847, 28482, 22803, 22846, 22441, 22778, 22832, 22818, 22836, 22850, 22758, 22783, 22781, 22759, 22782, 22493, 22859, 22856, 22855, 22854, 22852, 22753, 22857, 22801, 22860, 22863, 22864, 22877, 22935, 22904, 22885, 22874, 22876, 22490, 22903, 22868, 22484, 22873, 22848, 22800, 22870, 22643, 22862, 22871, 22906, 22881, 22882, 22880, 22879, 24433, 22872, 22893, 22895, 22896, 22894, 22892, 22897, 24441) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---