---

SELECT m.albumid, m.url_replace, a.url_scheme, a.shortname FROM albums_merchandise m, merchandise_affiliates a WHERE m.albumid IN(36119, 35814, 35836, 35821, 35838, 35833, 35844, 35839, 35843, 35840, 35837, 35834, 35835, 35841, 35842, 35845, 35406, 35847, 35860, 35856, 35895, 35874, 35818, 35861, 35865, 35848, 35852, 35918, 35888, 35859, 35871, 35968, 35864, 35855, 35857, 35486, 35892, 35879, 35873, 33969, 35851, 35858, 35846, 35872, 35820, 35866, 35863, 35862, 35891, 35868, 35870, 35867, 35869, 35878, 35889, 35887, 35877, 35886, 35880, 35883, 35882, 35884, 35885, 36970, 36156, 35881, 35890, 35901, 35898, 35910, 35920, 35913, 35908, 35904, 35905, 35914, 35925, 35902, 35850, 35906, 35927, 35921, 35929, 35915, 35964, 35909, 35897, 35875, 36116, 35928, 35926, 35919, 22144, 35726, 35907, 35912, 35935, 35849, 35911, 35916, 35965, 35923, 35954, 35924, 35934, 35933, 35930, 35932, 35931, 35984, 35941, 35975, 35972, 35944, 35953, 35951, 35959, 35376, 35977, 35938, 35939, 35936, 35960, 35946, 35942, 35947, 36026, 35969, 35974, 35955, 35952, 36063, 35973, 35945, 35970, 35950, 35961, 35940, 35896, 35943, 35949, 35957, 35937, 36000, 35966, 35963, 35976, 35979, 35978, 35992, 35986, 35985, 36302, 36025, 35962, 35998, 36240, 36155, 36024, 35989, 36014, 36015, 36055, 35991, 35990, 36023, 36004, 36019, 36005, 35997, 36008, 36009, 36020, 36010, 36018, 35999, 36001, 35987, 36011, 36021, 36006, 35903, 35996, 35995, 36007, 35994, 35993, 36016, 36027, 36013, 36012, 36030, 36029, 35982, 36033, 36031, 36032, 36038, 36039, 35988, 36045, 36035, 35389, 35876, 36050, 36042, 36052, 36051, 36072, 36049, 35748, 36077, 36076, 36085, 36084, 36057, 36073, 36068, 36043, 36040, 36034, 36046, 36041, 36048, 36081, 36075, 36074, 12325, 36047, 36044, 36069) AND m.affiliateid=a.affiliateid ORDER BY a.sortorder ASC

---