Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Successful HLS track transcodes
by
Brooke Vibber (WMF)
This query is marked as a draft
This query has been published
by
Brooke Vibber (WMF)
.
Note false positives from old jobs that failed in funky ways, to be cleaned up. Until I finish refactoring the query in Special:Transcode_statistics which currently fails most of the time on Commons
Toggle Highlighting
SQL
select transcode_key, transcode_image_name, transcode_time_addjob, transcode_time_startwork from transcode where (transcode_time_addjob IS NOT NULL AND transcode_time_startwork IS NOT NULL AND transcode_time_success IS NULL AND transcode_time_error IS NULL) order by transcode_time_startwork desc, transcode_time_addjob desc, transcode_image_name desc,transcode_key desc
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...