漂亮的SQL

今天才发现，原来SQL也可以有出神入化的功能，

传说中PHP真的可以完全依靠于SQL而把性能发挥到极点，

使用了那么久的PHP+SQL，今天才明白，真惭愧。。。

select wap_favorite.id ,wap_favorite.ctype,wap_favorite.item_id,F_title,wap_favorite.F_url from wap_favorite,(

(

SELECT wap_bbs_topic.id,wap_bbs_topic.B_title as F_title FROM wap_bbs_topic ,

( select wap_favorite.item_id as favoriteID from wap_favorite where wap_favorite.ctype = 5 )

where wap_bbs_topic.id = favoriteID

)

UNION(

SELECT wap_rs_basis.id,wap_rs_basis.h_title_short as F_title FROM wap_rs_basis ,

( select wap_favorite.item_id as favoriteID from wap_favorite where wap_favorite.ctype != 5 ) where wap_rs_basis.id = favoriteID )

)

where wap_favorite.User_id = '$UserID' and wap_favorite.Status != 1 order by wap_favorite.cdate desc