SELECT
id,
title ,
option_1 ,
date ,
UNIX_TIMESTAMP( CONCAT( SUBSTRING(date,7,4) , "-" , SUBSTRING(date,1,2) , "-" , SUBSTRING(date,4,2) ) ) AS timestamp ,
content
FROM hard_content
WHERE type = "playlist" AND status = "active" AND UNIX_TIMESTAMP( CONCAT( SUBSTRING(date,7,4) , "-" , SUBSTRING(date,1,2) , "-" , SUBSTRING(date,4,2) ) ) > 1334808266 ORDER BY timestamp DESC