new_query.sql

SELECT 1
FROM `agreement`
LEFT JOIN `product1` ON (
    `agreement`.`id`=`product1`.`agreement_id`
    AND `product1`.`status` IN ('active', 'expiring')
)
LEFT JOIN `product2` ON (
    `agreement`.`id`=`product2`.`agreement_id`
    AND `product2`.`status` IN ('active', 'expiring')
)
WHERE `agreement`.customer_id = :id
GROUP BY agreement.id
HAVING count(product1.id) > 0 OR count(product2.id) > 0
LIMIT 1