How to query Umbraco latest publish content by content type alias

Environment
- Umbraco version 7.6.3 assembly: 1.0.6361.21154
- MSSQL 2012 V11

SELECT TOP 1 cmsPX.*, cmsCT.*
FROM [Umbraco_Intranet].[dbo].[cmsPreviewXml] AS cmsPX
LEFT JOIN [Umbraco_Intranet].[dbo].[cmsContentVersion] AS cmsCV ON ( cmsPX.versionId = cmsCV.VersionId 
                 and cmsPX.nodeId = cmsCV.ContentId)               
LEFT JOIN [Umbraco_Intranet].[dbo].[cmsContent] AS cmsC ON cmsC.nodeId = cmsPX.nodeId
LEFT JOIN [Umbraco_Intranet].[dbo].[cmsContentType] AS cmsCT ON cmsCT.nodeId = cmsC.contentType 
WHERE cmsCT.alias = 'Content Alias'
ORDER BY cmsPX.timestamp DESC