Company.php

SELECT (
			(
			SELECT cp.value
			FROM company_permission cp
			LEFT JOIN default_permission dp
			ON cp.default_permission_id = dp.id
			WHERE cp.company_id = :companyId
			AND dp.name = :permissionName
			AND cp.value IS NOT NULL
			)
			*
			(
			SELECT pp.value
			FROM plan_permission pp
			LEFT JOIN default_permission dp
			ON pp.default_permission_id = dp.id
			WHERE pp.plan_id = :planId
			AND dp.name = :permissionName
			AND pp.value IS NOT NULL
			)
			*
			(
			SELECT dp.value
			FROM default_permission dp
			WHERE dp.name = :permissionName
			)
		) AS value';