ack! query failed :
errorno=1052error=Column 'm_bcid' in where clause is ambiguousquery=
SELECT
*
FROM
m_blog_cats t1,
m_blog t2
WHERE
(t1.m_bcid IN(1) OR t1.m_bparentcid IN(1))
AND
(t1.m_bcid=t2.m_bcid)
AND
m_bdisplay IN('yes')
AND
m_bcid != 2
GROUP BY
t2.m_bid
ORDER BY
m_bdate DESC LIMIT 0,6