DIPLOMASI EKONOMI TIONGKOK KE ARAB SAUDI DALAM SEKTOR ENERGI TAHUN 2019-2023


(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 = 2456 ORDER BY seq  

(mysql): SELECT * FROM author_settings WHERE author_id = '3526'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4328'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4329'  

    (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 = 2456 ORDER BY seq  

    (mysql): SELECT * FROM author_settings WHERE author_id = '3526'  

    (mysql): SELECT * FROM author_settings WHERE author_id = '4328'  

    (mysql): SELECT * FROM author_settings WHERE author_id = '4329'  
  • Kemala Aulia Rahmah Universitas Jenderal Achmad Yani
  • Suwarti Sari Universitas Jenderal Achmad Yani
  • Jusmalia Oktaviani Universitas Jenderal Achmad Yani
Keywords: Arab Saudi, Tiongkok, Diplomasi, Energi, Minyak Bumi.

Abstract

Sebagai negara industry, kebutuhan energi minyak diperlukan untuk melancarkan roda perekonomian. Arab Saudi sebagai target pasar impor minyak bumi bagi Tiongkok. Pada tahun 1999 kedua negara memutuskan melakukan kerja sama di sektor energi minyak untuk mempermudah produksi, distribusi, dan konsumsi minyak. Pandemi Covid-19 yang berdampak pada sektor vital sehingga Tiongkok melakukan diplomasi ekonomi ke Arab Saudi demi menjaga pasokan cadangan energi.Tujuan penelitian untuk menganalisis strategi diplomasi ekonomi Tiongkok ke Arab Saudi di sektor energi  tahun 2019-2023. Penelitian menggunakan pendekatan liberalism dengan teori diplomasi, diplomasi ekonomi, konsep kepentingan nasional, dan konsep keamanan energi. Jenis penelitian ini deskriptif kualitatif yang menggunakan data sekunder diambil dari studi kepustakaan melalui jurnal, buku, artikel, berita, dan lainnya. Hasil penelitian menunjukkan Tiongkok menggunakan strategi diplomasi ekonomi di sektor energi melalui forum diskusi sebagai pertemuan kenegaraan melalui China Arab State Cooperation Forum, kerja sama dan investasi di industri perminyakan, kemitraan strategis komperhensif, dan Belt and Road Initiative.


(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 8 AND setting_name = 'displayStatistics'  

(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 8  

(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 = 2456 ORDER BY seq  

(mysql): SELECT * FROM author_settings WHERE author_id = '3526'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4328'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4329'  

References

B. Leach, JOffshore: The Petroleum Industry in The People’s Republic of China 19691978.
China
Economy.
13(1–2
).
1979.
105–151.
https://doi.org/https://doi.org/10.2753/CES1097-1475130102105
Bradsher, K. China’s Economic Stake in the Middle East: Its Thirst for Oil. New York
Times. 2023. https://www.nytimes.com/2023/10/11/business/china-oilsaudi-arabia-iran.html.
C. Black, B. How World War 1 ushered in the century of oil. 2017. The Conversation.
https://theconversation.com/how-world-war-i-ushered-in-the-century-of-oil74585#:~:text=At%20the%20start%20of%20World,predicated%20on%20access
%20to%20oil.
China Briefing. Saudi Arabia – China Ties: Several Investment Agreements, MoUs
Signed During President Xi’s Visit. 2022. https://www.chinabriefing.com/news/saudi-arabia-china-relations-xi-jinping-visit/.
Chinese Government Website. Energy security and safety are related to national
economy
and
people’s
livelihood.
2021.
https://www.gov.cn/xinwen/jdzc/202307/content_6894557.htm
Choon Ho, P., & Alan Cohen, J. The Politics of China’s Oil Weapon. Foreign Policy. 20.
1975. 28–49.
Consulate General of The People Republic of China in Jeddah. Relation Between
China
and
Saudi Arabia.
2004.
http://jeddah.china-
consulate.gov.cn/eng/zsgx/200411/t20041126_5294559.htm
Dahan, M. el, & Yaakoubi, dan A. el. China’s Xi calls for oil trade in yuan at Gulf
summit in Riyadh. 2022. Reuters. https://www.reuters.com/world/saudiarabia-gathers-chinas-xi-with-arab-leaders-new-era-ties-2022-12-09/
Economic and Commercial Counselor’s Office of the Chinese Embassy in Saudi Arabia.
China-Saudi Arabia trade volume exceeded US$40 billion in 2008. 2009.
http://sa.mofcom.gov.cn/article/jmxw/200902/20090206045787.shtml
Economic and Commercial Office of the Embassy of the People’s Republic of China in
the Kingdom of Saudi Arabia. Economic and Commercial Office of the Embassy of
the People’s Republic of China in the Kingdom of Saudi Arabia. 2021.
http://sa.mofcom.gov.cn/article/i/202101/20210103033755.shtml
Embassy of The People Republic of China in Kingdom of Saudi Arabia. Memorandum of
Understanding On Petroleum Cooperation between the Government of the
People’s Republic of China and the Government of the Kingdom of Saudi Arabia.
2002.
http://sa.china-
embassy.gov.cn/eng/zsgx/zzwl/201005/t20100528_2040548.htm
Hayley, A . China defies sanctions to make Russia its biggest oil supplier in 2023.
2024. Reuters. https://www.reuters.com/business/energy/china-defiessanctions-make-russia-its-biggest-oil-supplier-2023-2024-01-20/
Kant, I. To Perpetual Peace: A Philosophical Sketch. Ter. Ted Humphrey . London:
Hackett Publishing Company, Inc.2003.
Khatib, H.
(n.d.
). CHAPTER 4 : Energy Security. UNDP. 2000.Retrieved August 4,
2024,
from
https://www.undp.org/sites/g/files/zskgke326/files/publications/chapter4.pd
f
Kuangyi YAO. China-Arab States Cooperation Forum in the Last Decade. Journal of
Middle Eastern and Islamic Studies
(in Asia. 8(4). 2008. 26–42.
Kumar, P. Aramco in talks with Sinopec to expand Yanbu refiner. 2023.
https://www.agbi.com/oil-and-gas/2023/09/aramco-in-talks-with-chinassinopec-to-expand-yanbu-refinery/
Medeiros, E. S.
(n.d.
). Chapter Title: China’s Foreign Policy Actions Book Title: China’s
International Behavior Book Subtitle: Activism, Opportunism, and Diversification.
https://doi.org/10.7249/mg850af.14
Ministry of Foreign Affairs, the P. R. of C. Vision and Actions on Jointly Building Silk
Road Economic Belt and 21st-Century Maritime Silk Road. 2015.
Nicolson, H. G. Diplomacy . Oxford: Oxford University Press. 1942.
Plano, J. C., & Olton, R. The International Relations Dictionary: Third Edition
(3rd
ed.
). Clio Press. 1982.
Rana, K. S. Economic Diplomacy: The Experience of Developing Countries, Chapter 11
(Nicholas Bayne and Stephen Woolcock
). London: Ashgete. 2007
Rana, K. S. 21st-Century Diplomacy: A Practitioner’s Guide. USA: Bloomsbury
Publishing. 2011
Reuters. Saudi Arabia is top oil supplier to China in 2021. 2022. Arab News.
https://www.arabnews.com/node/2008206/business-economy.
Reuters. Saudi Arabia stays top crude supplier to China in 2022, Russian barrels
surge. 2023. Reuters https://www.reuters.com/markets/commodities/saudiarabia-stays-top-crude-supplier-china-2022-russian-barrels-surge-2023-0120/.
Riedel, Bruece. Saudi Arabia’s relations with China: Functional, but not strategic.
Brookings. 2020. https://www.brookings.edu/articles/saudi-arabias-relationswith-china-functional-but-not-strategic/
Saudi Press Agency. Saudi Arabia, China issue joint communiqué on establishing
comprehensive strategic partnership between the two countries. 2016.
https://www.spa.gov.sa/1448753?lang=ar%26newsid=1448753
Sinopec Corp. Sinopec and Aramco signed a MoU in Dhahran on YASREF+ Project.
2023.
http://www.sinopecgroup.com/group/en/Sinopecnews/20231113/news_2023
1113_546030855688.shtml
W. Creswell, J. Research Design Pendekatan Metode Kualitatif Kuantitatif dan
Campuran
(4th ed.
) Jakarta: Pustaka Belajar. 2016.
Xu, C., Zou, W., Yang, Y., Duan, Y., Shen, Y., Luo, B., Ni, C., Fu, X., & Zhang, J.
Status and prospects of deep oil and gas resources exploration and development
onshore China. Journal of Natural Gas Geoscience, 3(1), 2018. 11–24.
https://doi.org/10.1016/j.jnggs.2018.03.004/
Published
2024-10-23
How to Cite
Rahmah, K. A., Sari, S., & Oktaviani, J. (2024). DIPLOMASI EKONOMI TIONGKOK KE ARAB SAUDI DALAM SEKTOR ENERGI TAHUN 2019-2023, 1(1). https://doi.org/https://doi.org/10.36859/gij.v1i1.2456

(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 = 2456 ORDER BY seq  

(mysql): SELECT * FROM author_settings WHERE author_id = '3526'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4328'  

(mysql): SELECT * FROM author_settings WHERE author_id = '4329'  

(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 = 'Kemala Aulia' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Rahmah' 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 = 2456  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2456'  

(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 = 2456 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '713'  

(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 = 'Suwarti' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Sari' 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 = 2510  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2510'  

(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 = 2510 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '689'  

(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 = 2868  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2868'  

(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 = 2868 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '536'  

(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 = 2869  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2869'  

(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 = 2869 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '537'  

(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 = 2871  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2871'  

(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 = 2871 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '539'  

(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 = 2872  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2872'  

(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 = 2872 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '540'  

(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 = 2882  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2882'  

(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 = 2882 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '542'  

(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 = 2887  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2887'  

(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 = 2887 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '547'  

(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 = 2888  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2888'  

(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 = 2888 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '548'  

(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 = 2889  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2889'  

(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 = 2889 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '549'  

(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 = 2479  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2479'  

(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 = 2479 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '683'  

(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 = 2482  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2482'  

(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 = 2482 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '700'  

(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 = 2445  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2445'  

(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 = 2445 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '705'  

(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 = 2430  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2430'  

(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 = 2430 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '707'  

(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 = 2456  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2456'  

(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 = 2456 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '713'  

(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 = 2464  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2464'  

(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 = 2464 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '732'  

(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 = 2488  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2488'  

(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 = 2488 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '735'  

(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 = 3244  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3244'  

(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 = 3244 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1176'  

(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 = 2766  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2766'  

(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 = 2766 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '827'  

(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 = 2703  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2703'  

(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 = 2703 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '843'  

(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 = 2772  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2772'  

(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 = 2772 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '851'  

(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 = 2686  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2686'  

(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 = 2686 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '855'  

(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 = 2963  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2963'  

(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 = 2963 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '856'  

(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 = 2731  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2731'  

(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 = 2731 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '861'  

(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 = 3344  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3344'  

(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 = 3344 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1144'  

(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 = 2783  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2783'  

(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 = 2783 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '926'  

(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 = 2749  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2749'  

(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 = 2749 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '927'  

(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 = 2629  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2629'  

(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 = 2629 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '939'  

(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 = 4053  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '4053'  

(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 = 4053 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1422'  

(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 = 3308  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3308'  

(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 = 3308 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1130'  

(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 = 3286  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3286'  

(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 = 3286 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1131'  

(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 = 3305  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3305'  

(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 = 3305 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1141'  

(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 = 3292  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3292'  

(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 = 3292 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1156'  

(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 = 3323  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3323'  

(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 = 3323 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1161'  

(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 = 3217  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3217'  

(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 = 3217 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1168'  

(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 = 3209  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3209'  

(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 = 3209 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1172'  

(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 = 3239  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3239'  

(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 = 3239 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1182'  

(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 = 3218  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3218'  

(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 = 3218 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1185'  

(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 = 3960  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3960'  

(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 = 3960 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1424'  

(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 = 'Jusmalia' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Oktaviani' 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 = 405  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '405'  

(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 = 405 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '247'  

(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 = 2189  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2189'  

(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 = 2189 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '489'  

(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 = 2489  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2489'  

(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 = 2489 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '685'  

(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 = 2484  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2484'  

(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 = 2484 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '691'  

(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 = 2460  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2460'  

(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 = 2460 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '703'  

(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 = 2445  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2445'  

(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 = 2445 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '705'  

(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 = 2430  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2430'  

(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 = 2430 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '707'  

(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 = 2456  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2456'  

(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 = 2456 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '713'  

(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 = 2548  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2548'  

(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 = 2548 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '724'  

(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 = 2500  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2500'  

(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 = 2500 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '740'  

(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 = 2766  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2766'  

(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 = 2766 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '827'  

(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 = 2719  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2719'  

(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 = 2719 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '845'  

(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 = 2665  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2665'  

(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 = 2665 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '846'  

(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 = 2963  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2963'  

(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 = 2963 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '856'  

(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 = 3143  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3143'  

(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 = 3143 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '860'  

(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 = 2783  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2783'  

(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 = 2783 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '926'  

(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 = 3308  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3308'  

(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 = 3308 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1130'  

(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 = 3365  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3365'  

(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 = 3365 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1132'  

(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 = 3290  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3290'  

(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 = 3290 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1133'  

(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 = 3304  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3304'  

(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 = 3304 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1134'  

(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 = 3234  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3234'  

(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 = 3234 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1135'  

(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 = 3211  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3211'  

(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 = 3211 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1140'  

(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 = 3317  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3317'  

(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 = 3317 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1142'  

(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 = 3270  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3270'  

(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 = 3270 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1145'  

(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 = 3292  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3292'  

(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 = 3292 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1156'  

(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 = 3271  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3271'  

(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 = 3271 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1159'  

(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 = 3213  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3213'  

(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 = 3213 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1196'  

(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 = 3303  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3303'  

(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 = 3303 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1197'  

(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 = 4675  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '4675'  

(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 = 4675 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1632'  

(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 = 4257  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '4257'  

(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 = 4257 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1407'  

(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 = 3802  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3802'  

(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 = 3802 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1432'  

(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 = 3665  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3665'  

(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 = 3665 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1435'  

(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 = 3540  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '3540'  

(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 = 3540 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1463'  

(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 = 4074  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '4074'  

(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 = 4074 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1470'  

(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 = 405  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '405'  

(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 = 405 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '247'  

(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 = 405  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '405'  

(mysql): SELECT * FROM sections WHERE section_id = 3  

(mysql): SELECT * FROM section_settings WHERE section_id = '3'  

(mysql): SELECT * FROM journals WHERE journal_id = 3  

(mysql): SELECT * FROM journal_settings WHERE journal_id = '3'  

(mysql): SELECT i.* FROM issues i WHERE issue_id = 32  

(mysql): SELECT * FROM issue_settings WHERE issue_id = '32'  

(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 = 2189  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2189'  

(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 = 2189 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '489'  

(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 = 2189  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2189'  

(mysql): SELECT i.* FROM issues i WHERE issue_id = 61  

(mysql): SELECT * FROM issue_settings WHERE issue_id = '61'  

(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 = 2430  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2430'  

(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 = 2430 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '707'  

(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 = 2430  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2430'  

(mysql): SELECT * FROM sections WHERE section_id = 10  

(mysql): SELECT * FROM section_settings WHERE section_id = '10'  

(mysql): SELECT * FROM journals WHERE journal_id = 8  

(mysql): SELECT * FROM journal_settings WHERE journal_id = '8'  

(mysql): SELECT i.* FROM issues i WHERE issue_id = 69  

(mysql): SELECT * FROM issue_settings WHERE issue_id = '69'  

(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 = 2445  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2445'  

(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 = 2445 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '705'  

(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 = 2445  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2445'  

(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 = 2460  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2460'  

(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 = 2460 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '703'  

(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 = 2460  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2460'  

(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 = 2464  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2464'  

(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 = 2464 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '732'  

(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 = 2464  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2464'  

(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 = 2479  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2479'  

(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 = 2479 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '683'  

(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 = 2479  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2479'  

(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 = 2482  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2482'  

(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 = 2482 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '700'  

(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 = 2482  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2482'  

(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 = 2484  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2484'  

(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 = 2484 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '691'  

(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 = 2484  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2484'  

(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 = 2488  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2488'  

(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 = 2488 AND nsf.file_id IS NULL ORDER BY g.seq  

(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '735'  

(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 = 2488  

(mysql): SELECT * FROM submission_settings WHERE submission_id = '2488'  

Most read articles by the same author(s)

1 2 3 4 5 6 7 > >>