Copyright 1999-2019 Earth Clinic, LLC. All rights reserved.
All material and content, including, without limitation, text, graphics, photographs and images published on www.earthclinic.com (“Earth Clinic Content”) is the property of Earth Clinic, LLC, and protected by the federal Copyright Act and the copyright laws of other countries. Subject to the federal Copyright Act and any other applicable laws, no Earth Clinic Content may be copied, reproduced, modified, adapted, published, republished, publicly displayed, performed, distributed, sold, translated into any foreign language, made into any derivative work, in whole or in part, alone or in compilations, and/or incorporated in other works in any form, format, media or technology, by any method, device or process, now known or later developed, without the express written permission of Earth Clinic, LLC.
To obtain written permission for the use in any form, without limitation, of any content published on www.earthclinic.com, contact:
SELECT FeedbackName, FeedbackTitle, count(*) as totalSubTitles, (SELECT PageUrl FROM SubPages WHERE MainPage='1321' and SubPages.LinkTitle = b.FeedbackTitle LIMIT 1) as isSub, RatingText, (SELECT count(*) from ReaderFeedback as a where (StarRating = '5' OR StarRating = '4') AND PageId='1321' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS UpCount, min(FeedbackDate) as feedbackDatesMin, max(FeedbackDate) as feedbackDatesMax, (SELECT count(*) from ReaderFeedback as a where ParentFeedbackId IS NULL AND PageId='1321' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS CountParentPosts from ReaderFeedback as b where PageId='1321' AND ApprovalStatus=1 AND ShowLatest>1 AND ParentFeedbackId IS NULL GROUP BY FeedbackTitle, FeedbackName, RatingText ORDER BY FeedbackTitle
You must be logged in to this post! Please sign in: