Our readers offer information and opinions on Earth Clinic, not as a substitute for professional medical prevention, diagnosis, or treatment. Please consult with your physician, pharmacist, or health care provider before taking any home remedies or supplements or following any treatment suggested by anyone on this site. Only your health care provider, personal physician, or pharmacist can provide you with advice on what is safe and effective for your unique needs or diagnose your particular medical history.
SELECT FeedbackName, FeedbackTitle, count(*) as totalSubTitles, (SELECT PageUrl FROM SubPages WHERE MainPage='1533' and SubPages.LinkTitle = b.FeedbackTitle LIMIT 1) as isSub, RatingText, (SELECT count(*) from ReaderFeedback as a where (StarRating = '5' OR StarRating = '4') AND PageId='1533' 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='1533' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS CountParentPosts from ReaderFeedback as b where PageId='1533' 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: