"A pituitary macroadenoma is a non-cancerous growth in the pituitary gland that is more than 10 mm in size. When determining the type of pituitary macroadenoma a person has, doctors look at what kinds of hormones it produces -- if any -- and what symptoms the person has. Symptoms of a pituitary macroadenoma vary, but may include headaches, vision problems, vomiting, and dizziness. Pituitary macroadenoma treatment options may include surgery, radiation therapy, and drug therapy."
SELECT FeedbackName, FeedbackTitle, count(*) as totalSubTitles, (SELECT PageUrl FROM SubPages WHERE MainPage='735' and SubPages.LinkTitle = b.FeedbackTitle LIMIT 1) as isSub, RatingText, (SELECT count(*) from ReaderFeedback as a where (StarRating = '5' OR StarRating = '4') AND PageId='735' 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='735' AND ApprovalStatus=1 AND ShowLatest>1 and a.FeedbackTitle = b.FeedbackTitle) AS CountParentPosts from ReaderFeedback as b where PageId='735' 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: