(mysql): SELECT * FROM sessions WHERE session_id = 'iuo79ve8tvjgea4kbi6v8ofrk3'  
(mysql): SELECT * FROM journals WHERE path = 'ijocs'  
(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 = '56') 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 = '56'  
(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 = '20486' 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 = 20486  
(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 = 20486 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7562'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20486'  
(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 = 20486 ORDER BY s.seq  
(mysql): SELECT * FROM article_supp_file_settings WHERE supp_id = '3931'  
(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 = '741' ORDER BY i.issue_id  
(mysql): SELECT i.* FROM issues i WHERE issue_id = 741  
(mysql): SELECT * FROM issue_settings WHERE issue_id = '741'  
(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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= 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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= 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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM sections WHERE section_id = '119'  
(mysql): SELECT * FROM section_settings WHERE section_id = '119'  
(mysql): SELECT * FROM rt_versions WHERE version_id = 1052 AND journal_id = 56  
(mysql): SELECT * FROM rt_contexts WHERE version_id = 1052 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13660 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13661 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13662 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13663 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13664 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13665 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13666 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13667 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13668 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13669 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13670 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13671 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13672 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13673 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13674 ORDER BY seq  
(mysql): SELECT * FROM rt_searches WHERE context_id = 13675 ORDER BY seq  
(mysql): SELECT * FROM sections WHERE section_id = '119'  
(mysql): SELECT * FROM section_settings WHERE section_id = '119'  
(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 = 20486  
(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 = '20486' 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 = 20486  
(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 = 20486 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7562'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20486'  
(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 = 20486 ORDER BY s.seq  
(mysql): SELECT * FROM article_supp_file_settings WHERE supp_id = '3931'  
(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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= 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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= 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 = '56' 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:24:34' >= s.date_start AND '2025-09-17 10:24:34' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM citations WHERE assoc_type = 257 AND assoc_id = 20486 AND citation_state >= 0 AND citation_state <= 5 ORDER BY seq, citation_id  
(mysql): SELECT * FROM sections WHERE section_id = '119'  
(mysql): SELECT * FROM section_settings WHERE section_id = '119'  
(mysql): SELECT i.* FROM issues i WHERE journal_id = 56 AND current = 1  
(mysql): SELECT * FROM issue_settings WHERE issue_id = '1164'  
(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 = '56') OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)  
(mysql): select version()  
Ecobrick sebagai Solusi Sampah Plastik di Desa Temuroso Kecamatan Guntur, Demak | <hr /> (mysql): SELECT * FROM authors WHERE submission_id = 20486 ORDER BY seq   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '29825'   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '29826'   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '29827'   <hr /> Anik | Indonesian Journal of Community Services
(mysql): SELECT * FROM authors WHERE submission_id = 20486 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '29825'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29826'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29827'  
(mysql): SELECT * FROM authors WHERE submission_id = 20486 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '29825'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29826'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29827'  

Ecobrick sebagai Solusi Sampah Plastik di Desa Temuroso Kecamatan Guntur, Demak

(mysql): SELECT * FROM authors WHERE submission_id = 20486 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '29825'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29826'  
(mysql): SELECT * FROM author_settings WHERE author_id = '29827'  
Sri Anik, Wasitowati Wasitowati, Sri Ayuni

Abstract


Pengabdian masyarakat ini dilakukan sebagai upaya untuk mengurangi sampah plastik Didesa Temuroso Guntur Kabupaten Demak dengan ecobrick. Salah satu persoalaan yang dihadapi oleh sebagian besar masyarakat termasuk masyarakat di desa Temuroso Kecamatan Guntur Kabupaten Demak adalah sampah. Sampah merupakan persoalan klasik yang dari dulu hingga  saat ini menjadi masalah bersama di Indonesia maupun seluruh dunia. Indonesia sebagai negara berkembang, permasalahan sampah harusnya mendapat perhatian lebih, dan salah satu jenis sampah yang harus mendapat perhatian lebih adalah sampah plastik. Ecobrick merupakan pemanfaatan sampah plastik ramah lingkungan yang dijadikan sebagai barang berguna seperti kursi, meja. Selain itu  tujuan dari pengabdian masyarakat ini juga  merasakan manfaat dari pembuatan ecobrick tersebut dan tidak hanya sekedar untuk mengurangi sampah plastik saja. Metode pelaksanaan kegiatan pengabdian masyarakat di desa Temuroso Kecamatan Guntur Demak tentang pengelolaan sampah dengan ecobrick ini dilakukan dengan metode luring dan berbasis kelompok yang dipandu oleh narasumber yang kompeten. Berbasis Kelompok yaitu seluruh kegiatan pengabdian masyarakat ini dilakukan dengan menggunakan kelompok sebagai media belajar dan pendampingan, dan memonitor kegiatan. Kegiatan pengabdian masyarakat ini mendapat respon dan atusias dari peserta dengan  praktik membuat ecobrick, hal ini dibuktikan dengan ecobrick yang dihasilkan didaftarkan di web ecobrick dunia dengan no serialnya: 174630 (dengan berat 304 gram) dan 174632 (dengan berat 262 gram). Selanjutnya ecobrick- ecobrick yang sudah dibuat  dan dirangkai  menjadi satu produk  ecobrick yaitu tempat duduk, sehingga  dengan kegiatan ini  masalah sampah plastik di desa Temuroso Kecamatan Guntur Kabupaten Demak    Jawa Tengah dapat teratasi. Dengan menggunakan analisis potensi ecobrick (Bella et al., 2019) maka sampah plastik di Desa Temuroso Kecamatan Guntur Kabupaten Demak Jawa Tengah dapat dikurangi sebesar 45 % dari total timbunan sampah plastik di desa tersebut. 

This community service was carried out as an effort to reduce plastic waste in Temuroso Guntur Village, Demak Regency with ecobrick. One of the problems faced by most people, including the people in Temuroso Village, Guntur District, Demak Regency, is waste. Garbage is a classic problem that has always been a common problem in Indonesia and throughout the world. Indonesia as a developing country, waste problems should receive more attention, and one type of waste that should receive more attention is plastic waste. Ecobrick is the utilization of environmentally friendly plastic waste which is used as useful items such as chairs, tables. Besides that, the purpose of this community service is also to feel the benefits of making ecobrick and not just to reduce plastic waste. The method of implementing community service activities in Temuroso Village, Guntur Demak District regarding waste management with ecobrick is carried out using an offline and group-based method guided by competent resource persons. Group-Based, that is, all community service activities are carried out using groups as learning and mentoring media, and monitoring activities. This community service activity received response and enthusiasm from participants with the practice of making ecobricks, this is evidenced by the ecobricks produced being registered on the world ecobrick web with serial numbers: 174630 (with a weight of 304 grams) and 174632 (with a weight of 262 grams). Furthermore, the ecobricks that have been made and assembled into one ecobrick product, namely a chair, so that with this activity the problem of plastic waste in Temuroso Village, Guntur District, Demak Regency, Central Java, can be resolved. By using an ecobrick potential analysis (Bella et al, 2019), plastic waste in Temuroso Village, Guntur District, Demak Regency, Central Java, can be reduced by 45% of the total pile of plastic waste in the village.


Keywords


Temuroso Village; plastic waste; management; ecobricks

Full Text:

PDF

References


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

Bella. (2019). Potensi Ecobrick Dalam mengurangi Sampah plastik Rumah Tangga di Kecamatan Pontianak Barat. Jurnal Teknologi Lingkungan Lahan Basah, Vol. 07, No. 2, pp. 055-063.

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

Fatchurrahman. (2018). Article Manajemen Pengelolaan Sampah Berkelanjutan Melalui Inovasi Ecobrick:9.

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

Jambeck, J. R., Geyer, R., Wilcox, C., Siegler, T. R., Perryman, M., Andrady, A., ... & Law, K. L. (2015). Plastic waste inputs from land into the ocean. Science, 347(6223), 768-771. https://science.sciencemag.org/CONTENT/347/6223/768.abstract.

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

Jenna, et al. (2015). Plastic Waste Inputs From Land Into The Ocean. Vol. 347, Issue 6223, pp. 768-771.

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

Maier, Russell, Irene Angway. (2017). The Vision Ecobricks Construction Guide. Tersedia pada https://www.ecobricks.org.

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

PP no 27 tahun 2020 tentang Pengelolaan sampah plastik.

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

Safitri, P. A. (2018). Statistik Lingkungan Hidup Indonesia 2018. Pengelolaan Sampah di Indonesia. Badan Pusat Statistik.

Suminto, S. (2017). Ecobrick: solusi cerdas dan kreatif untuk mengatasi sampah plastik. Jurnal Desain Produk (Pengetahuan dan Perancangan Produk). Vol. 3, No. 1, Edisi Januari-Juni 2017.




DOI: http://dx.doi.org/10.30659/ijocs.4.2.212-218
(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 = '20486' 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 = 20486  
(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 = 20486 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '7562'  
(mysql): SELECT * FROM article_settings WHERE article_id = '20486'  
(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 = 20486 ORDER BY s.seq  
(mysql): SELECT * FROM article_supp_file_settings WHERE supp_id = '3931'  
(mysql): SELECT r.* FROM referrals r WHERE r.article_id = 20486 AND r.status = 2  

Refbacks

  • There are currently no refbacks.


Copyright (c) 2022 Indonesian Journal of Community Services

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

(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 = 1758104656, last_used = 1758104669, remember = 0, data = '', domain = 'jurnal.unissula.ac.id' WHERE session_id = 'iuo79ve8tvjgea4kbi6v8ofrk3'