4SEO 6.4.0.2524 - Joomla
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/theme_layouts/detail.thtml
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/listings/detail.thtml
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/listings/detail_header.thtml

4SEO 6.5.0.2541 - Joomla Extension

Updated March 31, 2025
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/elements/listing_detail_media.thtml
4SEO 6.5.0.2541 - Joomla Extension

🌟 4SEO 6.5.0.2541 – The Ultimate Joomla SEO Extension

4SEO 6.5.0.2541 is a powerful Joomla extension designed to enhance SEO, improve website performance, and optimize search engine indexing. With its 14 years of Joomla SEO expertise, it combines cutting-edge automation with advanced features to help you achieve better rankings, faster performance, and enhanced user experience. Whether you're managing metadata, generating sitemaps, or tracking Core Web Vitals, 4SEO is your all-in-one SEO powerhouse.

This extension is built to save you time and effort by automating the complexities of SEO. It ensures that search engines like Google, Bing, and Yahoo can easily crawl and index your site, leading to higher rankings and increased organic traffic. By generating both XML sitemaps (for search engines) and optimizing metadata, 4SEO bridges the gap between technical SEO and user experience.

One of the standout features of 4SEO is its AI-powered automation. It eliminates the need for complex configurations, allowing you to focus on creating exceptional content. Additionally, it supports Joomla 3, 4, and 5, ensuring smooth integration with your existing setup. With 4SEO, you can boost your search rankings, improve page speed, and drive more organic traffic to your site.


✨ Key Features

πŸ“Š Performance & SEO Monitoring

Track Core Web Vitals (LCP, FID, CLS) and optimize page speed with Google PageSpeed Insights for better rankings.

πŸ“Œ Advanced SEO Management

Manage metadata, canonical tags, and structured data effortlessly from the frontend or backend.

🌍 Automated Sitemap & Indexing

Generate and submit XML sitemaps to Google and Bing for faster indexing and error-free crawling.


πŸ“Έ See It in Action

Check out how 4SEO works in real-time. The screenshot above demonstrates the intuitive interface and powerful features that make it the go-to tool for SEO optimization and sitemap generation.

πŸš€ Ready to Elevate Your Website?

Don't miss out on the opportunity to optimize your Joomla site with the most advanced SEO tools available. Get 4SEO 6.5.0.2541 today and start improving your search rankings, page speed, and user engagement. With its intuitive interface and powerful features, you'll be able to create professional-quality SEO campaigns in no time. Transform your website and leave a lasting impression on your visitors.

πŸš€ New Version Available! πŸš€

πŸ“„ Versions Available for Download

  • 4SEO 6.5.0.2541 – Joomla Extension
  • 4SEO 6.4.0.2524 – Joomla Extension
  • 4SEO 6.3.0.2497 – Joomla Extension

⚑ What’s New in 4SEO?

  • βœ” AI-Powered SEO Automation – Automate technical & content SEO effortlessly.
  • βœ” Core Web Vitals Optimization – Improve page speed and user experience.
  • βœ” Advanced Metadata Management – Manage metadata, canonical tags, and structured data.
  • βœ” Automated Sitemap Generation – Generate and submit XML sitemaps to search engines.
  • βœ” Seamless Joomla Integration – Compatible with Joomla 3, 4, and 5.

πŸ“Œ Why Choose 4SEO 6.5.0.2541 - Joomla Extension?

4SEO is the ultimate Joomla SEO solutionβ€”helping you boost rankings, improve page speed, and enhance user engagement like a pro!

  • βœ” Boosts SEO & Indexing – Ensures your site is fully optimized for search engines.
  • βœ” Seamless Joomla Integration – Works perfectly in Joomla 3, 4, and 5.
  • βœ” User-Friendly & Efficient – Manage SEO directly from Joomla’s backend.
  • βœ” AI-Powered Automation – Automates complex SEO tasks effortlessly.
  • βœ” Improves Usability & Engagement – Optimizes Core Web Vitals for better user experience.

πŸ“₯ Download 4SEO 6.5.0.2541 Today!

πŸ”‘

Login to Download

Registration is Free, but you need a subscription to download. Read our F.A.Q. for more details.

πŸ“‚

Download Files

Login or Register First!

You need to be logged in to see and download the available files.

πŸ“§

Get Updates

Subscribe to our newsletter!

Don't hesitate to reach out if you need any previous versions!

Be sure to subscribe to our newsletter for the latest updates, exclusive offers, and more!

Don't hesitate to reach out if you need any previous versions!

Be sure to subscribe to our newsletter for the latest updates, exclusive offers, and more!

  

πŸ””

Stay Notified

Register then get notified when a new version is uploaded!

 

Sign_In!
Subscribe to this content and receive updates directly in your inbox.
4SEO 6.5.0.2541 - Joomla Extension
Loading...
 

com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/elements/listing_detail_media.thtml
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/reviews/editor_reviews.thtml

Editor review

1 review
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/reviews/review_layout.thtml
4SEO 6.5.0.2541 - Joomla Extension Staff-Curated Editor Review
(Updated: May 17, 2025)
Overall rating
 
1.6
πŸ–±οΈ Ease of Use
 
2.0
πŸš€ Features & Functionality
 
2.5
🎨 Customization & Flexibility
 
2.0
⚑ Performance & Speed
 
1.5
πŸ”’ Security & Reliability
 
0.5
πŸ’° Value for Money
 
1.0
4SEO 6.5.0.2541 claims to be the ultimate Joomla SEO extension, promising to revolutionize your website’s SEO with advanced automation, structured data management, and performance optimization. However, after extensive testing, I can confidently say that this extension falls far short of its promises. It is buggy, unreliable, and, frankly, a waste of money. I cannot recommend it to anyone, and I would go as far as to say it feels like a scam given its high price tag and poor performance.

Key Features & Promises
✨ Advanced SEO Automation – Supposedly automates metadata, canonical tags, and structured data.
✨ Core Web Vitals Optimization – Claims to improve page speed and user experience.
✨ XML Sitemap Generation – Promises seamless sitemap creation and submission to search engines.
✨ Frontend & Backend Management – Allows SEO management from both frontend and backend.

Real-Life Usage Insights: A Frustrating Experience
1. Structured Data Chaos
One of the most glaring issues I encountered was with structured data. On product pages, the extension mixed up structured data types, resulting in a jumbled mess of unrelated schema markup. For example, a product page displayed schema for articles, local businesses, and recipes simultaneously. This not only confuses search engines but also risks penalties for incorrect markup.

2. Undiscovered Pages & Canonical Issues
The extension failed to discover hundreds of pages on my site, leaving them unoptimized and without proper canonical tags. Even when I manually tried to set up canonical URLs, the process often failed, leaving duplicate content issues unresolved. This is a critical flaw for an SEO tool, as canonical tags are essential for avoiding duplicate content penalties.

3. Frontend Editing Failures
Frontend editing, one of the touted features, was a nightmare. Most attempts to edit metadata or SEO settings from the frontend resulted in errors or incomplete saves. The interface would often freeze, requiring a page reload, and changes were rarely applied correctly.

4. Crawling Performance
The crawling process is painfully slow, often taking days to complete even on a medium-sized website. During testing, the crawler frequently got stuck or crashed, requiring manual intervention to restart the process. This inefficiency makes it nearly impossible to rely on 4SEO for timely updates or optimizations.

5. Undiscovered Pages Cannot Be Processed
Perhaps the most frustrating issue is that the extension cannot process pages it fails to discover. If a page isn’t detected during the crawl, there’s no way to manually add it or force the extension to optimize it. This leaves large portions of your site completely unoptimized, defeating the purpose of an all-in-one SEO tool.

6. Sitemap Submission Failures
The generated XML sitemap frequently failed to submit to Google Search Console. Despite multiple attempts, the extension either timed out or returned vague error messages. This is a critical failure for an SEO tool, as sitemap submission is a basic requirement for proper indexing.

7. Security Concerns: Password Protection for Data Deletion
Starting from version 6.4.0, a highly questionable feature was introduced: password protection for the "Delete data upon uninstallation" option. This means you must enter your site administrator password to delete the data that 4SEO has added to your database.

This raises serious security concerns:

Where is your password being stored or transmitted?
Could it be sent out illegally?
Why is a password even required for such a basic function?

This feature feels invasive and unnecessary, adding a layer of risk to an already unreliable extension. It’s a major red flag and further erodes trust in the developers.

Pros & Cons

βœ… Pros:

The idea of an all-in-one SEO tool is appealing.
The interface, when it works, is visually clean and modern.

❌ Cons:
⚠ Mixed up structured data types, creating SEO risks.
⚠ Fails to discover hundreds of pages, leaving them unoptimized.
⚠ Canonical tag setup is unreliable and often fails.
⚠ Frontend editing is buggy and error-prone.
⚠ Crawling process is slow, inefficient, and prone to crashes.
⚠ Generated sitemaps frequently fail to submit to Google.
⚠ Extremely expensive for the level of functionality provided.
⚠ Poor customer support and lack of timely updates to fix critical bugs.
⚠ Security red flag: Password requirement for data deletion raises serious concerns.

Data Privacy & Handling

While 4SEO claims to handle data securely, the frequent crashes, errors, and the new password requirement for data deletion raise significant concerns about data integrity and security. During testing, I noticed that some settings and configurations were lost after crashes, requiring manual reconfiguration. This lack of reliability is unacceptable for a tool that handles sensitive SEO data.

Alternatives & Comparisons
πŸ†š Compared to Tassos Structured Data Joomla Extension – Tassos Structured Data is a lightweight, focused solution for managing structured data without the bloat and bugs of 4SEO. It’s more reliable and easier to use for schema markup.
πŸ†š Compared to Aimy Sitemap PRO – Aimy Sitemap PRO is far more reliable, with faster crawling, accurate structured data, and better canonical tag management.
πŸ†š Compared to RSSEO – RSSEO offers similar features at a fraction of the cost, with fewer bugs and better performance.
πŸ†š Compared to native Joomla SEO tools – Even Joomla’s built-in SEO features are more reliable than 4SEO, though they lack advanced automation.

Who Is It For?
Honestly, I cannot recommend 4SEO 6.5.0.2541 to anyone. It is overpriced, buggy, and fails to deliver on its core promises. The addition of the password requirement for data deletion is a major red flag, making this extension not just a poor investment but also a potential security risk.

Final Verdict: A Waste of Money and a Security Risk
4SEO 6.5.0.2541 is one of the most disappointing Joomla extensions I’ve ever tested. It is riddled with bugs, fails to deliver on its promises, and is outrageously expensive for the level of functionality it provides. The mixed-up structured data, undiscovered pages, unreliable canonical tag setup, and sitemap submission failures make it a liability for any website.

The addition of the password requirement for data deletion is a serious security concern. It raises questions about how user data is handled and whether passwords are being stored or transmitted insecurely. This alone is enough to steer clear of this extension.

If you’re serious about SEO, avoid this extension at all costs. It’s not just a poor investmentβ€”it’s a potential risk to your site’s search engine rankings and security. Save your money and opt for a more reliable and cost-effective solution.

Overall Rating: 1.6/5 – Not Recommended
Report this review Comments (0) | Was this review helpful? 0 0
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/reviews/user_reviews.thtml

User reviews

There are no user reviews for this listing.
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/reviews/create.thtml
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/elements/login.thtml
Already have an account?
com_content_controller.phpfunction com_content_view
components/com_jreviews/jreviews/views/themes/default/elements/form_user_details.thtml
Ratings
πŸ–±οΈ Ease of Use
How intuitive and user-friendly is the product? Can beginners quickly understand and navigate it, or does it require a steep learning curve?
πŸš€ Features & Functionality
Does the product provide all the essential features you need? Are the included tools and capabilities useful, well-designed, and effective for their intended purpose?
🎨 Customization & Flexibility
How easily can the product be tailored to meet your specific needs? Does it offer enough options, settings, and integrations to adapt to different use cases?
⚑ Performance & Speed
How efficiently does the product operate? Does it load quickly, run smoothly, and provide a fast, seamless user experience without slowing down your site?
πŸ”’ Security & Reliability
How secure and stable is this product? Does it protect against vulnerabilities and function consistently without issues?
πŸ’° Value for Money
Does this product provide good features and performance for its price? Is it worth the investment compared to similar options?
Comments
You will be able to upload media right after you submit your review.

Information

Joomla

WordPress

F.A.Q. | Section

Stay updated on social media!

Subscribe to our Newsletter!

Rapi Music Player Joomla Extension
Services VirtueMart CAPI Plugin - Joomla Extension
Social Buttons Mobile - Joomla Extension

S2Framework Debug Console

