Email us  01772 461454  | 360 Virtual Tour - NEW!
admin@newdaychurch.uk

01772 461454
admin@newdaychurch.uk    01772 461454

Graham Hooke

Details

Pastor at New Day Church (Retired)

Graham joined Calvary Christian Fellowship in 1978. His main role was as a worship leader before joining the full-time staff in 1993 and becoming senior leader in 1997. Previously he was Deputy Headteacher of a Penwortham primary school. He has recently led the church in transitioning to New Day Church, an ethos change as much as a name change - a place where people can make a fresh start in life.

He and his wife, Ruth married in 1980 and have two grown-up daughters, Sarah, a GP and Lydia, a student, and three grandsons.

Video Player

Media error: Format(s) not supported or source(s) not found

Download File: https://newdaychurch.uk/media/com_sermonspeaker/media/blank.mp3Download File: https://newdaychurch.uk/media/com_sermonspeaker/media/blank.mp3Download File: https://youtube.com/live/Kc9NLhZR-xI?feature=shareDownload File: https://youtube.com/live/AEwhUgW14Qo?feature=shareDownload File: https://www.youtube.com/watch?v=gKLoF7CSaz0Download File: https://youtube.com/live/ZAlnbjh7zmc?feature=shareDownload File: https://youtube.com/live/P_XbPlhhB_4?feature=shareDownload File: https://youtu.be/jR-o4vf3J1oDownload File: https://youtube.com/live/WIwrQQRJj34?feature=shareDownload File: https://youtu.be/K2ZoSuQv7zkDownload File: https://youtu.be/dCFjE_3wcd0Download File: https://youtu.be/FE_YO5-9aToDownload File: https://youtu.be/0ig_nVRhK5QDownload File: https://youtu.be/1EOEIMXjANkDownload File: https://youtu.be/8zFgMbHbBcADownload File: https://youtu.be/SleqLjGDNcADownload File: https://youtu.be/w55qq-ssiSUDownload File: https://newdaychurch.uk/media/com_sermonspeaker/media/blank.mp3Download File: https://youtu.be/ROnnw6wv4NIDownload File: https://youtu.be/FdOD1-KF3h4
00:00
00:00
00:00
Use Up/Down Arrow keys to increase or decrease volume.
Audio Player

Pushing the Boat Out

Details
Series: One-Off Talks
Date: Sunday, 23 February 2025
Scripture: Luke 5:1-11
Play the sermon

Grace Expectations - Graham Hooke

Details
Date: Sunday, 05 January 2025
Play the sermon

Seasons of Life

Details
Series: One-Off Talks
Date: Sunday, 03 November 2024
Scripture: Ecclesiastes 3
Play the sermon
Download Video

Heroic Influencer - GOAT?

Details
Series: One-Off Talks
Date: Sunday, 28 July 2024
Scripture: Acts 22-24
Play the sermon
Download Video

After the fire - when it all falls apart

Details
Series: One-Off Talks
Date: Sunday, 03 March 2024
Scripture: 1 Kings 19
Play the sermon
Download Video

New Beginnings

Details
Series: One-Off Talks
Date: Sunday, 07 January 2024
Play the sermon
Download Video

Jesus and the Church

Details
Series: Just Jesus
Date: Sunday, 05 November 2023
Scripture: Matthew 16:13-20
Play the sermon
Download Video

Stop Worrying and Start Living

Details
Series: One-Off Talks
Date: Sunday, 02 July 2023
Scripture: Matthew 6:25-34
Play the sermon
Download Video

Rebellion: The Golden Calf and the Corruption of the Beautiful.

Details
Series: Exodus
Date: Sunday, 26 March 2023
Scripture: Exodus 32
Play the sermon
Download Video

Israel in Egypt - Worship, work and slavery.

Details
Series: Exodus
Date: Sunday, 22 January 2023
Scripture: Exodus 5:1-6:9
Play the sermon
Download Video

The Good News of Christmas

Details
Series: An Unlikely Story - Christmas 2022
Date: Sunday, 04 December 2022
Play the sermon
Download Video

Harvest of Thanksgiving

Details
Series: One-Off Talks
Date: Sunday, 18 September 2022
Scripture: Psalm 1
Play the sermon
Download Video

Spirit Filled Proclamation

Details
Series: Acts of the Spirit
Date: Sunday, 29 May 2022
Scripture: Acts 2:14-40
Play the sermon
Download Video

