THE IMPACT OF EMOTIONAL INTELLIGENCE, TEACHER-STUDENT RELATIONSHIPS, PARENTAL INVOLVEMENT, AND CLASSROOM CLIMATE ON PRESCHOOLERS' SOCIAL-EMOTIONAL DEVELOPMENT
Abstract
This research aims to examine the influence of emotional intelligence, teacher-student relationships, parental involvement, and classroom climate on the social-emotional development of Indonesian preschool children in Sukabumi Regency. A total of 80 preschool children and their parents were recruited as participants. Data were collected using a questionnaire and analyzed with SPSS. The results of the study showed that emotional intelligence, teacher-student relationships, parental involvement, and classroom climate have a positive and significant effect on the social-emotional development of Indonesian preschool children. Specifically, higher emotional intelligence, positive teacher-student relationships, greater parental involvement, and a positive classroom climate were associated with better socio-emotional development in preschool children. The findings highlight the importance of focusing on these factors in early childhood education programs to promote the social-emotional development of preschool children in Indonesia.
Keywords
Full Text:
PDFReferences
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232874'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232874 ORDER BY metadata_description_id DESC
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232875'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232875 ORDER BY metadata_description_id DESC
Back, L. T., Polk, E., Keys, C. B., & McMahon, S. D. (2016). Classroom management, school staff relations, school climate, and academic achievement: Testing a model with urban high schools. Learning Environments Research, 19, 397–410.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232876'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232876 ORDER BY metadata_description_id DESC
Berkowitz, R., Astor, R. A., Pineda, D., DePedro, K. T., Weiss, E. L., & Benbenishty, R. (2021). Parental involvement and perceptions of school climate in California. Urban Education, 56(3), 393–423.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232877'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232877 ORDER BY metadata_description_id DESC
Corkin, D. M., Shirley, L. Y., Wolters, C. A., & Wiesner, M. (2014). The role of the college classroom climate on academic procrastination. Learning and Individual Differences, 32, 294–303.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232878'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232878 ORDER BY metadata_description_id DESC
Curby, T. W., Brown, C. A., Bassett, H. H., & Denham, S. A. (2015). Associations between preschoolers’ social–emotional competence and preliteracy skills. Infant and Child Development, 24(5), 549–570.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232879'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232879 ORDER BY metadata_description_id DESC
Denham, S. A., Bassett, H. H., Thayer, S. K., Mincic, M. S., Sirotkin, Y. S., & Zinsser, K. (2012). Observing preschoolers’ social-emotional behavior: Structure, foundations, and prediction of early school success. The Journal of Genetic Psychology, 173(3), 246–278.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232880'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232880 ORDER BY metadata_description_id DESC
Denham, S. A., Bassett, H. H., Zinsser, K., & Wyatt, T. M. (2014). How preschoolers’ social–emotional learning predicts their early school success: Developing theoryâ€promoting, competencyâ€based assessments. Infant and Child Development, 23(4), 426–454.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232881'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232881 ORDER BY metadata_description_id DESC
Dias Rodrigues, A., Cruz-Ferreira, A., Marmeleira, J., & Veiga, G. (2022). Effects of Body-Oriented Interventions on Preschoolers’ Social-Emotional Competence: A Systematic Review. Frontiers in Psychology, 12, 6508.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232882'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232882 ORDER BY metadata_description_id DESC
Djigic, G., & Stojiljkovic, S. (2011). Classroom management styles, classroom climate and school achievement. Procedia-Social and Behavioral Sciences, 29, 819–828.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232883'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232883 ORDER BY metadata_description_id DESC
Elias, M. J., & Arnold, H. (2006). The educator’s guide to emotional intelligence and academic achievement: Social-emotional learning in the classroom. Corwin Press.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232884'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232884 ORDER BY metadata_description_id DESC
Fauziah, P. Y., Kusumawardani, E., Nopembri, S., Mulyawan, R., Susilowati, I. H., Nugraha, S., Alimoeso, S., Hasiholan, B. P., Fauzi, L., & Cahyati, W. H. (2022). Play–Sleep Nexus in Indonesian Preschool Children before and during the COVID-19 Pandemic. International Journal of Environmental Research and Public Health, 19(17), 10695.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232885'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232885 ORDER BY metadata_description_id DESC
Ferdinand, F. V., & Lukas, S. (2020). HUBUNGAN ANTARA CLASSROOM ENVIRONMENT, TEACHER-STUDENT INTERPERSONAL BEHAVIOR, SERTA PRESTASI BELAJAR MAHASISWA PROGRAM STUDI MATEMATIKA [THE RELATIONSHIP BETWEEN THE CLASSROOM ENVIRONMENT AND TEACHER-STUDENT INTERPERSONAL BEHAVIOR ON THE LEARNING ACHIEVE. JOHME: Journal of Holistic Mathematics Education, 3(2), 127–145.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232886'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232886 ORDER BY metadata_description_id DESC
Firman, F., Mirnawati, M., Sukirman, S., & Aswar, N. (2020). The Relationship Between Student Learning Types and Indonesian Language Learning Achievement in FTIK IAIN Palopo Students. Jurnal Konsepsi, 9(1), 1–12.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232887'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232887 ORDER BY metadata_description_id DESC
Gershon, P., & Pellitteri, J. (2018). Promoting Emotional Intelligence in Preschool Education: A Review of Programs. International Journal of Emotional Education, 10(2), 26–41.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232888'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232888 ORDER BY metadata_description_id DESC
Goleman, D. (2001). Emotional intelligence: Issues in paradigm building. The Emotionally Intelligent Workplace, 13, 26.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232889'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232889 ORDER BY metadata_description_id DESC
Goleman, D. (2020). Emotional intelligence. Bloomsbury Publishing.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232890'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232890 ORDER BY metadata_description_id DESC
Green, C. L., Walker, J. M. T., Hoover-Dempsey, K. V, & Sandler, H. M. (2007). Parents’ motivations for involvement in children’s education: An empirical test of a theoretical model of parental involvement. Journal of Educational Psychology, 99(3), 532.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232891'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232891 ORDER BY metadata_description_id DESC
Haider Syed, M., Khan, S., Raza Rabbani, M., & Thalassinos, Y. E. (2020). An artificial intelligence and NLP based Islamic FinTech model combining Zakat and Qardh-Al-Hasan for countering the adverse impact of COVID 19 on SMEs and individuals.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232892'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232892 ORDER BY metadata_description_id DESC
Haidet, P., & Stein, H. F. (2006). The role of the student-teacher relationship in the formation of physicians: the hidden curriculum as process. Journal of General Internal Medicine, 21(Suppl 1), 16–20.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232893'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232893 ORDER BY metadata_description_id DESC
Hamre, B. K., & Pianta, R. C. (2006). Student-Teacher Relationships.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232894'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232894 ORDER BY metadata_description_id DESC
Henderson, A. T., & Mapp, K. L. (2002). A New Wave of Evidence: The Impact of School, Family, and Community Connections on Student Achievement. Annual Synthesis, 2002.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232895'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232895 ORDER BY metadata_description_id DESC
Hill, N. E., & Tyson, D. F. (2009). Parental involvement in middle school: a meta-analytic assessment of the strategies that promote achievement. Developmental Psychology, 45(3), 740.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232896'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232896 ORDER BY metadata_description_id DESC
Im, G. W., Jiar, Y. K., & Talib, R. B. (2019). Development of Preschool Social Emotional Inventory for Preschoolers: A Preliminary Study. International Journal of Evaluation and Research in Education, 8(1), 158–164.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232897'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232897 ORDER BY metadata_description_id DESC
Jamieson, D. W., & Thomas, K. W. (1974). Power and conflict in the student-teacher relationship. The Journal of Applied Behavioral Science, 10(3), 321–336.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232898'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232898 ORDER BY metadata_description_id DESC
Jeynes, W. H. (2005). A meta-analysis of the relation of parental involvement to urban elementary school student academic achievement. Urban Education, 40(3), 237–269.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232899'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232899 ORDER BY metadata_description_id DESC
Kariou, A., Koutsimani, P., Montgomery, A., & Lainidi, O. (2021). Emotional labor and burnout among teachers: A systematic review. International Journal of Environmental Research and Public Health, 18(23), 12760.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232900'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232900 ORDER BY metadata_description_id DESC
Kung, H.-Y., & Lee, C.-Y. (2016). Multidimensionality of parental involvement and children’s mathematics achievement in Taiwan: Mediating effect of math self-efficacy. Learning and Individual Differences, 47, 266–273.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232901'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232901 ORDER BY metadata_description_id DESC
Kusaeri, K., Aditomo, A., Ridho, A., & Fuad, A. (2018). Socioeconomic status, parental involvement in learning and student’mathematics achievement in Indonesian senior high school. Cakrawala Pendidikan Jurnal Ilmiah Pendidikan, 37(3), 333–344.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232902'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232902 ORDER BY metadata_description_id DESC
Laka, L. (2020). The Influence of Parental Involvement, Teacher, and Peer Support on Mastery Goal Orientation and Self-Efficacy among Vocational High School Students. SAPA-Jurnal Kateketik Dan Pastoral, 5(2), 13–28.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232903'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232903 ORDER BY metadata_description_id DESC
Longobardi, S., Pagliuca, M. M., & Regoli, A. (2022). School climate and academic performance of Italian students: the role of disciplinary behaviour and parental involvement. Statistical Methods & Applications, 31(5), 1355–1373.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232904'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232904 ORDER BY metadata_description_id DESC
Madigan, D. J., & Kim, L. E. (2021). Does teacher burnout affect students? A systematic review of its association with academic achievement and student-reported outcomes. International Journal of Educational Research, 105, 101714.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232905'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232905 ORDER BY metadata_description_id DESC
Maulana, R., Irnidayanti, Y., Fokkens-Bruinsma, M., & Helms-Lorenz, M. (2018). Indonesian students’ academic engagement and the role of teachers’ teaching behavior in secondary education. In Asian Education Miracles (pp. 63–83). Routledge.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232906'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232906 ORDER BY metadata_description_id DESC
Maulana, R., Opdenakker, M.-C., den Brok, P., & Bosker, R. (2011). Teacher–student interpersonal relationships in Indonesia: profiles and importance to student motivation. Asia Pacific Journal of Education, 31(01), 33–49.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232907'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232907 ORDER BY metadata_description_id DESC
Nix, R. L., Bierman, K. L., Domitrovich, C. E., & Gill, S. (2013). Promoting children’s social-emotional skills in preschool can enhance academic and behavioral functioning in kindergarten: Findings from Head Start REDI. Early Education & Development, 24(7), 1000–1019.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232908'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232908 ORDER BY metadata_description_id DESC
Piqueras, J. A., Mateu-MartÃnez, O., Cejudo, J., & Pérez-González, J.-C. (2019). Pathways into psychosocial adjustment in children: Modeling the effects of trait emotional intelligence, social-emotional problems, and gender. Frontiers in Psychology, 10, 507.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232909'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232909 ORDER BY metadata_description_id DESC
Poulou, M. S., Bassett, H. H., & Denham, S. A. (2018). Teachers’ perceptions of emotional intelligence and social-emotional learning: Students’ emotional and behavioral difficulties in US and Greek preschool classrooms. Journal of Research in Childhood Education, 32(3), 363–377.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232910'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232910 ORDER BY metadata_description_id DESC
Pujiastuti, S. I., Hartati, S., & Wang, J. (2022). Socioemotional competencies of Indonesian preschoolers: Comparisons between the pre-pandemic and pandemic periods and among DKI Jakarta, DI Yogyakarta and West Java provinces. Early Education and Development, 33(5), 877–892.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232911'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232911 ORDER BY metadata_description_id DESC
Rademacher, A., & Koglin, U. (2018). The concept of self-regulation and preschoolers’ social-emotional development: A systematic review. Early Child Development and Care.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232912'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232912 ORDER BY metadata_description_id DESC
Ren, L., & Xu, W. (2019). Coparenting and Chinese preschoolers’ social-emotional development: Child routines as a mediator. Children and Youth Services Review, 107, 104549.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232913'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232913 ORDER BY metadata_description_id DESC
Reyes, M. R., Brackett, M. A., Rivers, S. E., White, M., & Salovey, P. (2012). Classroom emotional climate, student engagement, and academic achievement. Journal of Educational Psychology, 104(3), 700.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232914'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232914 ORDER BY metadata_description_id DESC
Rhoades, B. L., Greenberg, M. T., & Domitrovich, C. E. (2009). The contribution of inhibitory control to preschoolers’ social–emotional competence. Journal of Applied Developmental Psychology, 30(3), 310–320.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232915'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232915 ORDER BY metadata_description_id DESC
Rodrigues, A. P., Jorge, F. E., Pires, C. A., & António, P. (2019). The contribution of emotional intelligence and spirituality in understanding creativity and entrepreneurial intention of higher education students. Education+ Training, 61(7/8), 870–894.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232916'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232916 ORDER BY metadata_description_id DESC
Schmid, R. (2018). Pockets of excellence: Teacher beliefs and behaviors that lead to high student achievement at low achieving schools. Sage Open, 8(3), 2158244018797238.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232917'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232917 ORDER BY metadata_description_id DESC
Shala, M. (2013). The impact of preschool social-emotional development on academic success of elementary school students. Psychology, 4(11), 787.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232918'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232918 ORDER BY metadata_description_id DESC
Sharma, J., Dhar, R. L., & Tyagi, A. (2016). Stress as a mediator between work–family conflict and psychological health among the nursing staff: Moderating role of emotional intelligence. Applied Nursing Research, 30, 268–275.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232919'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232919 ORDER BY metadata_description_id DESC
Ștefan, C. A., Dănilă, I., & Cristescu, D. (2022). Classroom-Wide School Interventions for Preschoolers’ Social-Emotional Learning: A Systematic Review of Evidence-Based Programs. Educational Psychology Review, 34(4), 2971–3010.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232920'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232920 ORDER BY metadata_description_id DESC
Tazouti, Y., & Jarlégan, A. (2019). The mediating effects of parental self-efficacy and parental involvement on the link between family socioeconomic status and children’s academic achievement. Journal of Family Studies, 25(3), 250–266.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232921'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232921 ORDER BY metadata_description_id DESC
van der Pol, L. D., Groeneveld, M. G., Endendijk, J. J., van Berkel, S. R., Hallers-Haalboom, E. T., Bakermans-Kranenburg, M. J., & Mesman, J. (2016). Associations between fathers’ and mothers’ psychopathology symptoms, parental emotion socialization, and preschoolers’ social-emotional development. Journal of Child and Family Studies, 25, 3367–3380.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232922'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232922 ORDER BY metadata_description_id DESC
Wang, M.-T., Degol, J. L., Amemiya, J., Parr, A., & Guo, J. (2020). Classroom climate and children’s academic and psychological wellbeing: A systematic review and meta-analysis. Developmental Review, 57, 100912.
(mysql): SELECT * FROM citation_settings WHERE citation_id = '232923'
(mysql): SELECT * FROM metadata_descriptions WHERE assoc_type = 1048579 AND assoc_id = 232923 ORDER BY metadata_description_id DESC
Warsito, O., Khomsan, A., Hernawati, N., & Anwar, F. (2012). Relationship between nutritional status, psychosocial stimulation, and cognitive development in preschool children in Indonesia. Nutrition Research and Practice, 6(5), 451–457.
Zedan, R. (2021). Parental Involvement as a Predictor of Classroom Climate, Motivation for Learning, and Learning Achievements. The Journal of Classroom Interaction, 56(1), 56–74.
DOI: http://dx.doi.org/10.30659/jp.19.1.26-38
(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 = '30531' 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 = 30531
(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 = 30531 ORDER BY g.seq
(mysql): SELECT * FROM article_galley_settings WHERE galley_id = '10154'
(mysql): SELECT * FROM article_settings WHERE article_id = '30531'
(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 = 30531 ORDER BY s.seq
(mysql): SELECT r.* FROM referrals r WHERE r.article_id = 30531 AND r.status = 2
Refbacks
- There are currently no refbacks.
(mysql): SELECT * FROM authors WHERE submission_id = 30531 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '43991'
Proyeksi by https://jurnal.unissula.ac.id/index.php/proyeksi/ is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.