---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(31800, 31693, 31767, 31760, 32860, 31759, 31682, 31850, 31773, 31823, 31777, 31778, 31987, 31781, 31802, 31785, 31780, 31809, 31801, 31808, 31742, 31391, 31798, 31803, 31819, 31807, 31774, 31797, 33802, 33803, 31779, 31792, 31790, 31821, 31745, 31788, 33564, 29349, 31799, 31810, 31794, 31796, 32152, 31419, 31795, 31827, 31690, 31793, 31786, 31804, 31812, 31806, 31811, 31817, 31814, 31813, 31815, 31816, 31822, 31825, 31828, 31826, 31824, 31896, 31838, 31858, 31844, 31856, 31829, 31869, 31830, 31996, 31855, 31841, 31840, 31854, 31843, 31848, 31839, 31845, 31866, 31835, 31871, 31867, 31587, 31842, 31832, 31837, 31787, 31831, 31847, 31846, 31851, 31849, 31864, 31852, 33325, 31863, 31872, 31860, 31861, 31862, 31818, 32153, 31776, 31833, 32533, 31901, 31899, 31954, 31909, 31892, 31933, 31903, 31905, 31900, 31805, 31270, 31414, 31878, 32449, 31904, 31880, 33542, 31895, 31956, 31955, 31836, 31859, 31875, 31893, 31902, 31775, 31702, 32622, 31928, 31891, 31894, 31879, 31874, 31889, 31888, 31886, 31882, 31881, 31887, 31885, 31883, 31884, 31873, 31917, 31600, 31890, 31876, 31877, 31898, 31897, 31911, 31915, 31914, 31906, 34733, 31912, 31921, 31932, 31865, 31913, 31923, 31924, 31922, 31918, 31925, 31937, 31919, 31920, 31916, 31946, 31929, 36294, 36064, 31930, 31931, 31377, 31935, 31949, 32446, 31938, 31908, 31948, 31951, 31952, 31677, 32050, 32961, 31926, 31936, 31907, 31942, 32454, 31945, 31943, 31944, 31950, 31939, 31953, 33229, 31957, 31963, 36621, 31961, 31960, 31959, 31974, 31966, 31973, 31967, 31964, 32003, 31970, 31971, 31969, 31975, 31978, 31980, 31979, 31989, 32036, 31984, 31982, 31965, 31983, 31976, 31927, 31981, 32405, 32001, 32002, 32033, 31958, 31977, 31985, 32000, 31986, 31991) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---