Strict Standards: Accessing static property JCache::$_handler as non static in /home3/agghanac/public_html/gh/libraries/joomla/cache/cache.php on line 420
Assemblies Of God, Ghana

Strict Standards: Non-static method modGTranslateHelper::getParams() should not be called statically in /home3/agghanac/public_html/gh/modules/mod_gtranslate/mod_gtranslate.php on line 13

Notice: Array to string conversion in /home3/agghanac/public_html/gh/components/com_content/models/articles.php on line 131
News-File

Strict Standards: Non-static method modNewsHighlighterHelper::getText() should not be called statically in /home3/agghanac/public_html/gh/modules/mod_sp_news_highlighter/tmpl/default.php on line 47
Let the insults cease - Saturday, 17 March 2012 13:17

AG Gallery


Strict Standards: Only variables should be assigned by reference in /home3/agghanac/public_html/gh/modules/mod_lv_enhanced_image_slider/tmpl/default.php on line 36

Theme 2014


Notice: Array to string conversion in /home3/agghanac/public_html/gh/components/com_content/models/articles.php on line 131

EPHESIANS 4:3  Endeavoring to keep the unity of the Spirit in the bond of peace.

The call to unity in any field of endeavour is certainly a call in the right direction.  In the corporate world, in institutions, in politics or nation building, in the home and family unit, or wherever humans find themselves, unity is a virtue that cannot be overemphasized. In the church, and more specifically, Assemblies of God, Ghana, this call could not have come at a better time.

This is not to say that there is fragmentation in the organization, but rather to emphasize an ingredient needed for the forward move, especially as we embark on novelty projects. It is important to remember that God responds to unity whether it is towards a good cause or an evil one.  Unity is always significant.

In the passage, Unity goes beyond a form of friendship or camaraderie, as may be the case in a supporters’ club.  Supporters of a team, a club, a political party, or any cause will of necessity have to unite their efforts in a bid to achieve their objective.  Unity in the Spirit goes beyond this.  Apostle Paul alludes to the fact that Unity is both an Attitude in line with our Walk, and an Activity in line with our Ways. 

In explaining Unity, he first of all gives us the basis of his admonishing.  I, therefore, the prisoner of the Lord, beseech you to walk worthy of the calling with which you were called, verse 1.  Our Unity must be based on the fact that we have been called by the Lord.  The Christian life is a Calling – a heavenly calling, a holy calling, and a high calling.  We are called into a special relationship with the Lord which requires an attitude of unity.  Unity ought to be the product of our common response to the call of God. 

Paul was very much aware of the diverse backgrounds, different tribes and cultures, multiple ideological persuasions, and pluralistic tendencies in his readers.  However, they still have something in common that should be the propelling force in getting united – the calling with which you were called.  If we accept that we have all responded to the same calling from one Lord and Saviour, then we should put aside every other interest or personal persuasion and relate in unity.  We should also be conscious of other people’s diverse opinions, but still seek unity.

Unity may not come naturally.  Staying united demands a certain effort.  It requires the nurturing of a certain attitude that looks beyond ourselves.  This is so because people’s approaches, adaptations, achievements, aspirations, and anticipations are never the same, and can never be the same.  It is no secret that some people are just not easy to live with or work with.  Unity is not a matter of putting our differences in one melting pot in order to come out with one identifiable goal for us all.  Unity is accepting and accommodating our differences, based on the fact that we have something in common that is more compelling.  That is why Paul mentions that we should seek unity “with all lowliness and gentleness, with longsuffering, bearing with one another in love.”  Unity requires an attitude of humility, tolerance, and love. 

Paul also describes Unity as an Activity that should reflect our ways as Christians.  Christian Unity is a product of the Holy Spirit, yet Paul encourages believers to endeavour to keep it.  This requires a conscious and active effort.  Since God created us with the freedom of choice, He cannot force unity on us.  Unity then is not a mechanical situation, but a vital, living, and active result of our activity.

Our active effort at staying in unity is once again boosted by the fact that there are many and more crucial things that should unite us than the things that should make us go our separate directions. There is one body and one Spirit, just as you were called in one hope of your calling; one Lord, one faith, one baptism; one God and Father of all, who is above all, and through all, and in you all.  Our salvation is characterized by one Derivation, one Duration, and one Destination.  That should settle it.

As a vital and vibrant church organization, we are undoubtedly doing very well in our various parishes and communities.  We may have individual hopes and aspirations for our congregations, which define and determine our activities.  We possess varied abilities, gifts, and anointing.  We have acquired diverse degrees in different fields of endeavour.  Everything we can think of favours our personalized approach to ministry, even the organizational structure itself. 

Our autonomy should not be the basis for disunity and division.  We cannot achieve growth, maturity, and national relevance if we follow our individual routes.  Belonging to one organization, having responded to one calling, serving one Master, sustained by one Spirit, aiming at one hope, and expecting one eternal habitation, the need for unity cannot be overemphasized.  In unity lie our Strength, our Sustenance, and our Success.

Our unity must not mean the merging of our visions but the acceptance of one overriding, organizational, and controlling vision.  It should mean setting aside our individual interests, and rallying behind the driving machinery, which in this case is the Executive Presbytery, when the need arises.  Our identity as an organization should be more important to all of us.

The year 2014 holds a lot of monumental developments for our organization.  The University takes off, the Pension Scheme gains root, the Headquarters building and several new projects receive attention.  A united organization, rallying behind the Leadership, is what will bring the results.

In our local churches, the same call to Unity should persist.  A united membership is strategic for the spiritual, numerical, and financial growth.  The same principle of rallying behind one supreme vision applies to every local church.  As Spirit-filled members and ministers, let us allow the unifying elements of our faith and hope to carry us to our deserved destination.

Profile Information

Application 0.015 seconds (+0.015); 0.56 MB (+0.560) - afterLoad
Application 0.614 seconds (+0.598); 3.38 MB (+2.824) - afterInitialise
Application 0.663 seconds (+0.050); 3.93 MB (+0.542) - afterRoute
Application 1.143 seconds (+0.479); 6.80 MB (+2.872) - afterDispatch
Application 1.198 seconds (+0.055); 6.98 MB (+0.183) - beforeRenderModule mod_lv_enhanced_image_slider (AG Gallery)
Application 1.332 seconds (+0.135); 7.04 MB (+0.055) - afterRenderModule mod_lv_enhanced_image_slider (AG Gallery)
Application 1.333 seconds (+0.000); 7.02 MB (-0.014) - beforeRenderModule mod_weblinks (Leadership)
Application 1.402 seconds (+0.069); 7.26 MB (+0.236) - afterRenderModule mod_weblinks (Leadership)
Application 1.402 seconds (+0.000); 7.21 MB (-0.044) - beforeRenderModule mod_weblinks (AG Ghana Information)
Application 1.419 seconds (+0.017); 7.26 MB (+0.049) - afterRenderModule mod_weblinks (AG Ghana Information)
Application 1.430 seconds (+0.011); 7.26 MB (-0.004) - beforeRenderModule mod_articles_latest (Theme 2014)
Application 1.493 seconds (+0.063); 7.46 MB (+0.199) - afterRenderModule mod_articles_latest (Theme 2014)
Application 1.493 seconds (+0.000); 7.42 MB (-0.043) - beforeRenderModule mod_arsdlid (Download )
Application 1.525 seconds (+0.032); 7.43 MB (+0.010) - afterRenderModule mod_arsdlid (Download )
Application 1.526 seconds (+0.000); 7.43 MB (+0.004) - beforeRenderModule mod_djimageslider (DJ-Image Slider for home page -main)
Application 1.580 seconds (+0.055); 7.58 MB (+0.151) - afterRenderModule mod_djimageslider (DJ-Image Slider for home page -main)
Application 1.581 seconds (+0.000); 7.55 MB (-0.028) - beforeRenderModule mod_iyosis_facebook (Iyosis Facebook Module)
Application 1.612 seconds (+0.031); 7.59 MB (+0.042) - afterRenderModule mod_iyosis_facebook (Iyosis Facebook Module)
Application 1.612 seconds (+0.000); 7.59 MB (-0.007) - beforeRenderModule mod_sp_news_highlighter (News-press)
Application 1.677 seconds (+0.065); 7.77 MB (+0.184) - afterRenderModule mod_sp_news_highlighter (News-press)
Application 1.678 seconds (+0.001); 7.69 MB (-0.087) - beforeRenderModule mod_maximenu_CK (Maxi Menu CK Main)
Application 1.721 seconds (+0.043); 7.98 MB (+0.299) - afterRenderModule mod_maximenu_CK (Maxi Menu CK Main)
Application 1.722 seconds (+0.001); 7.90 MB (-0.083) - beforeRenderModule mod_gtranslate (GTranslate)
Application 1.756 seconds (+0.035); 8.01 MB (+0.105) - afterRenderModule mod_gtranslate (GTranslate)
Application 1.757 seconds (+0.000); 7.92 MB (-0.081) - beforeRenderModule mod_weblinks (Mail-Login)
Application 1.762 seconds (+0.006); 7.94 MB (+0.019) - afterRenderModule mod_weblinks (Mail-Login)
Application 1.779 seconds (+0.017); 8.02 MB (+0.072) - afterRender

Memory Usage

8.06 MB (8,448,688 Bytes)

39 Queries Logged

  1. SELECT `data`
      FROM `ihgad_session`
      WHERE `session_id` = '6839e5tjlv67rpsqeh6kef06d6'
  2. DELETE
      FROM `ihgad_session`
      WHERE `time` < 1398248325
  3. SELECT `session_id`
      FROM `ihgad_session`
      WHERE `session_id` = '6839e5tjlv67rpsqeh6kef06d6'
      LIMIT 0, 1
  4. INSERT INTO `ihgad_session` (`session_id`, `client_id`, `time`)
      VALUES ('6839e5tjlv67rpsqeh6kef06d6', 0, 1398249225)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `ihgad_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM ihgad_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
  10. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, 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,e.element as component
      FROM ihgad_menu AS m
      LEFT JOIN ihgad_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. SELECT *
      FROM ihgad_languages
      WHERE published=1
      ORDER BY ordering ASC
  13. SELECT id, home, template, s.params
      FROM ihgad_template_styles as s
      LEFT JOIN ihgad_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 = 1
  14. SELECT a.rules
      FROM ihgad_assets AS a
      WHERE a.id = 1
  15. SELECT b.rules
      FROM ihgad_assets AS a
      LEFT JOIN ihgad_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  16. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM ihgad_content AS a
      LEFT JOIN ihgad_categories AS c
      on c.id = a.catid
      LEFT JOIN ihgad_users AS u
      on u.id = a.created_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:45')
      AND (a.state = 1 OR a.state =2)
  17. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM ihgad_categories as c
      LEFT JOIN ihgad_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=40
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  18. UPDATE ihgad_content
      SET hits = hits + 1
      WHERE id = 32
  19. SELECT params
      FROM ihgad_extensions AS e
      WHERE e.element='com_widgetkit'
  20. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM ihgad_modules AS m
      LEFT JOIN ihgad_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN ihgad_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-04-23 10:33:46')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-04-23 10:33:46')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  22. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_weblinks'
  23. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 37
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
  24. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 37
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
      LIMIT 0, 6
  25. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 38
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
  26. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 38
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
      LIMIT 0, 5
  27. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null 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,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM ihgad_content AS a
      LEFT JOIN ihgad_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.featured = 0
      AND a.catid IN (40)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:46')
      GROUP BY a.id
      ORDER BY a.created DESC
      LIMIT 0, 5
  28. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_djimageslider'
  29. SELECT a.*
      FROM ihgad_djimageslider AS a
      WHERE a.catid = 32
      AND a.published = 1
      ORDER BY a.ordering ASC
      LIMIT 0, 20
  30. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM ihgad_content AS a
      LEFT JOIN ihgad_categories AS c
      on c.id = a.catid
      LEFT JOIN ihgad_users AS u
      on u.id = a.created_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:46')
      AND (a.state = 1 OR a.state =2)
  31. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM ihgad_content AS a
      LEFT JOIN ihgad_categories AS c
      on c.id = a.catid
      LEFT JOIN ihgad_users AS u
      on u.id = a.created_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:46')
      AND (a.state = 1 OR a.state =2)
  32. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM ihgad_content AS a
      LEFT JOIN ihgad_categories AS c
      on c.id = a.catid
      LEFT JOIN ihgad_users AS u
      on u.id = a.created_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:46')
      AND (a.state = 1 OR a.state =2)
  33. SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM ihgad_content AS a
      LEFT JOIN ihgad_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ihgad_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN ihgad_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ihgad_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.featured = 0
      AND a.catid IN (28)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-23 10:33:46')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-23 10:33:46')
      GROUP BY a.id
      ORDER BY a.title ASC
      LIMIT 0, 2
  34. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM ihgad_categories as c
      LEFT JOIN ihgad_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM ihgad_categories AS cat JOIN ihgad_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=28
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  35. SELECT *
      FROM ihgad_modules
      WHERE published=1
      ORDER BY id ;
  36. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM ihgad_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  37. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 29
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
  38. SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
      FROM `ihgad_weblinks` AS a
      LEFT JOIN ihgad_categories AS c
      ON c.id = a.catid
      LEFT JOIN ihgad_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ihgad_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1)
      AND a.catid = 29
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      ORDER BY ordering asc
      LIMIT 0, 5
  39. UPDATE `ihgad_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1398249225;s:18:\"session.timer.last\";i:1398249225;s:17:\"session.timer.now\";i:1398249225;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1398249226
      WHERE `session_id` = '6839e5tjlv67rpsqeh6kef06d6'

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 8 × SELECT extension_id AS "id", element AS "option", params, enabled FROM ihgad_extensions
  2. 6 × SELECT a.*, c.published AS c_published, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, DATE_FORMAT(a.date, "%Y-%m-%d") AS created,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author FROM `ihgad_weblinks` AS a LEFT JOIN ihgad_categories AS c ON c.id = a.catid LEFT JOIN ihgad_users AS ua ON ua.id = a.created_by LEFT JOIN ihgad_users AS uam ON uam.id = a.modified_by
  3. 4 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM ihgad_content AS a LEFT JOIN ihgad_categories AS c on c.id = a.catid LEFT JOIN ihgad_users AS u on u.id = a.created_by LEFT JOIN ihgad_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN ihgad_categories as parent ON parent.id = c.parent_id LEFT JOIN ihgad_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ihgad_categories AS cat JOIN ihgad_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  4. 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM ihgad_categories as c LEFT JOIN ihgad_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM ihgad_categories AS cat JOIN ihgad_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM ihgad_modules AS m LEFT JOIN ihgad_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN ihgad_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  6. 1 × SELECT params FROM ihgad_extensions AS e
  7. 1 × SELECT a.* FROM ihgad_djimageslider AS a
  8. 1 × SELECT * FROM ihgad_modules
  9. 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ihgad_content AS a LEFT JOIN ihgad_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN ihgad_categories AS c ON c.id = a.catid LEFT JOIN ihgad_users AS ua ON ua.id = a.created_by LEFT JOIN ihgad_users AS uam ON uam.id = a.modified_by LEFT JOIN ihgad_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN ihgad_categories as parent ON parent.id = c.parent_id LEFT JOIN ihgad_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ihgad_categories AS cat JOIN ihgad_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  10. 1 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null 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,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ihgad_content AS a LEFT JOIN ihgad_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN ihgad_categories AS c ON c.id = a.catid LEFT JOIN ihgad_users AS ua ON ua.id = a.created_by LEFT JOIN ihgad_users AS uam ON uam.id = a.modified_by LEFT JOIN ihgad_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN ihgad_categories as parent ON parent.id = c.parent_id LEFT JOIN ihgad_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ihgad_categories AS cat JOIN ihgad_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  11. 1 × SELECT b.rules FROM ihgad_assets AS a LEFT JOIN ihgad_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  12. 1 × SELECT folder AS type, element AS name, params FROM ihgad_extensions
  13. 1 × SELECT id, rules FROM `ihgad_viewlevels
  14. 1 × SELECT `session_id` FROM `ihgad_session`
  15. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, 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,e.element as component FROM ihgad_menu AS m LEFT JOIN ihgad_extensions AS e ON m.component_id = e.extension_id
  16. 1 × SELECT * FROM ihgad_languages
  17. 1 × SELECT a.rules FROM ihgad_assets AS a
  18. 1 × SELECT id, home, template, s.params FROM ihgad_template_styles as s LEFT JOIN ihgad_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  19. 1 × SELECT `data` FROM `ihgad_session`
OTHER Tables:
  1. 1 × UPDATE `ihgad_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1398249225;s:18:\"session.timer.last\";i:1398249225;s:17:\"session.timer.now\";i:1398249225;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1398249226
  2. 1 × UPDATE ihgad_content SET hits = hits + 1
  3. 1 × INSERT INTO `ihgad_session` (`session_id`, `client_id`, `time`) VALUES ('6839e5tjlv67rpsqeh6kef06d6', 0, 1398249225
  4. 1 × DELETE FROM `ihgad_session`