Current Issue
Vol 2 No 1 (2025): Jurnal Prinsip
Published:
2025-10-27
Articles
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9309 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9309'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9311 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9311'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9313 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9313'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9315 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9315'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9317 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9317'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9319 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9319'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9321 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9321'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9323 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9323'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9325 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9325'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9327 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9327'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9329 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9329'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9331 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9331'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9333 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9333'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9335 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9335'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9337 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9337'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9339 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9339'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9341 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9341'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9343 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9343'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9345 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9345'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9347 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9347'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9349 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9349'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9351 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9351'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9353 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9353'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9355 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9355'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9357 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9357'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9359 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9359'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9372 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9372'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9374 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9374'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9376 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9376'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9378 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9378'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9380 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9380'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9382 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9382'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9384 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9384'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9386 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9386'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9388 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9388'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9390 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9390'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9392 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9392'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9394 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9394'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9396 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9396'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9398 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9398'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9400 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9400'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9402 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9402'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9404 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9404'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9406 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9406'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9408 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9408'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9410 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9410'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9412 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9412'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9416 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9416'
-
(mysql): SELECT DISTINCT sf.file_id AS submission_file_id, sf.revision AS submission_revision, af.file_id AS artwork_file_id, af.revision AS artwork_revision, suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision, s.locale AS submission_locale, sf.*, af.*, suf.* FROM submission_files sf LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision LEFT JOIN submissions s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision WHERE sf2.revision IS NULL AND sf.file_id = 9418 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '9418'