
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoListingExtendTitle");
UPDATE `multi_lang` SET `content` = 'Extend expiration date' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoListingExtendBody");
UPDATE `multi_lang` SET `content` = 'To publish your job or to extend its expiration date (if the job ad has already been published) choose the appropriate submission period. If for the desired period charges are applicable, then click on "Buy now" button and make the payment required. After payment is received the job will be automatically published / extended.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;