UPDATE<br /><br /> products_description pd INNER JOIN products_description pd2 ON<br /><br /> (pd.products_id=pd2.products_id AND pd2.language_id=1 AND pd.language_id<>1)<br /><br /> SET pd.products_seo = pd2.products_seo;

UPDATE users SET status = 1<br /><br /> WHERE id = (<br /><br /> SELECT id FROM (<br /><br /> SELECT id FROM users WHERE id = 10<br /><br /> ) u<br /><br /> )