oql filter and obsolte provider contracts

[Andreas Moroder]

Hello,
I have added list of contractsthat must be renewed in the next 60 days to my welcome page.

SELECT ProviderContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 60 DAY)

Now I would like to filter obsolete contracts. How can i do that?

happy new year
Andreas

[Vincent @ Combodo]

SELECT ProviderContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 60 DAY) AND status != 'obsolete'