mysql Ìæ´ú×Ó²éѯ

//in×Ó²éѯµÄд·¨ ÎÒ×Ô¼ºµÄmysqlÖ§³Ö ·þÎñÆ÷²»Ö§³Ö
(select user_no,videofile from user_info where phone in(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone not in(SELECT receiver from pair_info where caller='1365555'and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=1 and valid_top_datetime>now() order by lastupdatetime desc) union (select user_no,videofile from user_info where phone in(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone not in(SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=0 order by lastupdatetime desc)


//²»Ö§³Öin  ¿´¿´ anyÐв»,»¹ÊDz»ÐÐ
(select user_no,videofile from user_info where phone = any (SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone != any (SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2 and createtime>=now()) and status=1 and top_flag=1 and valid_top_datetime>now() order by lastupdatetime desc) union (select user_no,videofile from user_info where phone  = any(SELECT caller from pair_info where receiver='1365555' and invite_flag=1 and read_flag=0 ) and phone != any(SELECT receiver from pair_info where caller='1365555' and receive_invite_flag=2