• DelawareSlide
  • FlagSlide

UN Conquers Texas

Newsflash

CTP Candidate Forums

Carrollton Tea Party, sponsors candidate forum APRIL 23rd for May local election of City Council and CFBISD School Board General Election - May 9, 2015 CFBISD SCHOOL ADMIN BUILDING 1445 N. Perry...


Read More...

Events - Other

Watch this calendar for conservative events: http://grassrootstexans.net/events/ (http://grassrootstexans.net/events/)


Read More...

Donate

The Carrollton Tea Party is non-profit, Non partisan organization and relies on donations to support education and awarness activities.  Click below to donate (a Paypal account is NOT required).

Obama and Holder in Contempt on Multiple Counts!

Obama and Holder are in contempt not only of the legislative process but also of the laws, constitution, heritage, U.S. allies, and we, the American people!

According to a popular blog, Obama and Holder are in contempt that is legally defined as:

“The willful defiance, disregard, or disrespect of judicial or legislative authority or dignity, especially any disobedience of an order or any conduct that disrupts, obstructs, or interferes with the administration or procedures of a court or legislature.”

Further, their contempt is also shown for:

  • The balance of powers in the constitution by bypassing congress
  • The separation of powers in the Constitution by trying to intimidate justices of the
  • Supreme Court justices and telling his appointed cronies in government offices to ignore
  • Limits on their powers
  • Our military and veterans by making our disabled and wounded heroes pay more of their own medical costs, but exempting civilian DOD employees under the same plan from paying the same costs. (Union members who contribute to the Obama reelection campaign do not have to abide by the laws and rules that the rest of us do.)

As tyrants and totalitarian governments behave, so behave BO and Holder. They punish those who oppose them and their ideals, and reward their own supporters and allies with our tax dollars!

Get the whole story! Read more about Contempt!
http://www.michaelconnelly.jigsy.com/

Welcome

We of the Carrollton Tea Party are dedicated to preserving, protecting, promoting, and defending the liberties and freedoms embodied in the Constitution of the United States.

We are a non-profit conservative grassroots organization, promoting activism in local and state issues. We are non-partisan, and do not support any particular political party. We are an all volunteer organization.  While we are based in Carrollton, Texas, other grassroots conservatives from other places are also members of our group, too. They come from places like Flower Mound and Lewisville.

We hold forums in which candidates for local seats are invited to speak, and we also attend local city council, city planning, and school board meetings.

Ad 1

Profile Information

