
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_titles_ARRAY_AG01");
UPDATE `multi_lang` SET `content` = 'List updated!' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAddGroup");
UPDATE `multi_lang` SET `content` = 'Add List' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblDashSentTo");
UPDATE `multi_lang` SET `content` = 'Sent to' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

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

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblSentError");
UPDATE `multi_lang` SET `content` = 'Message was not sent. Please, try again.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AU04");
UPDATE `multi_lang` SET `content` = 'User has not been added. Please, try again.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AM04");
UPDATE `multi_lang` SET `content` = 'Message could not be saved. Please, try again.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AA12");
UPDATE `multi_lang` SET `content` = 'Please try again later.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_unsubscribe_ARRAY_FS02");
UPDATE `multi_lang` SET `content` = 'Subscriber was not be found!' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_confirm_ARRAY_FC02");
UPDATE `multi_lang` SET `content` = 'Subscriber was not be found!' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AS04");
UPDATE `multi_lang` SET `content` = 'Subscriber could not be added. Please, try again.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AG04");
UPDATE `multi_lang` SET `content` = 'List could not be created. Please, try again.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_titles_ARRAY_AG04");
UPDATE `multi_lang` SET `content` = 'List could not be added.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AG03");
UPDATE `multi_lang` SET `content` = 'A new list has been added.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_titles_ARRAY_AG03");
UPDATE `multi_lang` SET `content` = 'List was added!' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AG01");
UPDATE `multi_lang` SET `content` = 'All changes made to the list have been saved.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "pj_same_group");
UPDATE `multi_lang` SET `content` = 'List name is already in use.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "pj_group_required");
UPDATE `multi_lang` SET `content` = 'Subscriber must be assigned to at least one list.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAddAGroup");
UPDATE `multi_lang` SET `content` = 'Add a list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblNoGroupFound");
UPDATE `multi_lang` SET `content` = 'There are no lists.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AM09");
UPDATE `multi_lang` SET `content` = 'The message has been sent to subscribers of the selected list(s).' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblUpdateGroup");
UPDATE `multi_lang` SET `content` = 'Update list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_bodies_ARRAY_AG08");
UPDATE `multi_lang` SET `content` = 'List you are looking for is missing.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "error_titles_ARRAY_AG08");
UPDATE `multi_lang` SET `content` = 'List not found!' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAddToGroup");
UPDATE `multi_lang` SET `content` = 'Add to list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAddGroupText");
UPDATE `multi_lang` SET `content` = 'Please select list(s) below to assign selected subscribers.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAssignToGroup");
UPDATE `multi_lang` SET `content` = 'Assign to list' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "front_label_subscribe_inactive");
UPDATE `multi_lang` SET `content` = 'The form could not be loaded because the list you subscribe to is not active.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "infoSubscritionForm2Title");
UPDATE `multi_lang` SET `content` = 'Please set the status of this list to be active if you want to see the installation code and subscription form.' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblRemoveFromCurrentGroup");
UPDATE `multi_lang` SET `content` = 'Remove from current list(s)' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;