(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 = 'customblockmanagerplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'referralplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'tinymceplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'objectsforreviewplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'pdfjsviewerplugin' 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 = '20809' 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 = 20809  
(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 = 20809 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6904'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20809'  
(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 = 20809 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= 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 = 20809  
(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 = '20809' 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 = 20809  
(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 = 20809 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6904'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20809'  
(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 = 20809 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= 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:45:07' >= s.date_start AND '2025-09-17 10:45:07' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM citations WHERE assoc_type = 257 AND assoc_id = 20809 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 setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'doipubidplugin' AND journal_id = '922'  
(mysql): select version()  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'informationblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'navigationblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'roleblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'subscriptionblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'userblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'donationblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'languagetoggleblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'isbn' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'no isbn' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND journal_id = '922'  
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'webfeedblockplugin' AND journal_id = '922'  
AUTHORITY OF LOCAL GOVERNMENTS IN EMPOWERING INTELLECTUAL PROPERTY PRODUCTS OF SMALL MEDIUM ENTERPRISES FOR ECONOMIC IMPROVEMENT IN THE ERA OF DISRUPTION | <hr /> (mysql): SELECT * FROM authors WHERE submission_id = 20809 ORDER BY seq   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '30465'   <hr /> Mashdurohatun | The 4th Legal Internasional Conference and Studies
(mysql): SELECT * FROM authors WHERE submission_id = 20809 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30465'  
(mysql): SELECT * FROM authors WHERE submission_id = 20809 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30465'  

AUTHORITY OF LOCAL GOVERNMENTS IN EMPOWERING INTELLECTUAL PROPERTY PRODUCTS OF SMALL MEDIUM ENTERPRISES FOR ECONOMIC IMPROVEMENT IN THE ERA OF DISRUPTION

(mysql): SELECT * FROM authors WHERE submission_id = 20809 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '30465'  
Anis Mashdurohatun

Abstract


This study aims to examine and analyze the authority of local governments in empowering the Intellectual Property of SME products in order to increase the economy in the era of disruption. This study uses a social legal research approach. The data used are primary and secondary data. Analysis of the data descriptively analytical. The theory used is the theory of authority, the theory of the legal system. The results of the study found that the authority of local governments in empowering Intellectual Property of SMEs products legally has been regulated in local government laws, the Job Creation Law and the Law on MSMEs, while improving the economy in the era of disruption needs to be strengthened in digital data collection, assistance and registration of IPR for SME products in particular, funding and strengthening technology and markets for SME products and Optimization of the IKM E-Smart Program.


Full Text:

PDF

References


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

Azhari, Abdul Kholiq. Negoro, Abdul Haris Suryo, Desentralisasi dan Otonomi Daerah di Negara Kesatuan Republik Indonesia (Malang: Intrans Publishing,2019), 29.

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

Sanjaya, Wiliam. “Konstitusionalitas Pengaturan Dekonsentrasi Dalam Undang-Undang 23 Tahun 2014 Tentang Pemerintahan Daerah.†PADJADJARAN Jurnal Ilmu Hukum 2, No.3 (2015): 584-597

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

Lexy J. Moeleong “Metode Penelitian Kualitatif†Remaja Rosdakarya, Bandung, 2014, page 4

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

Sugiyono, Memahami Penelitian Kualitatif, Dilengkapi Contoh Proposal dan Laporan Penelitian, Alfabeta, Bandung, 2015, page 25

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

Bambang Sunggono, Metode Penelitian Hukum, Rajawali Press, Jakarta, 1997, page 103.

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

Brian Z Tamahana “ Realistic Socio-Legal Theory Pragmatism and a Social Theory of Law, Oxford University Press, New York, 1997, page 1

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

X. Adjie Samekto, Opcit. Page .62, Baca juga Cavendish, 1997, Law Cards Jurisprudence, Cavendish Publishing Limited, The Glass House, Warthon Strees London, page. 129-130

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

Esmi Warassih, Penelitian Socio-Legal; Dinamika Sejarah dan Perkembangnnya, Tulisan Ilmiah yang tidak dipublikasikan, page 5

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

Mukti Fajar ND dan Yulianto Achmad “ Dualisme Penelitian Hukum Normatif dan Empiris, Yogyakarya, 2010, page156

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

Sanapiah Faisal, Format-format Penelitian Sosial, Dasar-dasar dan Aplikasi, Rajawali Press, Jakarta, page 135, lihat juga Masri Singarimbun dan Sofian Effendi (Editor), Metode Penelitian Survai, LP3ES, Edisi Revisi, Yogyakarta, 1987, page 192.

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

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

A. Stauss and J. Corbin Busir, Qualitative Research: Grounded Theory Prosedure and Technique, Lindon Sage Publication, 1990, page 19

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

Mattew B. Miles & A. Michael Huberman, Analisis Data Kualitatif, UI Press, Jakarta, 1992, page 22

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

Miriam Budiardjo, Dasar-Dasar Ilmu Politik, Jakarta: Gramedia Pustaka Utama, 2008, page. 35

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

Aminuddin Ilmar, Hukum Tata Pemerintahan, Makassar:

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

Universitas Hasanuddin, 2013, page. 115

Juniarso Ridwan dan Achmad Sodik Sudrajat, Hukum Administrasi Negara dan Kebijakan Pelayanan Publik, Bandung: Nuansa, 2012, page. 136




DOI: http://dx.doi.org/10.26532/pdih.v4i4.20809
(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 = '20809' 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 = 20809  
(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 = 20809 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '6904'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20809'  
(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 = 20809 ORDER BY s.seq  
(mysql): SELECT r.* FROM referrals r WHERE r.article_id = 20809 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 = 1758105902, remember = 0, data = '', domain = 'jurnal.unissula.ac.id' WHERE session_id = '2kjjv00ev3stl38pheicnapar3'