SELECT tb.nid,tb.title , COUNT(tb2.l_id) AS CountLike FROM tb_news tb1 , tb_like tb2
WHERE 1=1
AND tb1.n_id = tb2.l_id
WHERE tb2.l_choice = '1'
GROUP BY tb.nid,tb.title
ORDER BY CountLike
LIMIT 0,10
SELECT tb_news.n_id,tb_news.n_title , COUNT(tb_like.l_id) AS CountLike FROM tb_news , tb_like WHERE 1=1
AND tb_news.n_id = tb_like.l_data_id and tb_like.l_choice = '1'
GROUP BY tb_news.n_id
ORDER BY CountLike
DESC LIMIT 0,10
Load balance : Server 02
