SELECT t_content.id, t_content.category_id, t_content.alias, t_content.title, t_content.display_date, t_content.search FROM t_content LEFT JOIN t_content_category ON (t_content_category.id = t_content.category_id) WHERE t_content_category.published AND t_content.published AND (CONCAT(t_content.display_date, ' ', t_content.display_time)<=NOW()) AND (t_content.category_id=30) AND t_content.language_code='id' ORDER BY display_date DESC, display_time DESC, t_content.id DESC LIMIT 1