Login or register for free to remove ads.

Games and Motivation to Learn Science: Personal Identity, Applicability, Relevance and Meaningfulness Article

, Michigan State University, United States

Journal of Interactive Learning Research Volume 19, Number 4, ISSN 1093-023X Publisher: Association for the Advancement of Computing in Education (AACE), Chesapeake, VA

Abstract

Game-based learning and designing has become a hot topic in educational technology. It is believed that video gaming is one way to get students engaged in learning complex and ill-structured material, holistic learning, and preparing learners for 21st century jobs. However, beyond engagement, games may also be used for learning and developing personal interest in science by utilizing the affordances for personal identity, applicability beyond the school setting and for a personal agenda, and relevance and meaningfulness of scientific practices and ideas. This article, based on the synthesis of information from the games, science education, and motivational research literatures present a focused view on how games for learning (serious games) can be designed and used for learning and developing an interest in science. The article also points in the direction of much needed research to assess the claims about games for learning.

Citation

Foster, A. (2008). Games and Motivation to Learn Science: Personal Identity, Applicability, Relevance and Meaningfulness. Journal of Interactive Learning Research, 19(4), 597-614. Chesapeake, VA: Association for the Advancement of Computing in Education (AACE).

Keywords

References

  1. Aikenhead, G. S. (2006). Science education for everyday life: Evidence-based practice. New York: Teachers College Press.
  2. Anderson, C. W. (2002). Learning to teach science for understanding: Intern year version. Unpublished manuscript, Michigan State University, East Lansing.
  3. Ardac, D., & Akaygun, S. (2004). Effectiveness of multimedia-based instruction that emphasizes molecular representations on students understanding of chemical change. Journal of Research in Science Teaching, 41(4), 317-337.
  4. Asgari, M. (2005). A three-factor model of motivation and game design. Paper presented at the 2005 International DiGRA Conference, Vancouver, British Columbia, Canada.
  5. Asgari, M., & Kaufman, D. (2005, June). Relationships among computer games, fantasy, and learning. Paper presented at the 2005 International DiGRA Conference, Vancouver, British Columbia, Canada.
  6. Barab, S. A., Hay, K. E., Barnett, M., & Squire, K. (2001). Constructing virtual worlds: Tracing the historical development of learner practices. Cognition and Instruction, 19(1), 47-94. Baumeister, R. F., Campbell, J. D., Krueger, J. I., & Vohs, K. (2003). Does high self-esteem cause better performance, interpersonal success, happiness, or healthier lifestyles? Psychological Science in the Public Interest, 4, 1-44.
  7. Brophy, J. E. (2004). Motivating students to learn (2nd ed.). Mahwah, NJ: Lawrence Erlbaum. Bruce, B. C., & Levin, J. A. (1997). Educational technology: Media for inquiry, communication, construction, and expression. Journal of Educational Computing Research, 17(1), 79-102. Cognition and Technology Group at Vanderbilt. (1992). The Jasper series as an example of anchored instruction: Theory, program description, and assessment data. Educational Psychologist, 27(3), 291-315.
  8. Cognition and Technology Group at Vanderbilt. (1997). Looking at technology in context: A framework for understanding technology and education research. In D. C. Berliner & R. C. Calfee (Eds.), Handbook of educational psychology (pp. 807-840). New York: Simon and Schuster Macmillan.
  9. Cordova, D. I., & Lepper, M. R. (1996). Intrinsic motivation and the process of learning: Beneficial effects of contextualization, personalization and choice. Journal of Educational Psychology, 88(4), 715-730.
  10. De Jong, T., & Van Joolingen, W. R. (1998). Scientific discovery learning with computer simulations of conceptual domains. Review of Educational Research, 68, 179-202.
  11. DiSessa, A. (1982). Unlearning Aristotelian physics: A study of knowledge-based learning. Cognitive Science, 5, 37-75.
  12. Driver, R., Asoko, H., Leach, J., Mortimer, E., & Scott, P. (1994). Constructing scientific knowledge in the classroom. Educational Researcher, 23(7), 5-12.
  13. Dunlap, J. C., & Grabinger, R. S. (1996). Rich environment for active learning in the higher education classroom. In B. G. Wilson (Ed.), Constructivist learning environments: Case studies in instructional design. Englewoods Cliffs, NJ: Educational Technology Publications. Federation of American Scientists. (2006). Summit of educational games: Harnessing the power of video games for learning. Washington, DC: Author.
  14. Galarneau, L. (2005, June). Authentic learning experiences through play: Games, simulations and the construction of knowledge. Paper presented at the 2005 International DiGRA Conference, Vancouver, British Columbia, Canada.
  15. Gee, J. P. (2003). What video games have to teach us about learning and literacy. New York: Palgrave MacMillan.
  16. Gee, J. P. (2005). Learning by design: Good video games as learning machines. E-Learning, 2(1), 5-16. Gentile, D. A., & Walsh, D. A. (2002). A normative study of family media habits. Applied Developmental Psychology, 23, 157-178.
  17. Gredler, M. (1996). Educational games and simulations: A technology in search of a research paradigm. In D. H. Jonassen (Ed.), Handbook of research for educational communications and technology (pp. 521-539): New York: MacMilan.
  18. Greeno, J. G., Collins, A. M., & Resnick, L. B. (1996). Cognition and learning. In D. C. Berliner & R. C. Calfee (Eds.), Handbook of educational psychology. New York: Simon & Schuster Macmillan.
  19. Honebein, P. C. (1996). Seven goals for the design of constructivist learning environments. In B. G. Wilson (Ed.), Constructivist learning environments: Case studies in instructional design (pp. 11-24). Englewood Cliffs, NJ: Educational Technology Publications.
  20. Huppert, J., Lomask, S. M., & Lazarowitz, R. (2002). Computer simulations in the high school: Students cognitive stages, science process skills and academic achievement in microbiology. International Journal of Science Education, 24(8), 803-821.
  21. Ijsselsteijn, W. (2003). Presence in the past: What can we learn from media history? In G. Riva, F. Davide, & W. A. Ijsselsteijn (Eds.), Being there: Concepts, effects and measurement of user presence in synthetic environments. Amsterdam, The Netherlands: Ios Press.
  22. International Society for Technology in Education. (2000). National educational technology
  23. Jenkins, H., & Squire, K. (2005). Theory theories. Computer Games Magazine.
  24. Keller, J. M. (1983). Motivation design of instruction. In C. M. Reigeluth (Ed.), Instructional design theories and models: An overview of their current status. Hillsdale, NJ: Lawrence Erlbaum. Lee, O., & Luykx, A. (2006). Science education and student diversity: Synthesis and research agenda. New York: Cambridge University Press.
  25. Linn, M. C. (1998). The impact of technology on science instruction: Historical trends and current opportunities. In B. J. Fraser & K. G. Tobin (Eds.), International handbook of science education (pp. 265-2994). Great Britain: Kluwer Academic Publishers.
  26. Losier, G. F., & Koestner, R. (1999). Intrinsic versus identified regulation in distinct political campaigns: The consequences of following politics for pleasure versus personal meaningfulness. Personality and Social Psychology Bulletin, 25, 287-298.
  27. Malone, T. W. (1981). Toward a theory of intrinsically motivating instruction. Cognitive Science, 5(4), 333-369.
  28. Malone, T. W., & Lepper, M. R. (1987). Making learning fun: A taxonomy of intrinsic motivations for learning. In R. E. Snow & M. J. Farr (Eds.), Apptitude, learning and instruction: Cognitive and affective processed analysis. (Vol. 3). Mahwah, NJ: Lawrence Erlbaum.
  29. Markus, H., & Nurius, P. (1986). Possible selves. American Psychologist, 41(9), 954-969. Marshall, H. (1994). Children's understanding of academic tasks: Work, play, or learning. Journal of Research in Childhood Education, 9, 35-46. Mitchell, M. (1993). Situational
  30. Moreno, R., & Mayer, R. E. (2000). Engaging students in active learning: The case for personalized multimedia messages. Journal of Educational Psychology, 92(4), 724-733. National
  31. Institute on the Media and the Family. (2002, November 6). Media use. Retrieved October 21, 2005, from http://www.mediafamily.org/facts/facts_mediause.shtml
  32. Papert, S. (1997). The connected family: Bridging the digital generation gap. Marietta, GA: Longstreet Press.
  33. Prensky, M. (2001). Digital game-based learning. New York: McGraw-Hill.
  34. Resnick, L. B. (1987). The 1987 presidential address: Learning in school and out. Educational Researcher, 16(9), 13-20, 54.
  35. Resnick, M. (1994). Turtles, termites, and traffic jams: Exploration in massively parallel worlds. Cambridge, MA: The MIT Media Press.
  36. Rowell, P. M. (2002). Peer interactions in shared technological activity: A study of participation. International Journal of Technology and Design Education, 12, 1-22.
  37. Scardamalia, M. (2000). Can schools enter a knowledge society? In M. Selinger & J. Wynn (Eds.), Educational technology and the impact on teaching and learning (pp. 6-10). Abingdon, UK: RM. Schraw, G., Flowerday, T., & Lehman, S. (2001). Increasing situational interest in the classroom. Educational Psychology Review, 13(3), 211-224.
  38. Shaffer, D. W. (2006). How computer games help children learn. New York: Palgrave MacMillan. Smith, C. L., Wiser, M., Anderson, C. W., & Krajcik, J., & Coppola, B. (in press). Implications of research on children’s learning for standards and assessment: A proposed learning progression for matter and the atomic molecular theory. Measurement: Interdisciplinary Research and Perspectives.
  39. Spiro, R. J., Feltovich, P. J., Jacobson, M. J., & Coulson, R. L. (1992). Hypertext: Random access instruction for advanced knowledge acquisition in ill-structured domains. In T. M. Duffy & D. H. Jonassen (Eds.), Constructivism and the technology of instruction (1st ed., pp. 232). Mahwah, NJ: Lawrence Erlbaum.
  40. Squire, K. (2003). Video games in education. International Journal of Intelligent Simulations and Gaming, 2(1).
  41. Turkle, S. (1995). Life on the screen: Identity in the age of the internet. New York: Simon and Schuster.
  42. Turkle, S. (1997). Seeing through computers. The American Prospect, 8(31).
  43. Turner, J., Cox, K. E., DiCinto, M., Meyer, D. K., Logan, C., & Thomas, C. T. (1998). Creating contexts for involvement in mathematics. Journal of Educational Psychology, 90(4), 730-745. Vansteenkiste, M., Lens, W., & Deci, E. L. (2006). Intrinsic versus extrinsic goal contents in self-determination theory: Another look at the quality of academic motivation. Educational Psychologist, 41(1), 19-31.
  44. Vygotsky, L. S. (1978). Mind in society. Cambridge, MA: Harvard University Press.
  45. Warren, B., Ballenger, C., Ogonowski, M., Roseberry, A. S., & Hudicort-Barnes, J. (2001). Rethinking diversity in learning science: The logic of everyday sense-making. Journal of Research in Science Teaching, 38(5), 529-552.
  46. White, B., & Frederiksen, J. R. (2000). Metacognitive facilitation: An approach to making scientific inquiry accessible to all. In J. Minstrell & E. V. Zee (Eds.), Inquiring into inquiry learning and teaching. Washington, DC: American Association for the Advancement of Science. Wigfield, A., Eccles, J. S., Schiefele, U., Roeser, R., & Davis-Kean, P. (2006). Development of achievement motivation. In W. Damon & N. Eisenberg (Eds.), Handbook of child psychology: Social, emotional, and personality development (Vol. 3, 6th ed.; 933-1002). New York: John Wiley.
  47. Williams, D. C. (2004). Trouble in river city: The social life of video games. Unpublished doctoral dissertation, University of Michigan, Ann Arbor.
  48. Williams, D. C. (2005). Bridging the methodological divide in game research. Simulation & Gaming, 36(4), 447-463.
  49. Williamson, K. M., Land, L., Butler, B., & Ndahi, H. B. (2004). A structured framework for using games to teach mathematics and science in K-12 classrooms. The Technology Teacher, 64(3), 15-18.
  50. Windschitl, M. (2000). Supporting the development of science inquiry skills with special classes of software. Educational Technology and Research Development, 48(2), 81-95.

These references have been extracted automatically and may have some errors. If you see a mistake in the references above, please contact info@editlib.org.


Feedback and Suggestions please email info@editlib.org or use our online feedback form.


Debugging Information
Railo (Togo) Os FINAL 4.2.1.008 (CFML Version 10,0,0,0)
Template /index.cfm (/var/sites/railo.editlib.org/index.cfm)
Time Stamp Feb 11, 2016 11:35 PM
Time Zone UCT
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.160.221.82
Host Name www.editlib.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
1010 ms 1010 ms 1 /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
923 ms 131 ms 7 /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
197 ms 98.6 ms 2 /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
50.8 ms 50.8 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
125 ms 41.7 ms 3 /var/sites/railo.editlib.org/models/sources/qry_source.cfm
55.3 ms 27.6 ms 2 /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
22.7 ms 22.7 ms 1 /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
44.8 ms 22.4 ms 2 /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
21.5 ms 21.5 ms 1 /var/sites/railo.editlib.org/models/papers/qry_references.cfm
3.77 ms 3.77 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
1.42 ms 1.42 ms 1 /var/sites/railo.editlib.org/layouts/lay_new_2014.cfm
2.73 ms 1.36 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/cache.cfm
2.1 ms 1.05 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/ini2struct.cfm
1.18 ms 0.59 ms 2 /var/sites/railo.editlib.org/reader/inc_share.cfm
0.221 ms 0.221 ms 1 /var/sites/railo.editlib.org/Application.cfm
0.183 ms 0.183 ms 1 /var/sites/railo.editlib.org/models/papers/act_generatecitation.cfm
0.094 ms 0.094 ms 1 /var/sites/railo.editlib.org/models/sources/act_generatesourcetext.cfm
0.053 ms 0.053 ms 1 /var/sites/railo.editlib.org/OnRequestEnd.cfm
0.043 ms 0.043 ms 1 /var/sites/railo.editlib.org/reader/inc_tools.cfm
0.042 ms 0.042 ms 1 /var/sites/railo.editlib.org/logger/act_logaccess.cfm
0.126 ms 0.042 ms 3 /var/sites/railo.editlib.org/security/act_identifyinstitution.cfm
0.04 ms 0.04 ms 1 /var/sites/railo.editlib.org/reader/inc_breadcrumb.cfm
0.08 ms 0.04 ms 2 /var/sites/railo.editlib.org/logger/act_readnavigationhistory.cfm
0.037 ms 0.037 ms 1 /var/sites/railo.editlib.org/reader/inc_collections.cfm
0.922 ms 0.036 ms 25 /var/sites/railo.editlib.org/fbx_Layouts.cfm
0.034 ms 0.034 ms 1 /var/sites/railo.editlib.org/security/act_determinesubscriptions.cfm
0.069 ms 0.034 ms 2 /var/sites/railo.editlib.org/reader/inc_login.cfm
0.032 ms 0.032 ms 1 /var/sites/railo.editlib.org/logger/act_lognavigationhistory.cfm
0.735 ms 0.029 ms 25 /var/sites/railo.editlib.org/fbx_Settings.cfm
0.08 ms 0.02 ms 4 /var/sites/railo.editlib.org/logger/fbx_Switch.cfm
0.11 ms 0.015 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Switch.cfm
0.302 ms 0.012 ms 25 /var/sites/railo.editlib.org/fbx_Circuits.cfm
0.046 ms 0.011 ms 4 /var/sites/railo.editlib.org/logger/fbx_Settings.cfm
0.033 ms 0.011 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Switch.cfm
0.185 ms 0.01 ms 18 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/nonessential.cfm
0.023 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Layouts.cfm
0.197 ms 0.007 ms 25 /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm
0.031 ms 0.007 ms 4 /var/sites/railo.editlib.org/logger/fbx_Layouts.cfm
0.052 ms 0.007 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Switch.cfm
0.022 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Switch.cfm
0.182 ms 0.007 ms 25 /var/sites/railo.editlib.org/functions.cfm
0.028 ms 0.004 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Settings.cfm
0.003 ms 0.003 ms 1 /var/sites/railo.editlib.org/reader/fbx_Layouts.cfm
0.011 ms 0.003 ms 3 /var/sites/railo.editlib.org/security/fbx_Settings.cfm
0.017 ms 0.002 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Settings.cfm
0.007 ms 0.002 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Settings.cfm
0.002 ms 0.002 ms 1 /var/sites/railo.editlib.org/layouts/inc_jquery_cdn.cfm
0 ms 0 ms 25 /var/sites/railo.editlib.org/index.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/lay_new.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Switch.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Settings.cfm
0.992 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
13.1 ms  APPLICATION EXECUTION TIME
2453 ms  QUERY EXECUTION TIME
2467 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Caught Exceptions

Type Message Detail Template
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277


SQL Queries

GetPaper (Datasource=aacepubs, Time=30.2 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=24259
		
GetPapers (Datasource=aacepubs_readonly, Time=50.7 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
	SELECT
		Papers.paper_id, Papers.paper_code, Papers.paper_title, Paper_Status.paper_status_name AS status_name, 
		Papers.paper_is_locked, Papers.date_created, Papers.date_modified, Papers.paper_type,

		Papers.paper_page_start, Papers.paper_page_end,

		Papers.paper_abstract, Papers.paper_comments,

		Papers.paper_decision, Papers.paper_status, 

		People.email AS contact_email,
		People.first_name AS contact_first, People.last_name AS contact_last,
		People.organization AS contact_organization, Countries.country_name AS contact_country,

		Sources.source_code, Sources.source_issn, Sources.source_type, Sources.source_title, Sources.source_abbr, Sources.source_id, Sources.source_authors,
		Sources.source_image,
		Sources.source_description, Sources.source_location,
		Sources.source_date, 
		SourceIssues.sourceissue_id, 
		SourceIssues.sourceissue_volume, SourceIssues.sourceissue_number, SourceIssues.sourceissue_title, SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_image,
		SourceIssues.sourceissue_date, 

		COALESCE(Publishers.publisher_name, Sources.source_publisher) as publisher_name,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date,

		(SELECT
			MIN(FullText.paperfile_name)
			FROM
				PaperFiles AS FullText
			WHERE
				FullText.paperfile_paper=Papers.paper_id
				AND FullText.date_deleted IS NULL AND FullText.paperfile_name > ''
				AND FullText.paperfile_hidden = 0 AND FullText.paperfile_type = 'PAPER'
		) AS fulltext_file,

		Authors.author_id,
		Authors.first_name AS author_first,
		Authors.last_name AS author_last,
		Authors.organization AS author_organization,
		AuthorCountries.country_name AS author_country,
		Authors.email AS author_email,
		Thumbnail.paperfile_name AS paper_thumbnail,
		Papers.paper_sourceissue,
		CAST(SourceIssues.sourceissue_volume AS varchar) + ':' + CAST(SourceIssues.sourceissue_number AS VARCHAR) AS issue_string
		

	FROM
		((((((((Papers 
		LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper AND 
		(Authors.author_type IS NULL OR Authors.author_type <> 'C')
		)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code)
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id)
		LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Paper_Status ON Papers.paper_status=Paper_Status.paper_status_code)
		)
		LEFT JOIN Countries ON People.country=Countries.country_code)
		LEFT JOIN Countries AS AuthorCountries ON Authors.country=AuthorCountries.country_code
		LEFT JOIN PaperFiles AS Thumbnail ON Papers.paper_id = Thumbnail.paperfile_paper AND Thumbnail.paperfile_type = 'THUMBNAIL'
		
	WHERE
		
		
			Papers.date_deleted IS NULL
		

		

		

		

		

		

		

		

		

		

		

		
		
			
					AND Papers.paper_type='Chapter'
					AND EXISTS (
						SELECT *
						FROM
							Sources
						WHERE
							Papers.paper_source=Sources.source_id AND
							Sources.source_paper=24259
					)
				
		
			
					AND Papers.date_added IS NOT NULL
					AND 
					(
						Papers.paper_status='DL_PUBLISH'
						
					)
				
		

		

	ORDER BY
	
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		Papers.paper_page_start,
		Papers.paper_page_end
	 
GetPaper (Datasource=aacepubs, Time=25 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=24259
		
Source (Datasource=aacepubs, Time=25.7 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 24259
		
PaperTopics (Datasource=aacepubs, Time=25.3 ms, Records=5) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 24259
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
Authors (Datasource=aacepubs, Time=25.5 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					24259
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
Authors (Datasource=aacepubs, Time=19.2 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					24259
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
PaperTopics (Datasource=aacepubs, Time=171 ms, Records=5) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 24259
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
PaperTags (Datasource=aacepubs, Time=3.72 ms, Records=9) in /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
	SELECT
		Tags.tag_id, Tags.tag_text
	FROM
		(Tags LEFT JOIN Paper_Tags ON Tags.tag_id=Paper_Tags.tag_id )
	WHERE
		
			Paper_Tags.paper_id = 24259
		
	ORDER BY
		tag_text
References (Datasource=aacepubs, Time=21.4 ms, Records=50) in /var/sites/railo.editlib.org/models/papers/qry_references.cfm
	SELECT
		Paper_References.paperreference_id,
		Paper_References.paperreference_content,
		Paper_References.paperreference_authors,
		Paper_References.paperreference_doi,
		Paper_References.paperreference_date
	FROM
		Paper_References
	WHERE
		Paper_References.paperreference_paper = 24259
	ORDER BY
		Paper_References.paperreference_order
PaperFiles (Datasource=aacepubs, Time=3.48 ms, Records=4) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
Source (Datasource=aacepubs, Time=3.89 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 24259
		
Source (Datasource=aacepubs, Time=95.3 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 24259
		
PaperFiles (Datasource=aacepubs, Time=24.9 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Presentations
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
				AND PaperFiles.paperfile_is_presentation=1
			
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=54.5 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Videos
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'video'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=242 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Slides
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
			
				AND paperfile_is_presentation = 1
				AND (
					paperfile_type IS NULL OR
					(paperfile_type <> 'paper' AND paperfile_type <> 'press')
				)
				AND (
					paperfile_format IS NULL OR
					paperfile_format <> 'FULL'
				)
				AND (
						PaperFiles.paperfile_name LIKE '%.ppt' OR
						PaperFiles.paperfile_name LIKE '%.pptx' OR
						PaperFiles.paperfile_name LIKE '%.pdf'
				)
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=181 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> MP3s
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
			AND 
			(
			
			
				
				PaperFiles.paperfile_name LIKE '%.mp3'
			
			)
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=217 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> URLs
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'url'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=197 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Recordings
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=24259
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'recording'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
AlsoAccessedPapers (Datasource=aacepubs, Time=1009 ms, Records=25) in /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
	SELECT TOP 25
		Papers.paper_id AS related_paper, Papers.paper_title AS related_title, COUNT(*) AS number_of_accesses 
	FROM
		Access_Log AS Other_Papers_Accessed
		INNER JOIN Access_Log AS This_Paper ON 
			Other_Papers_Accessed.person_id=This_Paper.person_id AND 
			This_Paper.paper_id <> Other_Papers_Accessed.paper_id AND
			This_Paper.paper_id = 24259
			
		INNER JOIN Papers ON Other_Papers_Accessed.paper_id=Papers.paper_id
	WHERE
		Papers.date_deleted IS NULL AND
		Papers.date_added > '1970-01-01' AND
		Papers.paper_status='DL_PUBLISH'
	GROUP BY Papers.paper_id, Papers.paper_title
	ORDER BY 3 DESC
Paper_GetSource (Datasource=aacepubs, Time=8.5 ms, Records=1) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT source_type, source_code, sourceissue_date, sourceissue_volume, sourceissue_number, paper_status
		FROM
			(Sources INNER JOIN Papers ON Sources.source_id=Papers.paper_source)
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=24259
	
Paper (Datasource=aacepubs, Time=12.1 ms, Records=1) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT 
			coalesce(paper_is_free,0) | coalesce(source_is_free,0) | coalesce(sourceissue_is_free,0) as paper_is_free, 
			paper_free_until, free_for_member, person_code, Authors.email
		FROM 
			Papers LEFT JOIN People ON Papers.paper_contact_person=People.person_id
			LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper
			LEFT JOIN Sources ON Papers.paper_source=Sources.source_id
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=24259
	
Journal_Is_Free (Datasource=aacepubs, Time=1.78 ms, Records=0) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
			SELECT journal_is_free
			FROM
				Journals
			WHERE
				journal_is_free=1 AND
				journal_code='JILR'
		
RecordedPresentations (Datasource=, Time=0.107 ms, Records=0) in /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
		SELECT *
		FROM
			Presentations
		WHERE
			upper(Presentations.paperfile_format) = 'RECORDEDPRESENTATION'
	


Scope Variables

Application Variables:
applicationname=editlib
INSTITUTION_IPS=Struct (9)
NON_INSTITUTION_IPS=Array (78)
CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/var/sites/railo.editlib.org/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=x-gzip, gzip, deflate
http_accept_language=en-us,en-gb,en;q=0.7,*;q=0.3
http_connection=close
http_cookie=
http_host=www.editlib.org
http_referer=
http_user_agent=CCBot/2.0 (http://commoncrawl.org/faq/)
https=
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=172.31.28.109
local_host=ip-172-31-28-109
path_info=
path_translated=/var/sites/railo.editlib.org/index.cfm
query_string=fuseaction=Reader.ViewAbstract&paper_id=24259&nl
remote_addr=54.160.221.82
remote_host=54.160.221.82
remote_user=
request_method=GET
request_url=http://www.editlib.org/index.cfm?fuseaction=Reader.ViewAbstract&paper_id=24259&nl
script_name=/index.cfm
server_name=www.editlib.org
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=
Form Variables:
CACHE_CODE=24259nlp
Request Variables:
_nonessential_code=false
_nonessential_content=
_nonessential_triggered=false
access_logged=false
addtoken=false
cache_code=24259nlp
cache_counter=1
cfroot=/editlib
checked_for_user=true
confdatasource=conference
current_path=/p/24259/
current_url=/p/24259/?nl
development_ips=63.172.201.5,82.111.242.163,71.48.156.102,65.41.111.68,71.53.208.41,71.53.210.238,196.205.118.231,41.196.180.26
domain=www.editlib.org
file_delimiter=/
fileroot=/var/sites/railo.editlib.org/
is_ajax=false
is_spider=true
layout=2014
login_javascript=
		
		
		
	
logindatasource=conference
loginpath=/login/
mailinglist_address=listserv@listserv.uh.edu
mailinglist_name=eductech
mailinglist_owner=jdprice@genesis.coe.uh.edu
mailinglist_password=bookstairs
maindatasource=aacepubs
maindatasource_ro=aacepubs_readonly
navigationhistory=Struct (2)
org.apache.catalina.AccessLog.Protocol=HTTP/1.0
org.apache.catalina.AccessLog.RemoteAddr=54.160.221.82
org.apache.catalina.AccessLog.RemoteHost=54.160.221.82
org.apache.catalina.AccessLog.ServerPort=80
page=Struct (13)
page_timeout=10
publications_scope=AACE
pubsdatasource=aacepubs
self=/
settings=Struct (47)
share_js=





site_name=EdITLib
stop_addtoken=true
webroot=/
Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
coldfusion=Struct (9)
java=Struct (8)
os=Struct (7)
railo=Struct (7)
separator=Struct (3)
servlet=Struct (1)
URL Variables:
fuseaction=Reader.ViewAbstract
nl=
paper_id=24259
READER_CACHE=1
Debug Rendering Time: 0 ms