Limo Guide Transportation Limos Great limo for the price
 

Great limo for the price Great limo for the price Hot

I booked bravo limo couple weeks ago for our weekend adventure and everything turned out so good. The driver was so amazing and patient also the dispatch was helpfull

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
 
Great limo for the price 2016-11-03 16:26:29 gordon
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by gordon    November 03, 2016
Top 100 Reviewer  -   View all my reviews

was so impressed with the quality of service

Definitely would recommend as a reliable limo company. We did not have any issues with them that was already out fourth ride, and like always perfect. Thanks bravo limo

Was this review helpful to you? 
00
Report this review
 

Directory

Profile Information

Application 0.000 seconds (+0.000); 0.25 MB (+0.251) - afterLoad
Application 0.143 seconds (+0.143); 1.39 MB (+1.134) - afterInitialise
Application 0.182 seconds (+0.039); 1.83 MB (+0.449) - afterRoute
Application 0.753 seconds (+0.572); 5.80 MB (+3.964) - afterDispatch
Application 0.790 seconds (+0.037); 6.14 MB (+0.338) - beforeRenderModule mod_custom (Logo)
Application 0.798 seconds (+0.007); 6.16 MB (+0.024) - afterRenderModule mod_custom (Logo)
Application 0.802 seconds (+0.004); 6.17 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.822 seconds (+0.020); 6.21 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 0.822 seconds (+0.000); 6.21 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.837 seconds (+0.015); 6.23 MB (+0.022) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.861 seconds (+0.024); 6.41 MB (+0.185) - beforeRenderModule mod_search (Search)
Application 0.872 seconds (+0.011); 6.45 MB (+0.041) - afterRenderModule mod_search (Search)
Application 0.878 seconds (+0.006); 6.45 MB (-0.001) - beforeRenderModule mod_menu (Menu)
Application 0.889 seconds (+0.011); 6.47 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 0.890 seconds (+0.000); 6.47 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.899 seconds (+0.010); 6.49 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.912 seconds (+0.013); 6.50 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.921 seconds (+0.008); 6.50 MB (+0.009) - afterRenderModule mod_menu (Links:)
Application 0.921 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.932 seconds (+0.012); 6.51 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.933 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.942 seconds (+0.010); 6.51 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.943 seconds (+0.000); 6.51 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 1.023 seconds (+0.080); 6.84 MB (+0.328) - afterRenderModule mod_jreviews_directories (Directory)
Application 1.038 seconds (+0.015); 6.84 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 1.041 seconds (+0.002); 6.84 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 1.057 seconds (+0.016); 6.79 MB (-0.049) - afterRender

Memory Usage

6.84 MB (7,168,640 Bytes)

45 Queries Logged

  1. SELECT `data`
      FROM `jtneb_session`
      WHERE `session_id` = '2169respp1n52invu9egqmltg7'
  2. DELETE
      FROM `jtneb_session`
      WHERE `time` < 1675426419
  3. SELECT `session_id`
      FROM `jtneb_session`
      WHERE `session_id` = '2169respp1n52invu9egqmltg7'
      LIMIT 0, 1
  4. INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
      VALUES ('2169respp1n52invu9egqmltg7', 0, 1675427319)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `jtneb_viewlevels`
  7. 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
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
  10. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM 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
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. 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=579
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  13. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 579
  14. SELECT *
      FROM jtneb_languages
      WHERE published=1
      ORDER BY ordering ASC
  15. 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
  16. SELECT a.rules
      FROM jtneb_assets AS a
      WHERE a.id = 1
  17. 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
  18. 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 = 579
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 12:28:39')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 12:28:39')
      AND (a.state = 1 OR a.state =2)
  19. 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
  20. SELECT enabled AS published, params
      FROM jtneb_extensions
      WHERE element = 'jreviews'
      AND type = 'plugin'
      AND folder = 'content'
      LIMIT 1
  21. SELECT catid
      FROM jtneb_content
      WHERE id = 579
  22. SELECT count(*)
      FROM jtneb_jreviews_categories AS Category
      WHERE Category.option = 'com_content'
      AND Category.id = 18
  23. SELECT count(*)
      FROM jtneb_jreviews_categories AS JreviewCategory
      WHERE JreviewCategory.id = 18
      AND JreviewCategory.option = 'com_content'
      AND JreviewCategory.criteriaid > 0
  24. (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`
  25. 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 = 579 )
  26. ( 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 )
  27. SELECT content_id AS listing_id, count(*) AS favored
      FROM jtneb_jreviews_favorites AS Favorite
      WHERE Favorite.content_id IN (579)
      GROUP BY listing_id
  28. 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 = 579
      AND Review.author = 1
      AND Review.published = 1 )
      ORDER BY `Review.created` DESC
      LIMIT 10
  29. 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 = 579
      AND Review.author = 1
      AND Review.published = 1 )
  30. 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= 579
      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
  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= 579
      AND Review.author = 0
      AND Review.published = 1
      AND Review.mode = 'com_content'
      AND JreviewsCategory.`option` = 'com_content' )
  32. 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 = 579
      AND Review.ipaddress = '3.235.25.27'
      AND Review.mode = 'com_content'
      AND Review.author = 0
      AND Review.published >= 0 )
  33. UPDATE jtneb_content
      SET hits = hits + 1
      WHERE id = 579
  34. SELECT params
      FROM jtneb_extensions AS e
      WHERE e.element='com_widgetkit'
  35. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  36. 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-02-03 12:28:40')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-03 12:28:40')
      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
  37. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 579
  38. 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
  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 = 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 )
  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 = 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 )
  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 = 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 )
  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 = 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 )
  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 = 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 )
  44. ( 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 )
  45. UPDATE `jtneb_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1675427319;s:18:\"session.timer.last\";i:1675427319;s:17:\"session.timer.now\";i:1675427319;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:\"c5e4f6de8f4e6cc41eef3aad402c2fe2\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"52a8ab5c5af225f8c19899e616cf1bac\";s:1:\"0\";s:32:\"566fdea4a2ab0245734c0005514d876d\";s:1:\"1\";s:32:\"6334756ee63271b7f67e5a1f68efe9bb\";s:1:\"0\";}}', `time` = 1675427320
      WHERE `session_id` = '2169respp1n52invu9egqmltg7'

31 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_content SET hits = hits + 1
  3. 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1675427319;s:18:\"session.timer.last\";i:1675427319;s:17:\"session.timer.now\";i:1675427319;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:\"c5e4f6de8f4e6cc41eef3aad402c2fe2\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"52a8ab5c5af225f8c19899e616cf1bac\";s:1:\"0\";s:32:\"566fdea4a2ab0245734c0005514d876d\";s:1:\"1\";s:32:\"6334756ee63271b7f67e5a1f68efe9bb\";s:1:\"0\";}}', `time` = 1675427320
  4. 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
  5. 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('2169respp1n52invu9egqmltg7', 0, 1675427319
  6. 1 × DELETE FROM `jtneb_session`