SELECT * FROM clients WHERE CDate >= DATE_SUB(NOW(),INTERVAL 1 YEAR) AND List = 'Yes' ORDER BY Featured DESC, CDate DESC