Latest Reviews

335 results - showing 1 - 10 « 1 2 3 4 5 6 7 ... 34 »
Ordering 
 
Limos
 
2018-06-12 08:01:26 Alo Z Car Service
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by Alo Z Car Service    June 12, 2018
Top 100 Reviewer  -   View all my reviews

Cheap Limo Car Service NJ

Hire! Best Taxi and Limo service NJ

Was this review helpful to you? 
00
Report this review
Limos
 
2017-12-13 18:06:12 successlimousine
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by successlimousine    December 13, 2017
Top 100 Reviewer  -   View all my reviews

successlimousine.com

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

Was this review helpful to you? 
00
Report this review
Limos
 
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
Limos
 
2017-05-07 09:46:41 Oscar Garrido
Overall rating 
 
4.5
Service 
 
4.5
Pricing 
 
4.5
Reviewed by Oscar Garrido    May 07, 2017
Top 100 Reviewer  -   View all my reviews

Best corporate transportation for business travelers

I want to thank you for your service Monday and yesterday, Plus I want to thank Carmen for driving back to my house to deliver my phone!!

Was this review helpful to you? 
00
Report this review
Limos
 
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
Limos
 
2017-02-16 12:25:17 Sergej
Overall rating 
 
4.5
Service 
 
5.0
Pricing 
 
4.0
Reviewed by Sergej    February 16, 2017
Top 100 Reviewer  -   View all my reviews

LimoBooking in Berlin is very good

Was this review helpful to you? 
00
Report this review
Limos
 
2016-11-03 16:26:29 gordon
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by gordon    November 03, 2016
Top 100 Reviewer  -   View all my reviews

was so impressed with the quality of service

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

Was this review helpful to you? 
00
Report this review
Limos
 
2016-10-29 15:30:14 Gordon
Overall rating 
 
5.0
Service 
 
5.0
Pricing 
 
5.0
Reviewed by Gordon    October 29, 2016

So Affordable and great

DEfinitely would give this company the highest rate as our experience was so amazing. I booked this company for our ride to airport as we always want to be sure we won't be late, and everything turned out so perfect. The driver was 10 min early. Also the car was so clean. Definitely we like it. Thanks guys

Was this review helpful to you? 
00
Report this review
Limos
 
2016-10-28 00:47:25 FastinOnline
Overall rating 
 
0.5
Service 
 
0.5
Pricing 
 
0.5
Reviewed by FastinOnline    October 28, 2016

drug test in a week

ati college of health generic plan b pill asus transformer tablet tf101 the 11th doctor who walmart drug list 2013

Was this review helpful to you? 
00
Report this review
Limos
 
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
335 results - showing 1 - 10 « 1 2 3 4 5 6 7 ... 34 »

Directory

Profile Information

Application 0.001 seconds (+0.001); 0.25 MB (+0.251) - afterLoad
Application 0.145 seconds (+0.145); 1.39 MB (+1.134) - afterInitialise
Application 0.172 seconds (+0.027); 1.77 MB (+0.382) - afterRoute
Application 0.595 seconds (+0.423); 5.16 MB (+3.397) - afterDispatch
Application 0.660 seconds (+0.065); 5.71 MB (+0.546) - beforeRenderModule mod_custom (Logo)
Application 0.687 seconds (+0.027); 5.84 MB (+0.131) - afterRenderModule mod_custom (Logo)
Application 0.691 seconds (+0.004); 5.85 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.711 seconds (+0.019); 5.89 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 0.711 seconds (+0.000); 5.89 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.732 seconds (+0.021); 5.94 MB (+0.053) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.756 seconds (+0.024); 6.12 MB (+0.181) - beforeRenderModule mod_search (Search)
Application 0.766 seconds (+0.011); 6.15 MB (+0.032) - afterRenderModule mod_search (Search)
Application 0.773 seconds (+0.006); 6.15 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 0.783 seconds (+0.010); 6.17 MB (+0.019) - afterRenderModule mod_menu (Menu)
Application 0.783 seconds (+0.000); 6.17 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.792 seconds (+0.009); 6.19 MB (+0.017) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.805 seconds (+0.013); 6.19 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.813 seconds (+0.008); 6.20 MB (+0.008) - afterRenderModule mod_menu (Links:)
Application 0.814 seconds (+0.000); 6.20 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.825 seconds (+0.011); 6.21 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.825 seconds (+0.000); 6.20 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.835 seconds (+0.010); 6.21 MB (+0.008) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.835 seconds (+0.000); 6.21 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 0.923 seconds (+0.088); 6.61 MB (+0.401) - afterRenderModule mod_jreviews_directories (Directory)
Application 0.938 seconds (+0.015); 6.61 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 0.940 seconds (+0.002); 6.61 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 0.962 seconds (+0.022); 6.59 MB (-0.022) - afterRender

Memory Usage

6.67 MB (6,990,576 Bytes)

32 Queries Logged

  1. SELECT `data`
      FROM `jtneb_session`
      WHERE `session_id` = '7ipo2499kl86tt4sp8vd9hqoq2'
  2. DELETE
      FROM `jtneb_session`
      WHERE `time` < 1675432781
  3. SELECT `session_id`
      FROM `jtneb_session`
      WHERE `session_id` = '7ipo2499kl86tt4sp8vd9hqoq2'
      LIMIT 0, 1
  4. INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
      VALUES ('7ipo2499kl86tt4sp8vd9hqoq2', 0, 1675433681)
  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_jreviews'
  12. SELECT *
      FROM jtneb_languages
      WHERE published=1
      ORDER BY ordering ASC
  13. 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
  14. SELECT *
      FROM jtneb_menu
      WHERE id = 163
  15. 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.mode AS `Review.extension`
      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
      WHERE 1 = 1
      AND ( Review.published = 1 )
      ORDER BY `Review.created` DESC
      LIMIT 10
  16. 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`
      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 IN (583,582,572,581,580,579,32,462,498) )
  17. ( 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 )
  18. SELECT content_id AS listing_id, count(*) AS favored
      FROM jtneb_jreviews_favorites AS Favorite
      WHERE Favorite.content_id IN (32,462,498,572,579,580,581,582,583)
      GROUP BY listing_id
  19. 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
      WHERE 1 = 1
      AND ( Review.published = 1 )
  20. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  21. 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
  22. SELECT params
      FROM jtneb_extensions AS e
      WHERE e.element='com_widgetkit'
  23. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jtneb_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  24. 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:14:41')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-03 14:14:41')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 163 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  25. 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
  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 = 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 )
  27. ( 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 )
  28. ( 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 )
  29. ( 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 )
  30. ( 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 )
  31. ( 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 )
  32. UPDATE `jtneb_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1675433681;s:18:\"session.timer.last\";i:1675433681;s:17:\"session.timer.now\";i:1675433681;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\":24:{s:9:\"\0*\0isRoot\";N;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\";N;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:13:\"session.token\";s:32:\"b7a8b57ac4e50063a64fcc20a111874e\";}__findCount|a:1:{s:6:\"Review\";a:1:{s:32:\"d51ae9492c267c73230903c376fe4e14\";s:3:\"335\";}}', `time` = 1675433682
      WHERE `session_id` = '7ipo2499kl86tt4sp8vd9hqoq2'

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 6 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
  2. 1 × 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
  3. 1 × SELECT content_id AS listing_id, count(*) AS favored FROM jtneb_jreviews_favorites AS Favorite
  4. 1 × 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 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` 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
  6. 1 × SELECT params FROM jtneb_extensions AS e
  7. 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
  8. 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
  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`, Review.mode AS `Review.extension` 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
  10. 1 × SELECT * FROM jtneb_menu
  11. 1 × SELECT id, rules FROM `jtneb_viewlevels
  12. 1 × SELECT `session_id` FROM `jtneb_session`
  13. 1 × SELECT folder AS type, element AS name, params FROM jtneb_extensions
  14. 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
  15. 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
  16. 1 × SELECT * FROM jtneb_languages
  17. 1 × SELECT `data` FROM `jtneb_session`
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:1675433681;s:18:\"session.timer.last\";i:1675433681;s:17:\"session.timer.now\";i:1675433681;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\":24:{s:9:\"\0*\0isRoot\";N;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\";N;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:13:\"session.token\";s:32:\"b7a8b57ac4e50063a64fcc20a111874e\";}__findCount|a:1:{s:6:\"Review\";a:1:{s:32:\"d51ae9492c267c73230903c376fe4e14\";s:3:\"335\";}}', `time` = 1675433682
  3. 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('7ipo2499kl86tt4sp8vd9hqoq2', 0, 1675433681
  4. 1 × DELETE FROM `jtneb_session`