codice:
SELECT id, category_id, title, description FROM article 
         WHERE category_id =22 AND CURDATE( )  
         BETWEEN foreground_start AND foreground_stop ORDER BY foreground_start DESC  
         LIMIT 0 , 1
niente, mi restituisce sempre il record con data 20/02 anzichè 21/02