SELECT Q.SEQ, Q.SUBJECT, Q.NAME, DATE_FORMAT( Q.INSERTDT, '%Y-%m-%d' ) INSERTDT, Q.PUBLICYN
FROM TB_QNA Q
LEFT JOIN (
SELECT T.P_SEQ, COUNT( T.P_SEQ )
FROM TB_QNACOMT T
GROUP BY T.P_SEQ
) AS QC ON Q.SEQ = QC.P_SEQ
ORDER BY Q.SEQ DESC
LIMIT 0 , 30
버전은 MySQL 4.0.26-standard 입니당
|