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='5' GROUP BY q.question_id ORDER BY maxdate DESC LIMIT 0, 10
