SELECT *, DATE_FORMAT(Posted,'%e %M, \'%y') as posted_f FROM textpattern WHERE status='4' ORDER BY 'Posted' desc