gistfile1.sql

SELECT DISTINCT tc.campaign_id, pc.iso_code AS currency
FROM summary_v2.campaign_placement_details_cost_daily_v2 AS daily
  INNER JOIN ref_data.tracking_campaign AS tc ON (daily.campaign_id            = tc.external_id::BIGINT)
  INNER JOIN ref_data.provider          AS pr ON (pr.id                        = tc.tracking_data_provider_id AND pr.tpasns_id    = daily.third_party_adserver_id)
  LEFT  JOIN mdata.placement_currency   AS pc ON (pc.tracking_data_provider_id = tc.tracking_data_provider_id AND pc.placement_id = daily.inventory_placement_id)

WHERE summary_v2.empty_to_null(tc.external_id) IS NOT NULL
      AND (tc.external_id ~ E'^\\d+$')
      AND  pr.tpasns_id IS NOT NULL
      AND  tc.campaign_id IN                     (23005,23081,22160,22165,22375,22164,23493,22374,22159,22161,22442,22162,22163,25982,26163,26241,28802,27050,26667,27579,28862,26457,28223,26488,26247,26775,30957,33323,28706,27582,34218,41921,41677,33801,34219,40233,39640,33325,43113,41913,40230,40241,42443,47381,52873,47386,47218,48005,48292,46207,50406,46202,46377,7919,7986,8435,8014,7987,8693,8677,7920,8364,8180,8143,8230,7923,7988,8015,8381,7925,8448,8466,8269,8071,7926,7927,7938,8727,8721,9096,8960,9489,9624,8744,8743,8722,9350,9308,8711,9311,8745,8746,8754,8803,9440,8871,7928,7914,7915,7982,7983,7979,7980,8193,7981,11341,11339,11343,11345,11340,11338,11342,11344,23359,15037,15036,14030,11518,11645,14366,11822,11716,10954,15473,12178,15474,10953,17355,15475,15433,15431,15432,16186,15319,11869,14547,16188,16792,17353,16516,19622,19621,16936,16951,16793,16257,16514,16515,17352,18168,16513,16443,17354,17902,17903,16444,16753,16745,24313,21007,21008,22005,21009,23127,21006,27332,26902,30205,29013,27731,27331,30555,11726,11724,11728,50443,50432,50441,50440,50436,50439,50437,50435,38941,42216,35947,35953,35948,35950,38993,38752,35949,35956,43801,35951,48612,50448,48609,48061,50452,50327,50331,50426,34688,38836,41882,39176,34800,39177,49025,40180,48315,48600,49960,49180,33791,33790,8895,8893,8897,8899,8894,8892,8896,8898,33398,51817,8317,8789,8402,8401,8791,8443,7930,7918,19098,19099,19096,19097,19095,19100 )
      AND  daily.report_date >= '2015-05-27'
      AND  daily.report_date <= '2015-06-04';