search

Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

database: GB: filtering GB content using new countriesOut field #413

Closed syndr0m closed 7 years ago

syndr0m commented 7 years ago

filtering contents using new countriesOut field

UPDATE "Movies"
SET "countriesOut"='{GB}'
WHERE "_id" NOT IN (
39,
47,
48,
49,
50,
51,
52,
53,
54,
131,
193,
195,
196,
197,
198,
199,
206,
207,
208,
210,
217,
219,
220,
241,
242,
243,
244,
261,
262,
263,
264,
265,
272,
273,
274,
275,
277,
278,
279,
281,
291,
299,
304,
24,
25,
26,
35,
123,
257,
258,
327,
332,
366,
367,
378,
384
)
syndr0m commented 7 years ago 
UPDATE "Seasons"
SET "countriesOut"='{GB}'
WHERE "_id" NOT IN (

36,
38,
39,
233,
42,
225,
51,
52,
53,
108,
78,
122,
123,
176,
181,
214,
215,
213,
216,
217,
226,
234

);
syndr0m commented 7 years ago 
UPDATE "Episodes"
SET "countriesOut"='{GB}'
WHERE "_id" NOT IN (

607,
608,
609,
610,
611,
612,
613,
614,
615,
616,
622,
623,
624,
625,
626,
627,
628,
629,
630,
631,
632,
633,
634,
635,
636,
637,
2929,
2925,
2926,
2928,
2924,
2927,
2930,
2931,
2932,
2933,
642,
643,
644,
645,
646,
647,
648,
649,
650,
651,
652,
2837,
2838,
2839,
2840,
2841,
2842,
2843,
2844,
2845,
2846,
1176,
1177,
1178,
1179,
1180,
1181,
1182,
1183,
1184,
1185,
1186,
1187,
1188,
1189,
1190,
1191,
1192,
1993,
2010,
2011,
2012,
2013,
2014,
1695,
1696,
1697,
1698,
1700,
1699,
1701,
2092,
2094,
2095,
2096,
2097,
2098,
2099,
2100,
2101,
2102,
2103,
2104,
2105,
2558,
2556,
2557,
2559,
2560,
2561,
2562,
2563,
2564,
2565,
2566,
2567,
2568,
2569,
2570,
2571,
2572,
2573,
2574,
2575,
2576,
2577,
2578,
2579,
2580,
2581,
2623,
2624,
2625,
2626,
2627,
2628,
2629,
2630,
2631,
2632,
2777,
2778,
2779,
2780,
2781,
2782,
2783,
2784,
2785,
2786,
2787,
2788,
2789,
2790,
2792,
2791,
2775,
2776,
2793,
2795,
2794,
2796,
2797,
2798,
2799,
2800,
2801,
2847,
2848,
2849,
2850,
2851,
2852,
2934,
2935,
2936,
2937,
2938,
2939,
2940,
2941,
2942,
2943,
2944,
2945
)
syndr0m commented 7 years ago

done