State Teams Event 011

The Commercial Hotel finished 4th in the State Teams event held at the LWC on March 19th & 20th, narrowly missing the finals when losing their last match against eventual winners the Foreshore Breakers 14 - 10, the LWC Scorpions finsihed 5th, full results on the Eightball Tasmania web site

Devonport Rep Match 2010

NTEBA v Devonport 8Ball Association
Sunday February 21st at the Launceston Workers Club - 11.00am
Won by NTEBA in the 3 Grades of Matches

Summer Results 2010-11

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4709

J.Boag & Son Summer Roster Grand Finals 011

The 2011 Summer Roster Grand Finals were played at the LWC on Saturday 5th March with an even representative of Hotels / Clubs across the 3 Grand Finals

The Div 1 Grand Finals saw the LWC Scorpions taking on the Riverside Hotel with the Riverside team taking an early lead of 3 - 2 after the first set of 5 frames, the LWC team then won the next 4 frames to take a 6 - 4 lead after 10 frames, the LWC team then quickly wrapped the match winning 8 - 4

Div 2 saw the LWC Black team play the Duke of Wellington, the Duke got away to a great start winning 4 - 1 in the first set and then 3 - 2 in the second set and winning the match in the third set 8 - 5

In Div 3 the TRC took on the Legana Tavern team and this proved the closest match of the night with the TRC winning 8 - 6

Score Sheets from the Grand Finals can be viewed on the NTEBA web site in the weekly results section and photos from the night can be viewed on our facebook page - https://www.facebook.com/NTEBA8Ball

LWC Scorpions

Duke of Wellington

TRC

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4760

NTEBA v Devonport 8Ball Associaton

Sunday February 20th

Venue: Sheffield RSL Club

77 Main St, Sheffield

Time 10.45am for 11.00am start

Open Team: Bradley Grant (Captain), Peter Miller, Ethan Brown, Rodney Martin, Zane Brown, Troy Rudling, Jenna Sampson, Denise Millington, Kris Cherry Alex Brooks, Andrew Rainbow

A Reserve Team: Lee Morcom (Captain), Paul Styles, David Kearnes, Andrew Johnson, Glenn Selby, Richard Austin, Simon Thomas, Heath Rainbow, Nicky Hodgetts, Greg Cooper

Women / Under 25: Sally Jackson, Debbie Rainbow, Janelle Kearnes, Alex Marshall, Tony Quach, Josh Rainbow

Bus to leave LWC at 9.15am and is only for players who have indicated they require, all other players to be at Sheffield RSL by 10.45am

Any player not available please contact us ASAP via email or 0419 393 838 / 63448788

Read more: NTEBA v Devonport 2011

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4410

  Reginald Keith Wallace - February 18th 2011

The NTEBA past and present committee and players express their deepest sympthay to our President Peter Wallace and family on the loss of Peter's father

Maxie David Kearnes - February 10th 2011

?The NTEBA past and present committee and players express their deepest sympthay to committee member David Kearnes and family on the loss of David's father

 

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4851

The side from Southern Tas proved to strong for the Northern team this year to regain the 'David Smart Memorial' trophy from last year's innagural event. The Southerners this year had a very strong team in A Grade with the majority of players having played for Tasmania at the National Championships. Chris Forsyth and Anthony Adams were outstanding for the South winning 6 frames from 6 played, Phillip 'Bogey' Hodgetts lead the way for the North winning 4 from 8 frames played and winning the Best Player trophy for the North, the best player fror the South went to Chris Forsyth

The B Grade team's match saw the win also go to the South, with an outstanding effort from veteran Dencil McGifford from the South winning all of her 5 frames

Results from A Grade Match

Original Team Information

Read more: David Smart Memorial Shield Match 2011

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4476

Xmas Raffle 2010

Drawn December 23rd at the LWC at 9.00pm

1st Prize: Chris ?

2nd: Matt Fair

3rd: George Zammit
 
4th: Les Barker
 
 5th: Darryl Phillips

Details
Parent Category: Past 8Ball Results
Category: Summer Results 2010-11
Hits: 4481

 'DAVID & SHARON SMART MEMORIAL MATCH 2011'

Greater North v Southern Tas

Date: Saturday 29th January 2011

Read more: Greater North v S.Tas 2011

  1. J.Boag & Son Summer Roster 2010/11 - SET
  2. 2010-11 J.Boag & Son Summer Roster Info

Page 1 of 2

Greater North v Southern Tas

Greater North v Southern Tas

Saturday February 20th 2010 at LWC at 11.00am

Won by Greater North - Article on Match and Results can be found on this link

Summer Finals 011

Finals Qualification Summer 2010

J.Boag & Son Summer Roster 09/10 Finals Qualification 

