Ayuda con sintaxis en SQLyog

[Libras]

Problema 1 :
UPDATE creature_template SET `faction_A` = '35' WHERE entry between 500000 and 500144

Problema 2:
UPDATE item_template SET `stat_value1` = t1.total
from
(
select stat_value1 / 3 as total from item_template
WHERE stat_type1 = 35 ;
) as t1


Saludos!