(mysql): SELECT * FROM sessions WHERE session_id = '2kjjv00ev3stl38pheicnapar3'  
(mysql): SELECT * FROM journals WHERE path = 'lics4'  
(mysql): SELECT * FROM site  
(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 ((journal_id = '922') OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'objectsforreviewplugin' AND journal_id = '922'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.pln.classes.tasks.Depositor'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.ReviewReminder'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.SubscriptionExpiryReminder'  
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'classes.tasks.OpenAccessNotification'  
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa INNER JOIN articles a ON pa.article_id = a.article_id LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') 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 WHERE ast.setting_name = 'pub-id::publisher-id' AND ast.setting_value = '20820' ORDER BY pa.issue_id, a.article_id  
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US') WHERE pa.article_id = a.article_id AND a.article_id = 20820  
(mysql): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = 20820 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '8000'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20820'  
(mysql): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 20820 ORDER BY s.seq  
(mysql): SELECT i.* FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id WHERE ist.setting_name = 'pub-id::publisher-id' AND ist.setting_value = '667' ORDER BY i.issue_id  
(mysql): SELECT i.* FROM issues i WHERE issue_id = 667  
(mysql): SELECT * FROM issue_settings WHERE issue_id = '667'  
(mysql): SELECT iss.subscription_id FROM institutional_subscriptions iss, subscriptions s, subscription_types st WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.3', LENGTH('216.73.216.3')+1, '.'))) != 0 AND iss.domain != '' AND iss.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)  
(mysql): SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND '3628718083' >= isip.ip_start AND '3628718083' <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND '3628718083' = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM sections WHERE section_id = '159'  
(mysql): SELECT * FROM section_settings WHERE section_id = '159'  
(mysql): SELECT * FROM sections WHERE section_id = '159'  
(mysql): SELECT * FROM section_settings WHERE section_id = '159'  
(mysql): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.galley_id = 0 AND g.article_id = 20820  
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa INNER JOIN articles a ON pa.article_id = a.article_id LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') 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 WHERE ast.setting_name = 'pub-id::publisher-id' AND ast.setting_value = '20820' ORDER BY pa.issue_id, a.article_id  
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US') WHERE pa.article_id = a.article_id AND a.article_id = 20820  
(mysql): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = 20820 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '8000'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20820'  
(mysql): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 20820 ORDER BY s.seq  
(mysql): SELECT iss.subscription_id FROM institutional_subscriptions iss, subscriptions s, subscription_types st WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.3', LENGTH('216.73.216.3')+1, '.'))) != 0 AND iss.domain != '' AND iss.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)  
(mysql): SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND '3628718083' >= isip.ip_start AND '3628718083' <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND '3628718083' = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = '922' AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-09-17 10:46:54' >= s.date_start AND '2025-09-17 10:46:54' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM citations WHERE assoc_type = 257 AND assoc_id = 20820 AND citation_state >= 0 AND citation_state <= 5 ORDER BY seq, citation_id  
(mysql): SELECT * FROM sections WHERE section_id = '159'  
(mysql): SELECT * FROM section_settings WHERE section_id = '159'  
(mysql): SELECT i.* FROM issues i WHERE journal_id = 922 AND current = 1  
(mysql): SELECT * FROM issue_settings WHERE issue_id = '667'  
(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 ((journal_id = '922') OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)  
(mysql): select version()  
CALCULATION OF INTERNAL STATE FINANCIAL LOSS CORRUPTION CRIMINAL ENFORCEMENT | <hr /> (mysql): SELECT * FROM authors WHERE submission_id = 20820 ORDER BY seq   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '30483'   <hr /> Siswanto | The 4th Legal Internasional Conference and Studies
(mysql): SELECT * FROM authors WHERE submission_id = 20820 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30483'  
(mysql): SELECT * FROM authors WHERE submission_id = 20820 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30483'  

CALCULATION OF INTERNAL STATE FINANCIAL LOSS CORRUPTION CRIMINAL ENFORCEMENT

(mysql): SELECT * FROM authors WHERE submission_id = 20820 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30483'  
Siswanto Siswanto

Abstract


The legal regulation of criminal acts of corruption regulates the formulation of offenses for criminal acts of corruption, one of which is the loss of state finances or the country's economy as stated in Article 2 and Article 3 of the Law on the Eradication of Criminal Acts of Corruption. In calculating state financial losses on audited cases by performing: identification of irregularities that occur, identification of transactions, identification, collection, verification, and analysis of evidence, and calculating the amount of state financial losses. The method of calculating state financial losses is basically very diverse according to the modus operandi of corruption cases, including the total loss method, total loss with adjustments, net loss, fair price, cost of goods, opportunity cost. opportunity cost), and interest.


Full Text:

PDF

References


(mysql): SELECT * FROM citation_settings WHERE citation_id = '146892'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146892 ORDER BY metadata_description_id DESC  
(mysql): SELECT * FROM citation_settings WHERE citation_id = '146893'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146893 ORDER BY metadata_description_id DESC  

Budiman Slamet, Metode Penghitungan Kerugian Keuangan Negara Dalam Audit Investigatif, Makalah pada Widyaiswara Madya Pusdiklatwas Badan Pengawasan Keuangan dan Pembangunan di Bogor, 2013.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146894'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146894 ORDER BY metadata_description_id DESC  

Chaerudin, dkk. Strategi Pencegahan dan Penegakan Hukum Tindak Pidana Korupsi, Refika Aditama, Bandung, 2008.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146895'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146895 ORDER BY metadata_description_id DESC  

Deputi Bidang Investigasi Bagian Proyek Penyuluhan Strategi Pencegahan dan Penanggulangan Korupsi, Peran Asosiasi Pengusaha Indonesia Dalam Mencegah dan Menanggulangi Korupsi, Badan Pengawasan Keuangan dan Pembangunan, Jakarta, 2003.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146896'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146896 ORDER BY metadata_description_id DESC  

--------, Petunjuk Pelaksanaan Pemeriksaan Khusus Kasus Penyimpangan Yang Berindikasi Merugikan Keuangan/Kekayaan Negara dan/atau Perekonomian Negara, Badan Pengawasan Keuangan dan Pembangunan, Jakarta, 2001.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146897'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146897 ORDER BY metadata_description_id DESC  

Eddy Mulyadi Soepardi, Memahami Unsur Kerugian Keuangan Negara sebagai Salah Satu Unsur Tindak Pidana Korupsi, Kuliah Umum pada Universitas Pakuan Bogor,24 Januari 2009.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146898'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146898 ORDER BY metadata_description_id DESC  

Elwi Daniel, Korupsi, Konsep, Tindak Pidana dan Pemberantasannya, Raja Grafindo Persada, Jakarta, 2012.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146899'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146899 ORDER BY metadata_description_id DESC  

Emerson Yuntho, Penerapan Unsur Merugikan Keuangan Negara Dalam Delik Tindak Pidana Korupsi, Indonesian Corruption Watch - Yayasan Lembaga Bantuan Hukum Indonesia - Lembaga Bantuan Hukum Semarang, Jakarta, 2014.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146900'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146900 ORDER BY metadata_description_id DESC  

Hans Otto Sano, et.al., Hak Asasi Manusia dan Good Governance, Membangun Suatu Ketertiban, Departemen Hukum dan Hak Asasi Manusia, Jakarta, 2003.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146901'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146901 ORDER BY metadata_description_id DESC  

Harkristuti Harkrisnowo, Korupsi, Konspirasi dan Keadilan di Indonesia, Jurnal Dictum LeIP, Edisi I, Lentera Hati, Jakarta, 2002

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146902'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146902 ORDER BY metadata_description_id DESC  

Leo Nugroho, Mengaji Ulang keberadaan Unsur Merugikan Keuangan Negara dalam Delik Tindak Pidana Korupsi. Focus Group Discussion, 17 September 2013.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146903'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146903 ORDER BY metadata_description_id DESC  

Lilik Mulyadi, Tindak Pidana Korupsi di Indonesia, Normatif, Teoritis, Praktik dan Masalahnya, Alumni, Bandung, 2007

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146904'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146904 ORDER BY metadata_description_id DESC  

---------, Tindak Pidana Korupsi (Tinjauan Khusus Terhadap Proses Penyidikan, Penuntutan, Peradilan Serta Upaya Hukumnya Menurut Undang-Undang Nomor 31 Tahun 1999), Citra Aditya Bakti, Bandung, 2000.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146905'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146905 ORDER BY metadata_description_id DESC  

M. Achsin, Deteksi Fraud & Audit Investigatif, Paparan pada Fakultas Ekonomi dan Bisnis Universitas Ma Chung, Malang, 19 Maret 2016.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146906'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146906 ORDER BY metadata_description_id DESC  

Muchtar Lubis dan James C Scoot, Bunga Rampai Korupsi, LP3ES, Jakarta, 1988

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146907'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146907 ORDER BY metadata_description_id DESC  

Nashriana, Asset Recovery Dalam Tindak Pidana Korupsi : Upaya Pengembalian Kerugian Keuangan Negara, Fakultas Hukum Universitas Brawijaya, Tanpa Tahun.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146908'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146908 ORDER BY metadata_description_id DESC  

Neni Sri Imaniyati, Pengaruh Paradigma Positivisme Terhadap Teori Hukum dan Perkembangannya, Jurnal Mimbar Volume XIX Nomor 3 Juli – Desember 2003

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146909'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146909 ORDER BY metadata_description_id DESC  

Ridwan, Kebijakan Penegakan Hukum Pidana dalam Pemberantasan Tindak Pidana Korupsi di Indonesia, Jurnal Jure Humano, Volume1 Nomor 1 Tahun 2009.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146910'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146910 ORDER BY metadata_description_id DESC  

R. Wiyono, Pembayahasan Undang-Undang Tindak Pidana Korupsi, Sinar Grafika, Jakarta, 2006

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146911'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146911 ORDER BY metadata_description_id DESC  

Shvoong, Pengertian Korupsi dan Tindak Pidana, http://id.shvoong.com/law-and-politics/law/2027081-pengertian-korupsi-dan-tindak-pidana.

(mysql): SELECT * FROM citation_settings WHERE citation_id = '146912'  
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 146912 ORDER BY metadata_description_id DESC  

Sudarto, Kapita Selekta Hukum Pidana, Bandung, Alumni, 1991.

Sudikno Mertokusumo, Mengenal Hukum Suatu Pengantar, Liberty, Yogyakarta, 1996.




DOI: http://dx.doi.org/10.26532/pdih.v4i4.20820
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa INNER JOIN articles a ON pa.article_id = a.article_id LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') 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 WHERE ast.setting_name = 'pub-id::publisher-id' AND ast.setting_value = '20820' ORDER BY pa.issue_id, a.article_id  
(mysql): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = 'title' AND stpl.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 sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US') LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US') WHERE pa.article_id = a.article_id AND a.article_id = 20820  
(mysql): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = 20820 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '8000'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20820'  
(mysql): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 20820 ORDER BY s.seq  
(mysql): SELECT r.* FROM referrals r WHERE r.article_id = 20820 AND r.status = 2  

Refbacks

  • There are currently no refbacks.
(mysql): UPDATE sessions SET user_id = NULL, ip_address = '216.73.216.3', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', created = 1758105900, last_used = 1758106008, remember = 0, data = '', domain = 'jurnal.unissula.ac.id' WHERE session_id = '2kjjv00ev3stl38pheicnapar3'