SELECT * FROM citation_settings WHERE citation_id = 15232 SELECT * FROM citation_settings WHERE citation_id = 15231 SELECT * FROM citation_settings WHERE citation_id = 15230 SELECT * FROM author_settings WHERE author_id = 6364 SELECT * FROM author_settings WHERE author_id = 6363 SELECT * FROM author_settings WHERE author_id = 6362 SELECT * FROM issue_settings WHERE issue_id = 1018 SELECT * FROM section_settings WHERE section_id = 137 SELECT * FROM sections WHERE section_id = 137 SELECT * FROM issue_settings WHERE issue_id = 340 WHERE ist.setting_name = pub-id::publisher-id AND ist.setting_value = 340 SELECT * FROM article_settings WHERE article_id = 3293įROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id SELECT * FROM article_galley_settings WHERE galley_id = 1714 LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 3293 LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id LEFT JOIN section_settings sapl ON (s.section_id = ction_id AND tting_name = abbrev AND sapl.locale = en_US) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US) LEFT JOIN section_settings stpl ON (s.section_id = ction_id AND tting_name = title AND stpl.locale = en_US)
LEFT JOIN sections s ON s.section_id = a.section_id INNER JOIN articles a ON pa.article_id = a.article_id SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = customthemeplugin AND journal_id = 104ĬOALESCE(stl.setting_value, tting_value) AS section_title,ĬOALESCE(sal.setting_value, tting_value) AS section_abbrev SELECT last_run FROM scheduled_tasks WHERE class_name =
SELECT last_run FROM scheduled_tasks WHERE class_name = .tasks.Depositor
(session_id, ip_address, user_agent, created, last_used, remember, data, domain) SELECT * FROM sessions WHERE session_id = sl2p68pjl5vavktdoan5h0g236