CodeCharge TAIWAN

select e.*,a.author,e1.php_name from e_news_articale e,author a,e_news_sub e1 where e.e_news_sub_id = e1.e_news_sub_id and e.author_id = a.author_id and e.homepage = 'Y' and state = 'Y' ORDER BY RAND() limit 0,1