The National Institute for Genealogical Studies presents . . .

GENEALOGY & COPYRIGHT GUIDELINES

Advanced Level

This publication, or any part of it, may not be reproduced in whole or in part without the, prior written consent of the National Institute for Genealogical Studies.

Please direct inquiries regarding orders, copyright or other matters to:
NATIONAL INSTITUTE FOR GENEALOGICAL STUDIES
do Louise St Denis
30 Wellington Street East
Suite 2002
Toronto, Ontario M5E 1S3

Telephone: (416) 861-0165
Fax: (416) 861-1894
Email: admin@genealogicalstudies.com

Genealogy and Copyright Guidelines
Author: Sharon DeBartolo Carmack, CG

Printed in Canada
First Edition: April, 2002
Third Edition: November, 2007
Copyright 2005-2007 Sharon DeBartolo Carmack

 

MODULE 1

REQUIRED READING: TEXT

Carmack's Guide to Copyright & Contracts
   Introduction
      Why You Need This book?
      Why I Wrote This Book?
   Chapter 1: Copyright Basics
      What's Protected by Copyright?
      Copyright Duration
      Registering Your Work
      Applying It to Genealogy

REQUIRED READING: ONLINE

Review Chapter Three of the Copyright Law of the United States of America, "Duration of Copyright"
http://www.copyright.gov/title17/92chap3.html 

AuthorsLawyer.com, Copyright Resources, Public Domain Dates
http://www.authorslawyer.com/c-term.shtml 

United States Copyright Office - Copyright Basics
http://www.copyright.gov/circs/circ01.pdf 

United States Copyright Office - Registering a Copyright with the U.S. Copyright Office
http://www.copyright.gov/fls/s135.pdf 

United States Copyright Office - Registering a Work
http://www.copyright.gov/help/faq/faq-register.html  
Copyright FAQs

OPTIONAL READING: KNOWLEDGE ENHANCEMENT

Wikipedia - "United States Copyright Law"
http://en.wikipedia.org/wiki/United_States_copyright_law

 

MODULE 2

REQUIRED READING: TEXT

Carmack's Guide to Copyright & Contracts
   Read pages 21-25 and 29, starting with "How Do You Get Permission?", through to page 37.
   Chapter 2: Fair Use, The Public Domain and Seeking Permission
      Do You Need Permission?
      What Is Fair Use?
      How Much Can You Quote?
      How Do You Get Permission?
      The Permission Letter
      Applying It to Genealogy

REQUIRED READING: ONLINE

Copyright Law of the United States of America, Chapter 1, Section: 107 "Limitations on exclusive rights: Fair Use" http://www.copyright.gov/title17/92chap1.html#107 

Copyright Law of the United States of America, "Fair Use"
http://www.copyright.gov/f1s/f1102.html 

Copyright Crash Course - Fair Use of Copyrighted Materials
http://copyright.lib.utexas.edu/copypol2.html 

CopyLaw.com, "Fair Use in a Nutshell: A Roadmap to Copyright's Most Important Exception", by Attorney Lloyd J. Jassin http://www.copylaw.com/new_articles/fairuse.html 

Checklist for Fair Use
http://copyright.columbia.edu/copyright/files/2009/10/fairusechecklist.pdf

OPTIONAL READING: KNOWLEDGE ENHANCEMENT

Wikipedia - "Fair Use"
http://en.wikipedia.org/wiki/Fair_use 

 

MODULE 3

REQUIRED READING: TEXT

Carmack 's Guide to Copyright & Contracts
   Read pages 25-29 and review pages 32-37.
   Chapter 2: Fair Use, The Public Domain and Seeking Permission
      What is the Public Domain?
      Searching the Copyright Office Rules
      Review: Applying it to Genealogy

REQUIRED READING: ONLINE

When U.S. Works Pass into the Public Domain
http://www.unc.edu/~unclng/public-d.htm 

Copyright Term and the Public Domain in the United States
http://wwvv.copyright.cornell.edu/resources/publicdomain.cfm 

Importance of the Public Domain
http://www.unc.edu/~unclng/copy-corner34.htm 

CopyLaw.com, "New Rules for Using Public Domain Materials", by Attorney Lloyd J. Jassin
http://www.copylaw.com/new_articles/PublicDomain.html 

Browse through "Wikipedia: Public Domain Resources"
http://en.wikipedia.org/wiki/Wikipedia:Public_domain_resources 

OPTIONAL READING: KNOWLEDGE ENHANCEMENT

Wikipedia - "Public Domain"
http://en.wikipedia.org/wiki/Public_domain 

 

MODULE 4

REQUIRED READING: TEXT

Carmack 's Guide to Copyright & Contracts
   Chapter 3: Illustrations, Images, Photographs, And Maps
      What About Historical Images?
      What About Using Family Photographs?
      Using Published Illustrations, Maps, and Photographs
      How Do You Locate a Photographer?
      Where are Public Domain Images and Maps?
      What About Stock Photos?
      Applying it to Genealogy

REQUIRED READING: ONLINE

ASMP - Frequently Asked Questions About Copyright
http://www.asmp.org/commerce/legal/copyright/faq1.php 
(Note: This is advice for professional photographers but it will also be beneficial to you as well.)

"Rights to Use Photographs," by Ivan Hoffman
http://www.ivanhoffman.com/photos.html 

Browse through Wikipedia's "Public Domain Image Resources"
http://en.wikipedia.org/wiki/Wikipedia:Public_domain_image_resources 

 

MODULE 5

REQUIRED READING: TEXT

Carmack's Guide to Copyright & Contracts
   Chapter 4: Work For Hire
      What the Copyright Law Says
      Your Client Reports
      What Is the Client Paying For?
      Joint Authorship
      Why Is It Important to Retain Copyright?
      The Lawsuit
      Educating Clients
      Applying It to Genealogy

REQUIRED READING: ONLINE

CopyLaw.com, "Working with Freelancers: What Every Publisher Should Know About the 'Work for Hire' Doctrine", by Attorney Lloyd J. Jassin http://copylaw.com/new_articles/wfh.html 

Keytlaw, "Works Made for Hire Under the Copyright Act"
http://www.keydaw.com/Copyrights/wfhire.htm 

OPTIONAL READING: KNOWLEDGE ENHANCEMENT

Wikipedia - "Work for Hire"
http://en.wikipedia.org/wiki/Work_for_hire 

 

MODULE 6

REQUIRED READING: TEXT

Carmack's Guide to Copyright & Contracts, Read Chapters 6 and 8; and pages 78-80.
   Chapter 6: Journal/Magazine Contract
      Details of a Journalism Agreement
      Applying It to Genealogy
   Chapter 7: Book Contracts
      Details of a Book Publishing Contract
   Chapter 8: Electronic Contracts
      Posting Your Work on the Web
      Applying It to Genealogy

REQUIRED READING: ONLINE

ASJA, "Rights 101: What Writers Should Know About All-Rights and Work-Made-For-Hire Contracts"
http://www.asja.org/pubtips/wmfh01.php 

Writing-World.com, "Rights: What They Mean and Why They're Important", by Marg Gilks
http://www.writing-world.com/rights/rights.shtml 

FindLaw - Library, "Subsidiary Rights - Acquisition & Licensing", by Lloyd L. Rich
http://library findlaw.com/1998/Jun/1/129368.html 

"Electronic Publishing and the Potential Loss of First Serial Rights", by Ivan Hoffman
http://www.ivanhoffman.com/first.html 

CopyLaw.com, "Electronic Publishing Rights: An Interview with Lloyd J. Jassin"
http://www.copylaw.com/new_articles/electronicrights.html 

J! InfoRequestSessionProfileQueries22Loaded32UntranslatedErrors
5.738MBMemory Usage530msRequest Duration
Joomla! Version5.2.2
PHP Version8.1.32
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.6.21-MariaDB-cll-lve-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "id" => "143" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "PHPSESSID" => "f11a984e934eba6b540f4952d1cf5237" ]
$_SERVER
array:46 [ "PHPRC" => "/home/prdro/public_html/" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTT...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743891083 "last" => 1743891083...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (357.86KB) (89.94ms)
  • afterInitialise (2.36MB) (200ms)
  • afterRoute (174.98KB) (3.21ms)
  • beforeRenderComponent com_content (181.42KB) (17.51ms)
  • Before Access::preloadComponents (all components) (244.23KB) (31.45ms)
  • After Access::preloadComponents (all components) (126.02KB) (2.51ms)
  • Before Access::preloadPermissions (com_content) (3.95KB) (28μs)
  • After Access::preloadPermissions (com_content) (130.7KB) (1.56ms)
  • Before Access::getAssetRules (id:229 name:com_content.article.143) (10.8KB) (38μs)
  • After Access::getAssetRules (id:229 name:com_content.article.143) (9.43KB) (1.17ms)
  • afterRenderComponent com_content (1.18MB) (102ms)
  • afterDispatch (2.36KB) (288μs)
  • beforeRenderRawModule mod_menu (Main Menu) (54.77KB) (8.03ms)
  • afterRenderRawModule mod_menu (Main Menu) (141.53KB) (30.27ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (13μs)
  • afterRenderModule mod_menu (Main Menu) (71.34KB) (994μs)
  • afterRender (238.1KB) (39.35ms)
  • 1 x afterInitialise (2.36MB) (37.82%)
    200ms
    1 x afterRenderComponent com_content (1.18MB) (19.24%)
    102ms
    1 x afterLoad (357.86KB) (16.98%)
    89.94ms
    1 x afterRender (238.1KB) (7.43%)
    39.35ms
    1 x Before Access::preloadComponents (all components) (244.23KB) (5.94%)
    31.45ms
    1 x afterRenderRawModule mod_menu (Main Menu) (141.53KB) (5.72%)
    30.27ms
    1 x beforeRenderComponent com_content (181.42KB) (3.31%)
    17.51ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (54.77KB) (1.52%)
    8.03ms
    1 x afterRoute (174.98KB) (0.61%)
    3.21ms
    1 x After Access::preloadComponents (all components) (126.02KB) (0.47%)
    2.51ms
    1 x After Access::preloadPermissions (com_content) (130.7KB) (0.29%)
    1.56ms
    1 x After Access::getAssetRules (id:229 name:com_content.article.143) (9.43KB) (0.22%)
    1.17ms
    1 x afterRenderModule mod_menu (Main Menu) (71.34KB) (0.19%)
    994μs
    1 x afterDispatch (2.36KB) (0.05%)
    288μs
    1 x Before Access::getAssetRules (id:229 name:com_content.article.143) (10.8KB) (0.01%)
    38μs
    1 x Before Access::preloadPermissions (com_content) (3.95KB) (0.01%)
    28μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    13μs
22 statements were executed, 6 of which were duplicates, 16 unique15.05ms135.38KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;92μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `josc2_session` WHERE `session_id` = ?282μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `josc2_session` WHERE `session_id` = :session_id LIMIT 1159μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `josc2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)752μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `josc2_viewlevels`278μs1.58KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `josc2_usergroups` AS `a` LEFT JOIN `josc2_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.27ms1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josc2_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)1.16ms7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josc2_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0770μs5.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `josc2_content`1.72ms3.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `josc2_content` SET `hits` = (`hits` + 1) WHERE `id` = '143'1.46ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `josc2_content` AS `a` INNER JOIN `josc2_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josc2_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josc2_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josc2_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josc2_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)840μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `josc2_categories` AS `s` INNER JOIN `josc2_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`928μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `josc2_contentitem_tag_map` AS `m` INNER JOIN `josc2_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)876μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `josc2_categories` AS `s` INNER JOIN `josc2_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`442μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM josc2_fields AS a LEFT JOIN `josc2_languages` AS l ON l.lang_code = a.language LEFT JOIN josc2_users AS uc ON uc.id=a.checked_out LEFT JOIN josc2_viewlevels AS ag ON ag.id = a.access LEFT JOIN josc2_users AS ua ON ua.id = a.created_user_id LEFT JOIN josc2_fields_groups AS g ON g.id = a.group_id LEFT JOIN `josc2_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.28ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `josc2_categories` AS `s` INNER JOIN `josc2_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`573μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `josc2_schemaorg` WHERE `itemId` = :itemId AND `context` = :context201μs4.36KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `josc2_content` AS `a` INNER JOIN `josc2_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josc2_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josc2_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josc2_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josc2_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)691μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `josc2_content` AS `a` INNER JOIN `josc2_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josc2_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josc2_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josc2_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josc2_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)428μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `josc2_scheduler_tasks` AS `a` WHERE `a`.`state` = 1230μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `josc2_session` WHERE `session_id` = ?160μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `josc2_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?458μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
ExtensionFile
joomla
  • + /language/en-GB/joomla.ini
lib_joomla
  • + /language/en-GB/lib_joomla.ini
tpl_cassiopeia
  • + /language/en-GB/tpl_cassiopeia.ini
com_content
  • + /language/en-GB/com_content.ini
  • + /administrator/language/en-GB/com_content.ini
plg_fields_subform
  • + /administrator/language/en-GB/plg_fields_subform.ini
plg_fields_calendar
  • + /administrator/language/en-GB/plg_fields_calendar.ini
plg_fields_checkboxes
  • + /administrator/language/en-GB/plg_fields_checkboxes.ini
plg_fields_color
  • + /administrator/language/en-GB/plg_fields_color.ini
plg_fields_editor
  • + /administrator/language/en-GB/plg_fields_editor.ini
plg_fields_imagelist
  • + /administrator/language/en-GB/plg_fields_imagelist.ini
plg_fields_integer
  • + /administrator/language/en-GB/plg_fields_integer.ini
plg_fields_list
  • + /administrator/language/en-GB/plg_fields_list.ini
plg_fields_media
  • + /administrator/language/en-GB/plg_fields_media.ini
plg_fields_radio
  • + /administrator/language/en-GB/plg_fields_radio.ini
plg_fields_sql
  • + /administrator/language/en-GB/plg_fields_sql.ini
plg_fields_text
  • + /administrator/language/en-GB/plg_fields_text.ini
plg_fields_textarea
  • + /administrator/language/en-GB/plg_fields_textarea.ini
plg_fields_url
  • + /administrator/language/en-GB/plg_fields_url.ini
plg_fields_user
  • + /administrator/language/en-GB/plg_fields_user.ini
plg_fields_usergrouplist
  • + /administrator/language/en-GB/plg_fields_usergrouplist.ini
mod_menu
  • + /language/en-GB/mod_menu.ini
plg_schemaorg_article
  • + /administrator/language/en-GB/plg_schemaorg_article.ini
plg_schemaorg_custom
  • + /administrator/language/en-GB/plg_schemaorg_custom.ini
plg_schemaorg_blogposting
  • + /administrator/language/en-GB/plg_schemaorg_blogposting.ini
plg_schemaorg_book
  • + /administrator/language/en-GB/plg_schemaorg_book.ini
plg_schemaorg_event
  • + /administrator/language/en-GB/plg_schemaorg_event.ini
plg_schemaorg_organization
  • + /administrator/language/en-GB/plg_schemaorg_organization.ini
plg_schemaorg_person
  • + /administrator/language/en-GB/plg_schemaorg_person.ini
plg_schemaorg_recipe
  • + /administrator/language/en-GB/plg_schemaorg_recipe.ini
plg_schemaorg_jobposting
  • + /administrator/language/en-GB/plg_schemaorg_jobposting.ini
plg_system_debug
  • + /administrator/language/en-GB/plg_system_debug.ini