Skip to content

Instantly share code, notes, and snippets.

@geronimod

geronimod/data_growth.sql

Created September 20, 2013 14:46
Show Gist options
  • Save geronimod/6638649 to your computer and use it in GitHub Desktop.
Save geronimod/6638649 to your computer and use it in GitHub Desktop.
Download ZIP
Data Growth
Raw
data_growth.sql
SELECT distinct_clips.campaign_id, arizona_fill_clip.pk as clipKey, distinct_clips.clip_cat_id as category_id, distinct_clips.folder_type_id as folder_type_id, day, viewDelta as views, commentDelta as comments, rateDelta as ratings
FROM arizona_fill_clip
JOIN (
SELECT DISTINCT campaign_id, pk, clip_cat_id, folder_type_id, unified_clip_id, data_source
FROM arizona
WHERE data_source = 'phx'
AND campaign_id in (249,989,1021,1626,1706,1726,1742,1746,1750,1754,1718,1634,1542,1546,1498,1494,1502,1530,1550,1758,1766,1770,1778,1774,1526,1738,1534,1630,1786,1794,1814,1818,1822,1826,1834,1838,1842,1846,1890,1566,1898,1902,1910,1922,1930,1934,1938,1942,1946,1950,1954,1958,1962,1966,1970,1974,1978,1982,1986,1990,1994,1998,2006,693,1894,2010,2014,1762,2018,2022,2026,2030,2034,2038,2042,2046,2050,2058,2062,2066,2070,2074,2082,2090,2094,2098,2106,2110,2114,2118,2122,2126,2130,2134,2154,2158,2162,2166,2170,2174,2178,2190,2194,2202,2206,2210,2214,2218,2222,2226,2230,2250,2254,2258,2262,2266,2270,2274,2278,2282,2286,2290,2294,2298,2302,2306,2314,2318,2398,2402,2406,2410,2414,2418,2422,2430,2434,2438,2442,2446,2450,2454,2462,2466,2470,2474,2478,2482,2490,2494,2498,2518,2522,2526,2530,2550,2554,2558,2562,2566,2570,2574,2582,2586,2594,2598,2610,2614,2618,2622,2626,2630,2634,2638,2650,2654,2658,2662,2670,2674,2682,2686,2690,2694,2698,2706,2710,2714,2718,2722,2725,2737,2741,2745,2749,2757,2769,2773,2777,2781,2789,2793,2797,2805,2809,2821,2833,2837,2841,2849,2853,2857,2865,2869,2897,2901,2905,2909,2921,2925,2929,2933,2953,2941,2957,2961,3009,3013,3017,3021,3025,3033,3037,3041,3045,3049,3085,3089,3093,3097,3101,3113,3117,3121,3133,3161,3169,3173,3177,3181,3189,3193,3197,3205,3209,3213,3217,3221,3229,3237,3245,3253,3257,3261,3265,3269,3273,3277,3281,3285,3293,3313,3317,3321,3325,3329,3333,3337,3341,3345,3349,3353,3357,3401,3409,3413,3421,3425,3429,1674,3437,3441,3445,3453,3457,3461,3473,3485,3489,3493,3497,3501,3505,3509,3517,3525,3529,3533,3541,3545,3549,3553,3561,3565,3569,3573,3581,3585,3589,3597,3617,3621,3625,3629,3637,3645,3649,3653,3657,3661,3665,3669,3673,3677,3681,3685,3697,3701,3705,3709,3713,3717,3721,3725,3729,3733,3737,3741,3749,3753,3757,3761,3769,3833,3837,3841,3845,3849,3853,3861,3945,3949,3953,3957,3961,3965,3969,3981,3985,3989,3997,4005,4021,4037,4045,4069,4073,4077,4081,4089,4093,4097,4101,3689,4105,4109,4113,1686,1790,3201,3977,1650,1694,2142,2310,3513,4025,3465,4057,4145,4149,4153,4157,4161,4165,1638,1682,1730,2234,4053,3993,3225,4065,4049,4189,4193,4197,4205,4209,4201,4213,4217,4221,4225,4229,4233,4237,4241,4245,4249,4253,4257,4261,4265,4269,4273,4277,4281,1610,1654,4285,1698,2150,2486,4289,4041,4017,4297,4301,4305,4309,4313,4317,4321,4325,4329,4333,4337,4341,4377,4401,4405,4409,4413,4417,4421,4425,4429,4433,4437,4441,4445,4449,4453,4457,4461,4465,4469,4473,4477,4481,4485,4489,4493,4497,4501,4505,4509,4513,4517,4521,4525,4529,4537,4541,4545,4549,4557,4561,4565,4569,4573,4577,4581,4585,4589,4593,4597,4601,4605,4609,4613,4617,4621,4629,4649,4709,4741,4689,4753,4761,4765,4769,4777,4781,4785,4789,4793,4797,4801,4805,4809,4813,4817,4821,4829,4833,4837,4841,4845,4849,4853,4865,4869,4873,4877,4881,4885,4889,4893,4897,4901,4905,4909,4913,4917,4921,4925,4929,4933,4937,4941,4945,4949,4969,4977,4985,4989,4993,4997,5001,5005,5009,5021,5025,5033,5041,5045,5049,5057,5089,5101,5105,5113,5117,5121,5125,5133,5137,5145,5149,5153,5157,5161,5173,5181,5185,5189,5193,5197,5201,5245,5257,5261,5265,5273,5277,5281,5289,5293,5301,5305,5309,5313,5317,5321,5325,5329,5341,5345,5349,5353,5357,5361,5365,5369,5373,5377,5381,5385,5389,5393,5397,5401,5405,5409,5413,5425,5429,5433,5437,5441,5445,5449,5477,5525,5529,5537,5541,5545,5549,5561,5565,5569,5573,5577,5581,5585,5589,5593,5597,5601,5605,5609,5613,5617,5621,5625,5629,5633,5637,5649,5653,5657,5661,5669,5673,5677,5681,5685,5689,5693,5697,5701,5705,5729,5733,5753,5761,5765,5769,5773,5777,5785,5789,5793,5797,5801,5805,5809,5813,5817,5821,5829,5837,5845,5849,5853,5857,5861,5865,5869,5873,5877,5881,5885,5889,5893,5901,5905,5909,5925,5929,5933,5937,5941,5953,5997,6005,6017,6021,6025,6029,6037,6041,6049,6057,6061,6069,6085,6089,6093,6097,6101,6105,6109,6113,6121,6125,6129,6133,6137,6141,6145,6153,6177,6181,6185,6189,6193,6197,6205,6209,6213,6217,6221,6225,6229,6237,6241,6245,6249,6253,6257,6261,6265,6269,6273,6285,6289,6293,6297,6317,6325,6329,6333,6337,6345,6357,6361,6365,6369,6377,6381,6385,6389,6393,6397,6401,6405,6409,6421,6425,6433,6437,6441,6445,6449,6453,6457,6461,6465,6469,6477,6481,6497,6501,6505,6509,6513,6517,6521,6529,6533,6537,6541,6545,6549,6553,6557,6561,6565,6577,6581,6585,6589,6593,6597,6605,6609,6617,6621,6625,6629,6633,6637,6641,6643,6647,6651,6655,6659,6663,6667,6675,6679,6683,6687,6691,6695,6699,6703,6707,6743,6747,6751,6759,6767,6779,6795,6799,6803,6807,6811,6815,6819,6823,6827,6831,6851,6855,6859,6863,6867,6871,6899,6903,6907,6911,6915,6919,6923,6927,6931,6935,6939,6951,6955,6959,6987,6991,6995,6999,7003,7007,7011,7015,7047,7059,7063,7067,7071,7075,7079,7087,7095,7099,7103,7107,7119,7123,7179,7183,7187,7191,7195,7199,7203,7207,7211,7215,7219,7223,7227,7231,7235,7239,7243,7247,7251,7255,7259,7263,7271,7291,7299,7331,7343,7347,7351,7355,7363,7367,7371,7375,7379,7383,7387,7407,7411,7415,7427,7431,7439,7443,7447,7451,7455,7459,7463,7471,7475,7479,7483,7491,7495,7499,7503,7507,7511,7515,7519,7575,7591,7607,7695,7699,7703,7707,7711,7715,7719,7723,7731,7739,7747,7751,7759,7763,7767,7771,7775,7779,7787,7791,7795,7803,7807,7811,7815,7819,7823,7827,7831,7835,7839,7883,7891,7895,7919,7927,7939,7987,7991,7995,8003,8011,8015,8019,8023,8027,8031,8035,8039,8043,8047,8051,8055,8059,8063,8067,8071,8075,8083,8087,8091,8095,8099,8103,8107,8111,8115,8119,8147,8155,8159,8163,8167,8171,8227,8235,8243,8247,8251,8263,8267,8311,8315,8327,8331,8335,8371,8375,8383,8387,8395,8399,8403,8431,8435,8439,8443,8447,8451,8455,8463,8467,8471,8507,8523,8527,8531,8535,8539,8603,8607,8611,8615,8619,8623,8627,8631,8635,8639,8647,8651,8655,8659,8663,8667,8671,8679,8683,8687,8691,8699,8703,8707,8711,8715,8719,8723,8727,8731,8735,8739,8743,8747,8751,8779,8783,8787,8819,8823,8843,8847,8851,8855,8859,8867,8871,8875,8883,8891,8895,8899,8903,8911,8915,8919,8927,8931,8943,8947,8951,8955,8959,8963,9023,9027,9031,9035,9039,9043,9047,9055,9059,9063,9067,9075,9079,9083,9091,9099,9103,9107,9111,9127,9135,9139,9143,9147,9151,9159,9163,9167,9175,9179,9183,9187,9191,9195,9199,9203,9207,9211,9215,9219,9223,9227,9231,9235,9239,9243,9247,9251,9255,9259,9263,9267,9271,9275,9323,9355,9359,9363,9371,9375,9383,9391,9395,9403,9407,9415,9419,9423,9427,9431,9443,9471,9475,9479,9483,9487,9491,9499,9503,9507,9515,9519,9523,9527,9531,9535,9539,9543,9547,9551,9555,9559,9563,9567,9571,9575,9783,9787,9791,9795,9799,9803,9807,9815,9823,9831,9835,9839,9843,9851,9855,9859,9863,9867,9871,9875,9879,9883,9887,9891,9895,9899,9903,9907,9919,9979,9983,9991,9995,10003,10007,10011,10031,10043,10047,10063,10067,10071,10075,10079,10083,10087,10091,10095,10099,10107,10111,10115,10119,10123,10127,10131,10135,10139,10143,10147,10151,10163,10171,10175,10251,10255,10259,10263,10051,10287,10299,10303,10331,10375,10379,10383,10387,10395,10399,10407,10411,10419,10427,10435,10443,10463,10471,10479,10487,10495,10499,10459,10535,10543,10559,10579,10615,10623,10635,10643,10611,10655,10663,10675,10679,10683,10687,10691,10695,10715,10527,10743,10747,10751,10755,10759,10763,10795,10807,10799,10811,10819,10827,10831,10847,10851,10855,10859,10867,10863,10879,10891,10899,10903,10915,10919,10923,10927,10931,10935,10939,10943,10947,10951,10959,10963,10967,10907,11035,11051,11059,11055,11063,11067,11071,11075,11087,11091,11095,11099,11103,11115,11119,11159,11163,11171,11211,11215,11223,11219,11227,11231,11235,11251,11255,11259,11263,11267,11275,11279,11283,11291,11295,11303,11299,11311,11315,11319,11327,11331,11335,11339,11343,10415,11367,10735,11387,11391,11395,11399,11407,11411,11431,11423,11439,11447,11451,11455,11459,11467,11471,11475,11487,11499,10403,11519,11547,11607,11611,11615,11631,11635,11643,11079,11647,11651,11655,11659,11663,11667,11671,11675,11679,11683,11687,11691,11695,11699,11703,11707,11711,11715,11719,11723,11727,11731,11735,11739,11743,11747,11751,11755,11759,11415,11775,11787,11791,11795,11799,11803,11811,11827,11843,11851,11859,11863,11879,11883,11887,11895,11899,11903,11911,11915,11919,11923,11927,11931,11935,11939,11943,11947,11951,11111,11959,11963,11967,11971,11975,11979,11983,11991,11995,11135,12015,12019,12023,12027,12031,12035,12039,12043,12055,12059,12063,12067,12071,12075,12079,12087,12095,12099,12103,12107,12111,12115,12119,12123,12127,12131,12135,12143,12147,12151,12155,12159,12163,12167,12171,12175,12179,12187,12231,12247,12251,12255,12259,12263,12267,12275,12279,12287,12291,12295,12299,12303,12307,12311,12315,12319,12323,12331,12351,12359,12367,12371,12375,12379,12383,12387,12391,12395,12399,12451,12455,12459,12463,12467,12471,12475,12479,12483,12491,12495,12507,12511,12515,12519,12523,12539,12543,12547,12551,12555,12563,12567,12571,12575,12579,12583,12587,12591,12619,12623,12647,12655,12659,12667,12671,12675,12679,12663,12687,12691,12695,12699,12707,12711,12715,12719,12723,12727,12731,12735,12739,12743,12747,12755,12759,12763,12767,12775,12779,12807,12819,12823,12827,12831,12835,12843,12867,12907,12939,12943,12947,12951,12955,12959,12967,12971,12975,12987,12995,13003,13007,13011,13019,13023,13027,13031,13035,13039,13043,13055,13059,13063,13067,13071,13075,13079,13111,13115,13119,13123,13127,13135,13139,13143,13147,13151,13155,13159,13163,13167,13171,13175,13179,13183,13207,13219,13223,13259,13263,13267,13271,13275,13279,13283,13287,13291,13295,13299,13303,13307,13311,13315,13319,13323,13331,13347,13351,13355,13359,13363,13487,13499,13503,13507,13511,13515,13519,13523,13527,13531,13535,13539,13543,13547,13551,13555,13559,13567,13571,13575,13579,13587,13591,13595,13599,13607,13611,13615,13619,13627,13631,13635,13643,13647,13655,13659,13663,13667,13671,13675,13679,13683,13691,13695,13699,13707,13711,13715,13719,13723,13731,13735,13739,13743,13747,13751,13759,13755,13763,13767,13775,13783,13787,13791,13795,13799,13807,13811,13815,13819,13827,13831,13843,13863,13867,13875,13891,13771,13931,13935,14047,14055,14067,14239,14243,14247,14251,14255,14259,14263,14267,14271,14275,14279,14283,14287,14291,14295,14299,14303,14307,14311,14315,14319,14343,14347,14351,14359,14363,14419,14435,14439,14443,14447,14451,14455,14463,14467,14471,14475,14483,14487,14491,14495,14499,14511,14515,14519,14523,14527,14535,14539,14531,14547,14551,14555,14559,14567,14459,14575,14579,14587,14595,14603,14611,14615,14623,14627,14635,14663,14667,14671,14679,14683,14687,14691,14695,14699,14703,14707,14711,14719,14723,14727,14735,14743,14747,14755,14751,14759,14763,14767,14771,14783,14779,14787,14791,14795,14799,14803,14807,14811,14815,14819,14823,14827,14831,14835,14839,14843,14847,14851,14859,14863,14867,14871,14875,14879,14883,14887,14599,14943,14947,14951,14955,14959,14963,14967,14971,14979,14983,14987,14991,14995,14999,15003,15007,15011,15019,15039,15051,15059,15063,15071,15083,15091,15099,15103,15107,15111,15115,15119,15123,15127,15131,15147,15151,15155,15159,15163,15167,15171,15175,15179,15183,15187,15191,15195,15199,15203,15207,15211,15215,15219,15223,15227,15231,15235,15239,15243,15251,15255,15247,15259,15263,15271,15267,15307,15311,15319,15323,15327,15331,15335,15339,15343,15347,15351,15355,15359,15363,15367,15371,15375,15395,15427,15431,15435,15439,15443,15447,15451,15455,15459,15463,15475,15483,15487,15491,15499,15503,15507,15511,15515,15607,15611,15615,15623,15647,15679,15683,15687,15691,15695,15699,15703,15707,15711,15715,15719,15723,15727,15731,15735,15739,15743,15747,15751,15519,15755,15759,15763,15767,15775,15783,15787,15791,15799,15803,15807,15815,15819,15823,15827,15811,15831,15835,15839,15843,15847,15851,15855,15859,15863,15867,15923,15955,2246,16003,16007,16011,16015,16019,16023,16027,16031,16035,16039,16059,16083,16091,16095,16099,16107,16111,16115,16119,16123,16127,16131,16135,16139,16143,16147,16151,16155,16159,16163,16167,16171,16175,16179,16183,16187,16191,16195,16207,16211,16215,16219,16223,16227,16231,16235,16239,16243,16247,16251,16255,16259,16263,16267,16275,16279,16283,16287,16291,16295,16055,16331,16303,16371,16375,16379,16383,16387,16391,16395,16323,16359,16403,16407,16411,16415,16423,16431,16435,16443,16455,16467,16471,16479,16483,16491,16495,16499,16503,16507,16511,16515,16519,16523,16527,16463,16531,16583,16587,16591,16595,16603,16607,16611,16615,16619,16623,16627,16631,16635,16475,16643,16647,16651,16667,16671,16679,16687,16691,16703,16707,16715,16719,16723,16727,16771,16787,16799,16815,16819,16823,16827,16831,16835,16863,16399,16867,16871,16875,16879,16887,16895,16891,16903,16907,16899,16911,16915,16923,16919,16927,16931,16935,16947,16959,16967,16971,17003,17019,17023,17031,17035,17047,17051,17055,17063,17067,17011,17087,17091,17095,17099,17119,17123,17127,17131,17103,17135,17139,17143,17147,17159,17155,17163,17167,17175,17171,17183,17187,17195,17199,17203,16939,17215,17219,17223,17231,17235,17239,17243,17247,17251,17255,17259,17319,17323,17327,17331,17335,17339,17343,17347,17351,17355,11047,17211,17383,17387,17403,17407,17411,17415,17419,17423,17435,17447,17431,17451,17459,17455,17463,17467,17471,17479,17483,17491,17495,17499,17503,17507,17511,17515,17519,17523,17527,17531,17535,17539,17543,17547,17551,17555,17559,17563,17571,17567,17575,17599,17603,17607,16599,17635,17639,17647,17707,17715,17719,17723,17727,17735,17739,17743,17747,17751,17755,17759,17763,17703,17771,17767,17779,17795,17799,17807,17815,17819,17847,17859,17863,17867,17871,17875,17879,17883,17887,17891,17895,17899,17903,17911,17919,17923,17927,17943,17855,17979,17991,17995,17999,18003,17699,18015,18027,18039,18043,18047,18051,18055,18059,18063,18071,18075,18079,18083,18087,18091,18099,18103,18107,18115,18119,18123,18127,18131,18135,18139,18143,18151,18159,18163,18167,18171,18175,18179,18183,18187,18191,18195,18199,18203,18207,18211,18215,18223,18227,18231,18235,18239,18243,18247,18251,18271,18275,18279,18283,18287,18291,18295,18299,18303,18307,18315,18319,18323,18327,18331,18335,18343,18347,18351,18355,18359,18363,18367,18375,18379,18419,18459,18467,18471,18479,18483,18487,18491,18495,18499,18503,18507,18511,18515,18519,18523,18527,18531,18539,18547,18551,18555,18559,18563,18567,18571,18575,18579,18583,18587,18591,18599,18603,18607,18611,18615,18435,18623,18627,18631,18635,18639,18643,18667,18695,18739,18743,18751,18755,18759,18763,18771,18775,18779,18783,18787,18791,18795,18799,18803,18807,18811,18823,18863,18867,18871,18879,18883,18887,18891,18895,18899,18903,18907,18911,18915,18919,18923,18927,18931,18939,18943,18819,18855,18975,17687,18987,18991,18995,18999,19003,19007,19011,19015,19019,18391,17007,19027,19031,19035,19039,19043,19047,19051,19055,19063,19067,19071,19075,19079,19083,19087,19091,19095,19099,19103,19107,19111,19127,19139,19155,19171,19187,19195,19203,19239,19259,19267,19275,19283,19291,19307,19399,19403,19407,19411,19415,19423,19431,19455,19459,19463,19467,19471,19479,19483,19487,19495,19499,19503,19507,19511,19515,19519,19523,19527,19535,19539,19543,19491,19555,19575,19579,17831,19583,19547,18663,19587,19591,19435,17851,19595,19599,19603,19607,18951,19611,19619,19623,19631,19635,19639,19643,19647,19651,19659,19663,19667,19671,19675,19679,19691,19695,19699,19703,19707,19711,19715,19719,19723,19727,19731,19735,19739,19743,19747,19751,19755,19759,19767,19775,19859,19867,19871,19875,19879,19883,17583,17587,19907,19911,19915,19919,19923,19927,19931,19939,19943,19947,19951,19963,19967,19971,19975,19979,19983,19987,19991,19995,19999,20003,20007,20011,20015,20019,20023,20027,19903,20031,20035,20039,20043,20047,20051,20055,20059,20063,20067,20071,20075,20079,19935,20119,20123,20127,20131,20135,20139,20143,20147,20155,20159,20163,20167,20175,20179,20183,20187,20191,20195,20199,20203,20207,20211,20215,20219,20223,20227,20231,20235,20239,20255,20259,20263,20267,20271,20279,20283,20287,20291,20295,20299,20303,20307,20311,20355,20359,20363,20367,20375,20379,20383,20391,20387,20395,20399,20403,20411,20427,20431,20435,20439,20443,20447,20451,20455,20459,20463,20467,20471,20475,20479,20483,20487,20491,20499,20507,20511,20519,20523,20515,20527,20531,20535,20539,20547,20555,20495,20503,20095,20595,20603,20611,20615,20619,20623,20631,20635,20639,20643,20647,20651,20655,20659,20663,20667,20671,20675,20679,20683,20687,20691,20699,20703,20707,20711,20715,20719,20723,20727,20731,20739,20747,20751,20755,20759,20743,20771,20775,20799,20803,20551,20543,20807,20811,20815,20819,20823,20831,20827,20835,20839,20843,20847,20851,20855,20859,20863,20867,20871,20875,20879,20883,20887,20891,20895,20899,20903,20907,20911,20915,20919,20923,20927,20931,20935,20939,20943,20947,20951,20955,20959,20963,20971,20975,20995,20999,21003,21035,21039,21047,21051,21055,21059,21063,21067,21071,21075,21079,21083,21087,21091,21095,21099,21103,21107,21111,21119,21123,21115,21127,21131,21135,21139,21143,21147,21151,21155,21163,21171,21175,21179,21183,21187,21191,21195,21199,21203,21207,21211,21215,21219,21223,21227,21231,21235,21239,21243,21247,21251,21255,21259,21303,21307,21311,21315,21319,21327,21331,21339,21335,21343,21347,21351,21355,21359,21363,21367,21375,21379,21323,21383,21387,21391,21395,21399,21407,21411,21415,21419,21423,21427,21431,21435,21439,21443,21447,21451,21455,21459,21463,21467,21471,21475,21479,21483,21487,21491,21495,21499,21507,21511,21515,21563,21567,21571,21575,21579,21583,19475,21595,21599,21603,21607,21611,21615,21619,21623,21627,21631,21635,21639,21643,21647,21651,21655,21663,21659,21667,21675,21683,21691,21695,21703,21707,21711,21715,21719,21723,21727,21731,21735,21739,21743,21747,21751,21755,21759,21775,21783,21787,21791,21795,21799,21807,21811,21815,21823,21827,21831,21839,21843,21847,21851,21855,21863,21867,21871,21875,21879,21883,21887,21891,21895,21899,21903,21907,21911,21915,21919,21923,21927,21931,21935,21939,21943,21963,21983,21995,21999,22003,22007,22011,22015,22019,22023,22027,22031,22035,22039,22071,22075,22087,22091,22103,22107,22111,21803,22119,22123,22127,22131,22135,22139,22143,22147,22151,22155,22159,22163,22167,22171,22175,22179,22183,22187,22191,22195,22199,22203,22207,22211,22215,22219,22223,22227,20791,22243,22247,22291,22307,22311,22323,22327,22331,22335,22339,22347,22343,22355,22351,22359,22363,22367,22371,22375,22379,22383,22403,22407,22411,22415,22419,22423,22427,22431,22435,22439,22443,22447,22451,22467,22475,22479,22487,22491,22495,22499,22503,22507,22511,22527,22531,22535,22543,22547,22551,22571,22567,22591,22595,22599,22603,22607,22611,22615,22619,22623,22627,22631,22635,22639,22643,22647,22651,22655,22659,22663,22667,22671,22675,22679,22683,22687,22691,22699,22695,22703,22707,22719,22723,22727,22731,22735,22739,22755,22759,22763,22767,22771,22775,22795,22803,22807,22811,22815,22819,22823,22827,22831,22835,22839,22843,22847,22851,22855,22859,22863,22867,22871,22875,22879,22895,22899,22907,22915,22919,22923,22927,22931,22935,22939,22943,22947,22951,22955,22959,22963,22967,22971,22975,22979,22983,22987,22991,22995,22999,23003,23007,23011,23015,23019,23023,23027,23031,23035,23039,23043,23047,23051,23075,23079,23087,23091,23095,23099,23103,23107,23111,23123,23127,23131,23135,23139,23143,23147,23151,23155,23159,23163,23167,23171,23207,23211,23215,23219,23223,23227,23231,23235,23239,23243,23247,23251,23255,23259,23263,23267,23271,23283,23287,23291,23295,23351,23355,23359,23363,23367,23379,23383,23391,23399,23403,23407,23411,23415,23419,23423,23427,23431,23435,23439,23443,23447,23455,23459,23463,23467,23479,23475,23471,23483,23487,23491,23495,23499,23503,23507,23511,23527,23531,23535,23539,23543,23547,23551,23555,23559,23563,23567,23571,23575,23579,23583,23587,23591,23619,23623,23627,23631,23635,23639,23647,23655,23659,23663,23667,23671,23675,23679,23683,23687,23691,23695,23699,23703,23707,23711,23715,23719,23723,23731,23735,23739,23743,23747,23751,23771,23775,23779,23783,23787,23791,23795,23799,23803,23807,23811,23815,23823,23827,23831,23835,23839,23843,23847,23851,23855,23859,23863,23867,23871,23875,23879,23903,23911,23919,23923,23927,23931,23935,23939,23943,23947,23951,23955,23959,23963,23967,23971,23975,23979,23983,23987,23991,23995,23999,24003,24007,24011,24015,24019,24023,24031,24027,24035,24039,24043,24047,24051,24055,24059,24063,24067,24071,24075,24079,24083,24087,24091,24095,24099,24103,24111,24115,24119,24123,24127,24131,24135,24139,24143,24147,24151,24155,24159,24163,14907,24182,24186,24190,24194,24198,24202,24246,24254,24258,24262,24266,24270,24274,24250,24210,24278,24282,24286,24290,24302,24306,24310,24314,24318,24322,24326,24330,24334,24338,24342,24346,24350,24354,24358,24362,24366,24374,24370,24378,24382,24386,24390,24398,24402,24414,24418,24422,24426,24430,24434,24438,24442,24446,24450,24454,24458,24294,24514,24518,24522,24526,24530,24534,24538,24542,24546,24550,24554,24558,24562,24566,24570,24574,24578,24582,24586,24590,24594,24598,24602,24606,24610,24614,24618,24622,24626,24630,24634,24638,24642,24646,24650,24654,24658,24662,24666,24670,24678,24682,24686,24690,24694,24702,24706,24710,24714,24718,24722,24726,24730,24734,24738,24742,24746,24750,24754,24758,24766,24770,24774,24778,24782,24790,24794,24830,24834,24838,24850,24854,24858,24842,19179,24870,24874,24878,24882,24886,24890,24894,24898,24902,24810,24906,24910,24914,24918,24922,24926,24930,24934,24946,24950,24954,24958,24962,24966,24970,24974,24978,24982,24986,24990,24994,24998,25002,25006,25010,25014,25018,25022,25026,25058,25062,25066,25070,25074,25078,25082,25086,25090,25094,25098,23759,25110,25114,25138,25142,25146,25150,25154,25158,25170,25174,25178,25182,25186,25194,25198,25202,25206,25210,25214,25218,25222,25226,25230,25234,25238,25242,25258,25262,25266,25270,25274,25278,25282,25126,25302,25310,25314,25318,25322,25326,25330,21403,25118,25362,25366,25370,25374,25378,25382,25386,25394,25398,25402,25406,25410,25414,25418,25422,25426,25430,25434,25438,25442,25446,25450,25162,25190,25454,25458,25466,25470,25474,25478,25482,25486,25490,25494,25498,25502,25506,25510,25514,25518,25522,25526,25530,25534,25538,25546,25550,25554,25566,25570,25578,25582,25606,25610,25630,25122,25642,25646,25654,25662,25638,25670,25674,25690,25694,25698,25702,25706,25710,25714,25718,25722,25726,25730,25734,25738,25742,25746,25750,25754,25758,25762,25770,25774,25778,25782,25786,25650,25790,25794,25814,25818,25822,25826,25830,25834,25838,25842,25846,25850,25854,25858,25862,25866,25870,25874,25878,25882,25886,25890,25894,25898,25918,25922,25930,25934,25942,25946,25954,25962,25966,25970,25974,25978,25982,25986,25990,26002,26006,26010,26014,26018,26022,26026,26030,26034,26038,26042,26046,26050,26074,26082,26086,26090,26094,26098,26102,26110,26114,26118,25902,26122,17675,2881,11599,26070,26126,26130,26134,26154,26166,24298,19763,26178,19299,18687,17843,17787,26182,17427,17179,16675,16655,26142,16539,26186,16063,16043,15299,14939,26190,26194,26198,26202,26206,26210,26214,26218,26222,10059,26230,14355,22799,10815,14563,10539,9495,13339,5017,26235,7887,26239,26243,26247,26251,26255,26259,26263,26267,26271,26275,26279,26283,26287,26291,26295,26299,26303,26307,26311,26315,26319,26323,26327,26331,26335,26347,26351,26355,26359,26363,26367,26371,26375,26379,26383,26387,26391,26395,26399,26403,26407,26411,26415,26419,26431,26435,26439,26443,26447,26451,26459,26467,26463,26471,26479,26483,26487,26495,26503,19687,18095,26491,26146,26519,26527,26531,26539,26543,26547,26551,26555,26559,26563,26579,26583,26587,26591,26595,26599,26603,26607,26611,26615,26619,26623,26627,26631,26635,26639,26643,26647,26651,26655,26659,26663,26667,26671,26675,26679,26683,26687,26691,26695,26699,26703,26707,26711,26715,26719,26723,26727,26731,26739,26747,26751,26755,26759,26763,26767,26799,26803,26807,26811,26815,26819,26823,26827,26831,15095,26174,26795,17279,22903,24798,26575,25914,26859,26863,26499,8079,26867,26871,26879,26883,26887,26895,26899,26903,26907,26891,26915,26919,26923,26927,26931,26911,26935,26939,26943,26947,26955,26959,26963,26971,26979,26975,26983,26987,26991,26995,26999,27007,27011,27003,27015,27019,27023,26967,27027,27035,27039,27043,27047,27051,27059,27055,27063,27067,27075,27071,27083,27091,27095,27099,27103,27079,27107,27111,27119,27131,27135,27139,27303,27307,27323,27331,27335,27355,27363,27451,27459,27463,27475,27275,27483,27487,27383,27491,27187,27499,27503,27507,27511,27519,27523,27531,27543,27547,27551,27567,27555,27563,27559,27571,27575,27579,27587,27591,27599,27611,27615,27623,27627,27631,27635,27639,27643,27647,27651,27655,27667,27675,27195,27679,27683,27691,27687,27171,27707,27711,27715,27267,27759,27719,27347,27231,27287,27779,27735,27727,27695,27699,27215,27731,27227,27159,27739,27151,27787,27795,27799,27803,27255,27199,27823,27851,27855,27859,27863,27867,27871,27875,27723,27883,27887,27891,27895,27899,27903,27907,27911,27915,27919,27923,27927,27931,27935,27939,27943,27947,27951,27955,27959,27963,27967,27971,27975,27979,27983,27987,27991,27995,27999,28003,28007,28011,28015,28019,28023,28035,28039,28043,28047,28051,28055,28059,28067,28071,28075,28079,28083,28087,28091,28095,28099,28103,28107,28111,28115,28119,28123,28131,28135,28139,28163,28179,28183,28187,28191,28195,28199,28127,28203,26162,26791,26158,28215,28219,28223,28227,28231,28235,28239,28243,28247,28255,28263,28267,28271,28275,28279,28287,28291,28283,28295,28299,28303,28307,28315,28319,28323,28327,28331,28335,28339,28343,28347,28351,28355,28359,28363,28367,28371,28375,28379,28383,28391,28395,28407,28259,28411,28431,28435,28439,28443,28455,28459,28463,28471,28475,28483,28487,28491,28447,28495,28499,28503,28507,28511,28515,28519,28523,28527,28531,28535,28543,28547,28551,28559,28555,28563,28567,28571,28575,28579,28583,28587,28591,28595,28599,28603,28607,28611,28615,28619,28623,28627,28631,28635,28639,28643,28647,28651,28655,28659,28663,28671,28675,28679,28683,28687,28691,28695,28699,28703,28707,28711,28715,28719,28723,28727,28731,28735,28739,28743,28747,28751,28759,28763,28767,28771,28775,28779,28791,28799,28803,28807,28811,28815,28819,28399,28823,28827,28831,28835,28839,28843,28847,28855,28859,28867,28871,28875,28879,28883,28887,28891,28895,28899,28903,28907,28911,28915,28919,28923,28927,28931,28935,28939,28947,28951,28955,28959,28963,28967,28971,28975,28979,28983,28987,28991,28995,28999,29003,29007,29011,29015,29019,29023,29027,29031,29043,29063,29075,29079,29083,29087,29091,29095,29099,29103,29107,29111,29115,29123,29127,29131,29135,29139,29143,29151,29155,29159,29163,29167,29171,29175,29183,29179,29187,29191,29195,29199,29203,29207,29211,29215,29219,29227,29231,29235,29239,29243,29247,29251,29255,29259,29263,29267,29271,29275,29279,29283,29287,29291,29295,29299,29303,29311,29315,29319,29343,29347,29351,29363,29367,29371,29375,29383,29387,29391,29395,29399,29403,29407,29415,29411,29419,29423,29427,29431,29435,29439,29443,29447,29451,29455,29467,29475,29479,29483,29487,29491,29495,29499,29503,29511,29507,29515,29519,29523,29527,29531,29535,29539,29543,29547,29551,29555,29559,29563,29567,29571,29575,29579,29583,29587,29591,29595,29599,29603,29611,29615,29379,29463,29619,29623,29627,29631,29471,29639,29643,29651,29659,29663,29671,29679,29675,29683,29687,29691,29695,29703,29707,29715,29711,29719,29723,29727,29731,29735,29743,29751,29755,29747,29759,29763,29767,29771,29775,29779,29783,29787,29795,29739,29799,29803,29807,29811,29815,29819,29823,29827,29831,29835,29839,29843,29847,29851,29855,29859,29863,29867,29871,29875,29879,29883,29887,29891,29895,29899,29903,29907,29911,29915,29919,29923,29927,29931,29935,29699,29955,29959,29963,29967,29975,29979,2845,29983,29987,29991,29995,29999,30003,30007,30011,30015,30019,30023,30027,30031,30035,30039,30071,30075,30079,30083,30087,30091,30099,30103,30107,30111,30115,30119,30123,30127,30131,30135,30143,30147,30155,30159,30163,30167,30171,30175,30179,30183,30187,30191,30195,30199,30203,30207,30211,30215,30219,30223,30227,30231,30235,30239,30243,30247,30251,30255,30259,30263,30267,30271,30275,30279,30283,30287,30291,30295,30299,30303,30307,30311,30315,29971,30067,29607,16067,10803,14591,25574,10627,21819,27807,11287,10307,16087,20763,17207,16103,15283,18411,9131,10607,17263,5641,5269,19315,5177,25558,17311,10339,18847,10519,17695,15675,9819,9811,10315,17931,10619,17227,17307,17275,17439,18671,17823,19627,14607,27479,3641,13335,27527,10883,11139,10391,18747,16075,10887,11495,10423,15291,27031,18683,25666,26339,16335,17475,16327,16779,13343,17915,26535,26571,23395,19023,19447,26875,28479,1690,25102,17691,23595,20991,17935,16803,15075,16683,16079,11147,27583,11239,16807,18647,25286,16639,25134,4393,16963,26475,21835,27751,26455,18387,11503,8599,23643,10651,7359,2913,20627,15275,10027,16319,13131,12999,11143,19887,26523,18311,24206,18415,25590,25586,10039,28311,18851,12327,16051,25926,18655,16955,18383,17443,8695,13803,18399,5921,17283,1370,17827,14583,17775,17303,30047,14571,17299,15315,10875,30063,16791,19147,30059,15279,30051,30055,4857,17839,17679,16775,17379,28171,16307,17595,9779,17835,11131,10631,11127,13779,10523,17291,27471,17791,4773,30323,25682,16459,17811,5977,15295,17191,15079,9095,30347,30355,30359,30363,30367,30371,30375,30383,30387,30391,30395,30399,30403,30407,30411,30415,30419,30423,30427,30431,30435,30439,30443,30447,30451,30455,30459,30463,30327,30467,30471,30475,30479,30483,30491,30503,30507,30511,30515,30519,30527,30531,30535,30539,30543,30547,30551,30559,30563,30567,30571,30575,30579,30583,30587,30351,30607,30615,30627,30635,30643,30647,30651,30655,30659,30663,30667,30671,30675,30679,30687,30695,30699,30703,30707,30711,30719,30723,30731,30739,30743,30747,30751,30755,30759,30763,30767,30771,30775,30779,30783,30787,30791,30795,30799,30803,30807,30811,30815,30819,30823,30827,30831,30835,30839,30843,30847,30851,30855,30859,30863,30867,30871,30875,30879,30883,30887,30891,30895,30715,30555,29147,30899,30911,30915,30919,30523,5129,10311,10439,10659,16439,17271,18255,18839,19443,23371,25958,16795,20767,25462,25678,26138,26567,16343,16699,16711,16991,17783,17803,18395,18407,18843,8863,9367,10791,10871,11123,12559,14619,15287,15795,16047,16071,16447,16535,16659,16695,16811,16951,16999,17295,17591,17683,18371,18675,18827,18831,18835,19163,19211,19439,19451,19615,21771,22539,23651,24846,26423,28027,28031,30947,30951,30959,30963,30955,30967,30971,30975,30983,30987,30995,30979,30999,31003,31007,31011,31015,31023,31027,31031,31035,31039,31043,31047,31051,31055,31059,31067,31071,31075,31079,31083,31087,31091,31095,31099,31103,31107,31111,31115,31119,31123,31127,31131,31135,31139,31143,31147,31151,31155,31159,31163,31167,31171,31175,31195,31203,31207,31211,31215,31219,16987,18067,31239,31243,31247,31251,31255,31259,31263,31267,31271,31279,31275,31283,31287,31291,31295,31299,31303,31307,31315,31311,31323,31327,31331,31319,31335,31339,31343,31347,31351,31355,31359,31363,31367,31371,31375,31379,31383,31391,31387,31395,31399,31403,31419,31407,31235,16995,19683,30903,31223,31431,31455,31459,31463,31467,31471,31475,31483,31487,31491,31495,31499,31503,31507,31519,31523,31527,31531,31535,31543,31547,31551,31563,31567,31571,31575,31579,31583,31587,31591,31595,31599,31603,31607,31631,31639,31643,31647,31651,31655,31663,31659,31667,31671,31675,31679,31683,31687,31691,31695,31699,31703,31707,31711,31715,31727,31731,31735,31723,31739,31743,31747,31751,31755,31759,31763,31767,31771,31775,31779,31783,31787,31791,31795,31799,31803,31807,31811,31815,31819,31823,31827,31831,31835,31839,31843,31847,31851,31855,31859,31863,31867,31907,31911,31915,31931,31935,31939,31943,31947,31951,31955,31959,31963,31967,31971,31975,31979,31983,31987,31991,31995,31999,32003,32007,32011,32015,32019,32023,32027,32031,32035,32039,32043,32047,32051,32079,32115,32119,32123,32127,32131,32135,32151,32155,32167,32171,32175,29791,32179,32183,32187,30591,32191,32195,32203,32199,32207,32211,30595,32067,32215,32219,32223,32227,32231,32235,32239,32243,32247,32251,32255,32259,32263,32267,32271,32275,32279,32291,32295,32299,32303,32311,32355,32359,32367,32371,32375,32379,32383,32391,32395,32399,32403,32407,32411,32415,32419,32423,32427,32431,32435,32439,32443,32451,32455,32459,32463,32467,32471,32475,32479,32483,32487,32491,32495,32499,32503,32507,32511,32515,32519,32523,32527,32531,32535,32539,32543,32563,32567,32571,32575,32579,32583,32587,32591,32595,32599,32603,32607,32611,32615,32619,32623,32627,32631,32635,32639,32643,32647,32651,32655,32659,32663,32667,32687,32691,32695,32699,32703,32707,32711,32715,32719,32723,32727,32731,32735,32739,32743,32747,32787,32791,32799,32803,32807,32811,32795,32831,32835,32839,32843,32847,32851,32855,32859,32863,32867,32871,32875,32879,32883,32887,32891,32895,32899,32903,32907,32915,32919,32923,32927,32931,32935,32939,32951,32947,32955,32959,32963,32967,32971,32975,32979,32983,32991,32995,32999,33007,33011,33015,33019,33027,33047,33003,31479,32771,33055,33059,33063,33067,33075,33087,33091,33095,33099,33107,33111,33115,33119,33123,33127,33131,33135,33139,33143,33147,33151,33159,33163,33171,33175,33179,33183,33187,33195,33203,33199,33211,33219,33227,33223,33231,33247,33051,33283,33299,32783,33083,33303,33307,33311,33315,32987,33319,33323,33327,33331,33335,33339,33343,33347,33351,33355,33359,33363,33367,33371,33375,33383,33407,33411,33415,33419,33423,33427,33431,33443,33463,33467,33471,33475,33479,33483,33487,33491,33495,33499,33507,33511,33519,33527,33523,33531,33535,33539,33543,33547,33551,33555,33559,33567,33571,33575,33579,33583,33587,33591,33595,33599,33603,33607,33611,33615,33619,33623,33627,33631,33635,33563,33447,33651,33659,33667,33695,33699,33703,33715,33723,33727,33731,33735,33739,33743,33747,33751,33755,33767,33775,33779,33783,33791,33795,33799,33803,33807,33811,33815,33819,33823,33827,33831,33835,33843,33847,33851,33855,33859,33863,33867,33763,33895,33903,33907,33915,33919,33923,33931,33935,33939,33943,33927,33947,33951,33955,33963,33967,33971,33975,33979,33983,33987,33991,33995,33999,34003,34007,34011,34015,33759,34019,34023,34027,34031,34079,34083,34087,34095,34099,34103,34111,34115,34119,34127,34131,34135,34139,34143,34147,34151,34155,34159,34123,34163,34167,34171,34175,34179,34183,34187,34191,34195,34199,34203,34207,34211,34215,34219,34223,34227,34231,34235,34251,34259,34263,34275,34279,34283,34291,34299,34303,34307,34311,34315,34319,34323,34327,34331,34339,34343,34347,34351,34355,34359,34363,34367,34371,34375,34379,34383,34387,34391,34395,34399,34407,34411,34415,34419,34423,34427,34431,34435,34439,34443,34447,34451,34455,34459,34295,34499,34507,34511,34515,34527,34531,34535,34539,34543,34547,34551,34555,34559,34563,34567,34575,34583,34587,34591,34595,34599,34603,34607,34611,34615,34619,34287,34635,34643,34647,34651,34655,34659,34663,34667,34671,34675,34679,34683,34695,34703,34707,34711,34715,34719,34723,34727,34731,34735,34739,34743,34747,34751,34755,34759,34763,34767,34771,34775,34779,34783,34787,34791,34803,34475,34579,34819,34823,34827,34831,34835,34839,34843,34847,34851,34855,34859,34863,34867,34871,34875,34879,34883,34911,34915,34919,34923,34927,34931,34935,34939,34903,34947,34951,34955,34959,34963,34967,34971,34975,34979,34983,34987,34991,34995,34999,35003,35007,35011,35015,35019,35023,35027,35031,35035,35039,35043,35047,35051,35055,35059,35063,35067,35071,35075,35079,35083,35087,35091,35095,35099,35103,35107,35111,35115,35123,35127,35131,35119,35151,35163,35175,35203,35207,35211,35215,35219,35223,35227,35231,35235,35239,35255,35259,35263,35267,35271,35275,35283,35291,35295,35299,35303,35307,35311,35315,35323,35331,35335,35339,35343,35347,35351,35355,35359,35363,35367,35387,35403,35407,35411,35415,35419,35423,35427,35431,35435,35439,35443,35447,35451,35459,35463,35467,35471,35475,35479,35483,35487,35495,35499,35503,35507,35511,35515,35523,35527,35535,35539,35543,35547,35555,35559,35563,35567,35571,35575,35579,35583,35587,35591,35595,35599,35603,35607,35611,35619,35643,35647,35651,35655,35659,35663,35171,35147,34907,34799,32159,35667,35671,35675,35679,35683,35687,35691,28251,2242,33267,30939,30631,35699,35703,35707,35711,35715,35731,35735,35739,35743,35747,35751,30611,35755,35759,35763,29947,28863,35767,35771,35775,35779,35783,35787,35791,35795,35799,35803,35815,35819,35823,35827,35831,35835,35839,35851,35855,35863,35867,35875,35879,35883,35887,35919,35923,35927,35931,35939,35943,35951,35955,35959,35963,35967,35971,35975,35979,35983,33839,32335,15067,14675,14431,14339,35907,35987,35991,35995,35999,36003,36007,36011,36015,36019,36023,36027,36031,36035,36039,36043,36047,36051,36055,36059,36063,36067,36071,36079,36083,36087,36091,36095,36099,36103,36127,36139,13703,13103,36143,12811,36147,12427,36151,36155,36159,36163,36167,36171,36175,36179,36183,36187,36191,36195,36199,36203,36207,36211,36215,36219,36223,11179,36227,36231,36235,36243,36247,36255,36259,36263,36267,36251,36275,36279,36283,36287,36271,23315,23175,4173,745,3577,19851,36295,11015,12335,11167,10595,5757,1414,23323,88,23335,321,5141,3001,7935,36323,36327,36331,36335,36339,36343,36347,36351,27819,7091,36367,36371,36375,36383,36387,15779,7915,27431,36403,36407,36411,36415,36419,36427,16783,36431,17071,36439,17075,36443,36447,36455,36459,36463,36467,36471,36475,36479,36487,17287,17711,19811,20107,19855,36491,36495,36499,36503,36507,36511,36515,33155,36519,36531,36539,36543,36547,36551,36555,36559,36563,36567,36571,36575,36579,36583,36587,36591,36595,36599,36603,36607,36611,36615,36619,36623,36627,36631,36635,36639,23523,21767,36643,36647,36651,36655,36659,36663,36667,21591,21523,36671,36675,21275,36691,36699,36703,36707,36711,36715,36719,36723,36731,36735,36739,36743,36747,36751,36755,36759,36763,36767,36771,36775,36779,36783,36787,36791,36795,36799,36803,36807,36811,36815,36819,36823,36827,36831,36839,36843,36847,36851,36859,36863,36867,36871,36875,36879,36883,36887,36891,36895,23303,36915,36835,36923,36931,36935,36939,36943,36947,36951,36955,36959,36963,36967,36971,36975,36979,36983,36987,36991,36995,36999,37003,36899,37007,37011,36687,37023,37027,37031,21971,37039,37043,37047,37051,37055,37059,24818,37063,37067,24238,37071,37075,25938,23187,25130,37083,37087,37091,37095,26843,23767,27427,37099,37103,37123,37127,37131,37135,37139,37143,37151,37155,37163,37167,37171,37175,37179,37183,37187,37199,37207,37211,37215,37219,37223,37227,37231,37235,37239,37243,37247,37251,37263,27423,37019,21587,26078,27283,26150,27115,27419,37267,27263,26839,26170,37299,37303,37307,37311,37319,37323,37327,37191,37335,37339,37343,37347,37351,37355,18111,3805,37375,37379,37383,37387,37391,37395,37399,3145,3593,3005,2506,37403,37439,37443,37447,37451,37455,37459,37463,37467,37471,37475,37479,37483,37487,37491,37495,37499,37503,37507,37515,37519,37523,37527,37531,37535,37539,21979,22067,1366,1322,37371,733,37543,713,681,353,29,37555,37559,37563,37567,37571,37575,37579,37583,37587,37591,37595,37599,37603,37607,37611,37615,37619,37623,37627,35947,17487,19863,36319,21291,37511,17651,22271,33255,36379,33719,33911,37667,37675,22395,37679,37687,37695,37699,37719,22575,37723,22743,37727,106,37735,37739,37743,37747,37751,37755,37759,37763,22747,37851,37907,37911,37915,37919,37927,37931,37935,24814,23319,23311,23307,37943,37947,37951,37955,37959,37963,37967,37971,37975,37979,37983,37987,22751,22883,22887,37991,37995,37999,38003,38007,38011,38015,38019,38023,38027,38031,38035,38039,38055,38059,38063,38067,38071,38079,38083,38087,38091,38095,38099,38103,38107,38111,38123,38127,38131,38135,38139,23183,38143,38151,38155,38159,38163,38167,38171,38175,38179,38183,38187,38191,38195,38199,38203,38207,38211,38215,38219,38223,38227,38239,38263,38307,38311,38315,38319,38323,38331,38343,38347,37815,37831,37835,37883,38351,38355,38359,38299,38363,38291,38367,38295,38371,27775,38379,38387,38391,38395,38399,38403,38407,38411,38419,38423,38427,38431,38435,38439,38443,38447,38451,38459,38463,38467,38471,38475,38479,38483,38487,38491,38495,38499,38503,38527,38539,38543,38547,38551,38555,38559,38563,38535,38567,38571,38575,38579,38583,38587,38591,38595,38599,38603,38607,38611,38627,38631,38635,38639,38651,38663,38667,38671,38675,38679,38683,38687,38691,38695,38699,38703,38707,38711,38715,38719,38723,38727,38731,38735,38739,38743,38747,38751,38759,38763,38767,38771,38779,39103,39111,39151,39155,39159,39163,39115,39171,39179,39183,39191,39127,39147,39139,39087,39083,39095,39135,39099,39231,39235,39107,39143,39239,39243,39247,39251,39255,39259,39263,39267,39271,39275,39279,39283,39119,39123,39295,39299,39303,39307,39315,39335,39351,39403,39411,39415,39419,39423,39427,39435,39439,39443,39447,39451,39455,39459,39467,39471,39479,39483,39487,39491,39495,39499,39503,39507,39511,39515,39519,39523,39527,39531,39535,39539,39543,39547,39091,39551,39215,39211,39555,39311,39203,39291,39559,39563)
AND folder_type_id in (1,2,11,15,19,23)
) as distinct_clips
ON arizona_fill_clip.unified_clip_id = distinct_clips.unified_clip_id
AND arizona_fill_clip.data_source = distinct_clips.data_source
WHERE day > '2013-08-01' AND arizona_fill_clip.data_source = 'phx'
AND day <= '2013-09-01'
ORDER BY campaign_id, clipKey, day
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment