Modx 2 query for template variables

This example shows how to query for template variable from a article:

SELECT cv.*, v.`name` FROM `modx_site_tmplvar_contentvalues` cv left join `modx_site_tmplvars` v on cv.tmplvarid=v.id

WHERE `contentid` = #