KEBIJAKAN LUAR NEGERI TIONGKOK DALAM MENDUKUNG ARAB SAUDI MENYELESAIKAN KONFLIK DENGAN IRAN TAHUN 2022-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 = 4089 ORDER BY seq  

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

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

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

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

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

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

    (mysql): SELECT * FROM author_settings WHERE author_id = '6069'  
  • Angie Nerazzury Hermawan Universitas Jenderal Achmad Yani
  • Angga Nurdin Rachmat Universitas Jenderal Achmad Yani
  • Bimbi Rianda Universitas Jenderal Achmad Yani
Keywords: Foreign Policy, China, Saudi Arabia, Saudi Arabia-Iran Conflict

Abstract

This study aims to explain the reasons behind China's support for Saudi Arabia in its efforts to resolve the conflict with Iran in 2022-2023. The main focus of this study is on analyzing China's foreign policy through a qualitative-explanatory approach, using Alex Mintz and Karl DeRouen's concept of foreign policy decision-making (FPDM), particularly psychological and international factors. The results of this study indicate that China's support is part of the transformation of its foreign policy, which is becoming increasingly active and responsive to regional dynamics. Stability in the Gulf region is crucial for energy security and the continuity of the Belt and Road Initiative (BRI) project, which is in line with Saudi Arabia's Vision 2030, so China provides diplomatic and symbolic support through its role as a mediator. The main reasons behind China's support are the consistency of its peaceful policy, its perception of Saudi Arabia as a key strategic partner, and its desire to maintain balance in the region. This underscores that China's foreign policy is not only focused on protecting its national interests but also reflects its aspirations as a global power playing a role in maintaining stability and supporting a multipolar world order.


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

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

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

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

References

