UPDATE catalog_pages INNER JOIN (SELECT * FROM catalog_pages ORDER BY caption ASC) as d ON d.id = catalog_pages.id JOIN (SELECT @ordernum := 0) L SET catalog_pages.order_num=@ordernum:=@ordernum+1 WHERE catalog_pages.parent_id = 912389;