Limo Guide Transportation Limos successlimousine.com
 

successlimousine.com successlimousine.com Hot

Editor rating
 
0.0
User rating
 
5.0 (1)
December 13, 2017     1363      0Add
successlimousine.com

http://successlimousine.com/ Success Limo is an extremely professional, reliable service to deal with. We have used other services in the past and they far exceed every other one. The cars new and spotless. They are very punctual (actually arrive early each time). The drivers are impeccably dressed and always so pleasant. Customer service is their top priority. I would never use another service. Give them a try - you'll be 100% satisfied!

User reviews

Average user rating from: 1 user(s)

Overall rating 
 
5.0
Service 
 
5.0  (1)
Pricing 
 
5.0  (1)
Ratings (the higher the better)
Service*
Pricing*
Comments
 
successlimousine.com 2017-12-13 18:06:12 successlimousine
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by successlimousine    December 13, 2017
Top 100 Reviewer  -   View all my reviews

successlimousine.com

Success Limo is an extremely professional, reliable service to deal with. We have used other services in the past and they far exceed every other one. The cars new and spotless. They are very punctual (actually arrive early each time). The drivers are impeccably dressed and always so pleasant. Customer service is their top priority. I would never use another service. Give them a try - you'll be 100% satisfied!

Comments (0)
Was this review helpful to you? 
00
Report this review
 

Links:

Directory

Profile Information

Application 0.000 seconds (+0.000); 0.25 MB (+0.252) - afterLoad
Application 0.138 seconds (+0.137); 1.39 MB (+1.134) - afterInitialise
Application 0.176 seconds (+0.038); 1.83 MB (+0.449) - afterRoute
Application 1.423 seconds (+1.247); 5.80 MB (+3.963) - afterDispatch
Application 1.459 seconds (+0.036); 6.14 MB (+0.338) - beforeRenderModule mod_custom (Logo)
Application 1.466 seconds (+0.007); 6.16 MB (+0.024) - afterRenderModule mod_custom (Logo)
Application 1.471 seconds (+0.004); 6.16 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 1.492 seconds (+0.022); 6.21 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 1.492 seconds (+0.000); 6.21 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 1.507 seconds (+0.014); 6.23 MB (+0.022) - afterRenderModule mod_login (Login || To submit a new listing)
Application 1.530 seconds (+0.023); 6.41 MB (+0.185) - beforeRenderModule mod_search (Search)
Application 1.540 seconds (+0.011); 6.45 MB (+0.040) - afterRenderModule mod_search (Search)
Application 1.546 seconds (+0.006); 6.45 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 1.557 seconds (+0.011); 6.47 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 1.557 seconds (+0.000); 6.47 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 1.566 seconds (+0.009); 6.49 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 1.579 seconds (+0.013); 6.49 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 1.588 seconds (+0.008); 6.50 MB (+0.008) - afterRenderModule mod_menu (Links:)
Application 1.588 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 1.599 seconds (+0.011); 6.51 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 1.599 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 1.609 seconds (+0.010); 6.51 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 1.609 seconds (+0.000); 6.51 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 1.689 seconds (+0.080); 6.83 MB (+0.327) - afterRenderModule mod_jreviews_directories (Directory)
Application 1.704 seconds (+0.015); 6.83 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 1.706 seconds (+0.002); 6.84 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 1.722 seconds (+0.017); 6.79 MB (-0.046) - afterRender

Memory Usage

6.84 MB (7,170,856 Bytes)

44 Queries Logged

  1. SELECT `data`
      FROM `jtneb_session`
      WHERE `session_id` = 'gbada1ia7sgduulicc3paj10o3'
  2. SELECT `session_id`
      FROM `jtneb_session`
      WHERE `session_id` = 'gbada1ia7sgduulicc3paj10o3'
      LIMIT 0, 1
  3. INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
      VALUES ('gbada1ia7sgduulicc3paj10o3', 0, 1701457318)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `jtneb_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM jtneb_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 jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
  9. 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 jtneb_menu AS m
      LEFT JOIN jtneb_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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jtneb_categories as c
      LEFT JOIN jtneb_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 jtneb_categories AS cat JOIN jtneb_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=582
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 582
  13. SELECT *
      FROM jtneb_languages
      WHERE published=1
      ORDER BY ordering ASC
  14. SELECT id, home, template, s.params
      FROM jtneb_template_styles as s
      LEFT JOIN jtneb_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 jtneb_assets AS a
      WHERE a.id = 1
  16. SELECT b.rules
      FROM jtneb_assets AS a
      LEFT JOIN jtneb_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.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 jtneb_content AS a
      LEFT JOIN jtneb_categories AS c
      on c.id = a.catid
      LEFT JOIN jtneb_users AS u
      on u.id = a.created_by
      LEFT JOIN jtneb_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jtneb_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jtneb_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jtneb_categories AS cat JOIN jtneb_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 = 582
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-01 19:01:58')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-01 19:01:58')
      AND (a.state = 1 OR a.state =2)
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jtneb_categories as c
      LEFT JOIN jtneb_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 jtneb_categories AS cat JOIN jtneb_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=18
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SELECT enabled AS published, params
      FROM jtneb_extensions
      WHERE element = 'jreviews'
      AND type = 'plugin'
      AND folder = 'content'
      LIMIT 1
  20. SELECT catid
      FROM jtneb_content
      WHERE id = 582
  21. SELECT count(*)
      FROM jtneb_jreviews_categories AS Category
      WHERE Category.option = 'com_content'
      AND Category.id = 18
  22. SELECT count(*)
      FROM jtneb_jreviews_categories AS JreviewCategory
      WHERE JreviewCategory.id = 18
      AND JreviewCategory.option = 'com_content'
      AND JreviewCategory.criteriaid > 0
  23. (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`
      FROM jtneb_categories AS ParentCategory
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON ListingType.id = JreviewsCategory.criteriaid
      WHERE ParentCategory.id = 18 ) UNION (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON ListingType.id = JreviewsCategory.criteriaid
      WHERE Category.published
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 18
      AND ParentCategory.parent_id > 0 )
      ORDER BY `Category.lft`
  24. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`
      FROM jtneb_content AS Listing
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON JreviewsCategory.id = Category.id
      LEFT JOIN jtneb_categories AS ParentCategory
      ON Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      LEFT JOIN jtneb_jreviews_listing_totals AS Totals
      ON Totals.listing_id = Listing.id
      AND Totals.extension = 'com_content'
      LEFT JOIN jtneb_jreviews_content AS Field
      ON Field.contentid = Listing.id
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      LEFT JOIN jtneb_users AS User
      ON User.id = Listing.created_by
      LEFT JOIN jtneb_jreviews_claims AS Claim
      ON Claim.listing_id = Listing.id
      AND Claim.approved = 1
      LEFT JOIN jtneb_content_frontpage AS Frontpage
      ON Frontpage.content_id = Listing.id
      WHERE 1 = 1
      AND ( Listing.id = 582 )
  25. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 18
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 18
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  26. SELECT content_id AS listing_id, count(*) AS favored
      FROM jtneb_jreviews_favorites AS Favorite
      WHERE Favorite.content_id IN (582)
      GROUP BY listing_id
  27. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 582
      AND Review.author = 1
      AND Review.published = 1 )
      ORDER BY `Review.created` DESC
      LIMIT 10
  28. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 582
      AND Review.author = 1
      AND Review.published = 1 )
  29. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid= 582
      AND Review.author = 0
      AND Review.published = 1
      AND Review.mode = 'com_content'
      AND JreviewsCategory.`option` = 'com_content' )
      ORDER BY `Review.created` DESC
      LIMIT 5
  30. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid= 582
      AND Review.author = 0
      AND Review.published = 1
      AND Review.mode = 'com_content'
      AND JreviewsCategory.`option` = 'com_content' )
  31. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 582
      AND Review.ipaddress = '3.239.2.192'
      AND Review.mode = 'com_content'
      AND Review.author = 0
      AND Review.published >= 0 )
  32. UPDATE jtneb_content
      SET hits = hits + 1
      WHERE id = 582
  33. SELECT params
      FROM jtneb_extensions AS e
      WHERE e.element='com_widgetkit'
  34. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  35. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jtneb_modules AS m
      LEFT JOIN jtneb_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jtneb_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 <= '2023-12-01 19:01:59')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-01 19:01:59')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 175 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  36. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 582
  37. SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count`
      FROM jtneb_categories AS Category
      LEFT JOIN jtneb_categories AS ParentCategory
      ON Category.lft <= ParentCategory.lft
      AND Category.rgt >= ParentCategory.rgt
      LEFT JOIN jtneb_content AS Listing
      ON ParentCategory.id = Listing.catid
      AND Listing.state = 1
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Category.id = JreviewsCategory.id
      AND JreviewsCategory.option = "com_content"
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON JreviewsCategory.criteriaid = ListingType.id
      WHERE 1 = 1
      AND ( Category.published = 1
      AND ParentCategory.access IN ( 1,1 )
      AND Category.extension = "com_content"
      AND Category.level <= 2 )
      GROUP BY Category.id
      ORDER BY Directory.desc,Category.lft
  38. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 16
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 16
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  39. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 19
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 19
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  40. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 20
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 20
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  41. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 17
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 17
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  42. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 21
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 21
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  43. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 22
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 22
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  44. UPDATE `jtneb_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701457318;s:18:\"session.timer.last\";i:1701457318;s:17:\"session.timer.now\";i:1701457318;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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;s:9:\"group_ids\";s:0:\"\";s:16:\"duplicate_review\";b:0;}s:13:\"session.token\";s:32:\"7b744278435076abc136ab9b9dffdd22\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"d02d8514daacf11c003a322bdc43f2ff\";s:1:\"0\";s:32:\"2a7b1eaab51e591c9823c43c4865f4b0\";s:1:\"1\";s:32:\"3b910b72967cb7ca178902e767b212cc\";s:1:\"0\";}}', `time` = 1701457320
      WHERE `session_id` = 'gbada1ia7sgduulicc3paj10o3'

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
  2. 3 × SELECT COUNT(*) FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  3. 2 × SELECT alias, catid FROM jtneb_content
  4. 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jtneb_categories as c LEFT JOIN jtneb_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 jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 1 × SELECT content_id AS listing_id, count(*) AS favored FROM jtneb_jreviews_favorites AS Favorite
  6. 1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips` FROM jtneb_content AS Listing INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt LEFT JOIN jtneb_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jtneb_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jtneb_users AS User ON User.id = Listing.created_by LEFT JOIN jtneb_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jtneb_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id
  7. 1 × SELECT count(*) FROM jtneb_jreviews_categories AS JreviewCategory
  8. 1 × SELECT count(*) FROM jtneb_jreviews_categories AS Category
  9. 1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  10. 1 × SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count` FROM jtneb_categories AS Category LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft <= ParentCategory.lft AND Category.rgt >= ParentCategory.rgt LEFT JOIN jtneb_content AS Listing ON ParentCategory.id = Listing.catid AND Listing.state = 1 INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id
  11. 1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  12. 1 × SELECT catid FROM jtneb_content
  13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jtneb_modules AS m LEFT JOIN jtneb_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jtneb_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  14. 1 × SELECT params FROM jtneb_extensions AS e
  15. 1 × 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 jtneb_content AS a LEFT JOIN jtneb_categories AS c on c.id = a.catid LEFT JOIN jtneb_users AS u on u.id = a.created_by LEFT JOIN jtneb_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jtneb_categories as parent ON parent.id = c.parent_id LEFT JOIN jtneb_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  16. 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 jtneb_menu AS m LEFT JOIN jtneb_extensions AS e ON m.component_id = e.extension_id
  17. 1 × SELECT folder AS type, element AS name, params FROM jtneb_extensions
  18. 1 × SELECT id, rules FROM `jtneb_viewlevels
  19. 1 × SELECT `session_id` FROM `jtneb_session`
  20. 1 × SELECT * FROM jtneb_languages
  21. 1 × SELECT id, home, template, s.params FROM jtneb_template_styles as s LEFT JOIN jtneb_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  22. 1 × SELECT `data` FROM `jtneb_session`
  23. 1 × SELECT b.rules FROM jtneb_assets AS a LEFT JOIN jtneb_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  24. 1 × SELECT a.rules FROM jtneb_assets AS a
  25. 1 × SELECT enabled AS published, params FROM jtneb_extensions
OTHER Tables:
  1. 7 × ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id
  2. 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701457318;s:18:\"session.timer.last\";i:1701457318;s:17:\"session.timer.now\";i:1701457318;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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;s:9:\"group_ids\";s:0:\"\";s:16:\"duplicate_review\";b:0;}s:13:\"session.token\";s:32:\"7b744278435076abc136ab9b9dffdd22\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"d02d8514daacf11c003a322bdc43f2ff\";s:1:\"0\";s:32:\"2a7b1eaab51e591c9823c43c4865f4b0\";s:1:\"1\";s:32:\"3b910b72967cb7ca178902e767b212cc\";s:1:\"0\";}}', `time` = 1701457320
  3. 1 × UPDATE jtneb_content SET hits = hits + 1
  4. 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('gbada1ia7sgduulicc3paj10o3', 0, 1701457318
  5. 1 × (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config` FROM jtneb_categories AS ParentCategory INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS ListingType ON ListingType.id = JreviewsCategory.criteriaid