Viettel portal   |   Imuzik   |   Game portal   |   Info portal   |   Viettel 3G Chúc một ngày tốt lành, Guest ! | [Đăng nhập] [Đăng ký]

SELECT SQL_CALC_FOUND_ROWS ringtone.id AS ringtoneId, ringtone.name AS ringtoneName, ringtone.avatar_path AS avatarPath, ringtone.category_id AS categoryId, ringtone.category_name AS categoryName, ringtone.duration AS duration, ringtone.file_path_mp3 AS filePath, ringtone.creator_id AS creatorId, ringtone.creator_name AS creatorName, UNIX_TIMESTAMP(ringtone.created_datetime) AS createdDatetime, (ringtone.total_download + ringtone.total_set) AS total_dl_set, ringtone.rt_status as rtStatus, ringtone.rbt_status as rbtStatus FROM ringtone WHERE ringtone.creator_id <> 1 AND ringtone.rbt_status = 1 AND ringtone.created_datetime >= DATE_SUB(now(), INTERVAL 10 DAY) ORDER BY top_order DESC