Limo Guide Transportation Limos ULC Limousines California http://www.ulclimos.com/
 

ULC Limousines California http://www.ulclimos.com/ ULC Limousines California http://www.ulclimos.com/ Hot

Los Angeles Limo Service (LA Limo) :

ULC limos has the benefit of being able to easy get to all area's within Los Angeles and LA County due to our geographic location right in the middle of Los Angeles. ULC vehicles are constantly seen on the road catering to the needs of the Hollywood's brightest stars. LA is the home of some of the best nightlife and entertainment in the entire United States, and ULC’s customers take full advantage of our VIP club packages and nights on the town specials during the week. ULC limos is well known for generating thousands of happy customers annually. Among the luxury offerings, the time-honored stretch limo leads the pack in addition to our limousine selections include Cadillac Escalades and H2s from Hummer, and Party Buses. Come by and visit ULC anytime at our LA office at 11301 w olympic blvd. los angeles ca 90064.

When compared to the competition's offerings, pricing and services offered simply don't match up. With cost effective services and an accreditation with the Better Business Bureau, you can rest assured that you are getting the best service for your hard earned money. The growth of the organization can be directly attributed to this focus on excellent service.

Orange County Limo Service (OC Limo) :

Based in Orange County, California, we are located at 7101 McNeil Lane, Buena Park, CA 90620. Since the beginning of ULC tradition, we offer exemplary pricing and service that is worth remembering. No other limo service, both in this region and around the world, provides such a strong blend of vehicle selection and attention to the customer's needs. Among the many accolades you'll see ULC featured in local and regional media from time and time throughout the year. ULC's defined it position in the limo service and limo rental industry the area's fastest rising star. The OC Metro, Orange County Register, OC Weekly, and even the Los Angeles Times have all favorably reviewed ULC and OC Limo.

This limo service is proud of its "A" rating with the BBB. This rating, in tandem with discount pricing, offers a unique opportunity for prospective customers. For testimonials and additional assurances, consider reviewing sites like Limos.com, ProjectWedding.com, and Yelp.com. From here, you can build your decision off of the experiences of others. Many production studios from across the country also find the services provided by ULC to be useful. You can also find OC's limousines on the street in places like Beverly Hills, and on TV in shows like the Housewives of Orange County.

Luxury Limo Rentals:

Are you in need of a party bus, conventional limo, and Hummer limousine? No other limo service can compare with our rentals, drivers, customer service, and overall quality. Below you will find more information on our luxury transportation selections.

  • Party Bus - will cover all of your party bus needs in the LA or OC areas. We offer all different sizes of party buses including 20 Passenger, 25 Passenger, 30 Passenger, 40 Passenger, and 50 passenger party buses at excellent prices you won't be able to find anywhere.
  • Hummer Limo -ULC was one of the first Hummer Limo rental companies in southern California. All of our Hummer limos are designed from the ground up, and have seating up to 24 passengers. At ULC, nothing beats the high quality and extreme look of a ULC Hummer limo. As the keystone of the ULC line, Hummer limousines continue to serve as a pivotal asset in the limo rental fleet. You can see our Hummer limos across all the parts of LA and Orange county on any given night.
  • Luxury Limo Services - If you think you can find a more affordable service, we challenge you to bring in the quoted price and we will meet it or beat it! Of course, in your searches please exert caution before committing to a rental. Some low budget competitors may be operating without the correct insurance and permits. The California Public Utilities Commission website can help verify any dubious claims. If this service confirms the legitimacy of the competitor, and they have a comparable vehicle, we will be more than happy to meet or beat their offer.

User reviews

Average user rating from: 1 user(s)

Overall rating 
 
0.5
Service 
 
0.5  (1)
Pricing 
 
0.5  (1)
Ratings (the higher the better)
Service*
Pricing*
Comments
 
ULC Limousines California http://www.ulclimos.com/ 2016-09-14 07:10:05 ThomUselay
Overall rating 
 
0.5
Service 
 
0.5
Pricing 
 
0.5
Reviewed by ThomUselay    September 14, 2016

viagra soft tabs 100mg

retroperitonealComplete Food and Nutrition Guide buy viagra online D.Nat.Alamy Neil Setchfield. cialis Measurement of blood sugar levels in a fasting patient at least hours and after intervals of minutes and and hours afterThe key to the medical use of stem cells lies in knowing how to manipulate different subgroups of genes so that they can be turned on and off as and when they are needed.treatmentEpiscleritis a.Bones of the Pelvis Pelvic girdle pelvis. levitra rachat Probably his major book earning him fame and financial security was Die Grosse Wundarzney The Great Surgery Book oflymphopoiesisStimulation of GCs by NO and natriuretic peptides and other endogenous ligands e.The effect of radiation on the healthy tissue can be reduced by frequently altering the direction of the beam passing through the body.Nutrients from food digested in the stomach and small intestine pass into the bloodstream through the lining cells of the small intestine.In she published her famous work Notes on Nursing It is recognized as the knowledge which every one ought to havedistinct from medical knowledge which only a profession can have. cheap cialis These medicines may reduce the risk of new ovarian cysts.We will simplify this circuit by neglecting the capacitance of the axon membrane.esophageal cancer Malignant tumor of the esophagus.Questions to Consider vivanza 20mg Thus the blood returning to the heart from tissue capillaries through venules and veins is lled with carbon dioxide but is depleted of oxygen.Specifically they can be stimulated or inactivated by cortisol because they have receptors on the actual immune cells themselves.Address the underlying cause.

Was this review helpful to you? 
00
Report this review
 

Directory

Profile Information

Application 0.001 seconds (+0.001); 0.25 MB (+0.252) - afterLoad
Application 0.141 seconds (+0.141); 1.39 MB (+1.134) - afterInitialise
Application 0.181 seconds (+0.039); 1.83 MB (+0.449) - afterRoute
Application 3.855 seconds (+3.674); 5.86 MB (+4.028) - afterDispatch
Application 3.894 seconds (+0.039); 6.20 MB (+0.339) - beforeRenderModule mod_custom (Logo)
Application 3.902 seconds (+0.008); 6.23 MB (+0.024) - afterRenderModule mod_custom (Logo)
Application 3.906 seconds (+0.005); 6.23 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 3.927 seconds (+0.020); 6.28 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 3.927 seconds (+0.000); 6.27 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 3.942 seconds (+0.015); 6.29 MB (+0.021) - afterRenderModule mod_login (Login || To submit a new listing)
Application 3.967 seconds (+0.024); 6.48 MB (+0.185) - beforeRenderModule mod_search (Search)
Application 3.978 seconds (+0.011); 6.52 MB (+0.040) - afterRenderModule mod_search (Search)
Application 3.984 seconds (+0.006); 6.52 MB (-0.001) - beforeRenderModule mod_menu (Menu)
Application 3.996 seconds (+0.011); 6.54 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 3.996 seconds (+0.000); 6.54 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 4.006 seconds (+0.010); 6.55 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 4.020 seconds (+0.014); 6.56 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 4.028 seconds (+0.009); 6.57 MB (+0.009) - afterRenderModule mod_menu (Links:)
Application 4.029 seconds (+0.000); 6.57 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 4.040 seconds (+0.011); 6.57 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 4.040 seconds (+0.000); 6.57 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 4.050 seconds (+0.010); 6.58 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 4.051 seconds (+0.000); 6.57 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 4.132 seconds (+0.081); 6.90 MB (+0.328) - afterRenderModule mod_jreviews_directories (Directory)
Application 4.147 seconds (+0.016); 6.90 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 4.149 seconds (+0.002); 6.91 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 4.173 seconds (+0.024); 6.87 MB (-0.035) - afterRender

Memory Usage

6.93 MB (7,261,888 Bytes)

