"Takayasu's arteritis (also known as "Aortic arch syndrome," and "Pulseless disease") is an inflammatory disease with an unknown cause. It affects the aorta, the main blood vessel from the heart, as well as the blood vessels that attach to it. Although it has been reported worldwide, it is more common in young Asian women. Females are about 8-9 times more likely to get it than males. People usually get the disease between 15 and 30 years of age. In the Western world, atherosclerosis is a more frequent cause of obstruction of the aortic arch vessels than is Takayasu's arteritis."
SELECT FeedbackName, FeedbackTitle, count(*) as totalSubTitles, (SELECT PageUrl FROM SubPages WHERE MainPage='955' and SubPages.LinkTitle = b.FeedbackTitle LIMIT 1) as isSub, RatingText, (SELECT count(*) from ReaderFeedback as a where (StarRating = '5' OR StarRating = '4') AND PageId='955' 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='955' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS CountParentPosts from ReaderFeedback as b where PageId='955' 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: