How to create a scope for this query?

db_campaigns_controller.rb

def index
    # Set Scenario for the Dashboard
    #
    # Excludes campaigns that belongs to "Un Jour Une Astuce" program
    ids_to_exclude = [864, 5, 7, 866, 8, 994, 868, 14, 870, 15, 17, 11, 16, 21, 23, 24, 25, 31, 20, 871, 29, 30, 27, 38, 1540, 34, 35, 37, 33, 872, 41, 43, 65, 42, 46, 47, 48, 995, 45, 873, 51, 53, 874, 50, 875, 58, 876, 59, 55, 877, 63, 878, 64, 61, 879, 68, 69, 67, 880, 73, 885, 74, 71, 881, 77, 79, 76, 882, 83, 883, 84, 81, 884, 101, 886, 103, 99, 887, 106, 107, 996, 105, 888, 110, 111, 127, 109, 889, 116, 1653, 1566, 113, 890, 119, 120, 891, 118, 892, 124, 125, 126, 123, 893, 132, 894, 129, 895, 135, 136, 146, 134, 896, 141, 897, 906, 138, 898, 145, 899, 143, 900, 151, 1571, 157, 149, 902, 154, 155, 156, 153, 904, 907, 161, 193, 1631, 909, 166, 911, 1482, 164, 1636, 169, 170, 171, 168, 913, 174, 176, 1497, 173, 1638, 179, 180, 563, 178, 915, 183, 184, 1588, 182, 917, 187, 188, 564, 186, 919, 192, 921, 190, 923, 197, 925, 195, 927, 202, 929, 200, 931, 206, 935, 204, 937, 209, 210, 224, 208, 941, 213, 214, 254, 212, 943, 218, 945, 303, 216, 949, 221, 223, 951, 220, 955, 228, 957, 226, 988, 231, 232, 308, 230, 961, 235, 236, 565, 234, 963, 240, 965, 238, 971, 244, 974, 242, 976, 248, 980, 246, 984, 253, 990, 250, 992, 257, 997, 256, 1000, 262, 1002, 260, 1008, 266, 264, 265, 1010, 270, 1013, 268, 1017, 274, 1019, 309, 272, 1022, 278, 1024, 276, 1027, 282, 1032, 280, 1034, 290, 1038, 284, 1040, 294, 292, 293, 1042, 298, 1044, 310, 296, 1049, 302, 1051, 300, 1054, 307, 1058, 305, 1060, 314, 1064, 312, 1066, 318, 1068, 316, 322, 1072, 1074, 319, 320, 1076, 326, 1078, 324, 1080, 329, 330, 328, 1082, 333, 334, 364, 332, 1084, 338, 1086, 336, 1088, 341, 342, 413, 340, 1092, 345, 346, 344, 1093, 349, 351, 454, 348, 1097, 354, 355, 471, 353, 1099, 1651, 358, 582, 359, 1101, 363, 1103, 361, 1105, 368, 1107, 369, 366, 1676, 372, 373, 374, 371, 1109, 378, 1111, 376, 1113, 381, 382, 380, 1686, 385, 386, 1599, 384, 1115, 390, 1117, 391, 388, 1120, 394, 395, 1604, 393, 1122, 400, 1692, 398, 399, 1126, 404, 1130, 402, 1131, 408, 1134, 406, 1136, 412, 1138, 410, 1140, 417, 1142, 415, 1144, 420, 421, 638, 419, 1146, 425, 1154, 423, 1156, 428, 429, 639, 427, 1159, 433, 1161, 431, 1163, 437, 1167, 435, 1171, 441, 1175, 439, 444, 445, 502, 443, 1177, 448, 449, 509, 447, 1180, 452, 453, 451, 1182, 458, 1184, 456, 1187, 462, 1188, 460, 1192, 466, 1197, 464, 1201, 469, 470, 468, 1202, 474, 475, 473, 1206, 478, 479, 477, 1210, 482, 483, 1212, 481, 1214, 486, 488, 485, 487, 1217, 492, 1218, 490, 1223, 495, 508, 494, 1227, 500, 501, 498, 1231, 506, 507, 1605, 504, 1282, 513, 1235, 511, 1237, 518, 516, 517, 1239, 521, 522, 531, 520, 1243, 525, 526, 532, 524, 1248, 1252, 1255, 528, 529, 1257, 535, 536, 542, 534, 1260, 539, 541, 538, 540, 1261, 545, 546, 552, 544, 1265, 549, 550, 551, 548, 1267, 555, 556, 557, 554, 1654, 560, 561, 562, 559, 1270, 568, 1272, 566, 1274, 573, 1278, 571, 1280, 577, 1283, 575, 1287, 581, 1291, 579, 1293, 587, 1295, 1300, 585, 1304, 590, 591, 592, 589, 1305, 596, 1307, 594, 1656, 599, 600, 601, 598, 1311, 605, 1316, 603, 1318, 609, 1320, 607, 1324, 615, 626, 613, 1327, 618, 619, 1330, 617, 1334, 624, 1338, 622, 623, 1340, 629, 630, 631, 628, 1342, 635, 636, 637, 634, 1344, 643, 641, 642, 1347, 646, 647, 648, 645, 1351, 652, 1356, 653, 650, 1358, 656, 657,  655, 1360, 661, 662, 663, 660, 1363, 1658, 666,  667, 1364, 671, 1367, 669, 674, 675, 787, 673, 1368, 679, 1372, 677, 1374, 682, 683, 1026, 681, 1376, 686, 687, 692, 685, 1378, 691, 1381, 1542, 689, 1385, 695, 696, 1063, 694, 1390, 700, 701, 698, 1392, 704, 705, 724, 703, 1394, 708, 710, 1398, 707, 1402, 713, 714, 712, 1405, 718, 1406, 716, 1410, 721, 722, 1412, 720, 1414, 728, 1418, 726, 1422, 732, 1426, 792, 730, 1544, 736, 737, 755, 735, 1428, 740, 741, 1430, 739, 1461, 745, 746, 847, 744, 1436, 750, 748, 749, 1439, 754, 1440, 752, 1442, 759, 1445, 757, 1447, 763, 1449, 761, 1451, 767, 1453, 765, 1564, 771, 772, 777, 769, 1455, 776, 1457, 774, 1459, 781, 1462,  779, 1465, 784, 785, 1467, 783, 1472, 790, 791, 13, 789, 1475, 795, 796, 797, 794, 1477, 800, 801, 1628, 799, 1483, 804, 806, 1488, 803, 1489, 810, 1493, 808, 1498, 814, 1502, 812, 1503, 818, 1506, 816, 1509, 821, 823, 1511, 820, 1514, 827, 1518, 825, 1520, 830, 832, 1703, 833, 829, 1522, 836, 837, 1629, 835, 1526, 1530, 1532, 839, 840, 1534, 845, 1536, 843, 844, 850, 851, 854, 855, 858, 1012, 1538, 857, 863,  861,  867,  865,  18,  901, 905, 903, 910, 908, 914, 912, 918, 916, 922, 920, 926, 924, 930, 928, 934, 936, 932, 940, 938, 939, 944, 942, 950, 956, 948, 954, 952, 953, 959, 960, 958, 964, 962, 969, 970, 966, 968, 975, 972, 973, 978, 979, 977, 982, 983, 989, 981, 986, 987, 985, 993, 991, 1001, 998, 999, 1006, 1007, 1003, 1004, 1005, 1011, 1009, 1016, 1014, 1015, 1020, 1021, 1018, 1025, 1023, 1029, 1030, 1031, 1028, 1035, 1033, 1039, 1036, 1037, 1043, 1041, 1046, 1047, 1048, 1045, 1052, 1053, 1050, 1057, 1055, 1056, 1061, 1062, 1059, 1067, 1065, 1070, 1071, 1069, 1075, 1073, 1079, 1077, 1083, 1081, 1087, 1085, 1091, 1121, 1089, 1090, 1096, 1094, 1095, 1100, 1098, 1104, 1102, 1108, 1106, 1112, 1110, 1116, 1114, 1119, 1118, 1124, 1125, 1666, 1123, 1128, 1129, 1158, 1127, 1132, 1667, 1133, 1137, 1135, 1141, 1139, 1145, 1143, 1148, 1149, 1147, 1152, 1153, 1150, 1151, 1157, 1155, 1162, 1179, 1160, 1165, 1166, 1164, 1169, 1170, 1168, 1173, 1174, 1172, 1178, 1176, 1183, 1181, 1186, 1680, 1185, 1190, 1191, 1189, 1194, 1195, 1196, 1193, 1199, 1200, 1198, 1204, 1205, 1203, 1208, 1209, 1310, 1207, 1213, 1211, 1216, 1256, 1215, 1220, 1222, 1219, 1221, 1225, 1226, 1681, 1224, 1230, 1228, 1229, 1233, 1234, 1232, 1238, 1236, 1241, 1242, 1329, 1240, 1246, 1247, 1244, 1245, 1250, 1251, 1346, 1249, 1254, 1380, 1253, 1259, 1389, 1258, 1263, 1264, 1444, 1262, 1268, 1269, 1266, 1273, 1271, 1276, 1277, 1275, 1281, 1279, 1286, 1284, 1285, 1290, 1288, 1289, 1294, 1292, 1297, 1298, 1299, 1296, 1303, 1309, 1301, 1302, 1308, 1306, 1314, 1315, 1312, 1313, 1319, 1317, 75, 1322, 1323, 1321, 1326, 1328, 1325, 1332, 1333, 1331, 1336, 1337, 1335, 1341, 1339, 1345, 1343, 1349, 1350, 1348, 1354, 1355, 1352, 1353, 1359, 1357, 1362, 1361, 1366, 1365, 1370, 1371, 1369, 1375, 1373, 1379, 1377, 1383, 1384, 1382, 1387, 1388, 1386, 1393, 1391, 1397, 1395, 1396, 1400, 1401, 1399, 1404, 1403, 1409, 1407, 1408, 1413, 1411, 1416, 1417, 1415, 1421, 1419, 1420, 1424, 1425, 1423, 1429, 1427, 1432, 1435, 1431, 1438, 1437, 1443, 1441, 1448, 1471, 1446, 1452, 1450, 1456, 1454, 1460, 1458, 1464, 1466, 1463, 1470, 1468, 1469, 1474, 1476, 1473, 1479, 1480, 1478, 1481, 1486, 1487, 1485, 1491, 1492, 1490, 1495, 1496, 1494, 1500, 1501, 1499, 1508, 1504, 1512, 1510, 1516, 1517, 1515, 1521, 1519, 1524, 1525, 1523, 78, 1528, 1529, 1527, 1533, 1531, 1537, 1535, 1541, 1539, 1545, 1543, 1548, 1549, 1547, 1552, 1551, 1557, 1555, 1561, 1559, 1565, 1563, 1568, 1569, 1570, 1567, 1574, 1572, 1573, 1578, 1576, 1577, 1582, 1580, 1581, 1586, 1587, 1584, 1592, 1593, 1590, 1591, 1596, 1598, 1595, 1603, 1601, 1609, 1610, 1607, 1614, 1615, 1612, 1621, 1622, 1619, 1620, 1625, 1626, 1624, 1634, 1635, 1632, 1633, 1639, 1637, 1643, 1644, 1641, 1648, 1646, 1652, 1650, 1657, 1655, 1660, 1661, 1659, 1665, 1663, 1664, 1670, 1671, 1669, 1674, 1675, 1673, 1678, 1679, 1677, 1684, 1685, 1682, 1683, 1688, 1689, 1687, 1696,  1693, 1700, 1698, 1704, 1702, 1707, 1706, 1, 6, 9, 10, 26, 28, 32, 39, 40, 44, 49, 52, 54, 56, 60, 62, 66, 70, 72, 80, 82, 85, 100, 104, 108, 112, 115, 117, 121, 122, 128, 130, 133, 137, 140, 142, 144, 148, 150, 152, 158, 160, 162, 163, 165, 167, 172, 177, 181, 185, 189, 191, 194, 196, 198, 201, 203, 205, 207, 211, 215, 217, 219, 222, 225, 227, 229, 233, 237, 239, 241, 243, 245, 247, 249, 251, 255, 258, 259, 261, 442, 263, 267, 269, 271, 273, 275, 277, 279, 411, 281, 283, 289, 291, 295, 297, 299, 301, 315, 304, 306, 311, 313, 317, 321, 323, 325, 327, 331, 335, 337, 339, 343, 347, 352, 356, 357, 360, 362, 365, 367, 370, 375, 377, 379, 383, 387, 389, 392, 396, 401, 403, 405, 407, 409, 414, 416, 418, 422, 424, 426, 430, 432, 434, 436, 438, 440, 446, 450, 455, 457, 459, 461, 463, 465, 467, 472, 476, 480, 514, 484, 489, 491, 493, 496, 497, 499, 519, 503, 510, 512, 515, 523, 527, 530, 533, 537, 543, 547, 553, 580, 558, 567, 569, 570, 632, 572, 574, 576, 578, 584, 586, 588, 593, 595, 597, 602, 604, 606, 608, 610, 614, 616, 620, 621, 625, 627, 640, 644, 649, 651, 654, 658, 664, 665, 668, 670, 672, 676, 678, 805, 680, 684, 688, 690, 693, 697, 699, 702, 706, 709, 711, 733, 715, 717, 719, 723, 725, 727, 729, 731, 734, 738, 742, 743, 747, 751, 753, 756, 758, 760, 762, 764, 766, 768, 773, 775, 778, 780, 782, 786, 788, 793, 798, 802, 807, 809, 811, 813, 815, 817, 819, 822, 824, 826, 828, 831, 834, 838, 841, 842, 846, 848, 849, 852, 853, 856, 859, 860, 862, 1546, 1550, 1553, 1554, 1556, 1558, 1560, 1562, 1575, 1579, 1583, 1585, 1589, 1594, 1597, 1600, 1602, 1606, 1608, 1611, 1613, 1618, 1623, 1627, 1640, 1642, 1645, 1647, 1649, 1662, 1668, 1690, 1672, 1695, 1697, 1699, 1701, 1705, 1708]
    # Defines all campaigns that will be shown (except the ones mentioned above)
    @campaigns = DbCampaign.where.not(campaign_id: ids_to_exclude).sorted.paginate(:page => params[:page], :per_page => 10).where(sender: nil)
  end