Site Infrastructure Database

The SCTC Site Infrastructure Database captures information on the patient characteristics, available resources and infrastructure, as well as practice patterns in the SCTC and EUSTAR centers. Sixty data elements are captured and regularly updated in this database.

The database has been updated four times so far ( Feb 2019, Dec 2019, Oct 2021, and Oct 2022).  It currently includes data from 138 centers. 

The site-level information captured in this database can be shared with the pharmaceutical companies or academic centers for the design and feasibility assessment when planning large-scale, international clinical trials.

These are some examples on the type of information included in the database.

Geographic distribution of centers that updated their records in October 2022:

Image

Average number of returning SSc patients per year:

Image

What percentage of the patients have diffuse systemic sclerosis?

Image

Preferred treatment for SSc-ILD based on October 2022 update:

Image

Pay Membership Fees

If you are a newly accepted member of the SCTC, please select Initial Fee at $250.00 USD.
If you are a returning member of the SCTC, please select the option of Annual Fee at $200.00 USD.
If your institution is unable to use PayPal, please contact admin@sclerodermaclinicaltrials.org.

Membership Fees



© 2025 Scleroderma Clinical Trials Consortium. Designed By Kangablu Ltd
J! InfoRequestSessionProfileQueries44
9.136MBMemory Usage175msRequest Duration
Joomla! Version5.1.2
PHP Version8.1.32
Identityguest
Response200
Templateshaper_helix3
Database
Server
mysql
Version
10.11.11-MariaDB-ubu2204
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:54 [ "PHP_INI_SCAN_DIR" => "/home/ampersand/lsphp/sctc-web:/usr/local/lsws/lsphp81/etc/php/8...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743880852 "last" => 1743880852...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (86.9KB) (4.36ms)
  • afterInitialise (1.38MB) (39.19ms)
  • afterRoute (89.94KB) (5.43ms)
  • beforeRenderComponent com_sppagebuilder (215.92KB) (6.02ms)
  • Before Access::preloadComponents (all components) (485.05KB) (3.45ms)
  • After Access::preloadComponents (all components) (117.7KB) (1.02ms)
  • Before Access::getAssetRules (id:60 name:com_sppagebuilder) (2.43KB) (31μs)
  • After Access::getAssetRules (id:60 name:com_sppagebuilder) (7.84KB) (173μs)
  • Before Access::preloadPermissions (com_sppagebuilder) (3.16MB) (51.86ms)
  • After Access::preloadPermissions (com_sppagebuilder) (46.31KB) (517μs)
  • Before Access::getAssetRules (id:114 name:com_sppagebuilder.page.37) (2.06KB) (17μs)
  • After Access::getAssetRules (id:114 name:com_sppagebuilder.page.37) (1.61KB) (12μs)
  • afterRenderComponent com_sppagebuilder (308.85KB) (25.14ms)
  • afterDispatch (2.28KB) (304μs)
  • beforeRenderRawModule mod_menu (Menu) (279.16KB) (22.03ms)
  • afterRenderRawModule mod_menu (Menu) (76.77KB) (5.12ms)
  • beforeRenderModule mod_menu (Menu) (704B) (11μs)
  • afterRenderModule mod_menu (Menu) (3.03KB) (383μs)
  • afterRender (150.76KB) (9.02ms)
  • 1 x Before Access::preloadPermissions (com_sppagebuilder) (3.16MB) (29.68%)
    51.86ms
    1 x afterInitialise (1.38MB) (22.43%)
    39.19ms
    1 x afterRenderComponent com_sppagebuilder (308.85KB) (14.39%)
    25.14ms
    1 x beforeRenderRawModule mod_menu (Menu) (279.16KB) (12.61%)
    22.03ms
    1 x afterRender (150.76KB) (5.16%)
    9.02ms
    1 x beforeRenderComponent com_sppagebuilder (215.92KB) (3.45%)
    6.02ms
    1 x afterRoute (89.94KB) (3.11%)
    5.43ms
    1 x afterRenderRawModule mod_menu (Menu) (76.77KB) (2.93%)
    5.12ms
    1 x afterLoad (86.9KB) (2.49%)
    4.36ms
    1 x Before Access::preloadComponents (all components) (485.05KB) (1.98%)
    3.45ms
    1 x After Access::preloadComponents (all components) (117.7KB) (0.58%)
    1.02ms
    1 x After Access::preloadPermissions (com_sppagebuilder) (46.31KB) (0.3%)
    517μs
    1 x afterRenderModule mod_menu (Menu) (3.03KB) (0.22%)
    383μs
    1 x afterDispatch (2.28KB) (0.17%)
    304μs
    1 x After Access::getAssetRules (id:60 name:com_sppagebuilder) (7.84KB) (0.1%)
    173μs
    1 x Before Access::getAssetRules (id:60 name:com_sppagebuilder) (2.43KB) (0.02%)
    31μs
    1 x Before Access::getAssetRules (id:114 name:com_sppagebuilder.page.37) (2.06KB) (0.01%)
    17μs
    1 x After Access::getAssetRules (id:114 name:com_sppagebuilder.page.37) (1.61KB) (0.01%)
    12μs
    1 x beforeRenderModule mod_menu (Menu) (704B) (0.01%)
    11μs
44 statements were executed, 20 of which were duplicates, 24 unique13.29ms326.36KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
  • SELECT @@SESSION.sql_mode;190μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jossl_session` WHERE `session_id` = ?195μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jossl_session` WHERE `session_id` = :session_id LIMIT 1119μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jossl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)355μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jossl_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 194μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jossl_viewlevels`76μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jossl_usergroups` AS `a` LEFT JOIN `jossl_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest86μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jossl_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`132μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jossl_template_styles` WHERE `client_id` = 0 AND `home` = 179μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT `template` FROM `jossl_template_styles` WHERE `client_id` = 0 AND `home` = 188μs856B/plugins/system/helix3/helix3.php:247Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jossl_menu` AS `m` LEFT JOIN `jossl_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`2.78ms37.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `jossl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC176μs2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jossl_template_styles` AS `s` LEFT JOIN `jossl_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1104μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jossl_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,:preparedArray41,:preparedArray42,:preparedArray43)210μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SHOW FULL COLUMNS FROM `jossl_sppagebuilder`1.32ms2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `jossl_sppagebuilder` WHERE `id` = '37'1.19ms108.25KB/libraries/src/Table/Table.php:780Copy
  • UPDATE `jossl_sppagebuilder` SET `hits` = (`hits` + 1) WHERE `id` = '37'716μs2.55KB/libraries/src/Table/Table.php:1348Copy
  • SELECT a.*,`l`.`title` AS `language_title`,`ua`.`name` AS `author_name` FROM `jossl_sppagebuilder` AS `a` LEFT JOIN `jossl_languages` AS `l` ON `l`.`lang_code` = `a`.`language` LEFT JOIN `jossl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` WHERE `a`.`id` = 37 AND `a`.`published` = 1919μs108.27KB/components/com_sppagebuilder/models/page.php:75Copy
  • SELECT `id` FROM `jossl_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=37%' AND `published` = '1'261μs856B/components/com_sppagebuilder/helpers/route.php:112Copy
  • SELECT `id` FROM `jossl_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=37%' AND `published` = '1'44μs856B/components/com_sppagebuilder/helpers/route.php:112Copy
  • SELECT `id` FROM `jossl_menu` WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=37%' AND `published` = '1'23μs856B/components/com_sppagebuilder/helpers/route.php:112Copy
  • SELECT enabled FROM `jossl_extensions` WHERE `name` = 'com_easystore'53μs840B/administrator/components/com_sppagebuilder/editor/helpers/ApplicationHelper.php:138Copy
  • SELECT `template` FROM `jossl_template_styles` WHERE `client_id` = 0 AND `home` = 161μs856B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM jossl_tags WHERE `published` = '1') AS a LEFT JOIN `jossl_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`level` != '0' ORDER BY a.lft ASC62μs1.11KB/components/com_sppagebuilder/builder/classes/base.php:372Copy
  • SELECT a.enabled FROM `jossl_extensions` AS `a` WHERE `a`.`name` = 'com_k2'40μs840B/components/com_sppagebuilder/builder/classes/base.php:967Copy
  • SELECT a.enabled FROM `jossl_extensions` AS `a` WHERE `a`.`name` = 'com_k2'24μs840B/components/com_sppagebuilder/builder/classes/base.php:967Copy
  • SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM jossl_tags WHERE `published` = '1') AS a LEFT JOIN `jossl_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`level` != '0' ORDER BY a.lft ASC32μs1.11KB/components/com_sppagebuilder/builder/classes/base.php:372Copy
  • SELECT a.enabled FROM `jossl_extensions` AS `a` WHERE `a`.`name` = 'com_k2'19μs840B/components/com_sppagebuilder/builder/classes/base.php:967Copy
  • SELECT a.enabled FROM `jossl_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')94μs840B/components/com_sppagebuilder/builder/classes/base.php:864Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jossl_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 092μs2.55KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'82μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'73μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'76μs11.89KB/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'40μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'41μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT `a`.`name`,`a`.`css_path` FROM `jossl_sppagebuilder_assets` AS `a` WHERE `a`.`published` = 140μs896B/components/com_sppagebuilder/helpers/helper.php:2066Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'45μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'52μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `jossl_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'35μs912B/components/com_sppagebuilder/helpers/helper.php:2035Copy
  • SELECT `template` FROM `jossl_template_styles` WHERE `client_id` = 0 AND `home` = 148μs856B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jossl_modules` AS `m` LEFT JOIN `jossl_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jossl_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.6ms2.19KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `jossl_scheduler_tasks` AS `a` WHERE `a`.`state` = 1883μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jossl_session` WHERE `session_id` = ?188μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jossl_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?462μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy