­
Chris Appleby Ministries

Chris Appleby Ministries

 

Search

Chris Appleby's Photos

Life in the Spirit -Help and Assurance  audio

Rom 8:26-39

Well, how’s life treating you?   That’s a fairly common question people might greet you with; commonly responded to with “Fine, thanks.” But is it fine? Or is life a bit tough at the moment, even if you don’t feel like sharing that with a mere acquaintance? Are you worried about some issue in your life? Are you concerned about the future?

Over the past few weeks we’ve been reading Paul’s letter to a church that were certainly doing it tough at a number of levels: at both the personal and external level. They were struggling with living lives that please God, and they were struggling with the pressure of living in a world where normal expectations and lifestyles were opposed to Christianity. In other words they weren’t that much different from us. Suffering is very much a universal experience.

Last week, though, Steve pointed out that we need to give thanks to God because the sufferings of this world can’t be compared to the glory that awaits us and now Paul goes on to build on that theme of thankfulness.

You know it’s interesting that most mentions of Christians suffering in the New Testament letters refer to the sort of suffering that arises from opposition or persecution but here he seems to have a much broader focus. If you look back at the previous couple of paragraphs you’ll see that he talks about the whole creation groaning as in the pains of childbirth. Well, there’s no question that the creation is groaning at the moment is there? With the global mean temperature at the highest point in recorded history, with ocean temperatures rising to the point where the Antarctic sea ice coverage, in the middle of winter, is at the smallest on record you’d have to say that this part of creation, this world, is certainly groaning.

On a smaller, more local scale we all groan, or perhaps cry out in protest, when we think about the various ailments that pop up from time to time, the tragedies that we experience, or see our friends experiencing; when we see the effect of disease and accidents on good people, even the effect of aging that some of us experience worse than others. We’ve all asked that perennial question, “Why do bad things happen to good people?”

We’re never given an answer to that question are we? All we’re told is what we find in those few verses last week: “The creation was subjected to futility … in the hope that the creation itself will be liberated from its bondage to decay and brought in to the freedom and glory of the children of God.”

You see, if we experience a sense of futility when we think about all the problems in our world, that’s simply a sign that we understand the reality of our world. Not much comfort though, is it?

Well Paul does finish this chapter with three good reasons for us to give thanks, three areas where we can find comfort.

Hope

The first is in vs 28-30: “28We know that all things work together for good for those who love God, who are called according to his purpose. 29For those whom he foreknew he also predestined to be conformed to the image of his Son, in order that he might be the firstborn within a large family. 30And those whom he predestined he also called; and those whom he called he also justified; and those whom he justified he also glorified.”

Now v28 there is probably one of the most misused verses in the Bible. I know I was told many times as I was growing up that all things work together for good for those who love God: to which my occasional response was the question “So, am I not loving God enough?” as things went wrong, as I had various accidents and other calamities. If God is a God who keeps his promises, what’s going on? Don’t tell me that everything will work out for good when I know that clearly they haven’t.

Well the thing is, this is just poor exegesis of the text. You can’t just pull out a nice sounding text and apply it willy-nilly. You need to read it in context. We need to read all three verses together. What’s the flow of the text? How do we know that all things will work out for those who love God, those whom God has called to be his children? Well look at what God has done. He’s called us and his plan is that we’ll be conformed to the image of his son. That is that, in the end, we’ll be made to be like Jesus.

One of Paul’s key descriptions of Christians in his letters is the phrase “In Christ”. In one place he talks about us having taken off the old nature and put on Christ, as though we’re now clothed not just in Christ’s clothing but in Christ himself. I think that’s the idea he has here. We’ve been given the Holy Spirit to change us into the image of Christ, or perhaps restore in us, the image of Christ. So he’s called us to follow him; and having called us he’s also justified us; that is, he’s made us right with him, wiping away every mark of sin from us, every failing; and the final step is that since we’re now made right with him we can also be glorified with him; that is, raised with Christ to God’s presence. Now clearly that hasn’t happened to me yet; or to any of you; but it will happen on the day that Jesus returns. And so we can rejoice and give thanks, that our future is secured, even as we experience the futility and suffering of life in a fallen world.

Faith

Then he gives us a firm reason for trusting in this promise in the form of a simple question: “If God is for us, who can be against us?” He’s saying, “Just give it some thought. What do you know about the gospel? If God gave up his only Son for our sake, what else could we need that he wouldn’t give us?” Is there something that you really need? Then ask God for it and if he agrees with you he’ll give it. God isn’t like the guy who lends his friend his car but expects his friend to fill it up before he brings it back. No, he lends us his car and gives us his fuel card to pay for the petrol as well.

And when you start to think that maybe you’re not good enough to deserve God’s kindness and generosity, read what comes next: “33Who will bring any charge against God's elect? It is God who justifies. 34Who is to condemn? It is Christ Jesus, who died, yes, who was raised, who is at the right hand of God, who indeed intercedes for us.”

Of course you don’t deserve God’s generosity and kindness. You don’t deserve to be forgiven. That’s basic to the idea of grace. Grace is the totally unmerited, unearned favour that God bestows on us. He forgives us purely out of his love for us, purely on the basis of Jesus’ sinless life and his death in our place. He forgives us because Jesus sits at his right hand asking for our sins, our failings, to be overlooked, washed away. If that’s the case then we can trust that God will continue to show us his grace no matter what failings we might see in ourselves.

Love

Underpinning all this of course is the love of God. He asks “35Who will separate us from the love of Christ? Will hardship, or distress, or persecution, or famine, or nakedness, or peril, or sword?” His question is about the strength of Christ’s love. “Just how strong is the love of Christ?” Is there something that might separate us from his love perhaps?

Well, let’s think about it. What are the sorts of things that separate people from each other? They say the greatest strain on marriages, the factor which most contributes to our high divorce rate, is worry over money, financial hardship. Hardship may well separate a husband from a wife, or a wife from a husband, but could there be any hardship great enough to separate us from God? What about distress, suffering? Again, human relationships may be damaged by the strain felt by people who are undergoing great distress or suffering, some great loss or tragedy in their life, but the love of God is often felt most strongly in those times as we lean on him for support even more than usual. And the same with the rest of that list: persecution, famine, nakedness, peril, sword? They’re all things that might separate us physically from human loved ones, but God’s love transcends those sorts of physical barriers. His plan for us runs through to eternity, to the realm of the spiritual, so no physical separation will harm it. All death does in that respect is to bring the fulfilment closer.

Victory

He rounds off this discussion with a statement about where our confidence comes from. “37No, in all these things we are more than conquerors through him who loved us.”

One of the clearest things we find as we read through this letter is that it isn’t our own efforts that bring victory over sin and death. No, it’s God who gives the victory. God has done everything necessary to make us right with him. He’s brought us through to the point where nothing can overcome us. Christ has won the victory and then shared the prize with us.

One of the events I always enjoy watching at the Olympics or the Commonwealth Games is the team pursuit in the cycling. I don’t know how familiar with the team pursuit you are, but the way it works is that there are 2 teams of four competing, each team riding in concert. The riders take turns at the head where the going is toughest and then move to the back of the pack to catch their breath. Sometimes one of them decides he can’t keep up the pace, so he drops out altogether. But the fact that he’s dropped out doesn’t stop the team from going on. What matters is that one of the team finishes. And even if one or two of the riders from the team have dropped out, if the lead rider crosses first, they all get the gold medal. Well, I think that’s a bit like what he’s talking about in v37: “No, in all these things we are more than conquerors through him who loved us.” How are we conquerors? We’re conquerors through Jesus Christ. He’s won the victory and we’re brought along in his wake to share the glory with him. In fact, he says, we’re more than conquerors. It’s as though the word isn’t enough to express all that Christ has won for us. His victory means more than we can ever imagine. His love is so great that nothing can ever separate us from it. Again, we have this list of forces that some people might imagine coming between us and Christ’s love: death, life, angels, rulers, things present, things to come, powers, 39height, depth. But no, there is nothing in all of creation that can separate us from God’s love.

How do we know our future is assured? How do we know we’re going to be with God when our time in this world is over? We know because our salvation is God’s work from start to finish. We know because God has poured out his love on us in Jesus Christ. We know because he’s filled us with his Spirit as the sign and seal of the salvation to come. We know because it’s God who’s begun this great work in us and who promises to bring it to completion on the last day. And we know because God has already shown us the measure of his love for us by giving up his own Son to bring us salvation.

If you ever find yourself wondering whether you can keep  going; if you ever find yourself doubting your salvation, doubting whether you're good enough for God, perhaps wondering whether it might all be too good to be true, remember that it’s God who sustains  us, God who justifies us, God who saves us, God whose love we’re depending on. And then we might join with Paul in saying that we too are “convinced that … nothing in all creation, will be able to separate us from the love of God in Christ Jesus our Lord.”

 

Contact Details

Phone: 0422187127
 