44 Queries Logged

  1. SELECT `data`
      FROM `jtneb_session`
      WHERE `session_id` = '0htaj526p73gesourdgfos7ds0'
  2. SELECT `session_id`
      FROM `jtneb_session`
      WHERE `session_id` = '0htaj526p73gesourdgfos7ds0'
      LIMIT 0, 1
  3. INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
      VALUES ('0htaj526p73gesourdgfos7ds0', 0, 1675434194)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `jtneb_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM jtneb_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
  9. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM jtneb_menu AS m
      LEFT JOIN jtneb_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jtneb_categories as c
      LEFT JOIN jtneb_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=498
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 498
  13. SELECT *
      FROM jtneb_languages
      WHERE published=1
      ORDER BY ordering ASC
  14. SELECT id, home, template, s.params
      FROM jtneb_template_styles as s
      LEFT JOIN jtneb_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  15. SELECT a.rules
      FROM jtneb_assets AS a
      WHERE a.id = 1
  16. SELECT b.rules
      FROM jtneb_assets AS a
      LEFT JOIN jtneb_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  17. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM jtneb_content AS a
      LEFT JOIN jtneb_categories AS c
      on c.id = a.catid
      LEFT JOIN jtneb_users AS u
      on u.id = a.created_by
      LEFT JOIN jtneb_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jtneb_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jtneb_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 498
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 14:23:14')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 14:23:14')
      AND (a.state = 1 OR a.state =2)
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jtneb_categories as c
      LEFT JOIN jtneb_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=18
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SELECT enabled AS published, params
      FROM jtneb_extensions
      WHERE element = 'jreviews'
      AND type = 'plugin'
      AND folder = 'content'
      LIMIT 1
  20. SELECT catid
      FROM jtneb_content
      WHERE id = 498
  21. SELECT count(*)
      FROM jtneb_jreviews_categories AS Category
      WHERE Category.option = 'com_content'
      AND Category.id = 18
  22. SELECT count(*)
      FROM jtneb_jreviews_categories AS JreviewCategory
      WHERE JreviewCategory.id = 18
      AND JreviewCategory.option = 'com_content'
      AND JreviewCategory.criteriaid > 0
  23. (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`
      FROM jtneb_categories AS ParentCategory
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON ListingType.id = JreviewsCategory.criteriaid
      WHERE ParentCategory.id = 18 ) UNION (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON ListingType.id = JreviewsCategory.criteriaid
      WHERE Category.published
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 18
      AND ParentCategory.parent_id > 0 )
      ORDER BY `Category.lft`
  24. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`
      FROM jtneb_content AS Listing
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON JreviewsCategory.id = Category.id
      LEFT JOIN jtneb_categories AS ParentCategory
      ON Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      LEFT JOIN jtneb_jreviews_listing_totals AS Totals
      ON Totals.listing_id = Listing.id
      AND Totals.extension = 'com_content'
      LEFT JOIN jtneb_jreviews_content AS Field
      ON Field.contentid = Listing.id
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      LEFT JOIN jtneb_users AS User
      ON User.id = Listing.created_by
      LEFT JOIN jtneb_jreviews_claims AS Claim
      ON Claim.listing_id = Listing.id
      AND Claim.approved = 1
      LEFT JOIN jtneb_content_frontpage AS Frontpage
      ON Frontpage.content_id = Listing.id
      WHERE 1 = 1
      AND ( Listing.id = 498 )
  25. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 18
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 18
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  26. SELECT content_id AS listing_id, count(*) AS favored
      FROM jtneb_jreviews_favorites AS Favorite
      WHERE Favorite.content_id IN (498)
      GROUP BY listing_id
  27. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 498
      AND Review.author = 1
      AND Review.published = 1 )
      ORDER BY `Review.created` DESC
      LIMIT 10
  28. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 498
      AND Review.author = 1
      AND Review.published = 1 )
  29. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid= 498
      AND Review.author = 0
      AND Review.published = 1
      AND Review.mode = 'com_content'
      AND JreviewsCategory.`option` = 'com_content' )
      ORDER BY `Review.created` DESC
      LIMIT 5
  30. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid= 498
      AND Review.author = 0
      AND Review.published = 1
      AND Review.mode = 'com_content'
      AND JreviewsCategory.`option` = 'com_content' )
  31. SELECT COUNT(*)
      FROM jtneb_jreviews_comments AS Review
      LEFT JOIN jtneb_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
      LEFT JOIN jtneb_users AS User
      ON Review.userid = User.id
      LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
      LEFT JOIN jtneb_content AS Listing
      ON Review.pid = Listing.id
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
      LEFT JOIN jtneb_categories AS Category
      ON Category.id = JreviewsCategory.id
      LEFT JOIN jtneb_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
      WHERE 1 = 1
      AND ( Review.pid = 498
      AND Review.ipaddress = '3.235.25.27'
      AND Review.mode = 'com_content'
      AND Review.author = 0
      AND Review.published >= 0 )
  32. UPDATE jtneb_content
      SET hits = hits + 1
      WHERE id = 498
  33. SELECT params
      FROM jtneb_extensions AS e
      WHERE e.element='com_widgetkit'
  34. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  35. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jtneb_modules AS m
      LEFT JOIN jtneb_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jtneb_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-03 14:23:18')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-03 14:23:18')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 175 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  36. SELECT alias, catid
      FROM jtneb_content
      WHERE id = 498
  37. SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count`
      FROM jtneb_categories AS Category
      LEFT JOIN jtneb_categories AS ParentCategory
      ON Category.lft <= ParentCategory.lft
      AND Category.rgt >= ParentCategory.rgt
      LEFT JOIN jtneb_content AS Listing
      ON ParentCategory.id = Listing.catid
      AND Listing.state = 1
      INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON Category.id = JreviewsCategory.id
      AND JreviewsCategory.option = "com_content"
      LEFT JOIN jtneb_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
      LEFT JOIN jtneb_jreviews_criteria AS ListingType
      ON JreviewsCategory.criteriaid = ListingType.id
      WHERE 1 = 1
      AND ( Category.published = 1
      AND ParentCategory.access IN ( 1,1 )
      AND Category.extension = "com_content"
      AND Category.level <= 2 )
      GROUP BY Category.id
      ORDER BY Directory.desc,Category.lft
  38. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 16
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 16
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  39. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 19
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 19
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  40. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 20
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 20
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  41. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 17
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 17
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  42. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 21
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 21
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  43. ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( ParentCategory.id = 22
      AND ParentCategory.published = 1 ) ) UNION ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft
      FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory
      LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = ParentCategory.id
      WHERE ( Category.published = 1
      AND Category.lft BETWEEN ParentCategory.lft
      AND ParentCategory.rgt
      AND Category.id = 22
      AND ParentCategory.parent_id > 0 )
      GROUP BY ParentCategory.id
      ORDER BY ParentCategory.lft )
  44. UPDATE `jtneb_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1675434194;s:18:\"session.timer.last\";i:1675434194;s:17:\"session.timer.now\";i:1675434194;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:\"26bf1661970415b7693e5c8cd89b6944\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"d4ba501db310cc3514d6d03fcd3aa6c2\";s:1:\"0\";s:32:\"84d958dd9f5937b559f2514116d7b208\";s:1:\"1\";s:32:\"c08631db413fffdcfb4bf6ee06864a03\";s:1:\"0\";}}', `time` = 1675434198
      WHERE `session_id` = '0htaj526p73gesourdgfos7ds0'

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
  2. 3 × SELECT COUNT(*) FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  3. 2 × SELECT alias, catid FROM jtneb_content
  4. 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jtneb_categories as c LEFT JOIN jtneb_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 1 × SELECT content_id AS listing_id, count(*) AS favored FROM jtneb_jreviews_favorites AS Favorite
  6. 1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips` FROM jtneb_content AS Listing INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt LEFT JOIN jtneb_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jtneb_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jtneb_users AS User ON User.id = Listing.created_by LEFT JOIN jtneb_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jtneb_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id
  7. 1 × SELECT count(*) FROM jtneb_jreviews_categories AS JreviewCategory
  8. 1 × SELECT count(*) FROM jtneb_jreviews_categories AS Category
  9. 1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  10. 1 × SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count` FROM jtneb_categories AS Category LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft <= ParentCategory.lft AND Category.rgt >= ParentCategory.rgt LEFT JOIN jtneb_content AS Listing ON ParentCategory.id = Listing.catid AND Listing.state = 1 INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id
  11. 1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
  12. 1 × SELECT catid FROM jtneb_content
  13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jtneb_modules AS m LEFT JOIN jtneb_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jtneb_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  14. 1 × SELECT params FROM jtneb_extensions AS e
  15. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jtneb_content AS a LEFT JOIN jtneb_categories AS c on c.id = a.catid LEFT JOIN jtneb_users AS u on u.id = a.created_by LEFT JOIN jtneb_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jtneb_categories as parent ON parent.id = c.parent_id LEFT JOIN jtneb_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  16. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jtneb_menu AS m LEFT JOIN jtneb_extensions AS e ON m.component_id = e.extension_id
  17. 1 × SELECT folder AS type, element AS name, params FROM jtneb_extensions
  18. 1 × SELECT id, rules FROM `jtneb_viewlevels
  19. 1 × SELECT `session_id` FROM `jtneb_session`
  20. 1 × SELECT * FROM jtneb_languages
  21. 1 × SELECT id, home, template, s.params FROM jtneb_template_styles as s LEFT JOIN jtneb_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  22. 1 × SELECT `data` FROM `jtneb_session`
  23. 1 × SELECT b.rules FROM jtneb_assets AS a LEFT JOIN jtneb_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  24. 1 × SELECT a.rules FROM jtneb_assets AS a
  25. 1 × SELECT enabled AS published, params FROM jtneb_extensions
OTHER Tables:
  1. 7 × ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id
  2. 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1675434194;s:18:\"session.timer.last\";i:1675434194;s:17:\"session.timer.now\";i:1675434194;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:\"26bf1661970415b7693e5c8cd89b6944\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"d4ba501db310cc3514d6d03fcd3aa6c2\";s:1:\"0\";s:32:\"84d958dd9f5937b559f2514116d7b208\";s:1:\"1\";s:32:\"c08631db413fffdcfb4bf6ee06864a03\";s:1:\"0\";}}', `time` = 1675434198
  3. 1 × UPDATE jtneb_content SET hits = hits + 1
  4. 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('0htaj526p73gesourdgfos7ds0', 0, 1675434194
  5. 1 × (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config` FROM jtneb_categories AS ParentCategory INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS ListingType ON ListingType.id = JreviewsCategory.criteriaid