sql

sql


SELECT 'u_15',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-15 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-16 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-17 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_23',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-18 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-19 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-20 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_15',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-21 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-22 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-23 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_23',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-24 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-25 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-26 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_23',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-27 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_24',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-28 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'umpr_23',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-15 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-12'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-16 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-13'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-17 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-14'

UNION ALL

SELECT 'umpr_23',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-18 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-15'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-19 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-16'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-20 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-17'

UNION ALL

SELECT 'umpr_23',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-21 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-18'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-22 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-19'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-23 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-20'

UNION ALL

SELECT 'umpr_23',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-24 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-21'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-25 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-22'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-26 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-23'

UNION ALL

SELECT 'umpr_23',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-27 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-24'

UNION ALL

SELECT 'umpr_24',sum(revenue_per_impression) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-11-28 00:00:00' AND sources.application_id = 1 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 1 AND DATE < '2017-12-25'


Report content on this page

Report Page

Please submit your DMCA takedown request to dmca@telegram.org