"Vogt-Koyanagi-Harada syndrome (VKH syndrome) is a condition seen in humans and dogs involving various melanocyte-containing organs, characterized by uveitis (inflammation of the inside of the eye), poliosis (whitening of hair), vitiligo (loss of pigment in the skin), and meningitis, although dogs with this syndrome rarely develop meningitis. It is also known as uveodermatologic syndrome."
SELECT FeedbackName, FeedbackTitle, count(*) as totalSubTitles, (SELECT PageUrl FROM SubPages WHERE MainPage='1054' and SubPages.LinkTitle = b.FeedbackTitle LIMIT 1) as isSub, RatingText, (SELECT count(*) from ReaderFeedback as a where (StarRating = '5' OR StarRating = '4') AND PageId='1054' 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='1054' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS CountParentPosts from ReaderFeedback as b where PageId='1054' 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: