Мульти сплит-системы

SELECT DISTINCT B.value FROM modx_site_tmplvar_contentvalues  as B
LEFT JOIN modx_site_content as A ON (B.contentid = A.id)
WHERE A.parent IN(3610,3535,3536,3538,3539,1724,1726,25) and B.tmplvarid=5