Hi ComeOn, If you want to solve everything with seblod:
1. create one calendar-field in your SearchForm storage: standard | article | publish_down With Button 3 (Match + Stage) in your form (SearchForm) you have to choose Date & Time| Past ( < or = ) you can set as default-value now
2. create one text-field in your SearchForm storage: standard | article | publish_down With Button 3 (Match + Stage) in your form (SearchForm) you have to choose Exclusion| Not Equal you have to set as default-value 0000-00-00 00:00:00
3. in your multiple-field you can set as default 0,1
4. If it works fine you can hidden all the fields not necessary (e.g. text-field default: 0000-00-00 00:00:00)
Hi ComeOn, Try this in phpMyAdmin (XXXX = your suffix in your Database): SELECT * FROM `XXXX_content` WHERE state = 0 OR publish_down <= '2013-11-07 18:29:57' This is equivalent to SELECT ...blablabla... when state=0 OR publish_down<NOW...
The result is all your entries from your content-table, because all articles (published or unpublished) have publish_down = '0000-00-00 00:00:00' when this field is not set.
Conclusion: OR is not a good solution (mysql takes either state or publish_down for comparison)
If you only want to have entries with state = 0 (Really unpublished articles)- you have to change the value in the filed multiple-select to Unpublished
With my suggestion you can find unpublished expired articles and / or published expired articles