Created
June 18, 2019 14:32
-
-
Save marker1k/e3311f3f54d8215203be461ec8f8214c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select count() | |
from dist_elog | |
where date>='2019-06-13' | |
and date<='2019-06-17' | |
and place_id=858410 | |
and load=1 | |
and ignore='' | |
and ya_device_type in (1, 3, 5) | |
and oc1 in ([311198], [325469]) | |
and (referrer like '%music.yandex.ru/home' or referrer like '%music.yandex.ru/new-releases' or referrer like '%music.yandex.ru/chart' or referrer like '%music.yandex.ru/genres' or referrer like '%music.yandex.ru/genre/' or referrer like '%music.yandex.ru/new-playlists' or referrer like '%music.yandex.ru/radio' or referrer like '%music.yandex.ru/home?%' or referrer like '%music.yandex.ru/new-releases?%' or referrer like '%music.yandex.ru/chart?%' or referrer like '%music.yandex.ru/genres?%' or referrer like '%music.yandex.ru/genre/?%' or referrer like '%music.yandex.ru/new-playlists?%' or referrer like '%music.yandex.ru/radio?%') | |
order by count() desc | |
┌─count()─┐ | |
│ 1714298 │ | |
└─────────┘ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment