(mysql): SELECT * FROM sessions WHERE session_id = 'c9j6tcg587v8qonm8g4qkmueq7'  
(mysql): INSERT INTO sessions (session_id, ip_address, user_agent, created, last_used, remember, data, domain) VALUES ('c9j6tcg587v8qonm8g4qkmueq7', '216.73.216.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1758102738, 1758102738, 0, '', 'jurnal.unissula.ac.id')  
(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 = '4176' 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 = 4176  
(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 = 4176 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '3055'  
(mysql): SELECT * FROM article_settings WHERE article_id = '4176'  
(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 = 4176 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 = '339' ORDER BY i.issue_id  
(mysql): SELECT i.* FROM issues i WHERE issue_id = 339  
(mysql): SELECT * FROM issue_settings WHERE issue_id = '339'  
(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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= 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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= 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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= 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 = 4176  
(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 = '4176' 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 = 4176  
(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 = 4176 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '3055'  
(mysql): SELECT * FROM article_settings WHERE article_id = '4176'  
(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 = 4176 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 = '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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= 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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= 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 09:52:24' >= s.date_start AND '2025-09-17 09:52:24' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))  
(mysql): SELECT * FROM citations WHERE assoc_type = 257 AND assoc_id = 4176 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()  
Pengenalan printing 3D dan software Autodesk Fusion untuk guru dan siswa SMK di eks karisidenan Surakarta | <hr /> (mysql): SELECT * FROM authors WHERE submission_id = 4176 ORDER BY seq   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '6817'   <hr /> <hr /> (mysql): SELECT * FROM author_settings WHERE author_id = '7280'   <hr /> Saputra | Indonesian Journal of Community Services
(mysql): SELECT * FROM authors WHERE submission_id = 4176 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'  
(mysql): SELECT * FROM author_settings WHERE author_id = '7280'  
(mysql): SELECT * FROM authors WHERE submission_id = 4176 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'  
(mysql): SELECT * FROM author_settings WHERE author_id = '7280'  

Pengenalan printing 3D dan software Autodesk Fusion untuk guru dan siswa SMK di eks karisidenan Surakarta

(mysql): SELECT * FROM authors WHERE submission_id = 4176 ORDER BY seq  
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'  
(mysql): SELECT * FROM author_settings WHERE author_id = '7280'  
Onery Andy Saputra, Sudiro Sudiro

Abstract


Abstrak

Salah satu teknologi yang saat ini mulai dimanfaatkan masyarakat untuk memproduksi komponen yaitu printing tiga dimensi. Printing tiga dimensi merupakan alat bantu membuat komponen otomotif dari desain tiga dimensi menjadi komponen nyata. Kebermanfaatan alat printing 3 dimensi ini ke depan sangat besar, pada saat membutuhkan komponen kita hanya perlu mendesain komponen tersebut didalam aplikasi dan selanjutnya dicetak menggunakan printing tiga dimensi. Permasalahan guru dan siswa SMK otomotif yang membutuhkan komponen otomotif yang langka dapat diantisipasi dengan penggunaan printing tiga dimensi. Alat printing tiga dimensi mampu membuat komponen sesuai dengan kebutuhan dari guru dan siswa. Sehingga guru dan siswa otomotif memerlukan pengetahuan dan pelatihan mengenai printing tiga dimensi beserta cara pembuatan komponen dengan alat printing tiga dimensi. Sehingga pelatihan printing tiga dimensi sangat bermanfaat bagi siswa dan guru. Tempat pelaksanaan pelatihan dilakukan di Laboratorium Politeknik Indonusa Surakarta. Waktu pelaksanaan pelatihan adalah tanggal 3 November 2018. Peserta pelatihan yaitu guru dan siswa SMK se-karisidenan Surakarta, dengan jumlah guru 12 dan siswa sebanyak 10 siswa dari SMK-SMK di wilayah Surakarta. Pelatihan dilakukan dengan metode penyampaian materi serta pelatihan dan diskusi. Hasil pelaksanaan pelatihan ini yaitu peserta pelatihan mendapatkan pengetahuan dan wawasan mengenai software untuk desain 3 Dimensi yang gratis untuk dunia pendidikan. Peserta juga mendapatkan keterampilan membuat desain 3 Dimensi dalam aplikasi Autodesk Fusion 360. Serta keterampilan yang diperoleh oleh peserta yaitu keterampilan pembuatan desain 3 dimensi sekaligus melakukan cetak desain yang dibuat menjadi benda yang nyata dalam bentuk 3 dimensi.

 

Kata kunci: 3D; printing; pelatihan; guru.

 

Abstract

One technology that is currently being used by the community to produce components is to print three dimensions. Printing three dimensions into a tool makes automotive components from three-dimensional design a real component. The usefulness of this 3-dimensional printing tool is very large, when a component is needed we only need to design the component in the application and then need to use three-dimensional printing. The problem of automotive vocational teachers and students who need automotive components that can be anticipated by using three-dimensional printing. Three-dimensional printing tools are able to make components according to the needs of the teacher and students. Related to automotive teachers and students, knowledge and training about three-dimensional printing is needed in how to make components with three-dimensional printing. Printing three-dimensional training is very beneficial for students and teachers. The place for conducting the training was conducted at the Indonusa Surakarta Polytechnic Laboratory. The time for the training is November 3, 2018. The trainees are vocational teachers and students from Surakarta residency, with 12 teachers and 10 students from Vocational Schools in the Surakarta region. The training was conducted with the method of delivering material and training and discussion. The results of the training are that trainees gain knowledge and insights about software for 3-dimensional design that is free for the world of education. Participants also obtained 3-dimensional design skills in the Autodesk Fusion 360 application. As well as the skills gained by participants, they were three-dimensional design skills to create designs that were made into real objects in 3-dimensional form.

 

Keywords: 3D; printing; training; teacher

Keywords


3D; printing, training, teacher

Full Text:

PDF

References


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

Anto. (2018). Norisanto.com. Norisanto.com, pp. 1–9, 09-Nov-2018.

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

Ahmadi, A. (2016). Menghaluskan hasil 3D Print. pp. 1–9, 2016.

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

Prasetyo, W. S. H. (2018). Industri 4.0: Telaah Klasifikasi Aspek Dan Arah Perkembangan Riset,†J. Tek. Ind., vol. 13, no. 1, p. 372.

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

Arthaya, B., & Fransiscus, E.H. (2015). E. Kemampuan, D. A. N. Kapasitas, P. Dalam, P. Modul, R. Dan, and B. A. B. I. Pendahuluan. Lembaga Penelitian dan Pengabdian kepada Masyarakat Universitas Katolik Parahyangan,†pp. 1–34, 2015.

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

Buncio, A. D. “3D Printing in the Construction Industry | VIATechnik,†2018.

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

Dewayana, T. S., Sugiarto, D., and Hetharia, D. (2012). Peluang dan Tantangan Industri Komponen Otomotif Indonesia, Pros. Semin., vol. 1, no. 2.

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

Fakhri, E. and Yufridawati. (2003). Relevansi Kompetensi dan Tingkat Daya Saing Lulusan SMK dalam Dunia Kerja ( Studi kasus pada SMK Teknik Otomotif di empat kabupaten / kota ), pp. 1–18, 2003.

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

Kemenperin, Industri Otomotif Ketergantungan Komponen Impor. pp. 3–5, 2018.

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

R. Indonesia, (2019). Solo. pp. 1–5.

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

Slameto, S., Rasional dan Elemen Perubahan Kurikulum 2013. (2017). Sch. J. Pendidik. dan Kebud., vol. 5, no. 1, p. 1.

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

Tay, Y. W. D. et al. (2017). 3D printing trends in building and construction industry: a review. Virtual Phys. Prototyp., Vol. 12, no. 3, pp. 261–276.

Wattimena, R. M. (2019). Analisa Pembuatan Serbuk Tembaga Hasil Proses Electrorefining Metode Laboratorium, J. Politek. Negeri Semarang, pp. 1–5, 2019.




DOI: http://dx.doi.org/10.30659/ijocs.1.1.83-94
(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 = '4176' 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 = 4176  
(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 = 4176 ORDER BY g.seq  
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '3055'  
(mysql): SELECT * FROM article_settings WHERE article_id = '4176'  
(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 = 4176 ORDER BY s.seq  
(mysql): SELECT r.* FROM referrals r WHERE r.article_id = 4176 AND r.status = 2  

Refbacks

  • There are currently no refbacks.


Copyright (c) 2019 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 = 1758102738, last_used = 1758102738, remember = 0, data = '', domain = 'jurnal.unissula.ac.id' WHERE session_id = 'c9j6tcg587v8qonm8g4qkmueq7'