Need a sample SQL query for the "ALL Defects" report.

Hi,

Here is the 'All Defects' report SQL query:

SELECT
d.defect_id AS `defectid`
,dReview.review_id AS `defectreviewid`
,d.defect_state AS `defectstate`
,d.defect_createdon AS `defectcreatedon`
,dCreat.user_name AS `defectcreatorusername`
,version.version_filepath AS `defectfile`
,d.defect_text AS `defecttext`
FROM
defect d
LEFT OUTER JOIN user dCreat ON (d.defect_userid = dCreat.user_id)
LEFT OUTER JOIN review dReview ON (dReview.review_id = d.defect_reviewid)
LEFT OUTER JOIN version version ON (version.version_id = d.defect_versionid)
ORDER BY
d.defect_id DESC

Since the database schema hasn't been drastically changed since version 9.3, this query should also work fine with this version.