Cacher is the code snippet organizer for pro developers

SELECT CASE
           WHEN cpi.active = 1
                AND (cpi.endDate IS NULL
                     OR cpi.endDate > NOW())
                AND cpia.name = 'common-customer/ProvisioningComplete'
                AND cpia.value = 'true' THEN 'YES'
           ELSE 'NO'
       END AS "provisioned",
       cpi.customer_id,
       c.customer_name,
       p.name,
       pt.name,
       cpi.active,
       cpi.startDate,
       cpi.endDate,
       cpia.name,
       cpia.value AS "attr_value"
FROM commondomain.customer_product_instance cpi
INNER JOIN commondomain.customer c ON c.id = cpi.customer_id
INNER JOIN commondomain.product p ON p.id = cpi.product_id
LEFT OUTER JOIN commondomain.product_type pt ON pt.id = p.product_type_id
LEFT OUTER JOIN commondomain.customer_product_instance_attribute cpia ON cpia.customer_product_instance_id = cpi.id
WHERE cpi.customer_id = 1298669
ORDER BY 1 DESC;