SELECT 
  * 
FROM 
  tt_news 
WHERE 
  1 
  and deleted = 0 
  and hidden = 0 
  and my_status = 2 
  and tx_mblnewsevent_from >= unix_timestamp(
    curDate()
  ) 
  and (
    tt_news.sys_language_uid = 1 
    or tt_news.sys_language_uid =-1
  ) 
  and tt_news.pid = 52527 
ORDER BY 
  tx_mblnewsevent_from