PENGARUH MODEL PEMBELAJARAN KOOPERATIF TIPEGROUP INVESTIGATION TERHADAP HASIL BELAJAR SISWA PADA MATERI SISTEM PERNAPASAN DI KELAS XI IPASMA NURUL FALAH PEKANBARU TAHUN AJARAN 2013/2014


(mysqli): SELECT a.*, ug.show_title, s.locale FROM authors a JOIN user_groups ug ON (a.user_group_id=ug.user_group_id) JOIN submissions s ON (s.submission_id = a.submission_id) WHERE a.submission_id = 151 ORDER BY seq  

(mysqli): SELECT * FROM author_settings WHERE author_id = '192'  

    (mysqli): SELECT a.*, ug.show_title, s.locale FROM authors a JOIN user_groups ug ON (a.user_group_id=ug.user_group_id) JOIN submissions s ON (s.submission_id = a.submission_id) WHERE a.submission_id = 151 ORDER BY seq  

    (mysqli): SELECT * FROM author_settings WHERE author_id = '192'  
  • Ermina Sari
Keywords: Group investigation, hasil belajar, sistem pernapasan

Abstract

Penelitian ini bertujuan untuk mengetahui pengaruh model pembelajaran Group
Investigation terhadap hasil belajar siswa pada materi sistem pernapasan di kelas XI IPA SMA
Nurul Falah Pekanbaru. Penelitian ini termasuk kuasi eksperimen. Desain penelitian ini adalah
preetest-posttest control group design. Populasi penelitian ini adalah seluruh siswa kelas XI IPA
di SMA Nurul Falah Pekanbaru dengan sampel sebanyak 68 siswa yang diambil dengan
menggunakan teknik simple random sampling. Pengumpulan data dilakukan melalui pretest,
posttest dan lembar observasi siswa dan guru. Teknik analisis data menggunakan uji-t jika data
berdistribusi normal dan varians homogen. N-gain kelas kontrol dengan kategori sedang (0,52)
dan kelas eksperimen dengan kategori tinggi (0,75). Hasil uji-t N-gain terdapat perbedaan
signifikan antara N-gain kelas kontrol dan N-gain kelas eksperimen. Berdasarkan hasil penelitian
ini dapat disimpulkan bahwa terdapat pengaruh model pembelajaran Group Investigation
terhadap hasil belajar siswa pada materi sistem pernapasan di kelas XI IPA SMA Nurul Falah
Pekanbaru Tahun Ajaran 2013/2014.


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

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

(mysqli): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 15 AND setting_name = 'chartType'  

Downloads

Download data is not yet available.

(mysqli): SELECT a.*, ug.show_title, s.locale FROM authors a JOIN user_groups ug ON (a.user_group_id=ug.user_group_id) JOIN submissions s ON (s.submission_id = a.submission_id) WHERE a.submission_id = 151 ORDER BY seq  

(mysqli): SELECT * FROM author_settings WHERE author_id = '192'  
Published
2014-02-20
How to Cite
Sari, E. (2014). PENGARUH MODEL PEMBELAJARAN KOOPERATIF TIPEGROUP INVESTIGATION TERHADAP HASIL BELAJAR SISWA PADA MATERI SISTEM PERNAPASAN DI KELAS XI IPASMA NURUL FALAH PEKANBARU TAHUN AJARAN 2013/2014. Lectura : Jurnal Pendidikan, 5(1). https://doi.org/10.31849/lectura.v5i1.151
Section
Articles
Abstract viewed =
(mysqli): SELECT * FROM journals WHERE journal_id = 15  

(mysqli): SELECT * FROM journal_settings WHERE journal_id = '15'  

(mysqli): 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)  

(mysqli): SELECT SUM(metric) AS metric FROM metrics WHERE assoc_id = '151' AND assoc_type = 1048585 AND context_id = '15' AND metric_type = 'ojs::counter'  
28 times
Pdf downloaded =
(mysqli): SELECT * FROM journals WHERE journal_id = 15  

(mysqli): SELECT * FROM journal_settings WHERE journal_id = '15'  

(mysqli): SELECT SUM(metric) AS metric FROM metrics WHERE assoc_id = '326' AND assoc_type = 515 AND context_id = '15' AND metric_type = 'ojs::counter'  
0 times

(mysqli): SELECT a.*, ug.show_title, s.locale FROM authors a JOIN user_groups ug ON (a.user_group_id=ug.user_group_id) JOIN submissions s ON (s.submission_id = a.submission_id) WHERE a.submission_id = 151 ORDER BY seq  

(mysqli): SELECT * FROM author_settings WHERE author_id = '192'  

(mysqli): SELECT DISTINCT a.submission_id FROM authors a LEFT JOIN submissions s ON (s.submission_id = a.submission_id) LEFT JOIN author_settings asg0 ON (asg0.author_id = a.author_id AND asg0.setting_name = 'givenName' AND asg0.locale = 'en_US') LEFT JOIN author_settings asf0 ON (asf0.author_id = a.author_id AND asf0.setting_name = 'familyName' AND asf0.locale = 'en_US') WHERE s.status = 3 AND ((asg0.setting_value = 'Ermina' AND asf0.setting_value = 'Sari')) AND a.country = 'ID'  

(mysqli): 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 = 151  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '151'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '67'  

(mysqli): 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 = 157  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '157'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '72'  

(mysqli): 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 = 185  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '185'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '95'  

(mysqli): 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 = 238  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '238'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '138'  

(mysqli): 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 = 303  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '303'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '191'  

(mysqli): 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 = 311  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '311'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '199'  

(mysqli): 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 = 323  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '323'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '210'  

(mysqli): 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 = 335  

(mysqli): 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 = 336  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '336'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '224'  

(mysqli): 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 = 356  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '356'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '245'  

(mysqli): 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 = 361  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '361'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '250'  

(mysqli): 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 = 396  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '396'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '276'  

(mysqli): 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 = 399  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '399'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '279'  

(mysqli): 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 = 1011  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '1011'  

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

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

(mysqli): 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 = 1901  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '1901'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '1206'  

(mysqli): 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 = 2045  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '2045'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '1460'  

(mysqli): 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 = 2685  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '2685'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '1614'  

(mysqli): 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 = 157  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '157'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '72'  

(mysqli): 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 = 157  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '157'  

(mysqli): SELECT * FROM sections WHERE section_id = 15  

(mysqli): SELECT * FROM section_settings WHERE section_id = '15'  

(mysqli): SELECT * FROM journals WHERE journal_id = 15  

(mysqli): SELECT * FROM journal_settings WHERE journal_id = '15'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 51  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '51'  

(mysqli): 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 = 185  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '185'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '95'  

(mysqli): 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 = 185  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '185'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 60  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '60'  

(mysqli): 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 = 238  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '238'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '138'  

(mysqli): 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 = 238  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '238'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 76  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '76'  

(mysqli): 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 = 303  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '303'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '191'  

(mysqli): 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 = 303  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '303'  

(mysqli): SELECT * FROM sections WHERE section_id = 16  

(mysqli): SELECT * FROM section_settings WHERE section_id = '16'  

(mysqli): SELECT * FROM journals WHERE journal_id = 16  

(mysqli): SELECT * FROM journal_settings WHERE journal_id = '16'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 88  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '88'  

(mysqli): 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 = 311  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '311'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '199'  

(mysqli): 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 = 311  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '311'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 89  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '89'  

(mysqli): 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 = 323  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '323'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '210'  

(mysqli): 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 = 323  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '323'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 90  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '90'  

(mysqli): 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 = 336  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '336'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '224'  

(mysqli): 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 = 336  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '336'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 91  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '91'  

(mysqli): 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 = 356  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '356'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '245'  

(mysqli): 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 = 356  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '356'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 92  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '92'  

(mysqli): 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 = 361  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '361'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '250'  

(mysqli): 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 = 361  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '361'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 93  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '93'  

(mysqli): 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 = 396  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '396'  

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

(mysqli): SELECT * FROM submission_galley_settings WHERE galley_id = '276'  

(mysqli): 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 = 396  

(mysqli): SELECT * FROM submission_settings WHERE submission_id = '396'  

(mysqli): SELECT i.* FROM issues i WHERE issue_id = 94  

(mysqli): SELECT * FROM issue_settings WHERE issue_id = '94'  

Most read articles by the same author(s)

> >>