How to find Quality Center Bug History using SQL?

Use below query to find out the bug history.

SELECT AL.AU_USER, AL.AU_TIME, AP.AP_PROPERTY_NAME,

       AP.AP_NEW_VALUE, AP.AP_NEW_LONG_VALUE, AP.AP_NEW_DATE_VALUE,AL.AU_ACTION

FROM AUDIT_LOG AL, AUDIT_PROPERTIES AP, BUG B

WHERE (AL.AU_ACTION_ID = AP.AP_ACTION_ID)

  AND (TO_CHAR(B.BG_BUG_ID) = TO_CHAR(AL.AU_ENTITY_ID))

  AND (B.BG_BUG_ID = 'Defect Id')

  AND (AL.AU_ENTITY_TYPE = 'BUG')

ORDER BY AU_TIME ASC