rootdaa.blogg.se

SELECT * FROM issue_settings WHERE issue_id = 509 WHERE ist.setting_name = pub-id::publisher-id AND ist.setting_value = 509 SELECT * FROM article_settings WHERE article_id = 6017įROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id SELECT * FROM article_galley_settings WHERE galley_id = 3377 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 = 6017 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 last_run FROM scheduled_tasks WHERE class_name = Ĭ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

SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = objectsforreviewplugin AND journal_id = 33 (session_id, ip_address, user_agent, created, last_used, remember, data, domain) SELECT * FROM sessions WHERE session_id = fej73hb0n5moo5g8fs1ep91f84