SELECT COUNT(a.answer_id) AS ans_count, q.question_id, q.question, qc.cat_name AS catName, qs.cat_name AS subCatName, q.fullname, q.member_id, q.recorddate, qc.cat_id as catId, qs.cat_id as subCatId , GREATEST(q.recorddate, a.recorddate) AS gdate , GREATEST(q.recorddate, MAX(a.recorddate), MAX(r.recorddate)) AS maxdate FROM questions q LEFT JOIN answers a ON q.question_id=a.question_id AND a.status = 1 LEFT JOIN reply r ON a.answer_id=r.answer_id LEFT JOIN question_cat qc ON q.cat_id=qc.cat_id LEFT JOIN question_cat qs ON q.subcat_id=qs.cat_id WHERE q.status='1' AND q.cat_id='9' GROUP BY q.question_id ORDER BY maxdate DESC LIMIT 0, 10

Real Estate in Your City Ahmedabad Property Bangalore Property Chennai Property Delhi/NCR Property Residential Real Estate Properties in Other Cities Hyderabad Property Kolkata Property Mumbai Property Pune Property Commercial Real Estate Our Services Search Property List Property Post Requirement Discussion Forum Advertise with Us Privacy & You Privacy Policy Terms Of Use Company Contact Us About Us Site Map India Property Sites List your site Network Sites Shaadi.com Mauj Mobile Astrolife.com MakaanIQ.com Connect with us Makaan.com, fastest growing property website in India was established with the mission to connect relevant buyers and sellers of real estate , massively increasing the propensity of transactions. The website is committed to help it\'s users make wise and profitable decisions relating to buying, selling, renting and leasing of properties in India and key global geographies. Makaan.com is part of People Group, owners of world famous brands like Shaadi.com & Mauj Mobile. Copyright © '2013' Makaan.com - Real Estate India - Property - Properties in India - All Rights Reserved.