SELECT 
                            a.hit,
                            b.id_news, b.id_topik, b.id_subkanal, b.title, b.url_title, b.date_created
                        FROM t_hit_news a LEFT JOIN t_news AS b ON b.id_news = a.id_news WHERE 
                                b.status = '0'
                                AND b.id_topik IS NOT null
                                AND b.id_topik != ''
                                AND b.`date_published` > DATE_SUB(NOW(), INTERVAL 1 DAY)
                                 ORDER BY a.hit DESC LIMIT 0,10