Actions Speak Louder.

Details
Series: Sermon on the Mount
Date: Sunday, 27 March 2022
Scripture: Matthew 7:21-29
Play the sermon
Download Video

Not me Guv!  -  A Matter of the Heart

Details
Series: Sermon on the Mount
Date: Sunday, 16 January 2022
Scripture: Matthew 5:21-30
Play the sermon
Download Video

Finding Joy

Details
Series: Journey to Joy (Christmas 2021)
Date: Sunday, 19 December 2021
Scripture: Matthew 2:1-13
Play the sermon
Download Video

Eyewitnesses

Details
Series: One-Off Talks
Date: Sunday, 07 November 2021
Scripture: Acts 8
Play the sermon
Download Video

"It's all too much!" - PS

Details
Series: One-Off Talks
Date: Sunday, 19 September 2021
Play the sermon

"It's all too much!"

Details
Series: One-Off Talks
Date: Sunday, 12 September 2021
Scripture: 2 Peter 3
Play the sermon
Download Video

Healthy Relationships

Details
Series: One-Off Talks
Date: Sunday, 04 July 2021
Play the sermon
Download Video

Page 1 of 3

Acts of the Spirit

Details
Download

An Unlikely Story - Christmas 2022

Details
Download

Exodus

Details
Download

How one people’s struggle and deliverance created a platform for the restoration of God’s presence to humanity and thereby set the tone for the entire history of the Church.

Journey to Joy (Christmas 2021)

Details
Download

Just Jesus

Details
Download

A seven-part series looking specifically at Jesus, who he is, what he really did, his master plan for us and how we should respond.

Light in the Darkness

Details
Download

Christmas Series 2020

One-Off Talks

Details
Download

Galatians

Details
Download

Timothy: Honouring God

Details
Download

 

 

 

 

 

 

This series, entitled Timothy - Honouring God, was preached by Senior Pastor, Graham Hooke, at New Day Church during 2020. The series began before covid-19 hit and the first three talks were recorded in audio with slides. After that, as church was closed, we began creating videos for the dispersed congregation and the rest of the series is video talks recorded at home.

There are eight talks in the series.

Sermon on the Mount

Details
Download

 

