update stats set id=(select id from uniques where
uniques.ip_address=stats.ip_address and
uniques.domain_id=stats.domain_id and
user_agent_id=stats.user_agent_id) where stats.unique_id is null
|
update stats set id=(select id from uniques where
uniques.ip_address=stats.ip_address and
uniques.domain_id=stats.domain_id and
user_agent_id=stats.user_agent_id) where stats.unique_id is null
|