Application 0.007 seconds (+0.007); 1.14 MB (+1.143) - afterLoad
Application 0.208 seconds (+0.202); 6.20 MB (+5.061) - afterInitialise
Application 0.240 seconds (+0.031); 7.45 MB (+1.250) - afterRoute
Application 0.642 seconds (+0.402); 13.07 MB (+5.616) - afterDispatch
Application 0.683 seconds (+0.041); 13.51 MB (+0.444) - beforeRenderModule mod_jTweet (jTweet)
Application 0.695 seconds (+0.011); 13.57 MB (+0.053) - afterRenderModule mod_jTweet (jTweet)
Application 0.707 seconds (+0.013); 13.60 MB (+0.035) - beforeRenderModule mod_custom (Logo)
Application 0.716 seconds (+0.008); 13.61 MB (+0.007) - afterRenderModule mod_custom (Logo)
Application 0.728 seconds (+0.013); 13.61 MB (+0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.785 seconds (+0.057); 13.74 MB (+0.129) - afterRenderModule mod_menu (Main Menu)
Application 0.833 seconds (+0.048); 14.63 MB (+0.884) - beforeRenderModule mod_widgetkit (Homepage SlideShow)
Application 0.842 seconds (+0.009); 14.68 MB (+0.053) - afterRenderModule mod_widgetkit (Homepage SlideShow)
Application 0.851 seconds (+0.009); 14.72 MB (+0.043) - beforeRenderModule mod_custom (TopVid)
Application 0.855 seconds (+0.004); 14.73 MB (+0.005) - afterRenderModule mod_custom (TopVid)
Application 0.866 seconds (+0.011); 14.68 MB (-0.045) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.883 seconds (+0.016); 14.72 MB (+0.031) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.892 seconds (+0.010); 14.76 MB (+0.046) - beforeRenderModule mod_search (Search)
Application 0.909 seconds (+0.017); 14.79 MB (+0.025) - afterRenderModule mod_search (Search)
Application 0.920 seconds (+0.012); 14.79 MB (+0.000) - beforeRenderModule mod_articles_latest (Latest Updates)
Application 0.957 seconds (+0.037); 15.12 MB (+0.338) - afterRenderModule mod_articles_latest (Latest Updates)
Application 0.967 seconds (+0.010); 14.93 MB (-0.196) - beforeRenderModule mod_articles_popular (Most Read)
Application 0.996 seconds (+0.029); 15.17 MB (+0.239) - afterRenderModule mod_articles_popular (Most Read)
Application 0.999 seconds (+0.003); 14.93 MB (-0.236) - beforeRenderModule mod_freeslider_sp1 (Newsflash)
Application 1.028 seconds (+0.030); 15.13 MB (+0.204) - afterRenderModule mod_freeslider_sp1 (Newsflash)
Application 1.045 seconds (+0.016); 15.09 MB (-0.041) - beforeRenderModule mod_menu (Hot Topics)
Application 1.089 seconds (+0.045); 15.13 MB (+0.040) - afterRenderModule mod_menu (Hot Topics)
Application 1.119 seconds (+0.029); 15.27 MB (+0.132) - beforeRenderModule mod_banners (Banners (bottom))
Application 1.146 seconds (+0.027); 15.44 MB (+0.174) - afterRenderModule mod_banners (Banners (bottom))
Application 1.157 seconds (+0.012); 15.43 MB (-0.009) - beforeRenderModule mod_custom (Bottom (about us))
Application 1.162 seconds (+0.004); 15.44 MB (+0.005) - afterRenderModule mod_custom (Bottom (about us))
Application 1.167 seconds (+0.005); 15.43 MB (-0.002) - beforeRenderModule mod_custom (Bottom (privacy))
Application 1.171 seconds (+0.004); 15.44 MB (+0.005) - afterRenderModule mod_custom (Bottom (privacy))
Application 1.192 seconds (+0.021); 15.44 MB (-0.002) - beforeRenderModule mod_custom (Bottom (donate))
Application 1.196 seconds (+0.004); 15.44 MB (+0.005) - afterRenderModule mod_custom (Bottom (donate))
Application 1.213 seconds (+0.017); 15.44 MB (-0.003) - beforeRenderModule mod_custom (Disclaimer)
Application 1.217 seconds (+0.004); 15.44 MB (+0.005) - afterRenderModule mod_custom (Disclaimer)
Application 1.226 seconds (+0.009); 15.44 MB (+0.000) - beforeRenderModule mod_menu (User Menu)
Application 1.235 seconds (+0.009); 15.45 MB (+0.009) - afterRenderModule mod_menu (User Menu)
Application 1.240 seconds (+0.005); 15.45 MB (-0.005) - beforeRenderModule mod_custom (Footer blurb)
Application 1.244 seconds (+0.004); 15.45 MB (+0.005) - afterRenderModule mod_custom (Footer blurb)
Application 1.259 seconds (+0.016); 15.35 MB (-0.098) - afterRender

Memory Usage

15.4 MB (16,145,392 Bytes)

35 Queries Logged

  1. SELECT `data`
      FROM `jml_session`
      WHERE `session_id` = '56665aef12002afad70a78c0a656586c'
  2. SELECT `session_id`
      FROM `jml_session`
      WHERE `session_id` = '56665aef12002afad70a78c0a656586c'
      LIMIT 0, 1
  3. INSERT INTO `jml_session` (`session_id`, `client_id`, `time`)
      VALUES ('56665aef12002afad70a78c0a656586c', 0, 1464076468)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jml_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `jml_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM jml_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jml_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT `value`
      FROM `jml_admintools_storage`
      WHERE `key` = 'cparams'
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jml_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
  10. SELECT *
      FROM jml_redj_redirects
      WHERE ( ( ('/' REGEXP BINARY fromurl)>0
      AND (case_sensitive<>0)
      AND (decode_url<>0)
      AND (request_only<>0) ) OR ( ('/' REGEXP BINARY fromurl)>0
      AND (case_sensitive<>0)
      AND (decode_url=0)
      AND (request_only<>0) ) OR ( ('http://carrolltonteaparty.com/' REGEXP BINARY fromurl)>0
      AND (case_sensitive<>0)
      AND (decode_url<>0)
      AND (request_only=0) ) OR ( ('http://carrolltonteaparty.com/' REGEXP BINARY fromurl)>0
      AND (case_sensitive<>0)
      AND (decode_url=0)
      AND (request_only=0) ) OR ( ('/' REGEXP fromurl)>0
      AND (case_sensitive=0)
      AND (decode_url<>0)
      AND (request_only<>0) ) OR ( ('/' REGEXP fromurl)>0
      AND (case_sensitive=0)
      AND (decode_url=0)
      AND (request_only<>0) ) OR ( ('http://carrolltonteaparty.com/' REGEXP fromurl)>0
      AND (case_sensitive=0)
      AND (decode_url<>0)
      AND (request_only=0) ) OR ( ('http://carrolltonteaparty.com/' REGEXP fromurl)>0
      AND (case_sensitive=0)
      AND (decode_url=0)
      AND (request_only=0) ) )
      AND published=1
      ORDER BY ordering
  11. 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 jml_menu AS m
      LEFT JOIN jml_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
  12. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jml_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  13. SELECT *
      FROM jml_languages
      WHERE published=1
      ORDER BY ordering ASC
  14. SELECT id, home, template, s.params
      FROM jml_template_styles as s
      LEFT JOIN jml_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
  15. SELECT a.rules
      FROM jml_assets AS a
      WHERE a.id = 1
  16. SELECT b.rules
      FROM jml_assets AS a
      LEFT JOIN jml_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  17. 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 jml_content AS a
      LEFT JOIN jml_categories AS c
      ON c.id = a.catid
      LEFT JOIN jml_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jml_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jml_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jml_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jml_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jml_categories AS cat JOIN jml_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
      INNER JOIN jml_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-24 07:54:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-24 07:54:29')
      GROUP BY a.id
      ORDER BY c.lft, fp.ordering, a.created DESC
      LIMIT 0, 5
  18. 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 jml_content AS a
      LEFT JOIN jml_categories AS c
      ON c.id = a.catid
      LEFT JOIN jml_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jml_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jml_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jml_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jml_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jml_categories AS cat JOIN jml_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
      INNER JOIN jml_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-24 07:54:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-24 07:54:29')
      GROUP BY a.id
      ORDER BY c.lft, fp.ordering, a.created DESC
  19. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jml_categories as c
      LEFT JOIN jml_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 jml_categories AS cat JOIN jml_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=78
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  20. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jml_categories as c
      LEFT JOIN jml_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 jml_categories AS cat JOIN jml_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=102
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  21. SELECT params
      FROM jml_extensions AS e
      WHERE e.element='com_widgetkit'
  22. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jml_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  23. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jml_modules AS m
      LEFT JOIN jml_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jml_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 <= '2016-05-24 07:54:29')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-05-24 07:54:29')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 435 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  24. SELECT *
      FROM jml_widgetkit_widget
      WHERE id=1
  25. 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 jml_content AS a
      LEFT JOIN jml_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jml_categories AS c
      ON c.id = a.catid
      LEFT JOIN jml_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jml_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jml_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jml_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jml_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jml_categories AS cat JOIN jml_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-24 07:54:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-24 07:54:29')
      GROUP BY a.id
      ORDER BY a.created DESC
      LIMIT 0, 5
  26. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jml_categories as c
      LEFT JOIN jml_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 jml_categories AS cat JOIN jml_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=93
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  27. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jml_categories as c
      LEFT JOIN jml_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 jml_categories AS cat JOIN jml_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=86
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  28. 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 jml_content AS a
      LEFT JOIN jml_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jml_categories AS c
      ON c.id = a.catid
      LEFT JOIN jml_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jml_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jml_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jml_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jml_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jml_categories AS cat JOIN jml_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.catid IN (78)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-24 07:54:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-24 07:54:29')
      GROUP BY a.id
      ORDER BY a.hits DESC
      LIMIT 0, 5
  29. 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 jml_content AS a
      LEFT JOIN jml_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jml_categories AS c
      ON c.id = a.catid
      LEFT JOIN jml_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jml_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jml_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jml_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jml_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jml_categories AS cat JOIN jml_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.catid IN (99)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-05-24 07:54:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-05-24 07:54:29')
      GROUP BY a.id
      ORDER BY a.publish_up ASC
      LIMIT 0, 9
  30. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jml_categories as c
      LEFT JOIN jml_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 jml_categories AS cat JOIN jml_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=99
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  31. SELECT *
      FROM jml_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  32. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jml_banners as a
      LEFT JOIN jml_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jml_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (10)
      ORDER BY a.sticky DESC,RAND()
  33. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jml_banners as a
      LEFT JOIN jml_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jml_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 1
      AND cl.state = 1
      AND a.catid IN (10)
      ORDER BY a.sticky DESC,RAND()
      LIMIT 0, 1
  34. UPDATE jml_banners
      SET impmade = (impmade + 1)
      WHERE id = 2
  35. UPDATE `jml_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1464076468;s:18:\"session.timer.last\";i:1464076468;s:17:\"session.timer.now\";i:1464076468;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;s:1:\"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` = 1464076470
      WHERE `session_id` = '56665aef12002afad70a78c0a656586c'

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jml_categories as c LEFT JOIN jml_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 jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  2. 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jml_extensions
  3. 2 × 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 jml_content AS a LEFT JOIN jml_categories AS c ON c.id = a.catid LEFT JOIN jml_users AS ua ON ua.id = a.created_by LEFT JOIN jml_users AS uam ON uam.id = a.modified_by LEFT JOIN jml_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml_categories as parent ON parent.id = c.parent_id LEFT JOIN jml_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  4. 2 × 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 jml_content AS a LEFT JOIN jml_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jml_categories AS c ON c.id = a.catid LEFT JOIN jml_users AS ua ON ua.id = a.created_by LEFT JOIN jml_users AS uam ON uam.id = a.modified_by LEFT JOIN jml_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml_categories as parent ON parent.id = c.parent_id LEFT JOIN jml_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM jml_banners as a LEFT JOIN jml_banner_clients AS cl ON cl.id = a.cid LEFT JOIN jml_categories as cat ON a.catid = cat.id
  6. 1 × SELECT * FROM jml_banners
  7. 1 × SELECT params FROM jml_extensions AS e
  8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jml_modules AS m LEFT JOIN jml_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jml_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  9. 1 × SELECT b.rules FROM jml_assets AS a LEFT JOIN jml_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  10. 1 × SELECT * FROM jml_widgetkit_widget
  11. 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 jml_content AS a LEFT JOIN jml_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jml_categories AS c ON c.id = a.catid LEFT JOIN jml_users AS ua ON ua.id = a.created_by LEFT JOIN jml_users AS uam ON uam.id = a.modified_by LEFT JOIN jml_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml_categories as parent ON parent.id = c.parent_id LEFT JOIN jml_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  12. 1 × SELECT a.rules FROM jml_assets AS a
  13. 1 × SELECT folder AS type, element AS name, params FROM jml_extensions
  14. 1 × SELECT id, rules FROM `jml_viewlevels
  15. 1 × SELECT `session_id` FROM `jml_session`
  16. 1 × SELECT `value` FROM `jml_admintools_storage`
  17. 1 × SELECT * FROM jml_redj_redirects
  18. 1 × SELECT id, home, template, s.params FROM jml_template_styles as s LEFT JOIN jml_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  19. 1 × SELECT * FROM jml_languages
  20. 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 jml_menu AS m LEFT JOIN jml_extensions AS e ON m.component_id = e.extension_id
  21. 1 × SELECT `data` FROM `jml_session`
OTHER Tables:
  1. 1 × UPDATE `jml_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1464076468;s:18:\"session.timer.last\";i:1464076468;s:17:\"session.timer.now\";i:1464076468;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;s:1:\"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` = 1464076470
  2. 1 × UPDATE jml_banners SET impmade = (impmade + 1)
  3. 1 × INSERT INTO `jml_session` (`session_id`, `client_id`, `time`) VALUES ('56665aef12002afad70a78c0a656586c', 0, 1464076468