Limo Guide Transportation Limos Limos4.net limousine service
 

Limos4.net limousine service Limos4.net limousine service Hot

Limos4.net offers high class, comfortable transfer services to our customers across Europe. Our services can be obtained in following cities: Stockholm, Copenhagen, Helsinki, Oslo, Barcelona, Paris, Geneva, Frankfurt, Munich, Brussels, London, Rome, Zurich. Reliability, punctuality, safety and satisfaction of our customers are of utmost importance to us and we are successfully providing those points throughout the years. 


Here are dedicated domains for the cities that our service supports:

www.limos4barcelona.com

www.limos4brussels.com

www.limos4copenhagen.com

www.limos4frankfurt.com

www.limos4geneva.com

www.limos4helsinki.com

www.limos4london.com

www.limos4munich.com

www.limos4oslo.com

www.limos4paris.com

www.limos4rome.com

www.limos4stockholm.com

www.limos4zurich.com
www.limos4germany.com 

 

User reviews

Average user rating from: 3 user(s)

Overall rating 
 
3.4
Service 
 
3.5  (3)
Pricing 
 
3.3  (3)
Ratings (the higher the better)
Service*
Pricing*
Comments
 
Limos4.net limousine service 2017-08-20 15:47:52 Ashley Lane
Overall rating 
 
0.5
Service 
 
0.5
Pricing 
 
0.5
Reviewed by Ashley Lane    August 20, 2017

Very Disappointing

I booked a limo pick up for my husband on his 40th birthday to take us on a tour of Barcelona before going to the airport. Much to my dismay the driver never showed up and was never planning to. I called the driver, as I was given his number, and he said that there had been a mistake with Limos4 and he was not coming. So I was stood along with my husband on a curbside in front of my hotel with all our bags, waiting in vain for the "big surprise" I had promised him on his birthday morning. I emailed Limos4 to get a refund, and felt that they would try to fix their mistake, but they only offered a slightly discounted limo (175 instead of 235) for the next time I was in Barcelona. Since I have been to Barcelona once in 36 years, I knew that would never be used. Let's face it, when someone books a limo, it is usually for a special occasion, and once the moment is foiled, then it's forever foiled.
I would definitely suggest to find a different limo service and also to touch base with them before the meeting time so that you know they will be there on your special ocIcasion.
In summary, they promised the world via email and delivered absolutely nothing. This was followed up by a discount offer that we will never use.
I was extremely disappointed with Limos4 service and also extremely disappointed to find a lack of public space for reviews.

Was this review helpful to you? 
00
Report this review
Limos4.net limousine service 2017-02-19 19:44:59 Peter Nigg
Overall rating 
 
4.8
Service 
 
5.0
Pricing 
 
4.5
Reviewed by Peter Nigg    February 19, 2017

Great service in Copenhagen

I used their service in Copenhagen and it was quite professional. English speaking driver took my luggage at the airport and escorted me to the brand new Mercedes S Klass. They are certainly not the cheapest car service but it was worth themoney.

Was this review helpful to you? 
10
Report this review
Limos4.net limousine service 2016-05-03 07:03:29 Aleksandra Tasic
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by Aleksandra Tasic    May 03, 2016

Limos4 Transportation

Was this review helpful to you? 
20
Report this review
 

Directory

Profile Information

Application 0.001 seconds (+0.001); 0.25 MB (+0.251) - afterLoad
Application 0.143 seconds (+0.142); 1.39 MB (+1.134) - afterInitialise
Application 0.182 seconds (+0.039); 1.84 MB (+0.450) - afterRoute
Application 0.773 seconds (+0.591); 5.86 MB (+4.027) - afterDispatch
Application 0.811 seconds (+0.039); 6.20 MB (+0.338) - beforeRenderModule mod_custom (Logo)
Application 0.819 seconds (+0.008); 6.22 MB (+0.024) - afterRenderModule mod_custom (Logo)
Application 0.823 seconds (+0.004); 6.23 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.844 seconds (+0.020); 6.28 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 0.844 seconds (+0.000); 6.27 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.859 seconds (+0.015); 6.29 MB (+0.022) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.884 seconds (+0.024); 6.48 MB (+0.185) - beforeRenderModule mod_search (Search)
Application 0.895 seconds (+0.011); 6.52 MB (+0.040) - afterRenderModule mod_search (Search)
Application 0.901 seconds (+0.006); 6.52 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 0.912 seconds (+0.011); 6.54 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 0.913 seconds (+0.000); 6.53 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.923 seconds (+0.010); 6.55 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.936 seconds (+0.014); 6.56 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.945 seconds (+0.008); 6.57 MB (+0.008) - afterRenderModule mod_menu (Links:)
Application 0.945 seconds (+0.000); 6.56 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.956 seconds (+0.011); 6.57 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.957 seconds (+0.000); 6.57 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.966 seconds (+0.010); 6.58 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.967 seconds (+0.000); 6.57 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 1.048 seconds (+0.081); 6.90 MB (+0.329) - afterRenderModule mod_jreviews_directories (Directory)
Application 1.063 seconds (+0.015); 6.90 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 1.065 seconds (+0.002); 6.91 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 1.086 seconds (+0.021); 6.87 MB (-0.039) - afterRender

Memory Usage

6.92 MB (7,256,872 Bytes)

45 Queries Logged

  1. SELECT `data`
      FROM `jtneb_session`
      WHERE `session_id` = 'hacnb50nte8c7djaqjks73n0e6'
  2. DELETE
      FROM `jtneb_session`
      WHERE `time` < 1675431693
  3. SELECT `session_id`
      FROM `jtneb_session`
      WHERE `session_id` = 'hacnb50nte8c7djaqjks73n0e6'
      LIMIT 0, 1
  4. INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
      VALUES ('hacnb50nte8c7djaqjks73n0e6', 0, 1675432593)
  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=572
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  13. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 572
  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 = 572
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 13:56:33')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 13:56:33')
      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 = 572
  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 = 572 )
  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 (572)
      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 = 572
      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 = 572
      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= 572
      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= 572
      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 = 572
      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 = 572
  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 13:56:34')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-03 13:56:34')
      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 = 572
  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:1675432593;s:18:\"session.timer.last\";i:1675432593;s:17:\"session.timer.now\";i:1675432593;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:\"8d3b553df6eda5b712d80a7ce9063e4d\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"45643ab2f1fddf9646b657dffb6b73b4\";s:1:\"0\";s:32:\"8040290d8ed19fb15c466606adba2793\";s:1:\"3\";s:32:\"2e567ca44230aff550e764cf519ec6bd\";s:1:\"0\";}}', `time` = 1675432594
      WHERE `session_id` = 'hacnb50nte8c7djaqjks73n0e6'

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:1675432593;s:18:\"session.timer.last\";i:1675432593;s:17:\"session.timer.now\";i:1675432593;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:\"8d3b553df6eda5b712d80a7ce9063e4d\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"45643ab2f1fddf9646b657dffb6b73b4\";s:1:\"0\";s:32:\"8040290d8ed19fb15c466606adba2793\";s:1:\"3\";s:32:\"2e567ca44230aff550e764cf519ec6bd\";s:1:\"0\";}}', `time` = 1675432594
  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 ('hacnb50nte8c7djaqjks73n0e6', 0, 1675432593
  6. 1 × DELETE FROM `jtneb_session`