INDONESIA`S ROLE IN THE ISSUE OF HUMAN RIGHT VIOLATIONS AGAINST THE UIGHUR ETHNIC GROUP IN XINJIANG

Merri Merliana; Angga Nurdin Rachmat; Jusmalia Oktaviani

doi:10.36859/jdg.v9i1.2189

INDONESIA`S ROLE IN THE ISSUE OF HUMAN RIGHT VIOLATIONS AGAINST THE UIGHUR ETHNIC GROUP IN XINJIANG

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

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

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

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

Merri Merliana Universitas Jenderal Achmad Yani
Angga Nurdin Rachmat Universitas Jenderal Achmad Yani
Jusmalia Oktaviani Universitas Jenderal Achmad Yani

DOI: https://doi.org/10.36859/jdg.v9i1.2189

Keywords: Foreign policy, Xinjiang, China, identity interest

Abstract

The issue of human rights violations against the Uighur ethnic group in Xinjiang, China, has drawn attention from Western countries as promoters of human rights and Muslim-majority nations, within the framework of solidarity. For Indonesia, the issue of human rights violations against the Uighur ethnic group poses a dilemma. This dilemma stems from Indonesia's status as a member of the UN Human Rights Council for the 2020-2022 period and as a country with a Muslim-majority population, while China, accused of committing human rights violations against the Uighur ethnic group, is a strategic economic partner. Based on this context, this paper aims to discuss the question of Indonesia's role in the issue of human rights violations against the Uighur ethnic group in the years 2020-2022. The purpose of this paper is to describe and analyze Indonesia's role using K.J. Holsti's theory of national roles, based on identity and interests from a constructivist perspective. The paper finds that Indonesia plays three roles in the issue of human rights violations against the Uighur ethnic group: independent, example, and bridge. These roles are based on Indonesia's identity as a middle power country with economic interests and its identity as a member of the UN Human Rights Council.

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

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

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

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

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

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

References

Adler, E. (1997). Seizing the Middle Ground : Constructivisme in World Politics. European Journal of International Relations, 3(3), 319–363.
Alvian, R. A., Putri, G. C., & Ardhani, I. (2018). Haluan Baru Politik Luar Negeri Indonesia: Perbandingan Diplomasi ‘Middle Power’ Susilo Bambang Yudhoyono dan Joko Widodo. Jurnal Hubungan Internasional, 6(2), 148–163.
Asia Pacific Centre for the Responsibility to Protect. (2020). Genocide and Crimes Against Humanity in Xinjiang? Applying the Legal Tests.
Clunan, A. L. (2009). The Social Construction of Russia`s Resurgence: Aspirations, Identity and Security Interest. The Jhons Hopkins University Press.
Darwich, M. (2019). Threats and Alliances in the Middle East. In Threats and Alliances in the Middle East. https://doi.org/10.1017/9781108656689
Debora, C., & Sulaiman, Y. (2019). Pengaruh Elit Politik Indonesia dalam Kebijakan Luar Negeri Indonesia: Kelompok Elit Radikal Islam Melalui Isu Palestina. Academia Praja, 2(2).
Dermawan, W., & Rohmaniah, A. (2019). Peran Indonesia dalam Kerja Sama ASEAN-Korea Selatan Melalui ASEAN-Korea Centre. JISPO, 9(1).
Erbas, I. (2022). Constructivist Approach in Foreign Policy and in International Relations. Journal of Positive School Psychology, 6(3), 5087–5096.
Fatikasari, R., & Fithriana, A. (2019). Kontroversi Kebijakan Re-Edukasi Terhadap Etnis Uighur oleh Pemerintah Tiongkok dalam Perspektif Hak Azasi Manusia. Budi Luhur Journal of Contemporary Diplomacy, 2(2), 177–185.
Fiadi, I. R. (2022). Tindakan Indonesia dan Arab Saudi dalam Isu Pelanggaran Hak Asasi Manusia Terhadap Etnis Uighur di Xinjiang Tahun 2019. Jurnal Populika, 10(1), 22–32.
Gurinda, N. C. H. (2019). Peran PBB dalam Perlindungan Hak Asasi Manusia Menurut Kajian Hukum Internasional. Lex Et Societatis, 7(9), 54–61.
Habib, A. (2022). Alasan RI Tolak Debat Isu Muslim Uighur di PBB. Cnnindonesia.Com. https://www.cnnindonesia.com/internasional/20221008144226-106-858034/alasan-ri-tolak-debat-isu-muslim-uighur-di-pbb
Holsti, K. . (1970). National Role Conception in the Study of Foreign Policy. International Studies Quarterly, 14(3), 233–309.
Institute for Policy Analysis of Conflict. (2019). Explaining Indonesia`s Silence on The Uyghur Issues, dalam Politicisation of The Uyghur Issue 2017-2018. https://www.jstor.org/stable/resrep24208.6
Kementrian Luar Negeri Republik Indonesia. (2019a). Indonesia dan Hak Azasi Manusia. Kemlu.Go.Id. https://kemlu.go.id/portal/id/read/40/halaman_list_lainnya/indonesia-dan-hak-asasi-manusia
Kementrian Luar Negeri Republik Indonesia. (2019b). Peran Aktif Pemerintah Indoensia dalam Berbagai Inisiatif HAM Internasional. Kemlu.Go.Id. https://kemlu.go.id/portal/id/read/59/halaman_list_lainnya/peran-aktif-pemerintah-indonesia-dalam-berbagai-inisiatif-ham-internasional
Kurniawan, A. A., Maulidya, A. D., Sa`ban, K., & Indrawati. (2020). The Chinese vs Western Media Framing on Uighur Conflict. Journal of Islamic World and Politics, 4(2), 131–148.
Liu, A. H., & Peters, K. (2017). The Hanification of Xinjiang, China: The Economic Effect of the Great Leap West. Studies in Ethnicity and Nationalism, 17(2), 265–280.
Mu`ti, A. (2019). Multidimensi Masalah Uighur. Republika.Co.Id. https://www.jdihn.go.id/files/2098/RP-26-12-2019.1.pdf
Novianto, R. D. (2019). Kisah Ormas Islam Indonesia ke Xinjiang Melihat dari Dekat Muslim Uighur. Sindonews.Com. https://nasional.sindonews.com/berita/1471969/15/kisah-ormas-islam-indonesia-ke-xinjiang-melihat-dari-dekat-muslim-uighur
Oktavia, E. M. (2023). Islam dalam Kebijakan Luar Negeri Indonesia Terhadap Cina dalam Penyelesaian Konflik Etnis Uighur. Jurnal Restorasi Hukum, 6(2), 130–145.
Peltonen, H. (2017). A tale of two cognitions: The Evolution of Social Constructivism in International Relations. Revista Brasileira de Política Internacional, 60(1), 1–18. https://doi.org/10.1590/0034-7329201700105
Pradityo, R. (2020). Indonesia diantara Masalah Etnis Rohingya dan Etnis Uighur 2014-2019. Indonesian Perspective, 5(2), 138–518.
Pundilaras, B., & Aswar, H. (2023). Peran PBB dan Hambatan yang Dihadapi Dalam Menangani Isu Pelanggaran HAM China Terhadap Etnis Uighur di Xinjiang Tahun 2018-2022. The Journal of Islamic Studies and International Relations, 6, 51–82.
Putri, F. A., & Yumitro, G. (2022). Pelanggaran HAM Etnis Muslim Uighur oleh Pemerintah China di Xinjiang. Journal of Contemporary Diplomacy, 6(1), 15–22.
Rohman, A., Musthofa, C., Hakim, M. F., Arif, M. Q. ‘Ainul, Amaliyah, R., Nurika, R. R., & Ismail, Z. (2020). Islam, Indonesia, Tiongkok: Analisis Potensi Peningkatan People to People Connectivity antara Indonesia-Tiongkok Perspektif Elite Muslim Indonesia.
Rosenau, J. N. (1980). The Scientifc Study of Foreign Policy. The Free Press.
Rosyidin, M. (2020). Teori Hubungan Internasional dari Perspektif Klasik sampai Non-Barat. Raja Grafindo.
Saragih, M. F., Hamid, S., & Muthe, M. (2019). Tinjauan Yuridis Pelanggaran HAM Terhadap Etnis Muslim Uighur di China Ditinjau Dari Hukum Humaniter. Journal of USU International Law, 4(2).
Sukendar. (2015). Hak Asasi Manusia dalam Kebijakan Luar Negeri Indonesia. Sawala: Jurnal Administasi Negara, 3(2), 70–76.
Taris, H. (2019). The Responsibility of People`s Republic of China for Alleged Human Rights Violations against the Uighurs. Pajajaran Jurnal Ilmu Hukum, 6(3), 619–637.
Wendt. (1992). Anarchy is what States Make of it : The Social Construction of Power Politics Author ( s ): Alexander Wendt Published by : The MIT Press Stable URL : http://www.jstor.org/stable/2706858. International Organization, 46(2), 391–425.
Wendt, A. (2004). The States as Person in International Theory. Review of International Studies, 30(2), 289–316.
Zahrah, F., & Widiani, R. (2023). Pengambilan Kebijakan Rasional oleh Pemerintah Tiongkok Terhadap Etnis Uighur di Xinjiang 2014-2019. Journal of International Relations, 9(1), 312–323.
Zulkarnain, & Ghonimah, S. N. (2020). Respon Turki Terhadap Tindakan Diskriminasi Pemerintah Cina Kepada Etnis Uighur di Xinjiang (2009-2015). Syntax Literate: Jurnal Ilmiah Indonesia, 5(10), 1215–1231.

Published

2024-06-30

How to Cite

Merliana, M., Rachmat, A. N., & Oktaviani, J. (2024). INDONESIA`S ROLE IN THE ISSUE OF HUMAN RIGHT VIOLATIONS AGAINST THE UIGHUR ETHNIC GROUP IN XINJIANG, 9(1), 109-124. https://doi.org/https://doi.org/10.36859/jdg.v9i1.2189

Download Citation

Issue

Vol 9 No 1 (2024): Dinamika Global : Jurnal Ilmu Hubungan Internasional

Section

Articles

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

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

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

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

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

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