Database Queries (20)

  1. SET SQL_BIG_SELECTS=1
  2. SHOW TABLES LIKE '%_jreviews_config'
  3. SELECT value FROM j11th_jreviews_config WHERE id = 'cms_secret'
  4. SELECT name FROM j11th_jreviews_addons WHERE state = 1 ORDER BY ordering
  5. SELECT id, language FROM j11th_menu WHERE link LIKE "%com_comprofiler&view=userprofile" AND published = 1 AND type = "component"
  6. SELECT id, language FROM j11th_menu WHERE link LIKE "%com_comprofiler&view=registers" AND published = 1 AND type = "component"
  7. SELECT count(*) FROM j11th_jreviews_categories AS JreviewCategory WHERE JreviewCategory.id = 22 AND JreviewCategory.option = 'com_content' AND JreviewCategory.criteriaid > 0
  8. SELECT JreviewsCategory.id FROM j11th_jreviews_categories AS JreviewsCategory LEFT JOIN j11th_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.`option`= "com_content" AND Category.published = 1 AND Category.access IN ( 1,5)
  9. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.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`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, 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.user_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`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j11th_content AS Listing LEFT JOIN j11th_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j11th_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j11th_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j11th_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j11th_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j11th_users AS User ON User.id = Listing.created_by LEFT JOIN j11th_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( (Listing.id = 423) AND Listing.catid IN (22) AND Listing.state >= -1 )
  10. SELECT content_id AS listing_id, count(*) AS favored FROM j11th_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (423) GROUP BY listing_id
  11. SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != listing_id AND media_type = 'photo' AND ((review_id = 0 AND user_id = 948) OR main_media = 1) THEN @photo := 1 ELSE IF(media_type = 'photo' AND ((review_id = 0 AND user_id = 948) OR main_media = 1),@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != listing_id AND media_type = 'video' AND ((review_id = 0 AND user_id = 948) OR main_media = 1) THEN @video := 1 ELSE IF(media_type = 'video' AND ((review_id = 0 AND user_id = 948) OR main_media = 1),@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != listing_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != listing_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := listing_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM j11th_jreviews_media WHERE listing_id IN (423) AND published = 1 AND approved = 1 AND access IN (1,5) AND extension = 'com_content' ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, listing_id, media_type, created DESC ) tmp JOIN j11th_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank BETWEEN 1 AND 7) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.created DESC
  12. SELECT Community.id AS `Community.user_id`, Community.id AS `Community.community_user_id`, Community.id AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.avatarapproved AS `Community.avatarapproved`, Community.banned AS `Community.banned`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block`, User.name AS `User.email` FROM j11th_comprofiler AS Community LEFT JOIN j11th_users AS User ON Community.id = User.id WHERE 1 = 1 AND ( Community.id IN (948) )
  13. SELECT rating_range, count(*) AS count FROM (SELECT CASE WHEN ROUND(rating,1) > 0 AND rating < 1.5 THEN 1 WHEN ROUND(rating,1) >= 1.5 AND ROUND(rating,1) < 2.5 THEN 2 WHEN ROUND(rating,1) >= 2.5 AND ROUND(rating,1) < 3.5 THEN 3 WHEN ROUND(rating,1) >= 3.5 AND ROUND(rating,1) < 4.5 THEN 4 WHEN ROUND(rating,1) >= 4.5 THEN 5 END as rating_range FROM j11th_jreviews_comments WHERE pid = 423 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range
  14. 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 `Review.user_id`, User.id 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`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, 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`, IF(Review.rating=0,"na",Review.rating) 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)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id` FROM j11th_jreviews_comments AS Review LEFT JOIN j11th_users AS User ON Review.userid = User.id LEFT JOIN j11th_jreviews_reviewer_ranks AS ReviewerRank ON Review.userid = ReviewerRank.user_id LEFT JOIN j11th_content AS Listing ON Listing.id = Review.pid LEFT JOIN j11th_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content' LEFT JOIN j11th_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( Review.pid = 423 AND Review.mode = 'com_content' AND Review.published = 1 AND Review.author = 1 AND JreviewsCategory.option = 'com_content' ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 5
  15. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j11th_jreviews_review_ratings WHERE review_id IN (23)
  16. 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 `Review.user_id`, User.id 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`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, 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`, IF(Review.rating=0,"na",Review.rating) 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)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text` FROM j11th_jreviews_comments AS Review LEFT JOIN j11th_users AS User ON Review.userid = User.id LEFT JOIN j11th_jreviews_reviewer_ranks AS ReviewerRank ON Review.userid = ReviewerRank.user_id LEFT JOIN j11th_content AS Listing ON Listing.id = Review.pid LEFT JOIN j11th_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content' LEFT JOIN j11th_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( Review.pid = 423 AND Review.mode = 'com_content' AND Review.published = 1 AND Review.author = 0 AND JreviewsCategory.option = 'com_content' ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 5
  17. SELECT COUNT(*) FROM j11th_jreviews_comments AS Review WHERE 1 = 1 AND ( Review.pid = 423 AND Review.mode = 'com_content' AND Review.published >= 0 AND Review.ipaddress = '216.73.216.40' )
  18. SELECT COUNT(*) FROM j11th_jreviews_comments AS Review WHERE 1 = 1 AND ( Review.pid = 423 AND Review.mode = 'com_content' AND Review.published >= 0 AND Review.author = 0 AND Review.userid = 0 )
  19. SELECT COUNT(*) FROM j11th_jreviews_comments AS Review WHERE 1 = 1 AND ( Review.pid = 423 AND Review.mode = 'com_content' AND Review.published >= 0 AND Review.author = 1 AND Review.userid = 0 )
  20. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.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`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, 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.user_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`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j11th_content AS Listing LEFT JOIN j11th_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j11th_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j11th_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j11th_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j11th_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j11th_users AS User ON User.id = Listing.created_by LEFT JOIN j11th_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.id IN (423) )