­
9.512MBMemory Usage403msRequest Duration
Joomla! Version5.2.5
PHP Version8.1.31
Identityguest
Response200
Templatersjuno
Database
Server
mysql
Version
8.0.28-0ubuntu0.20.04.3
Collation
utf8_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "CONTENT_LEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743893013 "last" => 1743893013...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_rsfirewall
array:1 [ "geoip" => array:1 [ "3.19.60.207" => "US" ] ]
  • afterLoad (95.33KB) (624μs)
  • afterInitialise (1.52MB) (40.8ms)
  • afterRoute (2.13MB) (57.85ms)
  • beforeRenderComponent com_content (175.05KB) (7.26ms)
  • Before Access::preloadComponents (all components) (71.37KB) (4.7ms)
  • After Access::preloadComponents (all components) (143.13KB) (2.99ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (13μs)
  • After Access::preloadPermissions (com_content) (153.71KB) (1.75ms)
  • Before Access::getAssetRules (id:366 name:com_content.article.688) (18.8KB) (18μs)
  • After Access::getAssetRules (id:366 name:com_content.article.688) (69.1KB) (653μs)
  • afterRenderComponent com_content (811.4KB) (120ms)
  • afterDispatch (109.03KB) (2.47ms)
  • beforeRenderRawModule mod_custom (footer) (509.86KB) (28.12ms)
  • afterRenderRawModule mod_custom (footer) (5.52KB) (2.35ms)
  • beforeRenderModule mod_custom (footer) (704B) (6μs)
  • afterRenderModule mod_custom (footer) (2.07KB) (720μs)
  • beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (785μs)
  • afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (20.25ms)
  • beforeRenderModule mod_banners (Dreamhost Banner) (704B) (6μs)
  • afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (293μs)
  • beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (1.09ms)
  • afterRenderRawModule mod_custom (Contact Details) (39.07KB) (3.58ms)
  • beforeRenderModule mod_custom (Contact Details) (720B) (5μs)
  • afterRenderModule mod_custom (Contact Details) (2.88KB) (63μs)
  • beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (258μs)
  • afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (965μs)
  • beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (5μs)
  • afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (67μs)
  • beforeRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (8.1KB) (51μs)
  • afterRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (125.79KB) (15.83ms)
  • beforeRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (752B) (4μs)
  • afterRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (14.44KB) (59μs)
  • beforeRenderRawModule mod_menu (Main Menu) (16.62KB) (750μs)
  • afterRenderRawModule mod_menu (Main Menu) (1.77MB) (39.39ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (10μs)
  • afterRenderModule mod_menu (Main Menu) (47.4KB) (315μs)
  • beforeRenderRawModule mod_finder (Search) (67.62KB) (417μs)
  • afterRenderRawModule mod_finder (Search) (74.49KB) (17.01ms)
  • beforeRenderModule mod_finder (Search) (704B) (7μs)
  • afterRenderModule mod_finder (Search) (3.73KB) (341μs)
  • beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (914μs)
  • afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (106μs)
  • beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (3μs)
  • afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (59μs)
  • afterRender (436.78KB) (29.75ms)
  • 1 x afterRenderComponent com_content (811.4KB) (29.8%)
    120ms
    1 x afterRoute (2.13MB) (14.35%)
    57.85ms
    1 x afterInitialise (1.52MB) (10.12%)
    40.80ms
    1 x afterRenderRawModule mod_menu (Main Menu) (1.77MB) (9.77%)
    39.39ms
    1 x afterRender (436.78KB) (7.38%)
    29.75ms
    1 x beforeRenderRawModule mod_custom (footer) (509.86KB) (6.98%)
    28.12ms
    1 x afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (5.02%)
    20.25ms
    1 x afterRenderRawModule mod_finder (Search) (74.49KB) (4.22%)
    17.01ms
    1 x afterRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (125.79KB) (3.93%)
    15.83ms
    1 x beforeRenderComponent com_content (175.05KB) (1.8%)
    7.26ms
    1 x Before Access::preloadComponents (all components) (71.37KB) (1.17%)
    4.70ms
    1 x afterRenderRawModule mod_custom (Contact Details) (39.07KB) (0.89%)
    3.58ms
    1 x After Access::preloadComponents (all components) (143.13KB) (0.74%)
    2.99ms
    1 x afterDispatch (109.03KB) (0.61%)
    2.47ms
    1 x afterRenderRawModule mod_custom (footer) (5.52KB) (0.58%)
    2.35ms
    1 x After Access::preloadPermissions (com_content) (153.71KB) (0.44%)
    1.75ms
    1 x beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (0.27%)
    1.09ms
    1 x afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (0.24%)
    965μs
    1 x beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (0.23%)
    914μs
    1 x beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (0.19%)
    785μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (16.62KB) (0.19%)
    750μs
    1 x afterRenderModule mod_custom (footer) (2.07KB) (0.18%)
    720μs
    1 x After Access::getAssetRules (id:366 name:com_content.article.688) (69.1KB) (0.16%)
    653μs
    1 x afterLoad (95.33KB) (0.15%)
    624μs
    1 x beforeRenderRawModule mod_finder (Search) (67.62KB) (0.1%)
    417μs
    1 x afterRenderModule mod_finder (Search) (3.73KB) (0.08%)
    341μs
    1 x afterRenderModule mod_menu (Main Menu) (47.4KB) (0.08%)
    315μs
    1 x afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (0.07%)
    293μs
    1 x beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (0.06%)
    258μs
    1 x afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (0.03%)
    106μs
    1 x afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (0.02%)
    67μs
    1 x afterRenderModule mod_custom (Contact Details) (2.88KB) (0.02%)
    63μs
    1 x afterRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (14.44KB) (0.01%)
    59μs
    1 x afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (0.01%)
    59μs
    1 x beforeRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (8.1KB) (0.01%)
    51μs
    1 x Before Access::getAssetRules (id:366 name:com_content.article.688) (18.8KB) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_banners (Dreamhost Banner) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (752B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (0%)
    3μs
44 statements were executed, 7 of which were duplicates, 37 unique85.37ms505.63KB
  • SELECT @@SESSION.sql_mode;278μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `J30_session` WHERE `session_id` = ?460μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = :session_id LIMIT 1288μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `J30_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)4.01ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `J30_viewlevels`890μs1.58KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `J30_usergroups` AS `a` LEFT JOIN `J30_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.19ms1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM J30_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'476μs840B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM J30_rsfirewall_hashes WHERE `type`='protect'184μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM J30_rsfirewall_configuration443μs3.44KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `J30_rsfirewall_logs`12.84ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM J30_rsfirewall_hashes WHERE (`type`='5.2.5' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)360μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM J30_rsfirewall_snapshots WHERE `type`='protect'429μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='3.19.60.207' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'313μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='3.19.60.207' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'387μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM J30_rsfirewall_exceptions WHERE `published`='1'360μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `J30_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.17ms2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_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)915μs10.63KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0853μs25.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `J30_content`12.75ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `J30_content` SET `hits` = (`hits` + 1) WHERE `id` = '688'4.33ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)3.01ms24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `J30_categories` AS `s` INNER JOIN `J30_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`990μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `J30_contentitem_tag_map` AS `m` INNER JOIN `J30_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.39ms5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `J30_categories` AS `s` INNER JOIN `J30_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`1.09ms5.19KBParams/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 J30_fields AS a LEFT JOIN `J30_languages` AS l ON l.lang_code = a.language LEFT JOIN J30_users AS uc ON uc.id=a.checked_out LEFT JOIN J30_viewlevels AS ag ON ag.id = a.access LEFT JOIN J30_users AS ua ON ua.id = a.created_user_id LEFT JOIN J30_fields_groups AS g ON g.id = a.group_id LEFT JOIN `J30_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC3.35ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `J30_users`10.2ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `J30_users` WHERE `id` = :userid345μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `J30_usergroups` AS `g` INNER JOIN `J30_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid421μs1.68KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `J30_template_styles` WHERE `client_id` = 0 AND `home` = 1394μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `J30_template_styles` WHERE `client_id` = 0 AND `home` = 1333μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `J30_modules` AS `m` LEFT JOIN `J30_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `J30_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.69ms298.13KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT * FROM `J30_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)2.58ms7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `J30_banners` AS `a` LEFT JOIN `J30_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 51.5ms13.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `J30_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)2.44ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • 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 J30_fields AS a LEFT JOIN `J30_languages` AS l ON l.lang_code = a.language LEFT JOIN J30_users AS uc ON uc.id=a.checked_out LEFT JOIN J30_viewlevels AS ag ON ag.id = a.access LEFT JOIN J30_users AS ua ON ua.id = a.created_user_id LEFT JOIN J30_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,: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 ASC1.81ms5.27KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT DISTINCT(i.id), i.filename, i.title, i.url, i.description, i.params, i.hits, i.created, i.modified FROM J30_rsmediagallery_items i LEFT JOIN J30_rsmediagallery_tags t ON (i.id=t.item_id) WHERE i.published='1' AND (t.tag='Chris A' OR t.tag='Chris') ORDER BY i.ordering asc LIMIT 251.92ms2.27KB/administrator/components/com_rsmediagallery/helpers/helper.php:56Copy
  • SELECT `name`,`element` FROM `J30_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.65ms976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `J30_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)1.7ms968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `J30_schemaorg` WHERE `itemId` = :itemId AND `context` = :context353μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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.26ms24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)552μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `J30_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.01ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = ?335μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `J30_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.13ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy