SELECT A.id, UNIX_TIMESTAMP(A.cdate) as cdate, UNIX_TIMESTAMP(A.mdate) as mdate, A.ip, B.var, B.data FROM bar_tree A, bar_data B WHERE A.id=B.parent_id AND A.parent_id=87 AND B.var='ONMAIN' AND B.data = '1' GROUP by A.id