Просмотр

== Все активные карты на договорах ==
<source lang="sql">
SELECT contract.id, contract.title, contract.comment, user_card.id as ucid, user_card.date1 as date1, user_card.date2 as date2 
FROM `contract`
JOIN `user_card_43` as `user_card` ON `user_card`.`cid` = `contract`.`id` AND (`user_card`.date1 IS NULL OR `user_card`.date1<=NOW()) AND (`user_card`.date2 IS NULL or NOW()<=`user_card`.date2)
</source>