Merge branch 'gh-704' into production
Merge branch 'staging' into production
Use id instead of created to order video actions

Since id is an auto-increment column, this should have the same
results but much quicker since it's indexed.

This should speed up the user profile page.
Speedup for adding cached_video_url attribute

The new code is more straightforward and also faster than the old
code.

This should speedup the user dashboard page, the team tasks page, and
the team dashboard page.
Merge branch 'dbtuning' into production
Merge branch 'staging' of github.com:pculture/unisubs into staging
Merge branch 'production' of github.com:pculture/unisubs into production
Merge branch 'staging' into production
Speedup for team video search index

Use a COUNT query, instead of calling len() for all_sls.

Only execute the query once for completed_sls.
Speedup SubtitleLanguage.having_non_empty_tip()

The INNER JOIN to a subquery wasn't being optimized very well by
mysql.  I think it was actually going through all subtitle version in
the DB.

Replaced it with a different subquery that returns the same results
and is optimized well by mysql.
Speed up video_gauge

Also re-implemented video_gauge_long.

Added tests for both
gh-754: don't make language metadata fall back to the video metadata

Also made it so that if we set metadata for a subtitle version, it
doesn't add it to the video metadata (although it still updates the
metadata types for the video).
Updating integration repo
gh755: display metadata in the correct locale
gh696: fix project filter for tasks

Replaced old code to reset the filter with one that simply searches
the DOM for the option that was originally selected and selects that.

Also improved the template a bit:
* Made the any project have the selected attribute if project=None
* Made the HTML for the options not span multiple lines
gh754: Don't default to video metadata in the new editor
Expand/Collapse both metadata sections together.

I've been meaning to fix this one for a while, and wanted to sneak it
in since I was already working with the metadata section.
gh719: fix alignment of rows in the new editor.

We were forcing the text fields to have at least 2 rows in them.  This
was another fix that I wanted to sneak in.
Merge pull request #761 from pculture/gh-754

Gh 754
Merge pull request #762 from pculture/gh-755

gh755: display metadata in the correct locale