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
FROM questions q
LEFT JOIN answers a ON q.question_id=a.question_id AND a.status = 1
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' GROUP BY q.question_id ORDER BY q.recorddate DESC LIMIT 0, 10
Makaan.com is part of Elara Technologies Pte Limited, Singapore which also owns and operates PropTiger.com, a digital real estate marketing and transactions services provider. In November 2014, global media, book publishing and digital real estate services company News Corp took a 25% stake in Elara. Elara's other major investors include SAIF Partners, Accel Partners and Horizon Ventures. Makaan.com is an endeavor to connect buyers to sellers on a common stage and assist them in performing transactions smoothly. The Indian real estate forum has, featured, some of the best properties across all major Indian cities. Buyers can look through these and select the desired flats for sale of Indian real estate forum. Property in real estate forum, can be searched on the basis of its price rate, dimensions, ownership, and type of construction.