清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

INSERT INTO recommend (

SELECT ut.userid,it.itemid, NOW() FROM user_tag ut,item_tag it WHERE 
EXISTS
( 

SELECT it.tagid FROM item_tag it WHERE it.tagid IN (SELECT ut.tagid FROM user_tag ut)

)

)