MySQL current date

 The following are just examples of the use date offsets;

SET @timeframe=now()-interval 2 year; 

SELECT ...
WHERE o.doe >= @timeframe

SET @timeframe = DATE_SUB(CURDATE(), interval 1 day);
SELECT ...
WHERE o.doe >= @timeframe and o.doe <= @timeframe

The former will deal with the full date/time stamp, while the latter will consider only the date and is good for when we need to find results for a particular day for example.

xfce Desktop and icons dissapear

 Running xfdesktop in the terminal seems to resolve.