Advertisement
neo01124

SuperbowlViews

Feb 3rd, 2015
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.61 KB | None | 0 0
  1. SELECT  latitude, longitude,geoip_city, country_code, guid, event_timestamp, abstrack INTO __tmp_apis_superbowl2 FROM views WHERE event_day BETWEEN '2015-02-01' AND '2015-02-02' AND abstrack IN (12510697,13400684,441277,12397836,12518542,8103264,8103292,8103221,1325987,1326192,1326059,8803587,39998438) ;
  2.  
  3. SELECT  latitude, longitude,geoip_city, country_code, guid, event_timestamp, abstrack INTO __tmp_apis_superbowl FROM views WHERE event_day BETWEEN '2015-02-01' AND '2015-02-02' AND guid <> '-' AND abstrack IN (12510697,13400684,441277,12397836,12518542,8103264,8103292,8103221,1325987,1326192,1326059,8803587,39998438) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement