/*Export of the extension role.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1209142268NMKA','1304525968YBL','1206732392OZVB','1206732392OZVG','1206961869IGND','1213695731KPWL','1398436917DTKC','1206732412DAEM','1326997214IWXZ','1213093111HQEY','1213093111HQEZ','1213695731KPWK','1298294100SWQR','1298294100SWQQ','1426609837MIDF','1206732361LXFD','1206732361LXFE','1206732372QTKL','1242282449PIPC','1206732399EINB','1206732393CXVV','1206732399EINF','1206732391QBUR','1228820287MBVC','1206732392OZUP','1206732400OWXG','1206732392OZVA','1206961869IGNE','1327092562CAGM','1206732411EGRU','1206732411EGRV','1206961854HENX','1298350340NHYH','1248858840SJVU','1248956147DPFH','1248858840SJVT','1254807071CUTF','1298350340NHYI','1206961882TDHA','1206732348RCNT','1206732400OWZO','1206732411EGRI','1206732411EGSE','1206961912MJPB','1206961998KTYJ','1211280059QYRD','1211280059QYRF','1211280059QYRJ','1211280059QYRL','1211280059QYRN','1211280059QYRQ','1212510541LVCO','1212510541LVCP','1212510541LVCQ','1212510541LVCU','1212510541LVCV','1213093169PGHQ','1221228435BYUA','1236926015ATTV','1236926015ATTW','1240888717QTMV','1242282450QJCU','1298350313CJWK','1298350313CJWL','1298350313CJWM','1298350313CJWN','1298350313CJWO','1298350804GFLD','1298520787FNQP','1298520787FNQQ','1298958645SVBO','1298958645SVBP','1298958645SVBQ','1298958645SVBR','1298958645SVBS','1298958645SVBT','1298958645SVBU','1298958645SVBV','1298958645SVBW','1298958645SVBX','1298958645SVBY','1298958645SVBZ','1298958645SVCA','1298958645SVCB','1298958645SVCC','1298958645SVCD','1298958645SVCE','1298958645SVCF','1298958645SVCG','1298958645SVCH','1298958645SVCI','1298958645SVCJ','1298958645SVCK','1298958645SVCL','1298958645SVCM','1298958645SVCN','1298958645SVCO','1298958645SVCP','1298958645SVCQ','1300366052PZRW','1300366053JXYR','1300773988BYXD','1300773989BZML','1358040638TETP','1358040638TETQ','1358040638TETR','1358040638TETS','1360107595TFTR','1360107595TFTS','1360925653IBLI','1360925653IBLJ','1360925653IBLK','1360925653IBLL','1360925653IBLM','1360925653IBLN','1373207700DBFX','1373207700DBFY','1373207701KOTA','1373207701KOTB','1410185242NOSI','1410185242NOSJ' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('role.node','role.trans','role.members') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('role.trans','role.node','role.members','members.node','joobi.languages','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('232uid','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','232html','232registered','199name','199main','199publish','199real','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','232login','199rtl','566rolid','566parent','566lft','566rgt','566core','568rolid','568lgid','568name','568description','566joomla','481wname','481wdescription','566namekey','232rolid','566color','566type','199availadmin','199availsite','618sid','618lgid','618name','199locale','566depth','199localeconv','visibility232','702uid','702rolid','714ctrid','714lgid','name714','description714','description485','auto568','fromlgid568','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto618','fromlgid618','auto714','fromlgid714','curid232','j16566','ip232','ctyid232','core199','mobile232','filid232','automatic199','message485') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__dataset_foreign`.* FROM `#__dataset_columns` LEFT JOIN `#__dataset_foreign` ON `#__dataset_foreign`.`feid` = `#__dataset_columns`.`dbcid` WHERE `#__dataset_columns`.`namekey` IN ('566parent','568rolid','568lgid','702uid','702rolid') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_parent_child_rolid','FK_role_trans_lgid','FK_role_trans_rolid','FK_role_members_rolid','FK_role_members_uid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('role.node') ;
SET @rolid_0 = (1);
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_568 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1 );
SET @pk_549_702 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('role_trans','role.trans',@pk_549_568,'','1.0.0',@rolid_0,'0','20','rolid,lgid','trans','role','51','2','0','0','7'),('role_members','role.members',@pk_549_702,'','',@rolid_0,'0','30','uid,rolid','members','role','51','2','0','0','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1);
SET @pk_454_43800 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_role_node_namekey' LIMIT 1 );
SET @pk_454_65468 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_roletrans_rolid_lgid' LIMIT 1 );
SET @pk_454_65622 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_members' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_43800,'1','UK_role_node_namekey',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65468,'3','PK_roletrans_rolid_lgid',@dbtid_2),(@pk_454_65622,'3','PK_role_members',@dbtid_3);
SET @pk_616_5537 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1 );
SET @pk_616_5538 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1 );
SET @pk_616_5587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566namekey' LIMIT 1 );
SET @pk_616_6705 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702uid' LIMIT 1 );
SET @pk_616_6706 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702rolid' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_5533 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566parent' LIMIT 1 );
SET @pk_616_5534 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566lft' LIMIT 1 );
SET @pk_616_5535 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rgt' LIMIT 1 );
SET @pk_616_5536 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566core' LIMIT 1 );
SET @pk_616_5539 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568name' LIMIT 1 );
SET @pk_616_5540 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568description' LIMIT 1 );
SET @pk_616_5577 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566joomla' LIMIT 1 );
SET @pk_616_5621 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566color' LIMIT 1 );
SET @pk_616_5668 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566type' LIMIT 1 );
SET @pk_616_6124 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566depth' LIMIT 1 );
SET @pk_616_6802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto568' LIMIT 1 );
SET @pk_616_6803 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid568' LIMIT 1 );
SET @pk_616_8447 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='j16566' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_3412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482name' LIMIT 1 );
SET @pk_616_3413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482description' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_5537,@dbtid_2,'rolid','1','0','2','1','1','','50','1',@rolid_0,'0','0','1','568rolid','1','0','0');
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_5538,@dbtid_2,'lgid','1','0','1','1','1','','50','1',@rolid_0,'0','0','1','568lgid','1','0','0'),(@pk_616_5587,@dbtid_1,'namekey','0','1','14','0','1','','2','1',@rolid_0,'0','50','1','566namekey','1','0','0'),(@pk_616_6705,@dbtid_3,'uid','1','0','4','1','1','','1','0','0','0','0','1','702uid','1','0','0'),(@pk_616_6706,@dbtid_3,'rolid','1','0','4','1','1','','2','0','0','0','0','1','702rolid','1','0','0'),(@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_1698,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_5532,@dbtid_1,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_5533,@dbtid_1,'parent','0','0','2','1','1','0','3','1',@rolid_0,'0','0','1','566parent','1','0','0'),(@pk_616_5534,@dbtid_1,'lft','0','0','2','1','1','0','4','1',@rolid_0,'0','0','1','566lft','1','0','0'),(@pk_616_5535,@dbtid_1,'rgt','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','566rgt','1','0','0'),(@pk_616_5536,@dbtid_1,'core','0','0','1','1','1','0','6','1',@rolid_0,'0','0','1','566core','1','0','0'),(@pk_616_5539,@dbtid_2,'name','0','0','14','0','1','','50','1',@rolid_0,'0','200','1','568name','1','0','0'),(@pk_616_5540,@dbtid_2,'description','0','0','16','0','1','','50','1',@rolid_0,'0','0','1','568description','1','0','0'),(@pk_616_5577,@dbtid_1,'joomla','0','0','2','1','1','0','7','1',@rolid_0,'0','0','1','566joomla','1','0','0'),(@pk_616_5621,@dbtid_1,'color','0','1','14','0','1','black','8','1',@rolid_0,'0','20','1','566color','1','0','0'),(@pk_616_5668,@dbtid_1,'type','0','0','1','1','1','1','9','1',@rolid_0,'0','0','1','566type','1','0','0'),(@pk_616_6124,@dbtid_1,'depth','0','0','2','1','1','0','10','1',@rolid_0,'0','0','1','566depth','1','0','0'),(@pk_616_6802,@dbtid_2,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto568','1','0','0'),(@pk_616_6803,@dbtid_2,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid568','1','0','0'),(@pk_616_8447,@dbtid_1,'j16','0','0','4','1','1','1','11','0','0','0','0','1','j16566','1','0','0'),(@pk_616_6039,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','618name','1','0','0'),(@pk_616_3412,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3419,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_6797,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_10823,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'message','0','1','16','0','1','','5','0','0','0','0','1','message485','1','0','0'),(@pk_616_3416,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3507,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3408,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0');
SET @pk_5_320 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='role.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='role',`wid`=@pk_5_320,`params`='',`status`='1',`type`='150',`name`='Role',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='role.node',`version`='4699',`lversion`='4699',`pref`='0',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='role.node';
INSERT IGNORE INTO `#__extension_node` (`publish`,`folder`,`wid`,`params`,`status`,`type`,`name`,`destination`,`parent`,`trans`,`certify`,`namekey`,`version`,`lversion`,`pref`,`install`,`core`,`showconfig`,`framework`) VALUES ('1','role',@pk_5_320,'','1','150','Role','node','0','1','0','role.node','4699','4699','0','','1','1','0');

SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_568 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='roletrans' LIMIT 1 );
SET @pk_621_569 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.members' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_1016 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.role' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_1,`path`='1',`namekey`='role',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='prtname=roletrans\ncachedata=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_566,@dbtid_1,'1','role','role',@rolid_0,'0','1','0','0','prtname=roletrans\ncachedata=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_568,`dbtid`=@dbtid_2,`path`='0',`namekey`='roletrans',`folder`='roletrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=role',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='roletrans';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_568,@dbtid_2,'0','roletrans','roletrans',@rolid_0,'0','1','0','0','\nmainmodel=role','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_569,`dbtid`=@dbtid_3,`path`='0',`namekey`='role.members',`folder`='role.members',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role.members';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_569,@dbtid_3,'0','role.members','role.members',@rolid_0,'0','1','0','0','autofld=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='users';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1015,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1016,`dbtid`=@dbtid_3,`path`='0',`namekey`='users.role',`folder`='users.role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='users.role';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1016,@dbtid_3,'0','users.role','users.role',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-trophy','');

SET @wid_4 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='role.node' LIMIT 1);
SET @sid_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1);
SET @sid_6 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @rolid_7 = (7);
SET @yid_8 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='acl_role_form' LIMIT 1);
SET @sid_9 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='roletrans' LIMIT 1);
SET @yid_10 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='role_listing' LIMIT 1);
SET @yid_11 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='role_users' LIMIT 1);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='role_acl_roles_dashbrd' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='role_listing_roletrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('role_listing_roletrans_namekey') LIMIT 1;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('The access to this page is restricted.','1','1206732348RCNT');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD'),('Edit','1','1206732361LXFE'),('Delete','1','1206732372QTKL'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('Author','1','1206732400OWZO'),('Lock','1','1206732411EGRI'),('Email','1','1206732411EGRU'),('Username','1','1206732411EGRV'),('Registered','1','1206732411EGSE'),('Parent','1','1206732412DAEM'),('Roles','1','1206961854HENX'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Back','1','1206961882TDHA'),('Customer','1','1206961912MJPB'),('Administrator','1','1206961998KTYJ'),('Role','1','1209142268NMKA'),('All Users','1','1211280059QYRD'),('Visitor','1','1211280059QYRF'),('Editor','1','1211280059QYRJ'),('Publisher','1','1211280059QYRL'),('Manager','1','1211280059QYRN'),('Super Administrator','1','1211280059QYRQ'),('This is the default role any visitor has.','1','1212510541LVCO'),('Any user allowed to log in on the front-end of the website.','1','1212510541LVCP'),('This role allows the user to create and modify articles.','1','1212510541LVCQ'),('This role allows the administration of menus, articles and applications.','1','1212510541LVCU'),('This role allows access to all functions on the website, including configuration and maintenance.','1','1212510541LVCV'),('Name of the Role','1','1213093111HQEY'),('Description of the role','1','1213093111HQEZ'),('This role allows the user to log in on the back-end of the website. Managers can edit any menu or article.','1','1213093169PGHQ'),('The position of the role in the roles tree compare to the parent/child element.<br>If <span style=\"font-weight: bold;\">parallel</span> the new role will be put <span style=\"font-weight: bold;\">in parallel to the children</span> roles of the chosen parent.<br>If <span style=\"font-weight: bold;\">nested</span> the <span style=\"font-weight: bold;\">current children</span> of the chosen parent will be put <span style=\"font-weight: bold;\">as children of the new role</span>.<br>','1','1213695731KPWK'),('Position','1','1213695731KPWL'),('Vendor','1','1221228435BYUA'),('Close','1','1228820287MBVC'),('Subscribe to read!','1','1236926015ATTV'),('Restricted Article','1','1236926015ATTW'),('Affiliate','1','1240888717QTMV'),('Done','1','1242282449PIPC'),('No User','1','1242282450QJCU'),('This view list all roles or ACL used in the site. Here the admin can add new roles and edit existing once.<br><br><span style=\"font-style: italic; color: rgb(204, 0, 0);\">Note: </span><span style=\"color: rgb(204, 0, 0);\"><span style=\"font-style: italic;\">You cannot delete roles that are core.</span></span><br>','1','1248858840SJVT'),('Roles & ACL Management','1','1248858840SJVU'),('Roles or ACL','1','1248956147DPFH'),('Nested Role: This role is higher than the parent role which means that the parent role can\'t access the said role. However, higher level roles can access it.<br><br>Parallel Role: This role is equal to the parent role. It can access to lower level roles of the parent role but it can\'t access the parent role, same as the parent role can\'t access to the created role since they are equal. Higher level roles can\'t access the said role also.<br>','1','1254807071CUTF'),('Choose a parent for this role. The parent define was role will be inherited.','1','1298294100SWQQ'),('Specify a unique ID for this role.<br>','1','1298294100SWQR'),('This role allows the user to edit articles.','1','1298350313CJWK'),('This role allows the user to publish articles.','1','1298350313CJWL'),('Any one who purchase a product in the store.','1','1298350313CJWM'),('Manufacturer or any organization that provides goods and services.','1','1298350313CJWN'),('Supplier','1','1298350313CJWO'),('Users for','1','1298350340NHYH'),('List of Users for a specified role','1','1298350340NHYI'),('Store Manager','1','1298350804GFLD'),('This role allows the user to be a vendor.','1','1298520787FNQP'),('This role allows to manage the store.','1','1298520787FNQQ'),('This role allows the user to publish mails.','1','1298958645SVBO'),('This role allows the user to edit mails.','1','1298958645SVBP'),('Any person who register to be an affiliate.','1','1298958645SVBQ'),('Any person who has signed up to be a reseller.','1','1298958645SVBR'),('Agent responsible to communicate with the customers.','1','1298958645SVBS'),('Agents\' manager. This role enables to create agent, and define their project and access rights.','1','1298958645SVBT'),('This role allows the user to create mails.','1','1298958645SVBU'),('Group moderator is allowed to moderate any group she is assigned to.','1','1298958645SVBV'),('Any person allowed to moderate the forum.','1','1298958645SVBW'),('Creator of a group, can administrate the group.','1','1298958645SVBX'),('Can moderate any group part of the community.','1','1298958645SVBY'),('Administrate the community. This role is required to install and setup the community.','1','1298958645SVBZ'),('This role allows to create article, blog, or wiki pages.','1','1298958645SVCA'),('This role allows to edit article, blog, or wiki pages.','1','1298958645SVCB'),('This role allows to publish article, blog, or wiki pages.','1','1298958645SVCC'),('Mail Publisher','1','1298958645SVCD'),('Mail Editor','1','1298958645SVCE'),('Reseller','1','1298958645SVCF'),('Support Agent','1','1298958645SVCG'),('Support Manager','1','1298958645SVCH'),('Mail Author','1','1298958645SVCI'),('Group Moderator','1','1298958645SVCJ'),('Moderator','1','1298958645SVCK'),('Group Manager','1','1298958645SVCL'),('Community Moderator','1','1298958645SVCM'),('Community Manager','1','1298958645SVCN'),('Article Author','1','1298958645SVCO'),('Article Editor','1','1298958645SVCP'),('Article Publisher','1','1298958645SVCQ'),('With this role user can manager the mail application and preferences','1','1300366052PZRW'),('Mail Manager','1','1300366053JXYR'),('Allow to manage the list of members.','1','1300773988BYXD'),('List Manager','1','1300773989BZML'),('','1','1304525968YBL'),('CMS Equivalent','1','1326997214IWXZ'),('View Users','1','1327092562CAGM'),('This role allows to access all information about contacts and organization.','1','1358040638TETP');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('This role allows to manager all sales agents. Provide access to all information and access to specific settings for contacts and organization.','1','1358040638TETQ'),('Sales Agent','1','1358040638TETR'),('Sales Manager','1','1358040638TETS'),('This role allows to access customer profile and organization profile.','1','1360107595TFTR'),('Sales Support','1','1360107595TFTS'),('Direct and inspire all developers\' managers.','1','1360925653IBLI'),('Any one who develop and customize Apps.','1','1360925653IBLJ'),('The manager of the developers. Has access to create new apps and invite developers.','1','1360925653IBLK'),('Architect','1','1360925653IBLL'),('Developer','1','1360925653IBLM'),('Developer Manager','1','1360925653IBLN'),('Anyone who can be added on a project to create and execute tasks.','1','1373207700DBFX'),('Project manager are able to create and manage projects. They can recruit project members to be part of their project.','1','1373207700DBFY'),('Team Member','1','1373207701KOTA'),('Project Manager','1','1373207701KOTB'),('Identifier','1','1398436917DTKC'),('Person who define general preferences and different project types.','1','1410185242NOSI'),('Project Administrator','1','1410185242NOSJ'),('Define what is the equivalent role in the CMS.','1','1426609837MIDF');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_roletrans_rolid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_roletrans_rolid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_role_node_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_members' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702uid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_members' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702rolid' LIMIT 1));
SET @pk_77_10566 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'role.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'566parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10359 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'568rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10360 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.languages\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'568lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10691 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'702uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10692 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'702rolid\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('parent','1','FK_parent_child_rolid',@pk_77_10566,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','rolid',@dbtid_1,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),'99');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('rolid','1','FK_role_trans_rolid',@pk_77_10359,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'3','3','rolid',@dbtid_1,@dbtid_2,'99'),('lgid','1','FK_role_trans_lgid',@pk_77_10360,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_2,'99'),('uid','1','FK_role_members_uid',@pk_77_10691,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702uid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'3','3','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),@dbtid_3,'1'),('rolid','1','FK_role_members_rolid',@pk_77_10692,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'3','3','rolid',@dbtid_1,@dbtid_3,'2');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_4,'0','1206732348RCNT');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_4,'1','1206732400OWZO'),(@wid_4,'1','1206732411EGRI'),(@wid_4,'1','1206732411EGSE'),(@wid_4,'1','1206961912MJPB'),(@wid_4,'1','1206961998KTYJ'),(@wid_4,'1','1211280059QYRD'),(@wid_4,'1','1211280059QYRF'),(@wid_4,'1','1211280059QYRJ'),(@wid_4,'1','1211280059QYRL'),(@wid_4,'1','1211280059QYRN'),(@wid_4,'1','1211280059QYRQ'),(@wid_4,'1','1212510541LVCO'),(@wid_4,'1','1212510541LVCP'),(@wid_4,'1','1212510541LVCQ'),(@wid_4,'1','1212510541LVCU'),(@wid_4,'1','1212510541LVCV'),(@wid_4,'1','1213093169PGHQ'),(@wid_4,'1','1221228435BYUA'),(@wid_4,'1','1236926015ATTV'),(@wid_4,'1','1236926015ATTW'),(@wid_4,'1','1240888717QTMV'),(@wid_4,'1','1242282450QJCU'),(@wid_4,'1','1298350313CJWK'),(@wid_4,'1','1298350313CJWL'),(@wid_4,'1','1298350313CJWM'),(@wid_4,'1','1298350313CJWN'),(@wid_4,'1','1298350313CJWO'),(@wid_4,'1','1298350804GFLD'),(@wid_4,'1','1298520787FNQP'),(@wid_4,'1','1298520787FNQQ'),(@wid_4,'1','1298958645SVBO'),(@wid_4,'1','1298958645SVBP'),(@wid_4,'1','1298958645SVBQ'),(@wid_4,'1','1298958645SVBR'),(@wid_4,'1','1298958645SVBS'),(@wid_4,'1','1298958645SVBT'),(@wid_4,'1','1298958645SVBU'),(@wid_4,'1','1298958645SVBV'),(@wid_4,'1','1298958645SVBW'),(@wid_4,'1','1298958645SVBX'),(@wid_4,'1','1298958645SVBY'),(@wid_4,'1','1298958645SVBZ'),(@wid_4,'1','1298958645SVCA'),(@wid_4,'1','1298958645SVCB'),(@wid_4,'1','1298958645SVCC'),(@wid_4,'1','1298958645SVCD'),(@wid_4,'1','1298958645SVCE'),(@wid_4,'1','1298958645SVCF'),(@wid_4,'1','1298958645SVCG'),(@wid_4,'1','1298958645SVCH'),(@wid_4,'1','1298958645SVCI'),(@wid_4,'1','1298958645SVCJ'),(@wid_4,'1','1298958645SVCK'),(@wid_4,'1','1298958645SVCL'),(@wid_4,'1','1298958645SVCM'),(@wid_4,'1','1298958645SVCN'),(@wid_4,'1','1298958645SVCO'),(@wid_4,'1','1298958645SVCP'),(@wid_4,'1','1298958645SVCQ'),(@wid_4,'1','1300366052PZRW'),(@wid_4,'1','1300366053JXYR'),(@wid_4,'1','1300773988BYXD'),(@wid_4,'1','1300773989BZML'),(@wid_4,'1','1358040638TETP'),(@wid_4,'1','1358040638TETQ'),(@wid_4,'1','1358040638TETR'),(@wid_4,'1','1358040638TETS'),(@wid_4,'1','1360107595TFTR'),(@wid_4,'1','1360107595TFTS'),(@wid_4,'1','1360925653IBLI'),(@wid_4,'1','1360925653IBLJ'),(@wid_4,'1','1360925653IBLK'),(@wid_4,'1','1360925653IBLL'),(@wid_4,'1','1360925653IBLM'),(@wid_4,'1','1360925653IBLN'),(@wid_4,'1','1373207700DBFX'),(@wid_4,'1','1373207700DBFY'),(@wid_4,'1','1373207701KOTA'),(@wid_4,'1','1373207701KOTB'),(@wid_4,'1','1410185242NOSI'),(@wid_4,'1','1410185242NOSJ');
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_4,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_4,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568name' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1),'1209142268NMKA',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='roletrans' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.members' LIMIT 1),'1209142268NMKA',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1));