new day footer silhouette
J! InfoRequestSessionProfileQueries59Log1
12MBMemory Usage543msRequest Duration
Joomla! Version4.3.4
PHP Version8.1.32
Identityguest
Response200
Templatert_koleti
Database
Server
mysql
Version
5.7.44-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:72 [ "CONTEXT_DOCUMENT_ROOT" => "/home/ndc1/public_html" "CONTEXT_PREFIX" => "" "DOCUMEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743604808 "last" => 1743604808...
registry
array:3 [ "data" => array:1 [ "com_sermonspeaker" => array:1 [ "series" => array:1 [ ...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (874.86KB) (47.19ms)
  • afterInitialise (2.2MB) (96.47ms)
  • afterRoute (1.05MB) (55.64ms)
  • beforeRenderComponent com_sermonspeaker (51.73KB) (503μs)
  • Before Access::preloadComponents (all components) (217.04KB) (13.49ms)
  • After Access::preloadComponents (all components) (133.45KB) (531μs)
  • Before Access::getAssetRules (id:66 name:com_sermonspeaker) (3.71KB) (17μs)
  • After Access::getAssetRules (id:66 name:com_sermonspeaker) (8KB) (536μs)
  • Before Access::preloadPermissions (com_sermonspeaker) (547.35KB) (55.03ms)
  • After Access::preloadPermissions (com_sermonspeaker) (26.88KB) (341μs)
  • afterRenderComponent com_sermonspeaker (1.63MB) (68.03ms)
  • afterDispatch (73.73KB) (5.74ms)
  • beforeRenderRawModule mod_latestsermons (Latest Talks) (2.76MB) (82.91ms)
  • afterRenderRawModule mod_latestsermons (Latest Talks) (50.29KB) (6.74ms)
  • beforeRenderModule mod_latestsermons (Latest Talks) (720B) (12μs)
  • afterRenderModule mod_latestsermons (Latest Talks) (6.68KB) (421μs)
  • beforeRenderRawModule mod_sermonspeaker (Series) (5.63KB) (468μs)
  • afterRenderRawModule mod_sermonspeaker (Series) (40.79KB) (2.86ms)
  • beforeRenderModule mod_sermonspeaker (Series) (720B) (8μs)
  • afterRenderModule mod_sermonspeaker (Series) (4.43KB) (128μs)
  • beforeRenderRawModule mod_sermonarchive (Talks Archive) (864B) (234μs)
  • afterRenderRawModule mod_sermonarchive (Talks Archive) (30.65KB) (1.44ms)
  • beforeRenderModule mod_sermonarchive (Talks Archive) (720B) (8μs)
  • afterRenderModule mod_sermonarchive (Talks Archive) (1.38KB) (107μs)
  • afterRender (983.84KB) (79.37ms)
  • 1 x afterInitialise (2.2MB) (17.76%)
    96.47ms
    1 x beforeRenderRawModule mod_latestsermons (Latest Talks) (2.76MB) (15.27%)
    82.91ms
    1 x afterRender (983.84KB) (14.61%)
    79.37ms
    1 x afterRenderComponent com_sermonspeaker (1.63MB) (12.53%)
    68.03ms
    1 x afterRoute (1.05MB) (10.25%)
    55.64ms
    1 x Before Access::preloadPermissions (com_sermonspeaker) (547.35KB) (10.13%)
    55.03ms
    1 x afterLoad (874.86KB) (8.69%)
    47.19ms
    1 x Before Access::preloadComponents (all components) (217.04KB) (2.48%)
    13.49ms
    1 x afterRenderRawModule mod_latestsermons (Latest Talks) (50.29KB) (1.24%)
    6.74ms
    1 x afterDispatch (73.73KB) (1.06%)
    5.74ms
    1 x afterRenderRawModule mod_sermonspeaker (Series) (40.79KB) (0.53%)
    2.86ms
    1 x afterRenderRawModule mod_sermonarchive (Talks Archive) (30.65KB) (0.26%)
    1.44ms
    1 x After Access::getAssetRules (id:66 name:com_sermonspeaker) (8KB) (0.1%)
    536μs
    1 x After Access::preloadComponents (all components) (133.45KB) (0.1%)
    531μs
    1 x beforeRenderComponent com_sermonspeaker (51.73KB) (0.09%)
    503μs
    1 x beforeRenderRawModule mod_sermonspeaker (Series) (5.63KB) (0.09%)
    468μs
    1 x afterRenderModule mod_latestsermons (Latest Talks) (6.68KB) (0.08%)
    421μs
    1 x After Access::preloadPermissions (com_sermonspeaker) (26.88KB) (0.06%)
    341μs
    1 x beforeRenderRawModule mod_sermonarchive (Talks Archive) (864B) (0.04%)
    234μs
    1 x afterRenderModule mod_sermonspeaker (Series) (4.43KB) (0.02%)
    128μs
    1 x afterRenderModule mod_sermonarchive (Talks Archive) (1.38KB) (0.02%)
    107μs
    1 x Before Access::getAssetRules (id:66 name:com_sermonspeaker) (3.71KB) (0%)
    17μs
    1 x beforeRenderModule mod_latestsermons (Latest Talks) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_sermonspeaker (Series) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_sermonarchive (Talks Archive) (720B) (0%)
    8μs
59 statements were executed, 15 of which were duplicates, 44 unique34.26ms467.46KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7
  • SELECT @@SESSION.sql_mode;76μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ndc1_session` WHERE `session_id` = ?204μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ndc1_session` WHERE `session_id` = :session_id LIMIT 1130μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ndc1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)901μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ndc1_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 184μs18.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ndc1_viewlevels`43μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ndc1_usergroups` AS `a` LEFT JOIN `ndc1_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest47μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ndc1_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`70μs4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `ndc1_menu` AS `m` LEFT JOIN `ndc1_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.21ms103.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ndc1_template_styles` AS `s` LEFT JOIN `ndc1_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` = 167μs1.48KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM ndc1_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_koleti' ORDER BY s.id133μs1.3KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `ndc1_languages` WHERE `published` = 1 ORDER BY `ordering` ASC77μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ndc1_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,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47)176μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT speaker.id, speaker.title, speaker.alias, speaker.website, speaker.state, speaker.catid,CASE WHEN CHAR_LENGTH(speaker.alias) THEN CONCAT_WS(':', speaker.id, speaker.alias) ELSE speaker.id END as slug,speaker.checked_out, speaker.checked_out_time, speaker.language,speaker.intro, speaker.bio, speaker.pic, speaker.hits, speaker.created, speaker.created_by,speaker.metakey, speaker.metadesc, speaker.created, speaker.created_by,speaker.publish_up, speaker.publish_down,c.title AS category_title, c.access AS category_access,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,user.name AS author FROM ndc1_sermon_speakers AS speaker LEFT JOIN ndc1_categories AS c on c.id = speaker.catid LEFT JOIN ndc1_users AS user ON user.id = speaker.created_by WHERE (speaker.publish_up = '0000-00-00 00:00:00' OR speaker.publish_up <= '2025-04-02 14:40:08') AND (speaker.publish_down = '0000-00-00 00:00:00' OR speaker.publish_down >= '2025-04-02 14:40:08') AND (speaker.catid = 0 OR c.published = 1) AND speaker.id = 2 AND speaker.state = 1547μs4.09KB/components/com_sermonspeaker/models/speaker.php:91Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ndc1_contentitem_tag_map` AS `m` INNER JOIN `ndc1_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)110μs5.2KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, speakers.bio, speakers.website,speakers.catid AS speaker_catid, speakers.language AS speaker_language,speakers.id AS speaker_id, speakers.intro, speakers.bio, speakers.website,CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar,series.catid AS series_catid, series.language AS series_language,CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author FROM `ndc1_sermon_sermons` AS sermons LEFT JOIN ndc1_sermon_scriptures AS script ON script.sermon_id = sermons.id LEFT JOIN ndc1_sermon_speakers AS speakers ON speakers.id = sermons.speaker_id LEFT JOIN ndc1_sermon_series AS series ON series.id = sermons.series_id LEFT JOIN ndc1_categories AS c_sermons ON c_sermons.id = sermons.catid LEFT JOIN ndc1_categories AS c_speaker ON c_speaker.id = speakers.catid LEFT JOIN ndc1_categories AS c_series ON c_series.id = series.catid LEFT JOIN ndc1_users AS user ON user.id = sermons.created_by WHERE (sermons.catid = 0 OR (c_sermons.access IN (1) AND c_sermons.published = 1)) AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1) AND c_speaker.published = 1)) AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1) AND c_series.published = 1)) AND (sermons.publish_up = '0000-00-00 00:00:00' OR sermons.publish_up <= '2025-04-02 14:40:08') AND (sermons.publish_down = '0000-00-00 00:00:00' OR sermons.publish_down >= '2025-04-02 14:40:08') AND sermons.state = 1 AND sermons.speaker_id = 2 GROUP BY sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,speakers.title, speakers.pic, speakers.state, speakers.catid, speakers.language, speakers.id, speakers.alias, speakers.intro, speakers.bio, speakers.website,series.title, series.avatar, series.state, series.catid, series.language, series.id, series.alias,c_sermons.title, c_sermons.id, c_sermons.alias,user.name ORDER BY sermon_date DESC LIMIT 209.43ms56.23KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, speakers.bio, speakers.website,speakers.catid AS speaker_catid, speakers.language AS speaker_language,speakers.id AS speaker_id, speakers.intro, speakers.bio, speakers.website,CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar,series.catid AS series_catid, series.language AS series_language,CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author FROM `ndc1_sermon_sermons` AS sermons LEFT JOIN ndc1_sermon_scriptures AS script ON script.sermon_id = sermons.id LEFT JOIN ndc1_sermon_speakers AS speakers ON speakers.id = sermons.speaker_id LEFT JOIN ndc1_sermon_series AS series ON series.id = sermons.series_id LEFT JOIN ndc1_categories AS c_sermons ON c_sermons.id = sermons.catid LEFT JOIN ndc1_categories AS c_speaker ON c_speaker.id = speakers.catid LEFT JOIN ndc1_categories AS c_series ON c_series.id = series.catid LEFT JOIN ndc1_users AS user ON user.id = sermons.created_by WHERE (sermons.catid = 0 OR (c_sermons.access IN (1) AND c_sermons.published = 1)) AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1) AND c_speaker.published = 1)) AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1) AND c_series.published = 1)) AND (sermons.publish_up = '0000-00-00 00:00:00' OR sermons.publish_up <= '2025-04-02 14:40:08') AND (sermons.publish_down = '0000-00-00 00:00:00' OR sermons.publish_down >= '2025-04-02 14:40:08') AND sermons.state = 1 AND sermons.speaker_id = 2 GROUP BY sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,speakers.title, speakers.pic, speakers.state, speakers.catid, speakers.language, speakers.id, speakers.alias, speakers.intro, speakers.bio, speakers.website,series.title, series.avatar, series.state, series.catid, series.language, series.id, series.alias,c_sermons.title, c_sermons.id, c_sermons.alias,user.name4.04ms107.17KB/libraries/src/MVC/Model/BaseDatabaseModel.php:211Copy
  • SELECT DISTINCT YEAR(`sermon_date`) AS `year` FROM `ndc1_sermon_sermons` WHERE `sermon_date` != '0000-00-00' AND state = 1 ORDER BY `year` ASC1.02ms968B/components/com_sermonspeaker/models/sermons.php:174Copy
  • SELECT DISTINCT MONTH(`sermon_date`) AS `value` FROM `ndc1_sermon_sermons` WHERE `sermon_date` != '0000-00-00' AND state = 1 ORDER BY `value` ASC627μs1.01KB/components/com_sermonspeaker/models/sermons.php:137Copy
  • SELECT DISTINCT `book` FROM `ndc1_sermon_scriptures` LEFT JOIN `ndc1_sermon_sermons` AS `sermons` ON `sermon_id` = `sermons`.`id` WHERE `book` != 0 AND `sermons`.`state` = 1 ORDER BY `book` ASC1.33ms1.45KB/components/com_sermonspeaker/models/sermons.php:205Copy
  • SELECT COUNT(1) FROM `ndc1_contentitem_tag_map` WHERE `type_alias` = 'com_sermonspeaker.sermon'43μs856B/components/com_sermonspeaker/models/sermons.php:224Copy
  • 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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC120μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM ndc1_wf_profiles WHERE published = 1 ORDER BY ordering ASC124μs2.25KB/components/com_jce/editor/libraries/classes/application.php:196Copy
  • SELECT * FROM ndc1_wf_profiles WHERE published = 1 ORDER BY ordering ASC56μs2.25KB/components/com_jce/editor/libraries/classes/application.php:196Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `ndc1_sermon_sermons` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `ndc1_categories` AS `c` WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 ORDER BY `c`.`lft`2.02ms5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ndc1_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 070μs2.23KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ndc1_assets`400μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ndc1_assets` WHERE `name` = 'com_sermonspeaker.sermons.category.root'52μs1.2KB/libraries/src/Table/Table.php:755Copy
  • SELECT series.id, series.title, series.catid, series.avatar, series.language, CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as slug, series.hits, series.series_description, series.alias, series.checked_out, series.checked_out_time, series.state, series.ordering, series.created, series.created_by, series.publish_up, series.publish_down, series.zip_dl,c_series.title AS category_title,CASE WHEN CHAR_LENGTH(c_series.alias) THEN CONCAT_WS(':', c_series.id, c_series.alias) ELSE c_series.id END as catslug,user.name AS author FROM `ndc1_sermon_series` AS series LEFT JOIN ndc1_categories AS c_series ON c_series.id = series.catid LEFT JOIN ndc1_users AS user ON user.id = series.created_by WHERE (series.catid = 0 OR (c_series.access IN (1) AND c_series.published = 1)) AND (series.publish_up = '0000-00-00 00:00:00' OR series.publish_up <= '2025-04-02 14:40:08') AND (series.publish_down = '0000-00-00 00:00:00' OR series.publish_down >= '2025-04-02 14:40:08') AND series.state = 1 AND series.state != -2 AND series.id IN ( SELECT DISTINCT series_id FROM ndc1_sermon_sermons WHERE speaker_id = 2 AND state = 1) ORDER BY ordering ASC LIMIT 201.57ms3.95KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT COUNT(*) FROM `ndc1_sermon_series` AS series LEFT JOIN ndc1_categories AS c_series ON c_series.id = series.catid LEFT JOIN ndc1_users AS user ON user.id = series.created_by WHERE (series.catid = 0 OR (c_series.access IN (1) AND c_series.published = 1)) AND (series.publish_up = '0000-00-00 00:00:00' OR series.publish_up <= '2025-04-02 14:40:08') AND (series.publish_down = '0000-00-00 00:00:00' OR series.publish_down >= '2025-04-02 14:40:08') AND series.state = 1 AND series.state != -2 AND series.id IN ( SELECT DISTINCT series_id FROM ndc1_sermon_sermons WHERE speaker_id = 2 AND state = 1)863μs856B/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • SHOW FULL COLUMNS FROM `ndc1_sermon_speakers`282μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ndc1_sermon_speakers` SET `hits` = (`hits` + 1) WHERE `id` = '2'424μs48B/libraries/src/Table/Table.php:1325Copy
  • 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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`158μs16.13KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ndc1_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC174μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`712μs5.14KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ndc1_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC730μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`114μs5.17KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ndc1_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC171μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`150μs5.17KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ndc1_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC120μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`110μs5.17KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC126μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`89μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`88μs5.17KBParams/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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC143μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `ndc1_categories` AS `s` INNER JOIN `ndc1_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`87μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT alias FROM ndc1_sermon_speakers WHERE id = 2148μs856B/components/com_sermonspeaker/router.php:130Copy
  • SELECT alias FROM ndc1_sermon_speakers WHERE id = 265μs856B/components/com_sermonspeaker/router.php:130Copy
  • SELECT alias FROM ndc1_sermon_speakers WHERE id = 233μs856B/components/com_sermonspeaker/router.php:130Copy
  • 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 ndc1_fields AS a LEFT JOIN `ndc1_languages` AS l ON l.lang_code = a.language LEFT JOIN ndc1_users AS uc ON uc.id=a.checked_out LEFT JOIN ndc1_viewlevels AS ag ON ag.id = a.access LEFT JOIN ndc1_users AS ua ON ua.id = a.created_user_id LEFT JOIN ndc1_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC149μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `ndc1_menu_types` AS `a` WHERE `a`.`client_id` = 053μs944B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM ndc1_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft58μs3.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ndc1_modules` AS `m` LEFT JOIN `ndc1_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ndc1_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)) 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.24ms2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT a.title, a.id, a.sermon_date, a.audiofile, a.videofile, a.sermon_time, a.picture, a.notes, a.hits, a.catid, a.language,b.title as speaker_title, b.pic, b.state AS speaker_state, b.catid AS speaker_catid, b.language AS speaker_language,c.title AS series_title, c.avatar, c.state AS series_state, c.catid AS series_catid, c.language AS series_language,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END as speaker_slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as series_slug,cat.title AS category_title,CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug FROM ndc1_sermon_sermons AS a LEFT JOIN ndc1_sermon_speakers AS b ON b.id = a.speaker_id LEFT JOIN ndc1_sermon_series AS c ON c.id = a.series_id LEFT JOIN ndc1_categories AS cat ON cat.id = a.catid WHERE a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-02 14:40:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-02 14:40:08') AND (a.catid = 58 OR a.catid IN ( SELECT sub.id FROM ndc1_categories as sub INNER JOIN ndc1_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt WHERE this.id = 58)) AND (a.catid = 0 OR (cat.access IN (1) AND cat.published = 1)) ORDER BY sermon_date DESC, (sermon_number+0) DESC LIMIT 71.6ms4.2KB/modules/mod_latestsermons/helper.php:175Copy
  • SELECT id, title, catid, language, series_description as tooltip, avatar as pic,CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug, 1 as level FROM ndc1_sermon_series WHERE state = 1 AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-02 14:40:08') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-02 14:40:08') AND catid = 59 ORDER BY ordering ASC461μs1.52KB/modules/mod_sermonspeaker/helper.php:86Copy
  • SELECT YEAR(`sermon_date`) AS `year`,CONCAT_WS('-', YEAR(`sermon_date`), MONTH(`sermon_date`), '15') AS `date`,0 AS `month` FROM ndc1_sermon_sermons WHERE `state` = 2 AND (`publish_up` = '0000-00-00 00:00:00' OR `publish_up` <= '2025-04-02 14:40:08') AND (`publish_down` = '0000-00-00 00:00:00' OR `publish_down` >= '2025-04-02 14:40:08') AND catid = 58 GROUP BY `year` ORDER BY `sermon_date` DESC400μs960B/modules/mod_sermonarchive/helper.php:73Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ndc1_modules` AS `m` LEFT JOIN `ndc1_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ndc1_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)) 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`124μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `ndc1_scheduler_tasks` AS `a` LEFT JOIN `ndc1_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc518μs4.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 `ndc1_scheduler_tasks` AS `a` LEFT JOIN `ndc1_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc78μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • warningassets - No asset found for com_sermonspeaker.sermons.category.root, falling back to com_sermonspeak...
warning