Ahdiat, A. (2024). 55% Cadangan Minyak Dunia Berada di Timur Tengah. Katadata Media Network. https://databoks.katadata.co.id/energi/statistik/5a2fe5cd695d7a0/55-cadangan-minyak-dunia-berada-di-timur-tengah
Alex Mintz, & DeRouen, K. (2010). Understanding Foreign Policy Decision Making. In Cambridge University Press. https://doi.org/10.1017/CBO9780511757761
Azimi, S. (2023). The Story Behind China’s Role in the Iran-Saudi Deal. Stimson Center. https://www.stimson.org/2023/the-story-behind-chinas-role-in-the-iran-saudi-deal/
BBC News. (2016). Eksekusi ulama Syiah di Arab Saudi picu kemarahan luas. https://www.bbc.com/indonesia/dunia/2016/01/160102_dunia_arab_syiah
Brown, K. (2016). CEO, China: the rise of Xi Jinping. Bloomsbury Publishing.
Chaziza, M. (2018). China’s mediation efforts in the middle east and North Africa: Constructive conflict management. Strategic Analysis, 42(1), 29–41. https://doi.org/10.1080/09700161.2017.1418956
Chen Aizhu. (2024). Exclusive: China’s Iranian crude imports find new market in northeast | Reuters. https://www.reuters.com/markets/commodities/chinas-iranian-crude-imports-find-new-market-northeast-2024-07-26/
China Economic Information Centre. (2022). Saudi Arabia Total Exports to China 2022. CEIC Data. https://www.ceicdata.com/en/indicator/saudi-arabia/total-exports-to-china
Eslami, M., & Papageorgiou, M. (2023). China’s Increasing Role in the Middle East: Implications for Regional and International Dynamics. Georgetown Journal of International Affairs, 2.
Fulton, J. (2020). China-Saudi Arabia Relations Through the ‘1 + 2+3’ Cooperation Pattern. Asian Journal of Middle Eastern and Islamic Studies, 14(4), 516–527. https://doi.org/10.1080/25765949.2020.1841991
Gideon, R. (1998). Neoclassical Realism and Theories of Foreign Policy. Worlds Politics, 51(1), 144–72. https://doi.org/10.1017/S0043887100007814
Kai, H., & Huiyuny, F. (2013). Xi jinping’s operational code beliefs and china’s foreign policy. Chinese Journal of International Politics, 6(3), 209–231. https://doi.org/10.1093/cjip/pot010
Ministry of Foreign Affairs of the People’s Republic of China. (n.d.). China’s Initiation of the Five Principles of Peaceful Co-Existence. Ministry of Foreign Affairs of the People’s Republic of China. Retrieved April 27, 2025, from https://www.mfa.gov.cn/eng/zy/wjls/3604_665547/202405/t20240531_11367542.html
Ministry of Foreign Affairs of the People’s Republic of China. (2023). Joint Trilateral Statement by the People’s Republic of China, the Kingdom of Saudi Arabia, and the Islamic Republic of Iran. Ministry of Foreign Affairs of the People’s Republic of China. https://www.fmprc.gov.cn/eng/gjhdq_665435/2675_665437/2878_663746/2879_663748/202303/t20230311_11039241.html
Mirza, M. N., Abbas, H., & Qaisrani, I. H. (2021). Structural Sources of Saudi–Iran Rivalry and Competition for the Sphere of Influence. SAGE Open, 11(3). https://doi.org/10.1177/21582440211032642
Musofa, A. Z. (2023). Rekonsiliasi Arab Saudi dan Iran dalam Perspektif Konstruktivisme. JRP (Jurnal Review Politik), 13(2), 75–99. https://doi.org/10.15642/jrp.2023.13.2.75-99
Neuman, W. L. (2014). Basics of Social Research: Qualitative & Quantitative Approaches (3rd ed.). Pearson Education Limited.
New Zealand Ministry of Foreign Affairs and Trade. (2021). The Importance of the Suez Canal to Global Trade. New Zealand Ministry of Foreign Affairs and Trade. https://www.mfat.govt.nz/en/trade/mfat-market-reports/the-importance-of-the-suez-canal-to-global-trade-18-april-2021
Pieter. (2022). Xi Jinping’s 10 Concentric Circles of Core Strategic Interest. Han Wei Consulting. https://hanweiconsulting.com/2022/07/17/xi-jinpings-10-concentric-circles-of-core-strategic-interest/
Reuters. (2023). Saudi Arabia stays top crude supplier to China in 2022, Russian barrels surge. https://www.reuters.com/markets/commodities/saudi-arabia-stays-top-crude-supplier-china-2022-russian-barrels-surge-2023-01-20/
Rudd, K. (2024). On Xi Jinping: How Xi’s Marxist Nationalism is Shaping China and the World. Oxford University Press.
Scobell, A., & Nader, A. (2017). China in the Middle East: The Wary Dragon. In China in the Middle East: The Wary Dragon. https://doi.org/10.7249/rr1229
Strategiecs Think Tank. (2022). China’s Strategy in the Middle East from an Analytical Perspective. Strategiecs. https://strategiecs.com/en/analyses/chinas-strategy-in-the-middle-east-from-an-analytical-perspective
Sugiyono. (2023). Metode Penelitian Kualitatif (Untuk penelitian yang bersifat: eksploratif, enterpretif, interaktif dan konstruktif). Metode Penelitian Kualitatif, 1–274.
The State Council The People’s Republic Of China. (2016). Full text of China’s Arab Policy Paper. https://english.www.gov.cn/archive/publications/2016/01/13/content_281475271412746.htm
Utami, A. N., Anam, S., & Munir, A. M. (2022). Pengaruh Pertentangan Ideologi Sunni-Syi’ah Terhadap Hubungan Bilateral Arab Saudi-Iran di Timur Tengah. Indonesian Journal of Peace and Security Studies (IJPSS), 4(1), 65–81. https://doi.org/10.29303/ijpss.v4i1.111
Wawancara dengan Dr. Muhammad Zulfikar Rakhmat. (2025).
Wawancara dengan Dr. Naser Al-Tamimi. (2025).
Yuan, Z. (2024). Crucial yet Limited : China ’ s Role in the Saudi-Iranian Rapprochement. Asian Journal of Middle Eastern and Islamic Studies, 18(3), 243–259. https://doi.org/10.1080/25765949.2024.2411104
Zhou, Q. (2024). China-Saudi Arabia Ties: Trade, Investment, and Opportunities. https://www.middleeastbriefing.com/news/china-saudi-arabia-ties-trade-investment-and-opportunities/
Published
2025-10-15
How to Cite
Hermawan, A., Rachmat, A. N., & Rianda, B. (2025). KEBIJAKAN LUAR NEGERI TIONGKOK DALAM MENDUKUNG ARAB SAUDI MENYELESAIKAN KONFLIK DENGAN IRAN TAHUN 2022-2023, 2(1). https://doi.org/https://doi.org/10.36859/gij.v2i1.4089

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

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

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

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

(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 = 'Angie' AND a.status = 3 AND (aa.middle_name = 'Nerazzury') AND aa.last_name = 'Hermawan' 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 = 4089  

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

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

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

(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 = 'Angga Nurdin' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Rachmat' 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 = 241  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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 = 'Bimbi' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Rianda' 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 = 4089  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Most read articles by the same author(s)

1 2 3 4 > >>