ProjectProvider::getFeatureQuery

static function getFeatureQuery($alias, $feature = '')
{
	if (!self::isAllowedFeatures($feature))
	{
		return false;
	}

	$subQuery = FeatureTable::query();
	$subQuery->where('ENTITY_TYPE', FeatureTable::FEATURE_ENTITY_TYPE_GROUP);
	$subQuery->where('FEATURE', $feature);
	$subQuery->where('ACTIVE', 'N');
	$subQuery->registerRuntimeField(
		new ExpressionField(
			'IS_INACTIVE_IN_GROUP', "CASE WHEN {$alias}.ID = %s THEN 1 ELSE 0 END", 'ENTITY_ID'
		)
	);
	$subQuery->where('IS_INACTIVE_IN_GROUP', 1);

	return $subQuery;
}