STRATEGI PERTAHANAN LUAR ANGKASA AMERIKA SERIKAT DALAM MERESPON MISI LUAR ANGKASA CHANG’E TIONGKOK

Bulan Kania Larasati; Angga Nurdin Rachmat; Jusmalia Oktaviani

doi:10.36859/gij.v1i1.2500

STRATEGI PERTAHANAN LUAR ANGKASA AMERIKA SERIKAT DALAM MERESPON MISI LUAR ANGKASA CHANG’E TIONGKOK

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

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

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

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

Bulan Kania Larasati Universitas Jenderal Achmad Yani
Angga Nurdin Rachmat Universitas Jenderal Achmad Yani
Jusmalia Oktaviani Universitas Jenderal Achmad Yani

DOI: https://doi.org/10.36859/gij.v1i1.2500

Keywords: Misi Luar Angkasa, Chinese Lunar Exploration Program, Chang'e, United States Space Command, United States Space Force

Abstract

Chinese Lunar Exploration Program (CLEP) atau dikenal dengan nama lain Chang’e merupakan sebuah misi luar angkasa Tiongkok yang mempunyai tujuan untuk mengeksplorasi bulan. Misi ini telah dilakukan Tiongkok sejak tahun 2007 hingga sampai saat ini. Tujuan akhir dari pada misi luar angkasa Tiongkok ini adalah untuk membangun stasiun berawak Tiongkok di Bulan sebagai bagian dari penelitiannya. Namun disisi lain, Amerika Serikat sebagai negara yang mempunyai kekuatan kekuasaan yang mendominasi luar angkasa menganggap misi luar angkasa Tiongkok ini sebagai ancaman yang akan mengancam keamanan nasionalnya. Penelitian ini bertujuan untuk mengetahui strategi pertahanan dan keamanan yang akan dilakukan oleh Amerika Serikat sebagai bagian dalam mencegah ancaman kekuatan baru di luar angkasa, khususnya ketika misi ini mencapai tingkat keberhasilan yang signifikan di tahun 2019-2021.

Untuk mengatasi masalah tersebut, maka masalah penelitian akan diteliti dengan menggunakan metode penelitian kualitatif deskriptif. Penelitian akan difokuskan terhadap strategi pertahanan dan keamanan luar angkasa Amerika Serikat dalam merespon misi luar angkasa Chang’e Tiongkok dengan menggunakan konsep strategi Arthur F. Lykke. Dengan fokus masalah tersebut, maka dapat diketahui Amerika Serikat melakukan balance of power untuk mengatasi ancaman dari Tiongkok di luar angkasa. Dengan melakukan internal balancing dan external balancing, Amerika Serikat dapat mempertahankan kekuatannya dengan membentuk sebuah strategi dalam berbagai sektor, seperti militer, sipil hingga komersial.

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

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

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

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

References

Buku
Art, R. J., & Jervis, R.
(2017). International Politics: Enduring Concepts and
Contemporary Issues. New York: Charlyce Jones Owen.
Bakry, U. S.
(2017). Metode Penelitian Hubungan Internasional. Yogyakarta:
Pustaka Pelajar.
Burchill, S., & etc.
(2005). Theories of International Relations
(Third Edition).
New York: Palgrave Macmillan.
Colucci, L. C.
(2023). The United States Space Force: Space, Grand Strategy,
and U.S. National Security. California: Praeger.
Cresswell, J. W.
(2013). Research Design: Qualitative, Quantitative, and
Mixed Methods Approaches. California: SAGE Publication.
Dolman, E. C.
(2002). Astropolitik: Classical Geopolitics in the Space Age.
London: Routledge.
Jr., J. N. (2011). The Future of Power. New York: Public Affairs.
Lacey, A., & Luff, D.
(2009). Qualitative Data Analysis. New York: The NIHR
Research Design Service for Yorkshire & The Humer.
Lykke, A. F.
(1997). Military Strategy: Theory and Application. New York:
Carlisle, PA: U.S. Army War College.
Mearsheimer, J.
(2007). International Relations Theories: Discipline and
Diversity. Oxford University Press.
Miles, M. B., Huberman, A. M., & Saldana, J.
(2014). Qualitative Data
Analysis. California: SAGE Publication, Inc.
Pelton, J. N.
(2020). US Space Policy Directive-3: National Space Traffic
Management Policy. Springer Nature Switzerland AG, 1-12.
Waltz, K. N.
(1979). Theory of International Politics. Philippines: Addison-
Wesley.
Wyse, S. E.
(2017). "What is The Difference Between Qualitative Research
and Quantitative Research. In U. S. Bakrie, Metode Penelitian
Hubungan Internasional
(p. 17). Yogyakarta: Pustaka Pelajar.
Yarger, H. R. (2006). Strategic Theory for The 21st Century: The Little Book on
Big Strategy.
Znaniecki, F.
(2003). Analytic Induction. In R. L. Brewer, The A-Z of Social
Research: A Dictionary of Key Social Science Research Concepts
(p.
155
). London : SAGE Publication Ltd.
Dokumen Pemerintah
Archive, U. G.
(2001
). Treaty On Principles Governing The Activities Of States
In The Exploration and Use Of Outer Space, Including The Moon And
Othe Celestial Bodies. U.S. Department Of State.
NASA,
The
Artemis
Accords
https://www.nasa.gov/wp
content/uploads/2022/11/Artemis-Accords-signed-13Oct2020.pdf, diakses
20 Juli 2024
U.S.Government. (2001
). Treaty On Principles Governing The Activities Of
States In The Exploration And Use Of Outer Space, Including The
Moon And Other Celestial Bodies. Retrieved From U..S Department Of
State: Https://2009- 2017.State.Gov/T/Isn/5181.Htm, diakses 07
Julli 2024
U.S.Government. (2005). Strategic Defense Initiative (Sdi). Retrieved From
Us
Department
Of
State:
Https://20012009.State.Gov/R/Pa/Ho/Time/Rd/104253.Htm,
diakses pada 25 Juli 2024
U.S. Space Command. (2019, September 5). The Future of Space 2060 and
Implications for U.S. Strategy: Report on the Space Futures
Workshop.
https://aerospace.csis.org
/wp-
content/uploads/2019/09/Future-of-Space-2060-v2-5-Sep.pdf
United States Space Command. 2024. “Strategic Vision”,
https://www.spacecom.mil/Portals/57/Documents/USSPACECOM%2
0Strategic%20Vision_Feb%202024%20Online.pdf?ver=INczxf__t9Iyetloh
Pw5dA%3d%3d, diakses 20 Juli 2024
Jurnal
Bartholomees, J.
(2010). The US Army College Guide To National Security
Issues Volume I Theory of War and Strategy. Pennsylvania: Director,
Strategic Studies Institute, U.S. Army War College, 49-53.
Habibi, D.
(2018). Kemunculan Perlombaan Antariksa Bernuansa Ekonomi.
Intermestic Journal, Vol. 2, No. 1, 55-67.
Mahardhika, K., Bintarsari, N., & dan Darmawan, A.
(2022). Pengaruh
Perkembangan Astropolitik Terhadap Kebijakan Keamanan dan
Pertahanan Amerika Serikat Pada Masa Kepemimpinan Donald
Trump (2018-2020). Review of International Relations, 87-108.
Noor, C., Karisma, G., & Rakhmadi, R.
(2022). Strategi Smart Power
Tiongkok dalam Dimensi Ruang Angkasa guna Mengimbangi
Kekuatan Amerika Serikat Tahun 2013-2021. Global Local
(Student
Journal on Global and Local Issue), 17-33.
Situmorang, V.
(2020). Rivalitas Negara Adidaya di Ruang Angkasa. Jurnal
Transformasi Global, Universitas Brawijaya, Vol. 7 No. 2, 292-298.
Sutyoko, M., Putranti, I., & Hanura, M.
(2022). Strategi Pertahanan Ruang
Angkasa Amerika Serikat Dalam Menghadapi Militerisasi Ruang
Angkasa Tiongkok. Journal of International Relations, Volume 8, Nomor
4, 822-833.
Internet
CNN.
(2019). Tiongkok Bakal Luncurkan Puluhan Pesawat Luar Angkasa di
2019.
Jakarta: CNN
Indonesia.
Diakses
melalui
https://www.cnnindonesia.com/teknologi/20190201181706-199365794/Tiongkok-bakal-luncurkan-puluhan-pesawat-luar-angkasadi-2019,
11 November 2023.
Natalia, D. (2024). Luncurkan Chang’e-6 Untuk Misi ke Bulan. Diakses pada
30
Juni
2024
dari
https://www.antaranews.com/berita/4089087/Tiongkok-luncurkanchange-6-untuk-misi-ke
bulan#:~:text=Dimulai%20dengan%20peluncuran%20Chang'e,melunc
urkan%20wahana%20penjelajah%20bulan%20sendiri
Rizal, G., & Hardiyanto, S.
(2024). Misi Pesawat Chang’e Milik Tiongkok,
Luar
Angkasa dan Sampel Batuan Bulan. Diakses 30 Juni 2024 dari
https://www.kompas.com/tren/read/2020/12/04/200500565/misipesawat-chang-e-5-milik-Tiongkok-luar-angkasa-dan-sampel-batuanbulan-?page=all
United States Space Command. 2023. “Frequently Asked Question”,
https://www.spacecom.mil/About/Frequently-Asked-Questions/,
diakses 20 Juli 2024
World Bank.
(2019). The World Bank Data: Tiongkok. Washington D. C.:
World Bank.
World Bank.
(2019). The World Bank Data: United States. Washington D.C:
World Bank.

Published

2024-10-24

How to Cite

Larasati, B. K., Rachmat, A. N., & Oktaviani, J. (2024). STRATEGI PERTAHANAN LUAR ANGKASA AMERIKA SERIKAT DALAM MERESPON MISI LUAR ANGKASA CHANG’E TIONGKOK, 1(1). https://doi.org/https://doi.org/10.36859/gij.v1i1.2500

Download Citation

Issue

Vol 1 No 1 (2024): Global Insights Journal

Section

Articles

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

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

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

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

(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 = 'Bulan Kania' AND a.status = 3 AND (aa.middle_name = '' OR aa.middle_name IS NULL) AND aa.last_name = 'Larasati' 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 = 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 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 * FROM submission_settings WHERE submission_id = '241'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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 = '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 * FROM submission_settings WHERE submission_id = '405'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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 * FROM submission_settings WHERE submission_id = '241'

(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 * FROM submission_settings WHERE submission_id = '405'

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

(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 * FROM submission_settings WHERE submission_id = '1108'

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

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

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

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

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

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

(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 * FROM submission_settings WHERE submission_id = '2404'

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

(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'