Created
November 13, 2013 19:59
-
-
Save cabateman/7455373 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
| cbates=> SELECT * FROM leviathan.ad_click WHERE date(time_created)>='2013-10-20' and ad_network_id = 61 and REGEXP_LIKE(custom_click_params, '2509fc855b4a671d') LIMIT 5; | |
| time_created | uuid | major_server_tag | minor_server_tag | client_build | client_data_version | server | remote_ip | campaign_id | iphone_udid | entry_source | forward_url | referrer | tracking_url_id | mapi_click_id | utm_source | utm_medium | utm_term | utm_content | utm_campaign | mapi_url_id | user_browser | user_browser_sha1 | ad_network_id | game_id | country_code | idfa | mac_address | android_id | source_id | custom_click_params | idfa_sha1 | idfa_md5 | idfa_raw | mac_address_sha1 | mac_address_md5 | mac_address_raw | android_id_sha1 | android_id_md5 | android_id_raw | unknown_id | reported_ip | request_uri | country | device_os | creative | campaign | odin1 | network_click_id | os_device_id | |
| ---------------------+--------------------------------------------------+------------------+------------------+--------------+---------------------+------------------------+---------------+-------------+-------------+--------------+-------------+-----------------------------------------------------+-----------------+-----------------------+------------+------------+----------+-------------+--------------+-------------+--------------+------------------------------------------+---------------+---------+--------------+------+-------------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+------------------+-----------------+-----------------+-----------------+----------------+----------------+------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-----------+----------+----------+-------+------------------+-------------- | |
| 2013-10-27 22:33:15 | analytics-mapiapp-prod-003-1382913195-zh2kz17c29 | not_set | not_set | | not_set | analytics-mapiapp-prod | 162.13.101.77 | | | | | mapi_click_id=1382913195-ykcnz0mk6q&mapi_url_id=206 | 206 | 1382913195-ykcnz0mk6q | | | | | | 206 | NING/1.0 | d0bd00cd43608fd4dc36f88d472673c88af171d4 | 61 | 39 | | | | | | {"click_url":"ad-x.co.uk\/API\/click\/GREE3heobd2fcn3shue0d3ntdp\/web205261c75904cc6\/NET\/1021a339e8d1f3e4befd826eb1f335\/moboqo?android_id=2509fc855b4a671d&ip=184.17.193.82","app_name":"jp.gree.modernwar","network":"Moboqo"} | | | | | | | | | | | 75.101.189.0 | /leviathan/tracking/click/event/3phagund3je5?android_id=2509fc855b4a671d&is_internal_service_call=true&custom_click_parameters=%7B%22click_url%22%3A%22ad-x.co.uk%5C%2FAPI%5C%2Fclick%5C%2FGREE3heobd2fcn3shue0d3ntdp%5C%2Fweb205261c75904cc6%5C%2FNET%5C%2F1021a339e8d1f3e4befd826eb1f335%5C%2Fmoboqo%3Fandroid_id%3D2509fc855b4a671d%26ip%3D184.17.193.82%22%2C%22app_name%22%3A%22jp.gree.modernwar%22%2C%22network%22%3A%22Moboqo%22%7D&no_redirect=true&ip=75.101.189.0 | | | | | | | | |
| 2013-10-28 00:09:09 | analytics-mapiapp-prod-004-1382918949-ycpo1ib7h6 | not_set | not_set | | not_set | analytics-mapiapp-prod | 162.13.101.77 | | | | | mapi_click_id=1382918949-husi3in1jw&mapi_url_id=206 | 206 | 1382918949-husi3in1jw | | | | | | 206 | NING/1.0 | d0bd00cd43608fd4dc36f88d472673c88af171d4 | 61 | 39 | | | | | | {"click_url":"ad-x.co.uk\/API\/click\/GREE3heobd2fcn3shue0d3ntdp\/web205261c75904cc6\/NET\/1021a339e8d1f3e4befd826eb1f335\/moboqo?android_id=2509fc855b4a671d&ip=184.17.193.82","app_name":"jp.gree.modernwar","network":"Moboqo"} | | | | | | | | | | | 23.22.231.0 | /leviathan/tracking/click/event/3phagund3je5?android_id=2509fc855b4a671d&is_internal_service_call=true&custom_click_parameters=%7B%22click_url%22%3A%22ad-x.co.uk%5C%2FAPI%5C%2Fclick%5C%2FGREE3heobd2fcn3shue0d3ntdp%5C%2Fweb205261c75904cc6%5C%2FNET%5C%2F1021a339e8d1f3e4befd826eb1f335%5C%2Fmoboqo%3Fandroid_id%3D2509fc855b4a671d%26ip%3D184.17.193.82%22%2C%22app_name%22%3A%22jp.gree.modernwar%22%2C%22network%22%3A%22Moboqo%22%7D&no_redirect=true&ip=23.22.231.0 | | | | | | | | |
| 2013-10-28 00:18:04 | analytics-mapiapp-prod-001-1382919484-zb8o52sweh | not_set | not_set | | not_set | analytics-mapiapp-prod | 162.13.101.77 | | | | | mapi_click_id=1382919484-dewjubx3cz&mapi_url_id=206 | 206 | 1382919484-dewjubx3cz | | | | | | 206 | NING/1.0 | d0bd00cd43608fd4dc36f88d472673c88af171d4 | 61 | 39 | | | | | | {"click_url":"ad-x.co.uk\/API\/click\/GREE3heobd2fcn3shue0d3ntdp\/web851ba14a51c282\/NET\/102966a98aa7406649e7442c773aef\/moboqo?android_id=2509fc855b4a671d","app_name":"com.iugome.lilknights","network":"Moboqo"} | | | | | | | | | | | 184.17.193.0 | /leviathan/tracking/click/event/3phagund3je5?android_id=2509fc855b4a671d&is_internal_service_call=true&custom_click_parameters=%7B%22click_url%22%3A%22ad-x.co.uk%5C%2FAPI%5C%2Fclick%5C%2FGREE3heobd2fcn3shue0d3ntdp%5C%2Fweb851ba14a51c282%5C%2FNET%5C%2F102966a98aa7406649e7442c773aef%5C%2Fmoboqo%3Fandroid_id%3D2509fc855b4a671d%22%2C%22app_name%22%3A%22com.iugome.lilknights%22%2C%22network%22%3A%22Moboqo%22%7D&no_redirect=true&ip=184.17.193.0 | | | | | | | | |
| (3 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment