Obwohl die Mitglieder der niedersächsischen Band Carpathian Dream erst zwischen 18 und 22 Jahre jung sind, liegt mir mit "Frozen Tears" der bereits zweite Output der Band vor. Stiltechnisch gesehen kann man die Mucke in den Bereichen Dark und Gothic Metal ansiedeln, obwohl da noch einiges an ungewohnten Einflüssen, wie beispielsweise Thrash und manchmal ein Hauch von Punk beziehungsweise Crossover hinzukommt.

Etwas crossoverartig beginnt die CD. "Glencoe" wandelt sich dann aber mehr und mehr in thrashbeeinflussten Dark Metal mit teilweise kreischenden (wahrscheinlich mit Harmonizer künstlich etwas Sphäre hinzugemixten) und cleanen mehrstimmigen vocals. Vor allem melodische Riffs und rockige Soli machen das Stück so speziell, nur die Drums könnten etwas abwechslungsreicher sein. "Dreams" ist dann ein ganzes Stück langsamer, aber es hat einen so verträumt sphärischen Klang und eine cleane Stimme, die einem dazu bringt, nur noch sterben zu wollen. Ich muss mich extrem zurückhalten, dass ich meine Ohren nicht noch weiter schädige (nach den Metaldays in Pratteln), indem ich immer lauter drehe... Kennt jemand die Belgier Channel Zero? Hier tönen die Vocals ähnlich, wie die von Franky dem Sänger von Channel Zero, nur etwas sanfter.

Stellt euch vor, ihr habt eure Freundin so enorm gern, dass ihr sie töten müsst. Ihr legt sie dann in ihrem Blut badend in ein Orchideenfeld. Genau um dies geht es lyrisch gesehen im psychopathisch anmutenden "Orchid Field", das durch wunderschöne Gitarrenmelodien und spannende Drums auffält und zwischendurch einen inneren Kampf zwischen ruhig und brutal durchlebt. Sepultura meets Goth Rock würde "Someone" wahrscheinlich am besten beschreiben. Der Song ist für meinen Geschmack aber irgendwie kommerziell und scheint an chartbesetzende Furzer wie Slipknot usw. zu erinnern. Es ist einerseits der härteste der Songs und andererseits auch derjenige, der am ehesten chartgeeignet ist.

"Autumn Child" ist schliesslich wieder sehr ruhig und lässt mich träumen. Es ist rein instrumental und hat sogar Volkeinflüsse. Der letzte offizielle Track ist "Escape", der wieder etwas schneller ist und stellenweise stimmlich an Green Day erinnert... und trotzdem durch einige härtere Parts seinen Reiz hat. Danach folgen noch drei Bonustracks vom Demo "The Carpathian Awakening", das 1999 eingespielt wurde. Die Songs sind keyboardlastiger, brutaler und durchwegs sehr gut.

Trotzdem, dass Carpathian Dream teilweise zu wenig druckvoll und aggressiv sind, ist ihnen mit "Frozen Tears" ein originelles Album gelungen, das sich vom grauen Druchschnitt abzuheben vermag, gerade weil es eine Mischung aus verschiedensten Sounds darstellt. Für 15 Steine könnt ihr euch die CD einer Band, die totsicher noch von sich reden machen wird auf www.carpathiandream.de erhaschen!

 

Albuminfo

Punkte

 

3/5

Label

 

Eigenproduktion

Veröffentlichung

 

9/2002

Format

 

CD

Land

   

Genre

 

Dark Metal

8MBMemory Usage328msRequest Duration
Joomla! Version4.3.4
PHP Version8.0.30
Identityguest
Response200
Templatea4joomla-dark
Database
Server
mysql
Version
10.6.18-MariaDB-0ubuntu0.22.04.1
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:51 [ "USER" => "flamboyant" "HOME" => "/var/www/vhosts/flamboyant-hertz.92-205-176-165.ple...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748098899 "last" => 1748098899...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.flamboyant-hertz.92-205-176-165.plesk.page/index.php/kritike...
  • afterLoad (553.37KB) (9.07ms)
  • afterInitialise (1.61MB) (51.97ms)
  • afterRoute (246.41KB) (9.88ms)
  • beforeRenderComponent com_content (320.61KB) (7.48ms)
  • Before Access::preloadComponents (all components) (120.58KB) (1.83ms)
  • After Access::preloadComponents (all components) (102.56KB) (2.48ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (22μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (2.33ms)
  • Before Access::getAssetRules (id:299 name:com_content.article.752) (18.8KB) (265μs)
  • After Access::getAssetRules (id:299 name:com_content.article.752) (9.73KB) (237μs)
  • afterRenderComponent com_content (568.9KB) (171ms)
  • afterDispatch (3.14KB) (166μs)
  • beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (7.29ms)
  • afterRenderRawModule mod_menu (Info Menu) (38.98KB) (3.44ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (12μs)
  • afterRenderModule mod_menu (Info Menu) (2.9KB) (299μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (65μs)
  • afterRenderRawModule mod_login (Anmeldung) (163.84KB) (5.51ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (13μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (198μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (30μs)
  • afterRenderRawModule mod_tags_popular (Tags) (43.32KB) (7.36ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (9μs)
  • afterRenderModule mod_tags_popular (Tags) (3.45KB) (192μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (64μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (1.24ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (246μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (68μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (5.77ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (11μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (139μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (276.09KB) (13.27ms)
  • Before Access::getAssetRules (id:8 name:com_content) (74.41KB) (2.61ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (13μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (19.16KB) (15.78ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (8μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (146μs)
  • afterRender (71.84KB) (626μs)
  • 1 x afterRenderComponent com_content (568.9KB) (52.04%)
    170.72ms
    1 x afterInitialise (1.61MB) (15.84%)
    51.97ms
    1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (19.16KB) (4.81%)
    15.78ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (276.09KB) (4.05%)
    13.27ms
    1 x afterRoute (246.41KB) (3.01%)
    9.88ms
    1 x afterLoad (553.37KB) (2.76%)
    9.07ms
    1 x beforeRenderComponent com_content (320.61KB) (2.28%)
    7.48ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (43.32KB) (2.24%)
    7.36ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (2.22%)
    7.29ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (1.76%)
    5.77ms
    1 x afterRenderRawModule mod_login (Anmeldung) (163.84KB) (1.68%)
    5.51ms
    1 x afterRenderRawModule mod_menu (Info Menu) (38.98KB) (1.05%)
    3.44ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (74.41KB) (0.8%)
    2.61ms
    1 x After Access::preloadComponents (all components) (102.56KB) (0.76%)
    2.48ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (0.71%)
    2.33ms
    1 x Before Access::preloadComponents (all components) (120.58KB) (0.56%)
    1.83ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (0.38%)
    1.24ms
    1 x afterRender (71.84KB) (0.19%)
    626μs
    1 x afterRenderModule mod_menu (Info Menu) (2.9KB) (0.09%)
    299μs
    1 x Before Access::getAssetRules (id:299 name:com_content.article.752) (18.8KB) (0.08%)
    265μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (0.07%)
    246μs
    1 x After Access::getAssetRules (id:299 name:com_content.article.752) (9.73KB) (0.07%)
    237μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.06%)
    198μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.45KB) (0.06%)
    192μs
    1 x afterDispatch (3.14KB) (0.05%)
    166μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (0.04%)
    146μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.04%)
    139μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.02%)
    68μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.02%)
    65μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.02%)
    64μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.01%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0%)
    13μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    5μs
33 statements were executed, 7 of which were duplicates, 26 unique192ms1.18MB
  • SELECT @@SESSION.sql_mode;153μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?1.14ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 1134μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `sm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.61ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `sm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 13.21ms20.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`422μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `sm_usergroups` AS `a` LEFT JOIN `sm_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest734μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `sm_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.58ms16.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT id FROM sm_yendifvideoshare_imports WHERE state = 1 AND next_import_date IS NOT NULL AND next_import_date != '0000-00-00 00:00:00' AND next_import_date <= '2025-05-24 15:01:39' LIMIT 1791μs2.07KB/plugins/system/yendifvideoshare/yendifvideoshare.php:75Copy
  • 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 `sm_menu` AS `m` LEFT JOIN `sm_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`1.94ms28.92KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `sm_categories` AS `s` INNER JOIN `sm_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`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.63ms6.62KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC545μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `sm_template_styles` AS `s` LEFT JOIN `sm_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` = 11.49ms1.33KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `sm_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)1.87ms10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `sm_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.53ms49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`437μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '752'2.01ms2.55KB/libraries/src/Table/Table.php:1325Copy
  • 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 `sm_content` AS `a` INNER JOIN `sm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sm_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)1.73ms25.38KBParams/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 `sm_categories` AS `s` INNER JOIN `sm_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`829μs6.67KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_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)5.59ms5.73KBParams/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 `sm_categories` AS `s` INNER JOIN `sm_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`411μs6.67KBParams/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 sm_fields AS a LEFT JOIN `sm_languages` AS l ON l.lang_code = a.language LEFT JOIN sm_users AS uc ON uc.id=a.checked_out LEFT JOIN sm_viewlevels AS ag ON ag.id = a.access LEFT JOIN sm_users AS ua ON ua.id = a.created_user_id LEFT JOIN sm_fields_groups AS g ON g.id = a.group_id LEFT JOIN `sm_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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.64ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `sm_content` AS `a` LEFT JOIN `sm_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC136ms918.03KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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 `sm_categories` AS `s` INNER JOIN `sm_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`390μs6.67KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `sm_modules` AS `m` LEFT JOIN `sm_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `sm_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`2.86ms2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id194μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id80μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `sm_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `sm_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `sm_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray3,:preparedArray4) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 105.39ms3.53KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `sm_scheduler_tasks` AS `a` LEFT JOIN `sm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc1.12ms4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `sm_scheduler_tasks` AS `a` LEFT JOIN `sm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc577μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_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)1.13ms5.73KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `sm_content` AS `a` LEFT JOIN `sm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sm_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `sm_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `sm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sm_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` INNER JOIN `sm_contentitem_tag_map` AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` AND `tagmap`.`type_alias` = 'com_content.article' WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` NOT IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `tagmap`.`tag_id` = :tagId ORDER BY RAND() ASC LIMIT 310.6ms28.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `t`.`access` IN (:preparedArray4,:preparedArray5)1.05ms17.86KBParams/libraries/src/Helper/TagsHelper.php:448Copy