My problem today is this statement.
The `tblRSS` is populate with an RSS document and statement publish random record.Code:SELECT * FROM tblRSS WHERE DATEINSERT >= CURRENT_DATE - INTERVAL 2 DAY ORDER BY MONTH(DATEINSERT) DESC, RAND() LIMIT 0, 1
But today strange import for the RSS document where `DATEINSERT`=2012-03-29 and the statement extract only this row where `DATEINSERT`=2012-03-29.
The manual intervention resolves this anomaly....
How to avoid future problems ?
I hope your help.