Div 1, 2 & 3 -  9 Matches (nights) = 60% appearance

Qualifying Matches for 011 Finals

Qualifying amount of Matches for Association Finals
Div 1: 60% = 9 Matches (Nights)
Div 2 & 3: 58% = 7 Matches (Nights)

Mick Hill - World 8Ball Champion

Mick Hill

Mick 'The Machine' Hill - LWC on Thursday April 7 at 7.30pm
Great Night was had by all who attended, approx 50 people enjoyed the night with opportunities to play the best in the world and a photo
To view photos from the night, click the Facebok logo at the top of the home page to view
Original Article for the show

Most Consistent Summer 2011

Most Consistent Award Summer 011
Div 1: Peter Miller: 28 wins 39 played = 71.79%
Div 2: Paul Styles: 18 wins 23 played = 78.26%
Div 3: Cor Zoon: 20 wins 28 played = 71.42%

 
J! InfoRequestSessionProfileQueries32Log
25.902MBMemory Usage352msRequest Duration
Joomla! Version4.4.2
PHP Version8.2.28
Identityguest
Response200
Templatert_acronym
Database
Server
mysql
Version
10.6.20-MariaDB-cll-lve
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:51 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745394062 "last" => 1745394062...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.99MB) (42.42ms)
  • afterInitialise (7.16MB) (88.64ms)
  • afterRoute (4.01MB) (39.57ms)
  • beforeRenderComponent com_content (320.43KB) (4.22ms)
  • Before Access::preloadComponents (all components) (746.45KB) (8.66ms)
  • After Access::preloadComponents (all components) (112.02KB) (699μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (42μs)
  • After Access::preloadPermissions (com_content) (382.69KB) (1.21ms)
  • Before Access::getAssetRules (id:40 name:com_content.category.15) (18.65KB) (54μs)
  • After Access::getAssetRules (id:40 name:com_content.category.15) (21.46KB) (412μs)
  • Before Access::getAssetRules (id:8 name:com_content) (349.17KB) (4.63ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (41μs)
  • afterRenderComponent com_content (2.02MB) (56.47ms)
  • afterDispatch (1.88KB) (75μs)
  • beforeRenderRawModule mod_djmegamenu (Main Menu) (3.41MB) (37.22ms)
  • afterRenderRawModule mod_djmegamenu (Main Menu) (540.54KB) (16.76ms)
  • beforeRenderModule mod_djmegamenu (Main Menu) (720B) (14μs)
  • afterRenderModule mod_djmegamenu (Main Menu) (15.59KB) (324μs)
  • beforeRenderRawModule mod_djmegamenu (Events n Results) (70.53KB) (2.13ms)
  • afterRenderRawModule mod_djmegamenu (Events n Results) (106.71KB) (4.03ms)
  • beforeRenderModule mod_djmegamenu (Events n Results) (720B) (10μs)
  • afterRenderModule mod_djmegamenu (Events n Results) (3.85KB) (238μs)
  • beforeRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (22.79KB) (40μs)
  • afterRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (3.69KB) (234μs)
  • beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (752B) (8μs)
  • afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (2.1KB) (207μs)
  • beforeRenderRawModule mod_custom (State Teams Event 011) (1.05KB) (252μs)
  • afterRenderRawModule mod_custom (State Teams Event 011) (55.8KB) (3.37ms)
  • beforeRenderModule mod_custom (State Teams Event 011) (720B) (10μs)
  • afterRenderModule mod_custom (State Teams Event 011) (2.7KB) (249μs)
  • beforeRenderRawModule mod_custom (Devonport Rep Match 2010) (2.38KB) (589μs)
  • afterRenderRawModule mod_custom (Devonport Rep Match 2010) (976B) (250μs)
  • beforeRenderModule mod_custom (Devonport Rep Match 2010) (736B) (8μs)
  • afterRenderModule mod_custom (Devonport Rep Match 2010) (4.16KB) (225μs)
  • beforeRenderRawModule mod_custom (Greater North v Southern Tas) (3.65KB) (692μs)
  • afterRenderRawModule mod_custom (Greater North v Southern Tas) (992B) (265μs)
  • beforeRenderModule mod_custom (Greater North v Southern Tas) (736B) (9μs)
  • afterRenderModule mod_custom (Greater North v Southern Tas) (2.59KB) (211μs)
  • beforeRenderRawModule mod_custom (Summer Finals 011) (24B) (36μs)
  • afterRenderRawModule mod_custom (Summer Finals 011) (912B) (432μs)
  • beforeRenderModule mod_custom (Summer Finals 011) (720B) (9μs)
  • afterRenderModule mod_custom (Summer Finals 011) (5.95KB) (202μs)
  • beforeRenderRawModule mod_custom (Finals Qualification Summer 2010) (4.51KB) (423μs)
  • afterRenderRawModule mod_custom (Finals Qualification Summer 2010) (1KB) (254μs)
  • beforeRenderModule mod_custom (Finals Qualification Summer 2010) (736B) (8μs)
  • afterRenderModule mod_custom (Finals Qualification Summer 2010) (2.4KB) (226μs)
  • beforeRenderRawModule mod_custom (Qualifying Matches for 011 Finals) (280B) (37μs)
  • afterRenderRawModule mod_custom (Qualifying Matches for 011 Finals) (928B) (250μs)
  • beforeRenderModule mod_custom (Qualifying Matches for 011 Finals) (736B) (9μs)
  • afterRenderModule mod_custom (Qualifying Matches for 011 Finals) (3.21KB) (219μs)
  • beforeRenderRawModule mod_custom (Mick Hill - World 8Ball Champion) (264B) (40μs)
  • afterRenderRawModule mod_custom (Mick Hill - World 8Ball Champion) (1.03KB) (229μs)
  • beforeRenderModule mod_custom (Mick Hill - World 8Ball Champion) (736B) (7μs)
  • afterRenderModule mod_custom (Mick Hill - World 8Ball Champion) (2.96KB) (200μs)
  • beforeRenderRawModule mod_custom (Most Consistent Summer 2011) (88B) (37μs)
  • afterRenderRawModule mod_custom (Most Consistent Summer 2011) (928B) (259μs)
  • beforeRenderModule mod_custom (Most Consistent Summer 2011) (736B) (8μs)
  • afterRenderModule mod_custom (Most Consistent Summer 2011) (3.21KB) (213μs)
  • afterRender (2MB) (34.03ms)
  • 1 x afterInitialise (7.16MB) (25.2%)
    88.64ms
    1 x afterRenderComponent com_content (2.02MB) (16.05%)
    56.47ms
    1 x afterLoad (3.99MB) (12.06%)
    42.42ms
    1 x afterRoute (4.01MB) (11.25%)
    39.57ms
    1 x beforeRenderRawModule mod_djmegamenu (Main Menu) (3.41MB) (10.58%)
    37.22ms
    1 x afterRender (2MB) (9.67%)
    34.03ms
    1 x afterRenderRawModule mod_djmegamenu (Main Menu) (540.54KB) (4.76%)
    16.76ms
    1 x Before Access::preloadComponents (all components) (746.45KB) (2.46%)
    8.66ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (349.17KB) (1.32%)
    4.63ms
    1 x beforeRenderComponent com_content (320.43KB) (1.2%)
    4.22ms
    1 x afterRenderRawModule mod_djmegamenu (Events n Results) (106.71KB) (1.15%)
    4.03ms
    1 x afterRenderRawModule mod_custom (State Teams Event 011) (55.8KB) (0.96%)
    3.37ms
    1 x beforeRenderRawModule mod_djmegamenu (Events n Results) (70.53KB) (0.61%)
    2.13ms
    1 x After Access::preloadPermissions (com_content) (382.69KB) (0.34%)
    1.21ms
    1 x After Access::preloadComponents (all components) (112.02KB) (0.2%)
    699μs
    1 x beforeRenderRawModule mod_custom (Greater North v Southern Tas) (3.65KB) (0.2%)
    692μs
    1 x beforeRenderRawModule mod_custom (Devonport Rep Match 2010) (2.38KB) (0.17%)
    589μs
    1 x afterRenderRawModule mod_custom (Summer Finals 011) (912B) (0.12%)
    432μs
    1 x beforeRenderRawModule mod_custom (Finals Qualification Summer 2010) (4.51KB) (0.12%)
    423μs
    1 x After Access::getAssetRules (id:40 name:com_content.category.15) (21.46KB) (0.12%)
    412μs
    1 x afterRenderModule mod_djmegamenu (Main Menu) (15.59KB) (0.09%)
    324μs
    1 x afterRenderRawModule mod_custom (Greater North v Southern Tas) (992B) (0.08%)
    265μs
    1 x afterRenderRawModule mod_custom (Most Consistent Summer 2011) (928B) (0.07%)
    259μs
    1 x afterRenderRawModule mod_custom (Finals Qualification Summer 2010) (1KB) (0.07%)
    254μs
    1 x beforeRenderRawModule mod_custom (State Teams Event 011) (1.05KB) (0.07%)
    252μs
    1 x afterRenderRawModule mod_custom (Devonport Rep Match 2010) (976B) (0.07%)
    250μs
    1 x afterRenderRawModule mod_custom (Qualifying Matches for 011 Finals) (928B) (0.07%)
    250μs
    1 x afterRenderModule mod_custom (State Teams Event 011) (2.7KB) (0.07%)
    249μs
    1 x afterRenderModule mod_djmegamenu (Events n Results) (3.85KB) (0.07%)
    238μs
    1 x afterRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (3.69KB) (0.07%)
    234μs
    1 x afterRenderRawModule mod_custom (Mick Hill - World 8Ball Champion) (1.03KB) (0.07%)
    229μs
    1 x afterRenderModule mod_custom (Finals Qualification Summer 2010) (2.4KB) (0.06%)
    226μs
    1 x afterRenderModule mod_custom (Devonport Rep Match 2010) (4.16KB) (0.06%)
    225μs
    1 x afterRenderModule mod_custom (Qualifying Matches for 011 Finals) (3.21KB) (0.06%)
    219μs
    1 x afterRenderModule mod_custom (Most Consistent Summer 2011) (3.21KB) (0.06%)
    213μs
    1 x afterRenderModule mod_custom (Greater North v Southern Tas) (2.59KB) (0.06%)
    211μs
    1 x afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (2.1KB) (0.06%)
    207μs
    1 x afterRenderModule mod_custom (Summer Finals 011) (5.95KB) (0.06%)
    202μs
    1 x afterRenderModule mod_custom (Mick Hill - World 8Ball Champion) (2.96KB) (0.06%)
    200μs
    1 x afterDispatch (1.88KB) (0.02%)
    75μs
    1 x Before Access::getAssetRules (id:40 name:com_content.category.15) (18.65KB) (0.02%)
    54μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    42μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    41μs
    1 x beforeRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (22.79KB) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_custom (Mick Hill - World 8Ball Champion) (264B) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_custom (Qualifying Matches for 011 Finals) (280B) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_custom (Most Consistent Summer 2011) (88B) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_custom (Summer Finals 011) (24B) (0.01%)
    36μs
    1 x beforeRenderModule mod_djmegamenu (Main Menu) (720B) (0%)
    14μs
    1 x beforeRenderModule mod_djmegamenu (Events n Results) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (State Teams Event 011) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Greater North v Southern Tas) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Qualifying Matches for 011 Finals) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Summer Finals 011) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (752B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Finals Qualification Summer 2010) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Devonport Rep Match 2010) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Most Consistent Summer 2011) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Mick Hill - World 8Ball Champion) (736B) (0%)
    7μs
32 statements were executed, 3 of which were duplicates, 29 unique19.03ms448.41KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;152μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `joom_session` WHERE `session_id` = ?222μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `joom_session` WHERE `session_id` = :session_id LIMIT 1153μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)254μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1101μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `joom_viewlevels`83μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `joom_usergroups` AS `a` LEFT JOIN `joom_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest84μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `joom_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`159μs59.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM joom_rsform_config137μs1.69KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `joom_menu` AS `m` LEFT JOIN `joom_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.79ms215.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `joom_template_styles` AS `s` LEFT JOIN `joom_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` = 1112μs912B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM joom_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_acronym' ORDER BY s.id138μs784B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `joom_languages` WHERE `published` = 1 ORDER BY `ordering` ASC106μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_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)164μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0312μs61.48KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`,( SELECT COUNT(`i`.`id`) FROM `joom_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `joom_categories` AS `s` INNER JOIN `joom_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`803μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `joom_content` AS `a` LEFT JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `joom_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `joom_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `joom_categories` AS `sub` INNER JOIN `joom_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId AND `sub`.`level` <= `this`.`level` + :levels)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY c.lft, a.ordering, a.created LIMIT 103.88ms23.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `joom_contentitem_tag_map` AS `m` INNER JOIN `joom_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8) AND `t`.`access` IN (:preparedArray9)482μs4.78KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT COUNT(*) FROM `joom_content` AS `a` LEFT JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `joom_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `joom_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `joom_categories` AS `sub` INNER JOIN `joom_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId AND `sub`.`level` <= `this`.`level` + :levels)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)2.3ms4.54KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `joom_contentitem_tag_map` AS `m` INNER JOIN `joom_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)303μs3.95KBParams/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 `joom_categories` AS `s` INNER JOIN `joom_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`505μs3.91KBParams/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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) 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.07ms4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC186μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `joom_categories` AS `s` INNER JOIN `joom_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`181μs3.91KBParams/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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) 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.13ms4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `joom_categories` AS `s` INNER JOIN `joom_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`179μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `joom_modules` AS `m` LEFT JOIN `joom_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `joom_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`2.15ms18.03KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM joom_extensions WHERE element='mod_djmegamenu' LIMIT 180μs536B/modules/mod_djmegamenu/helpers/helper.php:404Copy
  • 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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.14ms4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `joom_scheduler_tasks` AS `a` WHERE `a`.`state` = 1234μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `joom_session` WHERE `session_id` = ?187μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `joom_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?254μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy