CREATE table
SELECT b.realname,b.address,b.qq,c.email,FROM_UNIXTIME(a.lastvisit) FROM by_common_member_status a LEFT JOIN by_common_member_profile b USING (uid) LEFT JOIN by_common_member c USING (uid)
WHERE lastvisit<=1378656000 ;
SELECT b.realname,b.address,b.qq,c.email,FROM_UNIXTIME(a.lastvisit) FROM by_common_member_status a LEFT JOIN by_common_member_profile b USING (uid) LEFT JOIN by_common_member c USING (uid)
WHERE lastvisit<=1378656000 ;