update ps_meta_lang ml inner join ps_meta m on m.id_meta = ml.id_meta and m.page = "" inner join ps_lang l on ml.id_lang = l.id_lang and l.iso_code = "" set ml.title="", ml.description="", ml.url_rewrite="" ;