(mysql): SELECT * FROM sessions WHERE session_id = '67kundous71arenl0utec1ntq2'
(mysql): SELECT * FROM journals WHERE path = 'prinsip'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '9'
(mysql): SELECT * FROM site
(mysql): SET time_zone = '+7:00'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = '9' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4757' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4757' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4757
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4757'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4757
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1342'
(mysql): SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = 'pub-id::publisher-id' AND ist.setting_value = '93' ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 93
(mysql): SELECT * FROM issue_settings WHERE issue_id = '93'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.galley_id = 0
AND nsf.file_id IS NULL AND g.submission_id = 4757
(mysql): SELECT * FROM journals WHERE path = 'prinsip'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '9'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 9
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 19
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '235'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '238'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '236'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '239'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '237'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '240'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '241'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 19
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2091'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2094'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2092'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2095'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2093'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2096'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2097'
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 20
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '303'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '309'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '304'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '305'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '306'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '308'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '307'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '242'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '243'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '247'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '244'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '310'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 20
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2433'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2434'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2435'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2436'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2437'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2438'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2439'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2440'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2441'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2442'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2443'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2444'
(mysql): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND context_id = 9
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND context_id = 9
(mysql):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 9 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '97'
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 9 AND supplementary = 1
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '98'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '99'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '100'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '101'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '102'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '103'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '104'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '105'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '108'
(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 * FROM sections WHERE section_id = 11
(mysql): SELECT * FROM section_settings WHERE section_id = '11'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4757)
1062: Duplicate entry 'submissionKeyword-1048585-4757' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4757)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4757) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4757
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19816 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '14561'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4757' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.submission_id
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4757' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4757
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4757'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4757
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1342'
(mysql):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 9
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:49' >= s.date_start AND '2026-01-29 02:09:49' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4757)
1062: Duplicate entry 'submissionKeyword-1048585-4757' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4757)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4757) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4757
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19816 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '14561'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4757)
1062: Duplicate entry 'submissionKeyword-1048585-4757' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4757)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4757) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4757
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 19816 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '14561'
(mysql): SELECT * FROM sections WHERE section_id = 11
(mysql): SELECT * FROM section_settings WHERE section_id = '11'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = '9' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT i.* FROM issues i WHERE journal_id = 9 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '93'
STRATEGI BADAN PENDAPATAN DAERAH (BAPENDA) DALAM REALISASI PEMUNGUTAN PAJAK REKLAME BERDASARKAN PERATURAN WALI KOTA NOMOR 28 TAHUN 2022 DI KOTA BANDUNG
STRATEGI BADAN PENDAPATAN DAERAH (BAPENDA) DALAM REALISASI PEMUNGUTAN PAJAK REKLAME BERDASARKAN PERATURAN WALI KOTA NOMOR 28 TAHUN 2022 DI KOTA BANDUNG
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
Keywords:
advertisement tax, local revenue, tax management strategy, Bapenda Bandung.
Abstract
This study aims to analyze the strategies implemented by the Regional Revenue Agency (Bapenda) of Bandung City in realizing the collection of advertisement tax based on the Mayor’s Regulation Number 28 of 2022. Using a qualitative descriptive approach, the research explores the effectiveness of the planning, implementation, and evaluation mechanisms in local tax management. The data were obtained through in-depth interviews, observations, and documentation with key informants consisting of Bapenda officials, private billboard operators, and the local community. The results indicate that Bapenda has implemented two main strategies: intensification and extensification of advertisement tax collection. However, the implementation still faces challenges related to coordination among agencies, inadequate taxpayer databases, and low public awareness of tax compliance. The study concludes that an integrated digital tax management system and consistent public socialization are necessary to optimize advertisement tax revenue and increase the city’s local own-source revenue (PAD).
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 9 AND setting_name = 'displayStatistics'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 9
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
References
Agustino, L. (2012). Dasar-Dasar Kebijakan Publik. Bandung: Alfabeta.
Bachrul Elmi. (2012). Manajemen Pemerintahan. Jakarta: Bumi Aksara.
Creswell, J. W. (2018). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches (5th ed.). Thousand Oaks, CA: Sage Publications.
Dinas Pendapatan Daerah Kota Bandung. (2024). Laporan Realisasi Penerimaan Pajak Reklame Tahun 2023. Bandung: Pemerintah Kota Bandung.
Dunn, W. N. (2018). Public Policy Analysis: An Integrated Approach (6th ed.). New York: Routledge.
Lincoln, Y. S., & Guba, E. G. (1985). Naturalistic Inquiry. Beverly Hills, CA: Sage Publications.
Miles, M. B., Huberman, A. M., & Saldaña, J. (2014). Qualitative Data Analysis: A Methods Sourcebook (3rd ed.). Thousand Oaks, CA: Sage Publications.
Moleong, L. J. (2017). Metodologi Penelitian Kualitatif (Edisi Revisi). Bandung: Remaja Rosdakarya.
Mulgan, R. (2015). Making Public Policy: Institutions, Values, and Instruments. London: Routledge.
Nugroho, R. (2017). Public Policy: Dinamika Kebijakan, Analisis Kebijakan, Manajemen Kebijakan, dan Etika Kebijakan. Jakarta: Elex Media Komputindo.
Sugiyono. (2019). Metode Penelitian Kualitatif, Kuantitatif, dan R&D. Bandung: Alfabeta.
Terry, G. R. (1972). Principles of Management. Homewood, IL: Richard D. Irwin, Inc.
Todaro, M. P., & Smith, S. C. (2012). Economic Development (11th ed.). Boston: Pearson Education.
Undang-Undang Republik Indonesia Nomor 1 Tahun 2024 tentang Pajak Daerah dan Retribusi Daerah. Lembaran Negara Republik Indonesia Tahun 2024 Nomor 9.
Undang-Undang Republik Indonesia Nomor 23 Tahun 2014 tentang Pemerintahan Daerah. Lembaran Negara Republik Indonesia Tahun 2014 Nomor 244.
United Nations Development Programme (UNDP). (1997). Governance for Sustainable Human Development: A UNDP Policy Document. New York: UNDP.
Winarno, B. (2014). Kebijakan Publik: Teori, Proses, dan Studi Kasus. Yogyakarta: CAPS (Center for Academic Publishing Service).
Yin, R. K. (2018). Case Study Research and Applications: Design and Methods (6th ed.). Thousand Oaks, CA: Sage Publications.
Samosir, G., Permana, D., & Kristian, I. (2025). STRATEGI BADAN PENDAPATAN DAERAH (BAPENDA) DALAM REALISASI PEMUNGUTAN PAJAK REKLAME BERDASARKAN PERATURAN WALI KOTA NOMOR 28 TAHUN 2022 DI KOTA BANDUNG, 2(1), 537-551. https://doi.org/https://doi.org/10.36859/prinsip.v2i1.4757
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4757 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '7112'
(mysql): SELECT * FROM author_settings WHERE author_id = '7199'
(mysql): SELECT * FROM author_settings WHERE author_id = '7200'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Ganda'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Samosir'
AND (asl.setting_value = 'Universitas Jenderal Achmad Yani')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4757
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4757'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4757
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1342'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Danny'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Permana'
AND (asl.setting_value = 'Universitas Jenderal Achmad Yani')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 957
(mysql): SELECT * FROM submission_settings WHERE submission_id = '957'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 957
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '313'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 1203
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1203'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 1203
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '372'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2918
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2918'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2918
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '614'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2919
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2919'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2919
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '615'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2922
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2922'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2922
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '618'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2926
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2926'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2926
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '622'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2928
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2928'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2928
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '624'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2940
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2940'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2940
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '636'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2944
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2944'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2944
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '640'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2946
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2946'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2946
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '642'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2948
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2948'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2948
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '644'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2950
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2950'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2950
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '646'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2952
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2952'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2952
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '648'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2953
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2953'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2953
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '649'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3380
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3380'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3380
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '941'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3383
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3383'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3383
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '944'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3384
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3384'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3384
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '945'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3385
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3385'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3385
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '946'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3387
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3387'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3387
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '948'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3389
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3389'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3389
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '950'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3391
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3391'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3391
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '952'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3398
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3398'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3398
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '959'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3400
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3400'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3400
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '961'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3401
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3401'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3401
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '962'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3402
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3402'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3402
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '963'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3403
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3403'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3403
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '964'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3409
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3409'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3409
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '970'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3411
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3411'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3411
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '972'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3413
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3413'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3413
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '974'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3415
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3415'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3415
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '976'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3428
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3428'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3428
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '983'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4729
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4729'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4729
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1314'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4737
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4737'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4737
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1322'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4740
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4740'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4740
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1325'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4749
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4749'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4749
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1334'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4750
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4750'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4750
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1335'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4756
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4756'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4756
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1341'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4757
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4757'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4757
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1342'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4758
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4758'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4758
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1343'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4759
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4759'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4759
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1344'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4761
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4761'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4761
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1346'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4762
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4762'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4762
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1347'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4763
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4763'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4763
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1348'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Indra'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Kristian'
AND (asl.setting_value = 'Universitas Jenderal Achmad Yani')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2837
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2837'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2837
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '519'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2940
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2940'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2940
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '636'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3381
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3381'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3381
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '942'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 3386
(mysql): SELECT * FROM submission_settings WHERE submission_id = '3386'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 3386
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '947'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2072
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2072'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2072
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '510'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4673
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4673'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4673
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1649'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4730
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4730'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4730
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1315'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4731
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4731'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4731
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1316'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4736
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4736'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4736
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1321'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4746
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4746'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4746
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1331'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4757
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4757'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4757
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1342'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4763
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4763'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4763
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1348'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 957
(mysql): SELECT * FROM submission_settings WHERE submission_id = '957'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 957
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '313'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 957
(mysql): SELECT * FROM submission_settings WHERE submission_id = '957'
(mysql): SELECT * FROM sections WHERE section_id = 1
(mysql): SELECT * FROM section_settings WHERE section_id = '1'
(mysql): SELECT * FROM journals WHERE journal_id = 1
(mysql): SELECT * FROM journal_settings WHERE journal_id = '1'
(mysql): SELECT i.* FROM issues i WHERE issue_id = 39
(mysql): SELECT * FROM issue_settings WHERE issue_id = '39'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 1203
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1203'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 1203
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '372'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 1203
(mysql): SELECT * FROM submission_settings WHERE submission_id = '1203'
(mysql): SELECT * FROM sections WHERE section_id = 2
(mysql): SELECT * FROM section_settings WHERE section_id = '2'
(mysql): SELECT * FROM journals WHERE journal_id = 2
(mysql): SELECT * FROM journal_settings WHERE journal_id = '2'
(mysql): SELECT i.* FROM issues i WHERE issue_id = 48
(mysql): SELECT * FROM issue_settings WHERE issue_id = '48'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2072
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2072'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2072
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '510'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2072
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2072'
(mysql): SELECT * FROM sections WHERE section_id = 9
(mysql): SELECT * FROM section_settings WHERE section_id = '9'
(mysql): SELECT * FROM journals WHERE journal_id = 7
(mysql): SELECT * FROM journal_settings WHERE journal_id = '7'
(mysql): SELECT i.* FROM issues i WHERE issue_id = 65
(mysql): SELECT * FROM issue_settings WHERE issue_id = '65'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2837
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2837'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2837
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '519'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2837
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2837'
(mysql): SELECT i.* FROM issues i WHERE issue_id = 67
(mysql): SELECT * FROM issue_settings WHERE issue_id = '67'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2918
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2918'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2918
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '614'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2918
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2918'
(mysql): SELECT * FROM sections WHERE section_id = 11
(mysql): SELECT * FROM section_settings WHERE section_id = '11'
(mysql): SELECT * FROM journals WHERE journal_id = 9
(mysql): SELECT * FROM journal_settings WHERE journal_id = '9'
(mysql): SELECT i.* FROM issues i WHERE issue_id = 71
(mysql): SELECT * FROM issue_settings WHERE issue_id = '71'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2919
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2919'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2919
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '615'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2919
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2919'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2922
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2922'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2922
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '618'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2922
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2922'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2926
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2926'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2926
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '622'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2926
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2926'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2928
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2928'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2928
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '624'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2928
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2928'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2940
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2940'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 2940
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '636'
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.locale = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 2940
(mysql): SELECT * FROM submission_settings WHERE submission_id = '2940'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 2918 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '4124'
(mysql): SELECT * FROM author_settings WHERE author_id = '4125'
(mysql): SELECT * FROM author_settings WHERE author_id = '4126'
Simon Freddy Pasaribu,
Danny Permana,
Yovinus Yovinus,
ANALISIS PELAYANAN PUBLIK DI KECAMATAN BUNAKEN KOTA MANADO DALAM MEMBERIKAN PELAYANAN PRIMA
,
: Vol 1 No 1 (2024): Jurnal Prinsip
