918801 - Run SQL to get country stats for Flicks Prod

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Osmose [:osmose, :mkelly]]

We'd like to run the following query on the firefoxflicks.mozilla.org production database and get the results as a CSV. The output will contain PID in case that is relevant.

SELECT u.email AS user_email, p.full_name AS user_name, p.country AS user_country, v.id AS video_id, v.title AS video_title FROM videos_video2013 AS v LEFT JOIN auth_user AS u ON v.user_id = u.id LEFT JOIN users_userprofile AS p ON p.user_id = u.id;

Thanks!

Comment 1

[Sheeri Cabral [:sheeri]]

Hi Michael,

I ran the query and the result is 314 rows. Does that sound about right to you? If so, I can make a doc with this information and share it privately with you.

Comment 2

[Sheeri Cabral [:sheeri]]

Shared via a Google Doc. Please re-open if there are any problems/questions.