SELECT *,unix_timestamp(date) as `mydate` FROM `product_category` where 1 and display='1' ORDER BY sorting asc ,`id` LIMIT 0, 8