blog_id [x] blog_url [x] blog_status -> Table1
asin_id [x] asin_name [x] blog_under [x] asin_status -> Table2

SELECT Table1.blog_id, Table1.blog_url, Table1.blog_status, tmpTable.tmp
FROM Table1
INNER JOIN
(SELECT Table2.blog_under AS tmpblog_under, COUNT(*) AS tmp
FROM Table2
WHERE asin_status = 0
GROUP BY Table2.blog_under) AS tmpTable ON Table1.blog_id = tmpTable.tmpblog_under
WHERE tmpTable.tmp < 5;

http://wprobot.net/forum/topic.php?id=1224

rand(1, 40);

<a href="http://www.newdigg.com" title="dofollow social bookmark">Dofollow Bookmark</a> : NewDigg

<a href="http://www.newdigg.com" title="social bookmarking site">Social Bookmarking site</a> : NewDigg.com