strSQL: SELECT `threadList`.* FROM `threadList` WHERE `lastDate` BETWEEN '2012-05-07' AND '2012-05-22' Order by `itemsOrder`,`lastDate` Desc;