CRM-12639, eliminate left joins for pseudoconstants