/*Export of the extension users.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1298350334ECWR','1229653442FEQZ','1298350400ESTE','1299729469KOHO','1206732411EGRV','1206732412DADP','1206732413BNND','1206732408DEIM','1206732413BNNC','1206732411EGQX','1298350446IEXM','1206732412DABR','1206732412DABZ','1206732412DAEO','1206732411EGRU','1206732412DACF','1206732405TIXE','1206732412DACJ','1206732400OWXG','1298350446IEXR','1206732392OZVB','1352316765KOLP','1242282412EESC','1330732086QQWK','1330732086QQWL','1206961922ESOY','1206961922ESOZ','1330731950JWCH','1206961922ESPA','1206732412DAEA','1335905452QHTH','1389276419BAQT','1382364838SGIL','1242178310INQN','1206961948HYTE','1401195621GJAG','1242282445BFLI','1406858734GTFT','1401307164QWBQ','1401307164QWBR','1401307164QWBS','1401307164QWBT','1389052188SONB','1206732392OZVE','1401307164QWBU','1401307164QWBV','1401721045QFQW','1206732400OXBG','1401307164QWBX','1401307164QWBY','1401465959YVM','1401465959YVN','1206732400OWZR','1401465959YVP','1401465959YVQ','1246541676GWQN','1401465959YVR','1401465959YVS','1401465959YVT','1394069593IQAS','1394069593IQAT','1206961870KLBH','1206732411EGRX','1401721045QFQX','1228709252AHXW','1349726540AIFR','1338338160QKOG','1206961997BSZV','1206961997BSZT','1298350878GWBR','1298350878GWBS','1350063002LIBK','1241675239ROHF','1350063006GDSH','1401908087BVRZ','1206961869IGND','1402327862IRBJ','1402327862IRBK','1406645170POVD','1406858734GTFU','1406858734GTFV','1406858734GTFW','1409189814MIGS','1410384293KGZU','1206961998KTYL','1417651524CODW','1417651524CODX','1419461935EXSJ','1206732412DABT','1206732412DABV','1206732412DABX','1304525968YBL','1269573870RCTQ','1208867895OVVA','1298350451QKHN','1298294093RWKN','1411145556CLAN','1352316767OMER','1352316767OMEV','1411145556CLAQ','1411145556CLAP','1411145556CLAW','1411145556CLAY','1251948773GQVX','1379525397DLDC','1389052396IWCC','1352316767OMEU','1427292714DFWB','1352316767OMET','1401195621GJAI','1401195621GJAH','1402327862IRBL','1401307164QWCB','1401307164QWCC','1401307164QWCD','1401307164QWCE','1401307164QWCF','1401307164QWCG','1401307164QWCH','1401307164QWCI','1417629901BWSE','1401307164QWCK','1401465959YVV','1401465959YVW','1401465960RGMK','1401465960RGML','1401465960RGMM','1401307164QWCJ','1401465960RGMN','1401465960RGMO','1401465960RGMP','1401721045QFQY','1401721045QFQZ','1338338166DFZK','1298350881GXHD','1298350881GXHC','1206961997BSZX','1418159422PCRS','1298350884SAII','1350003787BNEL','1349824736IPWN','1417651524CODY','1401307164QWCA','1402327862IRBM','1417651524CODZ','1401465959YVU','1406858734GTFY','1406858734GTFZ','1410384294EKCN','1401908087BVSA','1406645171LJLM','1406858734GTFX','1419461936BSHK','1433954805HOYU','1433954805HOYV','1433954805HOYW','1206732411EGRI','1401377882ETOG','1206732399EINF','1206732361LXFD','1206732361LXFE','1206732372QTKL','1206961882TDHA','1310522876DTCC','1307975933EESV','1228820287MBVC','1206732391QBUR','1206732392OZUP','1206732399EINB','1242282449PIPC','1206732393CXVV','1206732431CQBG','1206732411EGRP','1206732411EGRQ','1206961902CIFC','1298357874SMVP','1251253308LVCT','1246518490RFLH','1210091183EQHU','1206964235BPWJ','1376965924DOOS','1218029673NSUZ','1389275714NKEJ','1375216514MLLF','1246518662OHAB','1206732412DAEJ','1206732413BNMX','1206961997BSZK','1307002587NUOA','1395718272MFDG','1395718272MFDK','1395718272MFDI','1395718272MFDF','1407183443BJQU','1395718271OGDN','1206732392OZVA','1241675187IFAK','1206732411EGSE','1298350400ESTF','1298294092CJJG','1306382540KOEE','1206732392OZVG','1206961869IGNE','1298294095NUCM','1209142268NMKA','1230531895KYXK','1206961899DDKO','1392297641IKCB','1206732411EGQZ','1208359284QWNS','1298350401HIBI','1379376150SNGZ','1380567654HBVC','1401473376KUOI','1401307164QWCM','1401473376KUOJ','1401721045QFRA','1409189814MIGT','1409189814MIGU','1410373235PUIM','1248858840SJVU','1248858840SJVT','1206732410ICCJ','1401307164QWBL','1401307164QWBM','1257243220BKUD','1401307164QWBN','1401307164QWBO','1401307164QWBP','1401465959YVL','1406858734GTFR','1406858734GTFS','1298350401HIBK','1401465960RGMQ','1298350401HIBL','1242282449PIPL','1401465960RGMR','1298350401HIBM','1298350401HIBN','1298350401HIBP','1298350401HIBQ','1298350401HIBR','1298350401HIBS','1298350401HIBT','1298350401HIBU','1298350401HIBV','1401195622JBQM','1298350401HIBX','1338516605INFR','1338516605INFS','1338516605INFT','1401195622JBQN','1380048183BXIY','1410373235PUIN','1401855800NDHG','1401855800NDHH','1401855800NDHI','1401465960RGMS','1401855800NDHJ','1410373235PUIO','1401908088KSZQ','1410373235PUIP','1401908088KSZR','1401908088KSZS','1410373235PUIQ','1401855800NDHK','1401855800NDHL','1401855800NDHM','1401465960RGMV','1401855800NDHN','1401908088KSZT','1219856743ELFT','1407807688RGBP','1411021264NDMH','1407877167CEQY','1407807688RGBR','1404175053SXGE','1404175053SXGF','1407807688RGBS','1410373235PUIS','1206732372QTKI','1206732372QTKJ','1206732410ICCI','1206961899DDKP','1212843293BKVD','1298350399EIUD','1299148902FYMY','1331164428MGHN','1338404831MNYL','1377734782BTNQ','1377828382KXRU','1401195620IMUD','1401465958GTFC','1401465958GTFD','1401465958GTFE','1401465958GTFF','1401465958GTFG','1401465958GTFH','1401465958GTFI','1401465958GTFJ','1401465958GTFK','1401465958GTFL','1401465958GTFM','1401465958GTFN','1401465958GTFO','1401465958GTFP','1401465958GTFQ','1401818484FRIA','1401855798FZFQ','1401855798FZFR','1401855798FZFS','1401908086NTVF','1401908086NTVG','1401908086NTVH','1401908086NTVI','1401908086NTVJ','1401908086NTVK','1402327858JCQW','1402327860NWWL','1402327860NWWM','1406645169SRMK','1407807686JAZD','1407807686JAZE','1408041590EIQX','1410373233CVZL','1410373233CVZM','1410373233CVZN','1410384292GWRX','1414741764AKJF','1415722221IUIO','1424728189PIMT','1426609899QDEC','1433381333KDQJ' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','members.lang','role.members','members.details') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','members.lang','role.members','members.details','joobi.files','joobi.languages','joobi.countries','role.node','currency.node','organization.node','users','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','dropset.valuestrans','eguillage.trans','mailing.trans') AND `#__dataset_columns`.`namekey` NOT IN ('232uid','478filid','478modified','478name','478params','478path','478size','478type','264uid','264lgid','199lgid','199code','199premium','200ctyid','200isocod2','200isocod3','200name','200namekey','200numcode','251id','251name','251username','251email','251password','251usertype','251block','251sendemail','251gid','251registerdate','251lastvisitdate','251activation','251params','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','478secure','478uid','382mgid','382lgid','382name','382ctext','382chtml','382smail','382sname','232html','232registered','199name','199main','199publish','199real','478thumbnail','478theight','478twidth','478width','478height','264ordering','478approved','478modifiedby','232unsub','478mime','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','382rname','382remail','232login','199rtl','541vid','541name','541lgid','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','566type','199availadmin','199availsite','618sid','618lgid','618name','199locale','624curid','624title','624code','624number','624symbol','624position','624cents','624basic','624publish','624rate','566depth','199localeconv','visibility232','accepted624','ordering624','702uid','702rolid','714ctrid','714lgid','name714','description714','description485','auto382','fromlgid382','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto618','fromlgid618','auto714','fromlgid714','timezone200','curid232','publish200','md5478','j16566','bouncemail382','authorid382','modified382','intro382','core200','alias478','vendid478','ordering200','modified200','core478','storage478','folder478','ip232','ctyid232','1004vendid','organization1004','phone1004','fax1004','tweeter1004','facebook1004','industry1004','ownership1004','rating1004','annual_revenue1004','description1004','modified1004','modifiedby1004','created1004','1009uid','field_first_name1009','middle_name1009','last_name1009','suffix1009','title1009','department1009','vendid1009','description1009','skypeid1009','facebook1009','twitter1009','linkedin1009','core199','core624','phone1009','fax1009','signature1009','smsmessage382','mobile232','filid232','automatic199','title382','subtitle382','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 ('264uid','264lgid','232lgid','232rolid','702uid','702rolid','curid232','ctyid232','1009uid','vendid1009','filid232') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_members_details_uid','FK_members_node_lgid','FK_members_rolid','FK_members_lang_lgid','FK_members_lang_uid','FK_role_members_rolid','FK_role_members_uid','FK_members_ctyid','FK_members_curid','FK_members_node_filid','FK_members_details_vendid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('users.node') ;
SET @rolid_0 = (1);
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_264 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.lang' LIMIT 1 );
SET @pk_549_702 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1 );
SET @pk_549_1009 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.details' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_200 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_624 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1 );
SET @pk_549_1004 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='organization.node' LIMIT 1 );
SET @pk_549_251 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='users' 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_1014 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1 );
SET @pk_549_882 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' 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_568 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_541 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
SET @pk_549_382 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','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 ('members_lang','members.lang',@pk_549_264,'','1.0.0',@rolid_0,'0','30','uid,lgid','lang','members','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'),('members_details','members.details',@pk_549_1009,'','',@rolid_0,'0','10','uid','','','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'),('joobi_countries','joobi.countries',@pk_549_200,'','1.0.0',@rolid_0,'0','1','ctyid','countries','joobi','51','2','0','0','7'),('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('currency_node','currency.node',@pk_549_624,'','1.0.0',@rolid_0,'0','1','curid','node','currency','51','2','0','0','7'),('organization_node','organization.node',@pk_549_1004,'','',@rolid_0,'0','10','vendid','','','51','2','0','0','7'),('users','users',@pk_549_251,'','1.0.0',@rolid_0,'0','1','id','','users','250','2','0','1','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'),('widgets_node','widgets.node',@pk_549_1014,'','',@rolid_0,'0','1','widgetid','','','51','2','0','0','7'),('joobi_states','joobi.states',@pk_549_882,'','',@rolid_0,'0','1','stateid','states','joobi','51','2','0','0','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'),('role_trans','role.trans',@pk_549_568,'','1.0.0',@rolid_0,'0','20','rolid,lgid','trans','role','51','2','0','0','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('dropset_valuestrans','dropset.valuestrans',@pk_549_541,'','1.0.0',@rolid_0,'0','20','vid,lgid','valuestrans','dropset','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'),('mailing_trans','mailing.trans',@pk_549_382,'','1.0.0',@rolid_0,'0','20','mgid,lgid','trans','mailing','51','0','0','0','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.lang' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.details' LIMIT 1);
SET @pk_454_134 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_email' LIMIT 1 );
SET @pk_454_1117 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_members_node_name' LIMIT 1 );
SET @pk_454_65398 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_language_uid_lgid' LIMIT 1 );
SET @pk_454_65594 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_username' LIMIT 1 );
SET @pk_454_65622 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_members' LIMIT 1 );
SET @pk_454_65710 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_node' LIMIT 1 );
SET @pk_454_65990 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_members_details|main_userdata' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_134,'1','UK_members_node_email',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_1117,'2','IX_members_node_name',@dbtid_1),(@pk_454_65398,'3','PK_members_language_uid_lgid',@dbtid_2),(@pk_454_65594,'1','UK_members_node_username',@dbtid_1),(@pk_454_65622,'3','PK_role_members',@dbtid_3),(@pk_454_65710,'3','PK_members_node',@dbtid_1),(@pk_454_65990,'3','PK_jos_members_details|main_userdata',@dbtid_4);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='users' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1);
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1651 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264uid' LIMIT 1 );
SET @pk_616_1652 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264lgid' LIMIT 1 );
SET @pk_616_1949 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232name' LIMIT 1 );
SET @pk_616_1950 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232username' LIMIT 1 );
SET @pk_616_1952 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232email' 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_9303 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1009uid' LIMIT 1 );
SET @pk_616_1583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_1929 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_6095 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='624curid' LIMIT 1 );
SET @pk_616_9223 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1004vendid' LIMIT 1 );
SET @pk_616_1971 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232lgid' LIMIT 1 );
SET @pk_616_5616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1 );
SET @pk_616_7404 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='curid232' LIMIT 1 );
SET @pk_616_8996 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctyid232' LIMIT 1 );
SET @pk_616_9310 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='vendid1009' LIMIT 1 );
SET @pk_616_10245 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid232' LIMIT 1 );
SET @pk_616_1935 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251id' LIMIT 1 );
SET @pk_616_1936 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251name' LIMIT 1 );
SET @pk_616_1937 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251username' LIMIT 1 );
SET @pk_616_1938 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251email' LIMIT 1 );
SET @pk_616_1939 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251password' LIMIT 1 );
SET @pk_616_1940 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251usertype' LIMIT 1 );
SET @pk_616_1941 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251block' LIMIT 1 );
SET @pk_616_1942 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251sendemail' LIMIT 1 );
SET @pk_616_1943 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251gid' LIMIT 1 );
SET @pk_616_1944 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251registerdate' LIMIT 1 );
SET @pk_616_1945 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251lastvisitdate' LIMIT 1 );
SET @pk_616_1946 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251activation' LIMIT 1 );
SET @pk_616_1947 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251params' LIMIT 1 );
SET @pk_616_1948 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232id' LIMIT 1 );
SET @pk_616_1951 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232openid' LIMIT 1 );
SET @pk_616_1953 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232password' LIMIT 1 );
SET @pk_616_1955 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232block' LIMIT 1 );
SET @pk_616_1957 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232activation' LIMIT 1 );
SET @pk_616_1958 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232timezone' LIMIT 1 );
SET @pk_616_1959 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232confirmed' LIMIT 1 );
SET @pk_616_1960 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232registerdate' LIMIT 1 );
SET @pk_616_1961 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232modified' LIMIT 1 );
SET @pk_616_2405 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232html' LIMIT 1 );
SET @pk_616_2483 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232registered' LIMIT 1 );
SET @pk_616_2682 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264ordering' LIMIT 1 );
SET @pk_616_3281 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232unsub' LIMIT 1 );
SET @pk_616_3557 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232login' LIMIT 1 );
SET @pk_616_6456 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='visibility232' LIMIT 1 );
SET @pk_616_8995 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ip232' LIMIT 1 );
SET @pk_616_9304 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='field_first_name1009' LIMIT 1 );
SET @pk_616_9305 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='middle_name1009' LIMIT 1 );
SET @pk_616_9306 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='last_name1009' LIMIT 1 );
SET @pk_616_9307 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='suffix1009' LIMIT 1 );
SET @pk_616_9308 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title1009' LIMIT 1 );
SET @pk_616_9309 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='department1009' LIMIT 1 );
SET @pk_616_9311 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1009' LIMIT 1 );
SET @pk_616_9312 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='skypeid1009' LIMIT 1 );
SET @pk_616_9313 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='facebook1009' LIMIT 1 );
SET @pk_616_9314 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='twitter1009' LIMIT 1 );
SET @pk_616_9315 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='linkedin1009' LIMIT 1 );
SET @pk_616_10061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='phone1009' LIMIT 1 );
SET @pk_616_10063 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fax1009' LIMIT 1 );
SET @pk_616_10100 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='signature1009' LIMIT 1 );
SET @pk_616_10123 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='mobile232' 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_3717 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541name' 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 );
SET @pk_616_2217 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1 );
SET @pk_616_2218 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1 );
SET @pk_616_2219 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1 );
SET @pk_616_8616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1 );
SET @pk_616_8617 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1 );
SET @pk_616_8618 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1 );
SET @pk_616_8678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1 );
SET @pk_616_10120 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1 );
SET @pk_616_10801 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1 );
SET @pk_616_10802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' 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_1468,@dbtid_1,'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','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_1651,@dbtid_2,'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','264uid','1','0','0'),(@pk_616_1652,@dbtid_2,'lgid','1','0','1','1','1','1','2','1',@rolid_0,'0','0','1','264lgid','1','0','0'),(@pk_616_1949,@dbtid_1,'name','0','1','14','0','1','','5','1',@rolid_0,'0','200','1','232name','1','0','0'),(@pk_616_1950,@dbtid_1,'username','0','1','14','0','1','','4','1',@rolid_0,'0','40','1','232username','1','0','0'),(@pk_616_1952,@dbtid_1,'email','0','1','14','0','1','','6','1',@rolid_0,'0','100','1','232email','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_9303,@dbtid_4,'uid','1','0','4','1','1','','1','0','0','1','0','1','1009uid','1','0','0'),(@pk_616_1583,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),'filid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','478filid','1','0','0'),(@pk_616_1698,@dbtid_5,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_1929,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),'ctyid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','200ctyid','1','0','0'),(@pk_616_5532,@dbtid_6,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_6095,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1),'curid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','624curid','1','0','0'),(@pk_616_9223,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='organization.node' LIMIT 1),'vendid','1','0','4','1','1','','1','0','0','1','0','0','1004vendid','1','0','0'),(@pk_616_1971,@dbtid_1,'lgid','0','0','1','1','1','1','2','1',@rolid_0,'0','0','1','232lgid','1','0','0'),(@pk_616_5616,@dbtid_1,'rolid','0','0','2','1','1','1','18','1',@rolid_0,'0','0','1','232rolid','1','0','0'),(@pk_616_7404,@dbtid_1,'curid','0','1','2','1','1','0','21','0','0','0','0','1','curid232','1','0','0'),(@pk_616_8996,@dbtid_1,'ctyid','0','1','2','1','1','0','23','0','0','0','0','1','ctyid232','1','0','0'),(@pk_616_9310,@dbtid_4,'vendid','0','1','4','1','1','0','8','0','0','0','0','0','vendid1009','1','0','0'),(@pk_616_10245,@dbtid_1,'filid','0','1','4','1','1','0','25','0','0','0','0','1','filid232','1','0','0'),(@pk_616_1935,@dbtid_7,'id','1','0','4','0','1','','0','1',@rolid_0,'1','11','1','251id','1','0','0'),(@pk_616_1936,@dbtid_7,'name','0','0','14','0','1','','0','1',@rolid_0,'0','11','1','251name','1','0','0'),(@pk_616_1937,@dbtid_7,'username','0','0','14','0','1','','0','1',@rolid_0,'0','150','1','251username','1','0','0'),(@pk_616_1938,@dbtid_7,'email','0','0','14','0','1','','0','1',@rolid_0,'0','100','1','251email','1','0','0'),(@pk_616_1939,@dbtid_7,'password','0','0','14','0','1','','0','1',@rolid_0,'0','100','1','251password','1','0','0'),(@pk_616_1940,@dbtid_7,'usertype','0','0','14','0','1','','0','1',@rolid_0,'0','75','1','251usertype','1','0','0'),(@pk_616_1941,@dbtid_7,'block','0','0','1','0','1','0','0','1',@rolid_0,'0','4','1','251block','1','0','0'),(@pk_616_1942,@dbtid_7,'sendemail','0','0','1','0','1','0','0','1',@rolid_0,'0','4','1','251sendemail','1','0','0'),(@pk_616_1943,@dbtid_7,'gid','0','0','1','0','1','1','0','1',@rolid_0,'0','3','1','251gid','1','0','0'),(@pk_616_1944,@dbtid_7,'registerdate','0','0','10','0','1','0000-00-00 00:00:00','0','1',@rolid_0,'0','3','1','251registerdate','1','0','0'),(@pk_616_1945,@dbtid_7,'lastvisitdate','0','0','10','0','1','0000-00-00 00:00:00','0','1',@rolid_0,'0','3','1','251lastvisitdate','1','0','0'),(@pk_616_1946,@dbtid_7,'activation','0','0','14','0','1','','0','1',@rolid_0,'0','100','1','251activation','1','0','0'),(@pk_616_1947,@dbtid_7,'params','0','0','16','0','1','','0','1',@rolid_0,'0','100','1','251params','1','0','0'),(@pk_616_1948,@dbtid_1,'id','0','0','4','0','1','0','3','1',@rolid_0,'0','10','1','232id','1','0','0'),(@pk_616_1951,@dbtid_1,'openid','0','1','14','0','1','','9','1',@rolid_0,'0','255','1','232openid','1','0','0'),(@pk_616_1953,@dbtid_1,'password','0','1','14','0','1','','7','1',@rolid_0,'0','200','1','232password','1','0','0'),(@pk_616_1955,@dbtid_1,'blocked','0','0','1','0','1','0','11','1',@rolid_0,'0','3','1','232block','1','0','0'),(@pk_616_1957,@dbtid_1,'activation','0','0','14','0','1','','12','1',@rolid_0,'0','32','1','232activation','1','0','0'),(@pk_616_1958,@dbtid_1,'timezone','0','0','2','0','1','999','8','1',@rolid_0,'0','0','1','232timezone','1','0','0'),(@pk_616_1959,@dbtid_1,'confirmed','0','0','1','0','1','0','10','1',@rolid_0,'0','3','1','232confirmed','1','0','0'),(@pk_616_1960,@dbtid_1,'registerdate','0','0','10','0','1','','17','1',@rolid_0,'0','0','1','232registerdate','1','0','0'),(@pk_616_1961,@dbtid_1,'modified','0','1','4','1','1','0','16','1',@rolid_0,'0','0','1','232modified','1','1','0'),(@pk_616_2405,@dbtid_1,'html','0','0','1','1','1','1','14','1',@rolid_0,'0','0','1','232html','1','0','0'),(@pk_616_2483,@dbtid_1,'registered','0','0','25','0','1','1','13','1',@rolid_0,'0','0','1','232registered','1','0','0'),(@pk_616_2682,@dbtid_2,'ordering','0','0','1','1','1','0','3','1',@rolid_0,'1','0','1','264ordering','1','0','0'),(@pk_616_3281,@dbtid_1,'unsub','0','0','25','0','1','0','15','1',@rolid_0,'0','0','1','232unsub','1','0','0'),(@pk_616_3557,@dbtid_1,'login','0','0','10','0','1','','19','1',@rolid_0,'0','0','1','232login','1','0','0'),(@pk_616_6456,@dbtid_1,'visibility','0','0','1','1','1','231','20','0','0','0','0','1','visibility232','1','0','0'),(@pk_616_8995,@dbtid_1,'ip','0','0','7','1','0','0','22','0','0','0','0','1','ip232','1','0','0'),(@pk_616_9304,@dbtid_4,'first_name','0','1','14','0','1','','3','0','0','0','100','0','field_first_name1009','1','0','0'),(@pk_616_9305,@dbtid_4,'middle_name','0','1','14','0','1','','4','0','0','0','100','0','middle_name1009','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_9306,@dbtid_4,'last_name','0','1','14','0','1','','5','0','0','0','100','0','last_name1009','1','0','0'),(@pk_616_9307,@dbtid_4,'suffix','0','1','14','0','1','','2','0','0','0','20','0','suffix1009','1','0','0'),(@pk_616_9308,@dbtid_4,'title','0','1','14','0','1','','7','0','0','0','100','0','title1009','1','0','0'),(@pk_616_9309,@dbtid_4,'department','0','1','14','0','1','','6','0','0','0','100','0','department1009','1','0','0'),(@pk_616_9311,@dbtid_4,'description','0','1','16','0','1','','11','0','0','0','0','0','description1009','1','0','0'),(@pk_616_9312,@dbtid_4,'skypeid','0','1','14','0','1','','12','0','0','0','50','0','skypeid1009','1','0','0'),(@pk_616_9313,@dbtid_4,'facebook','0','1','14','0','1','','10','0','0','0','200','0','facebook1009','1','0','0'),(@pk_616_9314,@dbtid_4,'twitter','0','1','14','0','1','','9','0','0','0','100','0','twitter1009','1','0','0'),(@pk_616_9315,@dbtid_4,'linkedin','0','1','14','0','1','','13','0','0','0','100','0','linkedin1009','1','0','0'),(@pk_616_10061,@dbtid_4,'phone','0','1','14','0','1','','15','0','0','0','255','0','phone1009','1','0','0'),(@pk_616_10063,@dbtid_4,'fax','0','1','14','0','1','','14','0','0','0','255','0','fax1009','1','0','0'),(@pk_616_10100,@dbtid_4,'signature','0','1','16','0','1','','16','0','0','0','0','0','signature1009','1','0','0'),(@pk_616_10123,@dbtid_1,'mobile','0','1','14','0','1','','24','0','0','0','20','0','mobile232','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_3717,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','541name','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'),(@pk_616_2217,@dbtid_8,'name','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','382name','1','0','0'),(@pk_616_2218,@dbtid_8,'ctext','0','0','19','0','1','','8','1',@rolid_0,'0','0','1','382ctext','1','0','0'),(@pk_616_2219,@dbtid_8,'chtml','0','0','19','0','1','','7','1',@rolid_0,'0','0','1','382chtml','1','0','0'),(@pk_616_8616,@dbtid_8,'bouncemail','0','1','14','0','1','','11','0','0','0','100','1','bouncemail382','1','0','0'),(@pk_616_8617,@dbtid_8,'authorid','0','1','4','1','1','0','14','0','0','0','0','1','authorid382','1','0','0'),(@pk_616_8618,@dbtid_8,'modified','0','1','4','1','1','0','15','0','0','0','0','1','modified382','1','1','0'),(@pk_616_8678,@dbtid_8,'intro','0','1','16','0','1','','6','0','0','0','0','1','intro382','1','0','0'),(@pk_616_10120,@dbtid_8,'smsmessage','0','1','16','0','1','','16','0','0','0','0','1','smsmessage382','1','0','0'),(@pk_616_10801,@dbtid_8,'title','0','1','14','0','1','','17','0','0','0','255','1','title382','1','0','0'),(@pk_616_10802,@dbtid_8,'subtitle','0','1','14','0','1','','18','0','0','0','255','1','subtitle382','1','0','0');
SET @pk_5_1427 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='users.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='users',`wid`=@pk_5_1427,`params`='',`status`='1',`type`='150',`name`='Users',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='users.node',`version`='2958',`lversion`='2958',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='users.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','users',@pk_5_1427,'','1','150','Users','node','0','1','0','users.node','2958','2958','1','','1','1','0');

SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_251 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.users' LIMIT 1 );
SET @pk_621_1016 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.role' LIMIT 1 );
SET @pk_621_1058 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.language' LIMIT 1 );
SET @pk_621_1411 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.details' LIMIT 1 );
SET @pk_621_1180 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1 );
SET @pk_621_199 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1 );
SET @pk_621_200 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries' LIMIT 1 );
SET @pk_621_946 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries.states' LIMIT 1 );
SET @pk_621_1177 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='contacts.details' LIMIT 1 );
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 );
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=@dbtid_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,@dbtid_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_251,`dbtid`=@dbtid_7,`path`='0',`namekey`='joomla.users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.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_251,@dbtid_7,'0','joomla.users','users',@rolid_0,'0','1','0','0','','','users','0','0','1','','');
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','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1058,`dbtid`=@dbtid_2,`path`='0',`namekey`='users.language',`folder`='users.language',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='users.language';
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_1058,@dbtid_2,'0','users.language','users.language',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1411,`dbtid`=@dbtid_4,`path`='0',`namekey`='users.details',`folder`='users.details',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-user',`pnamekey`='' WHERE  `namekey`='users.details';
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_1411,@dbtid_4,'0','users.details','users.details',@rolid_0,'0','1','0','0','autofld=1','','users','1','0','1','fa-user','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1180,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1),`path`='1',`namekey`='main.widget',`folder`='main.widget',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='widget',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-puzzle-piece',`pnamekey`='' WHERE  `namekey`='main.widget';
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_1180,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1),'1','main.widget','main.widget',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','widget','0','0','1','fa-puzzle-piece','');
UPDATE `#__model_node`  SET `sid`=@pk_621_199,`dbtid`=@dbtid_5,`path`='0',`namekey`='library.languages',`folder`='library.languages',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-language',`pnamekey`='' WHERE  `namekey`='library.languages';
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_199,@dbtid_5,'0','library.languages','library.languages',@rolid_0,'0','1','0','0','','','joobi','0','0','1','fa-language','');
UPDATE `#__model_node`  SET `sid`=@pk_621_200,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),`path`='1',`namekey`='countries',`folder`='countries',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\ncachedata=1\nvalidtoggle=1',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-globe',`pnamekey`='' WHERE  `namekey`='countries';
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_200,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),'1','countries','countries',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\ncachedata=1\nvalidtoggle=1','','joobi','0','0','1','fa-globe','');
UPDATE `#__model_node`  SET `sid`=@pk_621_946,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' LIMIT 1),`path`='0',`namekey`='countries.states',`folder`='countries.states',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=ctyid\ngrptable=countries\nautofld=1',`alias`='',`prefix`='states',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='countries.states';
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_946,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' LIMIT 1),'0','countries.states','countries.states',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=ctyid\ngrptable=countries\nautofld=1','','states','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1177,`dbtid`=@dbtid_4,`path`='0',`namekey`='contacts.details',`folder`='contacts.details',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=contacts\nautofld=1',`alias`='',`prefix`='contacts',`fields`='1',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='contacts.details';
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_1177,@dbtid_4,'0','contacts.details','contacts.details',@rolid_0,'0','1','0','0','mainmodel=contacts\nautofld=1','','contacts','1','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_6,`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_6,'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`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1),`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,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1),'0','roletrans','roletrans',@rolid_0,'0','1','0','0','\nmainmodel=role','','role','0','0','1','fa-trophy','');

SET @wid_9 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='users.node' LIMIT 1);
SET @sid_10 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @rolid_11 = (9);
SET @sid_12 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1);
SET @rolid_13 = (7);
SET @rolid_14 = (3);
SET @yid_15 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_show' LIMIT 1);
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_address_registration' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_login_registration' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_preferences' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_login' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_user_widget' LIMIT 1);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_register' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_form' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_show_registration' LIMIT 1);
SET @did_24 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='users_language' LIMIT 1);
SET @did_25 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='users_timezone' LIMIT 1);
SET @did_26 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='users_activation_method' LIMIT 1);
SET @did_27 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='users_passowrd_strenght' LIMIT 1);
SET @rolid_28 = (8);
SET @rolid_29 = (21);
SET @ref_yid_30 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_controlpanel_menu' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('users_preferences_registration','users_preferences_password','users_preferences_general') LIMIT 3;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('users_preferences_profile','users_preferences_users_avatar') LIMIT 2;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_show_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('users_show_users_filid','users_show_users_name','users_show_users_username','users_show_users_email','users_show_users_rolid','users_show_users_block','users_show_users_lgid','users_show_users_timezone','users_show_users_uid','users_show_users_uid_1') LIMIT 10;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_address_registration_login' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('users_address_registration_loginusername','users_address_registration_loginpassword','users_address_registration_login_button') LIMIT 3;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_address_registration_register' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('users_address_registration_name','users_address_registration_firstname','users_address_registration_middlename','users_address_registration_lastname','users_address_registration_username','users_address_registration_email','users_address_registration_password','users_address_registration_confirmpassword','users_address_registration_originaddress','users_address_registration_originaddress2','users_address_registration_origincity','users_address_registration_originstate','users_address_registration_originstateid','users_address_registration_originzipcode','users_address_registration_originctyid','users_address_registration_phone','users_address_registration_captcha') LIMIT 17;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_login_registration_login' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('users_login_registration_username','users_login_registration_password','users_login_registration_login_remember','users_login_registration_login_button','users_login_registration_lost') LIMIT 5;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_login_registration_register' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('users_login_registration_register_name','users_login_registration_register_firstname','users_login_registration_register_middlename','users_login_registration_register_lastname','users_login_registration_register_username','users_login_registration_register_email','users_login_registration_register_password','users_login_registration_register_confirmpassword','users_login_registration_register_mobile','users_login_registration_register_filid','users_login_registration_register_language','users_login_registration_register_curid','users_login_registration_register_timezone','users_login_registration_register_html','users_login_registration_register_captcha','users_login_registration_register_button') LIMIT 16;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_profile' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('users_preferences_users_node_uselanguage','users_preferences_users_node_usetimezone','users_preferences_users_node_usecurrency','users_preferences_users_node_useavatar','users_preferences_users_node_usemobile','users_preferences_users_node_usehtmlemail') LIMIT 6;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('apps_preferences_form_users_node_framework_be','apps_preferences_form_users_node_framework_fe','users_preferences_users_node_allowregistration','users_preferences_users_node_loginallow') LIMIT 4;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_registration' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('users_preferences_users_node_activationmethod','users_preferences_users_node_registrationrole','users_preferences_users_node_loginemail','users_preferences_users_node_usecaptcha','users_preferences_users_node_frameworkrole','users_preferences_users_node_login_style','users_preferences_users_node_registration_page','users_preferences_users_node_registration_landing','users_preferences_users_node_login_page','users_preferences_users_node_login_landing','users_preferences_users_node_account_landing','users_preferences_users_node_logout_landing') LIMIT 12;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_password' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('users_preferences_users_node_emailpwd','users_preferences_users_node_notifyadmin','users_preferences_users_node_notifyadminemail','users_preferences_users_node_fail_max','users_preferences_users_node_fail_interval','users_preferences_users_node_pwd_strength_register','users_preferences_users_node_pwd_strength_admin','users_preferences_users_node_changeusername','users_preferences_users_node_usernamedefault') LIMIT 9;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='users_preferences_users_avatar' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('users_preferences_users_node_watermarkitem','users_preferences_users_node_maxpw','users_preferences_users_node_maxph','users_preferences_users_node_smalliw','users_preferences_users_node_smallih','users_preferences_users_node_imgformat','users_preferences_users_node_imgmaxsize','users_preferences_users_node_storage_items_photos') LIMIT 8;
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_node_horizontalmenu_fe' LIMIT 1);
SET @yid_32 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_listings' LIMIT 1);
SET @yid_33 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='users_role_listing' LIMIT 1);
SET @p_9_0 = ( SELECT  A.`mid`  FROM `#__layout_mlinks`  AS A  WHERE  A.`namekey` ='main_user_horizontalmenu_fe_home' LIMIT 1);
UPDATE `#__layout_mlinks` SET `parent`=@p_9_0 WHERE `namekey` IN ('main_user_horizontalmenu_fe_edit_profile','main_user_horizontalmenu_fe_profile','main_user_horizontalmenu_fe_vendor','main_user_horizontalmenu_fe_inbox') LIMIT 4;
SET @p_9_1 = ( SELECT  A.`mid`  FROM `#__layout_mlinks`  AS A  WHERE  A.`namekey` ='main_user_horizontalmenu_fe_order' LIMIT 1);
UPDATE `#__layout_mlinks` SET `parent`=@p_9_1 WHERE `namekey` IN ('main_user_horizontalmenu_fe_license','main_user_horizontalmenu_fe_subscriptions','main_user_horizontalmenu_fe_auctions','main_user_horizontalmenu_fe_coupons') LIMIT 4;
SET @p_9_2 = ( SELECT  A.`mid`  FROM `#__layout_mlinks`  AS A  WHERE  A.`namekey` ='main_user_horizontalmenu_fe_program' LIMIT 1);
UPDATE `#__layout_mlinks` SET `parent`=@p_9_2 WHERE `namekey` IN ('vendors_horizontalmenu_fe_commissions') LIMIT 1;
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='users_listings_role' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('users_listings_users_rolid_2','users_listings_users_rolid') LIMIT 2;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='users_listings_users_login_header' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('users_listings_users_login','users_listings_users_ip') LIMIT 2;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='users_listings_users_login_report' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('users_listings_users_login_report_uid') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='user_role_listing_roletrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('user_role_listing_roletrans_description') LIMIT 1;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE'),('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Delete','1','1206732372QTKL'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Profile','1','1206732392OZVE'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('General','1','1206732400OWZR'),('Security','1','1206732400OXBG'),('Language','1','1206732405TIXE'),('Create an account!','1','1206732408DEIM'),('Not selected','1','1206732410ICCI'),('None','1','1206732410ICCJ'),('Login','1','1206732411EGQX'),('Login Form','1','1206732411EGQZ'),('Lock','1','1206732411EGRI'),('Edit Profile','1','1206732411EGRP'),('Inbox','1','1206732411EGRQ'),('Email','1','1206732411EGRU'),('Username','1','1206732411EGRV'),('Confirmed','1','1206732411EGRX'),('Registered','1','1206732411EGSE'),('General Information','1','1206732412DABR'),('First Name','1','1206732412DABT'),('Middle Name','1','1206732412DABV'),('Last Name','1','1206732412DABX'),('Full Name','1','1206732412DABZ'),('Locked','1','1206732412DACF'),('Time Zone','1','1206732412DACJ'),('Password','1','1206732412DADP'),('Register','1','1206732412DAEA'),('Send New Password','1','1206732412DAEJ'),('Access','1','1206732412DAEO'),('Logout','1','1206732413BNMX'),('Remember me','1','1206732413BNNC'),('Lost Password?','1','1206732413BNND'),('Home','1','1206732431CQBG'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Menu','1','1206961870KLBH'),('Back','1','1206961882TDHA'),('Report','1','1206961899DDKO'),('email','1','1206961899DDKP'),('Orders','1','1206961902CIFC'),('City','1','1206961922ESOY'),('State','1','1206961922ESOZ'),('Country','1','1206961922ESPA'),('Currency','1','1206961948HYTE'),('Catalog','1','1206961997BSZK'),('Max height','1','1206961997BSZT'),('Max width','1','1206961997BSZV'),('Specify the width that the thumbnail should be resized to (in pixels).<br>Leave empty for original width.<br>','1','1206961997BSZX'),('Admin email','1','1206961998KTYL'),('Tickets','1','1206964235BPWJ'),('User','1','1208359284QWNS'),('Specify the access rights of the member.','1','1208867895OVVA'),('Role','1','1209142268NMKA'),('Coupons','1','1210091183EQHU'),('You can not include the field \"$FIELD\" for security reasons.','1','1212843293BKVD'),('Subscriptions','1','1218029673NSUZ'),('0','1','1219856743ELFT'),('Avatar','1','1228709252AHXW'),('Close','1','1228820287MBVC'),('Users','1','1229653442FEQZ'),('IP','1','1230531895KYXK'),('Default Role','1','1241675187IFAK'),('Max file size','1','1241675239ROHF'),('Timezone','1','1242178310INQN'),('Phone','1','1242282412EESC'),('Allow User Registration','1','1242282445BFLI'),('Done','1','1242282449PIPC'),('Edit User','1','1242282449PIPL'),('Commissions','1','1246518490RFLH'),('Vendor Profile','1','1246518662OHAB'),('Block','1','1246541676GWQN'),('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'),('Programs','1','1251253308LVCT'),('Enter your username<br>','1','1251948773GQVX'),('Normal','1','1257243220BKUD'),('Select which application should be use to manage users in the front-end ( registration, login, etc... )<br>','1','1269573870RCTQ'),('Last Login','1','1298294092CJJG'),('The list of the user\'s roles.<br><br>','1','1298294093RWKN'),('Has Role','1','1298294095NUCM'),('Joomla User','1','1298350334ECWR'),('The email provided is not valid!','1','1298350399EIUD'),('User Roles','1','1298350400ESTE'),('Joomla ID','1','1298350400ESTF'),('User\'s Roles','1','1298350401HIBI'),('List of Users','1','1298350401HIBK'),('New User','1','1298350401HIBL'),('User Show','1','1298350401HIBM'),('User cancel','1','1298350401HIBN'),('Trigger Before the Save of the User','1','1298350401HIBP');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Trigger After the Save of the User','1','1298350401HIBQ'),('Trigger After the Delete of the User','1','1298350401HIBR'),('Trigger Before the Delete of the User','1','1298350401HIBS'),('Popup User\'s Role','1','1298350401HIBT'),('Change Role','1','1298350401HIBU'),('General Login','1','1298350401HIBV'),('Login or Register','1','1298350401HIBX'),('User Management Front-End','1','1298350446IEXM'),('User Management Back-End','1','1298350446IEXR'),('Select which application should be use to manage users in the back-end ( registration, login, etc... )<br>','1','1298350451QKHN'),('Thumbnail Max width','1','1298350878GWBR'),('Thumbnail Max height','1','1298350878GWBS'),('The max height accepted for product picture (in pixels).<br>Leave empty for unlimited height.<br>','1','1298350881GXHC'),('The max width accepted for product picture (in pixels).<br>Leave empty for unlimited width.<br>','1','1298350881GXHD'),('Specify all the photo formats allowed separated by a comma.<br>Leave empty if you want to allow any format.<br><br>','1','1298350884SAII'),('Auctions','1','1298357874SMVP'),('The field \"$FIELD\" has not been found.','1','1299148902FYMY'),('users.language','1','1299729469KOHO'),('','1','1304525968YBL'),('Extra Roles','1','1306382540KOEE'),('Cart','1','1307002587NUOA'),('Approve','1','1307975933EESV'),('Disapprove','1','1310522876DTCC'),('Postal code','1','1330731950JWCH'),('Address line 1','1','1330732086QQWK'),('Address line 2','1','1330732086QQWL'),('Server max File Upload','1','1331164428MGHN'),('Field','1','1335905452QHTH'),('Use Watermark','1','1338338160QKOG'),('Yes to apply the watermark to the picture.','1','1338338166DFZK'),('Click here to define watermark settings in Media tab','1','1338404831MNYL'),('Trigger the addExtra for a user','1','1338516605INFR'),('Trigger the editExtra for a user','1','1338516605INFS'),('Update of Role of the User','1','1338516605INFT'),('Photos','1','1349726540AIFR'),('Define the location where the photo files for Items and Categories get stored.<br>','1','1349824736IPWN'),('Specify the maximum image size allowed ( 0 unlimited ).<br>The unit is Kb ( Kilo bytes )<br><br>','1','1350003787BNEL'),('Photo file format','1','1350063002LIBK'),('Photos location','1','1350063006GDSH'),('Confirm Password','1','1352316765KOLP'),('Specify a username to identify yourself on this site.','1','1352316767OMER'),('Confirm you password<br>','1','1352316767OMET'),('Enter your full name<br>','1','1352316767OMEU'),('Enter the email address you want to use to receive notification from the administrator.','1','1352316767OMEV'),('Classifieds','1','1375216514MLLF'),('My Offers','1','1376965924DOOS'),('The user with the following id or username could not be found: $userId','1','1377734782BTNQ'),('The email provided is not valid! ($EMAIL)','1','1377828382KXRU'),('User registration','1','1379376150SNGZ'),('Enter your password<br>','1','1379525397DLDC'),('You account information for {widget:sitename}','1','1380048183BXIY'),('Profile widget','1','1380567654HBVC'),('Mobile','1','1382364838SGIL'),('Use Captcha','1','1389052188SONB'),('Prove that you are not a robot by entering in the field, the letters you read in the image.','1','1389052396IWCC'),('API key','1','1389275714NKEJ'),('Proof','1','1389276419BAQT'),('Emails report','1','1392297641IKCB'),('column1','1','1394069593IQAS'),('column2','1','1394069593IQAT'),('View sales commission created from the orders.<br>','1','1395718271OGDN'),('View, add and edit auctions that are shown to visitors.<br>','1','1395718272MFDF'),('Edit your vendor profile in the store.','1','1395718272MFDG'),('View and reply to your customers\' inquiries.<br>','1','1395718272MFDI'),('View your vendor profile in the store.','1','1395718272MFDK'),('A user with the same email address already exist. Please login or register with another email!','1','1401195620IMUD'),('HTML email','1','1401195621GJAG'),('Do you want to receive HTML email or text only?','1','1401195621GJAH'),('Enter your mobile number','1','1401195621GJAI'),('User Registration','1','1401195622JBQM'),('Login or Registration','1','1401195622JBQN'),('Self','1','1401307164QWBL'),('Admin Approval','1','1401307164QWBM'),('Strong','1','1401307164QWBN'),('Weak','1','1401307164QWBO'),('Super Strong','1','1401307164QWBP'),('Registration Role','1','1401307164QWBQ'),('Email Password','1','1401307164QWBR'),('Account Activation','1','1401307164QWBS'),('Notify Admin','1','1401307164QWBT'),('Use Language','1','1401307164QWBU'),('Use Timezone','1','1401307164QWBV'),('Maximum fails','1','1401307164QWBX'),('Fail interval','1','1401307164QWBY'),('If set to No, no user will be able to login to the site.<br>','1','1401307164QWCA'),('Define what should be the default registration role.','1','1401307164QWCB'),('Email the password to the user at registration.','1','1401307164QWCC'),('Define the method the account should be activated.','1','1401307164QWCD'),('Notify administrators on new registration.','1','1401307164QWCE'),('Set to Yes to use Captcha at registration.','1','1401307164QWCF'),('Set to Yes to let the users choose their language.','1','1401307164QWCG'),('Set to Yes to let the users choose their timezone.','1','1401307164QWCH'),('Set to Yes to let the users change their username.','1','1401307164QWCI'),('If no username is provided, use the email or a random string.','1','1401307164QWCJ'),('Define the period ( in minutes ) after which a user can try to login again if their failed too many times.','1','1401307164QWCK'),('Users Preferences','1','1401307164QWCM'),('Unlock','1','1401377882ETOG'),('The password need to be at least 4 characters long.','1','1401465958GTFC'),('The password need to be at least 6 characters long.','1','1401465958GTFD'),('The password need to have at least 1 letter.','1','1401465958GTFE'),('The password need to have at least 1 number or 1 special character.','1','1401465958GTFF');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('The password need to be at least 8 characters long.','1','1401465958GTFG'),('The password need to have at least 1 upper case letter.','1','1401465958GTFH'),('The password need to have at least 1 lower case letter.','1','1401465958GTFI'),('The password need to be at least 10 characters long.','1','1401465958GTFJ'),('The password need to have at least 2 special characters.','1','1401465958GTFK'),('The password need to have at least 1 number.','1','1401465958GTFL'),('$TOTAL users have been unlocked!','1','1401465958GTFM'),('The user has been unlocked!','1','1401465958GTFN'),('$TOTAL users have been locked!','1','1401465958GTFO'),('The user has been locked!','1','1401465958GTFP'),('The password confirmation does not match the password.','1','1401465958GTFQ'),('Random String','1','1401465959YVL'),('Admin User Strength','1','1401465959YVM'),('HTML emails','1','1401465959YVN'),('Use Mobile','1','1401465959YVP'),('Default Username','1','1401465959YVQ'),('Use Currency','1','1401465959YVR'),('Register User Strength','1','1401465959YVS'),('Framework Role','1','1401465959YVT'),('Define the URL to redirect to when the users click on My Account button.<div>Leave empty for default Users dashboard.</div>','1','1401465959YVU'),('Define the required strength of administrator users’ password.<br>','1','1401465959YVV'),('Specified preferred language.','1','1401465959YVW'),('Receive email in HTML format.','1','1401465960RGMK'),('Specified the preferred currency.','1','1401465960RGML'),('Set to Yes to ask the mobile phone of the user.','1','1401465960RGMM'),('Set to Yes to ask the preferred currency to the user.','1','1401465960RGMN'),('Define the required strength of standard users’ password.','1','1401465960RGMO'),('Define the minimum role to update the framework user database.<div><u>Recommended</u>: “Register\"</div>','1','1401465960RGMP'),('Lock user','1','1401465960RGMQ'),('Delete Users','1','1401465960RGMR'),('Unfortunately, your account has not been approved on {widget:sitename}','1','1401465960RGMS'),('<p>Hello {widget:param|name=name},</p><p> </p><p>Unfortunately! Your account has not been approved on {widget:sitename}.</p><p>Please contact the administrator should you need more details.</p><p><br></p><p>Best regards,</p><p>{widget:sitename} Team<br></p>','1','1401465960RGMV'),('User Horizontal Menu FE','1','1401473376KUOI'),('User Dashboard','1','1401473376KUOJ'),('Allow username change','1','1401721045QFQW'),('Use Avatar','1','1401721045QFQX'),('Set to Yes to let user upload an avatar.','1','1401721045QFQY'),('Upload an image for your avatar.','1','1401721045QFQZ'),('Users Button for Control Panel','1','1401721045QFRA'),('The password could not be email because the user ID was not found.','1','1401818484FRIA'),('Registration is not allowed!','1','1401855798FZFQ'),('The user has been approved!','1','1401855798FZFR'),('The user has been denied access to the website!','1','1401855798FZFS'),('New user \"{widget:param|name=username}\" has registered to the website {widget:sitename}','1','1401855800NDHG'),('New user \"{widget:param|name=username}” need approval','1','1401855800NDHH'),('Congratulation, you have been approved on {widget:sitename}','1','1401855800NDHI'),('You need to confirm your email address on {widget:sitename}','1','1401855800NDHJ'),('<p>Hello admin,</p><p>&nbsp;</p><p>A new user has registered to the website&nbsp;{widget:sitename}</p><p><br></p><p><strong>Here are the user information.</strong></p><p><span style=\"text-decoration: underline;\">Name:</span>&nbsp;{widget:param|name=name}</p><p><span style=\"text-decoration: underline;\">Username:</span> {widget:param|name=username}</p><p><span style=\"text-decoration: underline;\">Email:</span> {widget:param|name=email}</p><p><span style=\"text-decoration: underline;\">Language:</span>&nbsp;{widget:param|name=language}<br></p><p><span style=\"text-decoration: underline;\">Country:</span>&nbsp;{widget:param|name=country}<br></p><p><span style=\"text-decoration: underline;\">Timezone:</span>&nbsp;{widget:param|name=timezone}<br></p><p><br></p><p><br></p>','1','1401855800NDHK'),('<p>Hello admin,</p><p>&nbsp;</p><p>A new user has registered to the website&nbsp;{widget:sitename} and needs your approval.</p><p><b>Go to the following link to approve the user:</b></p><p>{widget:param|name=approvalLink}<br></p><p><br></p><p><strong>Here are the user information.</strong></p><p><span style=\"text-decoration: underline;\">Name:</span>&nbsp;{widget:param|name=name}</p><p><span style=\"text-decoration: underline;\">Username:</span> {widget:param|name=username}</p><p><span style=\"text-decoration: underline;\">Email:</span> {widget:param|name=email}</p><p><span style=\"text-decoration: underline;\">Language:</span>&nbsp;{widget:param|name=language}<br></p><p><span style=\"text-decoration: underline;\">Country:</span>&nbsp;{widget:param|name=country}<br></p><p><span style=\"text-decoration: underline;\">Timezone:</span>&nbsp;{widget:param|name=timezone}<br></p><p><br></p><p><br></p>','1','1401855800NDHL'),('<p>Hello {widget:param|name=name},</p><p> </p><p>Congratulation! You have been approved to  {widget:sitename}.</p><p>You can now login with your credentials:</p><p><br></p><p><span style=\"text-decoration: underline;\">Name:</span> {widget:param|name=name}</p><p><span style=\"text-decoration: underline;\">Username:</span> {widget:param|name=username}</p><p><span style=\"text-decoration: underline;\">Email:</span> {widget:param|name=email}</p><p><br></p><p>We look forward to your visit,</p><p>{widget:sitename} Team</p>','1','1401855800NDHM'),('<p>Hello {widget:param|name=name},</p><p>&nbsp;</p><p>This is the final step to access&nbsp;</p><p>Thank you for registering at&nbsp;{widget:sitename}. &nbsp;Your account is created and must be activated before you can use it.</p><p>To activate the account click on the following link or copy-paste it in your browser:</p><p>{widget:param|name=selfApprovalLink}</p><p><br></p><p>After activation you may login to {widget:siteurl} using you credentials</p><p>{widget:param|name=credentials}<br></p><div style=\"cursor: pointer; width: 16px; height: 16px;display: inline-block;\" e26f27915a6b878d=\"j32.joobiplex.com\"><div><div style=\"cursor: pointer; width: 16px; height: 16px;display: inline-block;\" e26f27915a6b878d=\"j32.joobiplex.com\"><br></div></div><div><div style=\"cursor: pointer; width: 16px; height: 16px;display: inline-block;\" e26f27915a6b878d=\"j32.joobiplex.com\"><br></div></div>&nbsp;</div><p>Best regards,<br></p><p>{widget:sitename} Team</p>','1','1401855800NDHN'),('You account could not be created!','1','1401908086NTVF'),('Your account has been created, however the administrator need to approve it before you can login!','1','1401908086NTVG'),('Your account has been created and an activation link has been sent to the email address you entered.','1','1401908086NTVH'),('Note that you must activate the account by clicking on the activation link when you receive the email before you can login.','1','1401908086NTVI'),('Your account has been created, you are now login!','1','1401908086NTVJ'),('Your account has been created, please login!','1','1401908086NTVK'),('Registration landing page','1','1401908087BVRZ'),('Option: specify an email address where the notification of new subscribers should be sent to. If not specified the notification will go to all Super administrators.<div>Hint: separate multiple emails with a comma.</div>','1','1401908087BVSA'),('Hello {widget:name} welcome to {widget:sitename},\r\n\r\nHere are your account information.  \r\n\r\nUsername: {widget:param|name=username}\r\nPassword: {widget:param|name=password}\r\nEmail: {widget:param|name=email}\r\n\r\nPlease make sure you keep those credentials in a secure and safe place. You will need them to login again on our website.\r\n\r\nWe highly recommend that next time you login you change the password.\r\n\r\nBest regards\r\n{widget:sitename} Team\r\n\r\n','1','1401908088KSZQ'),('Hello {widget:name},\r\n\r\nHere is a new password for your account.\r\nMake sure you change the password once you have logged in.\r\n\r\nPassword: {widget:param|name=password}\r\n\r\nPlease make sure you keep those credentials in a secure and safe place.\r\nBest regards,\r\n\r\n{widget:sitename} Team','1','1401908088KSZR'),('<p>Hello {widget:name} welcome to {widget:sitename},</p><p>&nbsp;</p><p><strong>Here are your account information.</strong></p><p><span style=\"text-decoration: underline;\">Username:</span> {widget:param|name=username}</p><p><span style=\"text-decoration: underline;\">Password:</span> {widget:param|name=password}</p><p><span style=\"text-decoration: underline;\">Email:</span> {widget:param|name=email}</p><p>&nbsp;</p><p>Please make sure you keep those credentials in a secure and safe place. You will need them to login again on our website. We highly recommend that next time you login you change the password.</p><p>Best regards,</p><p>{widget:sitename} Team</p>','1','1401908088KSZS'),('<p>Hello {widget:name},</p><p>&nbsp;</p><p><strong>Here is a new&nbsp;password for your account.</strong></p><p><strong><font color=\"#ff0000\">Make sure you change the password once you have logged in.</font></strong></p><p><span style=\"text-decoration: underline;\">Password:</span> {widget:param|name=password}</p><p>&nbsp;</p><p>Please make sure you keep those credentials in a secure and safe place.</p><p>Best regards,</p><p>{widget:sitename} Team</p>','1','1401908088KSZT'),('Login and Registration are disable for the moment!','1','1402327858JCQW'),('Login is disabled at the moment.','1','1402327860NWWL'),('You cannot delete your user from the database!','1','1402327860NWWM'),('Allow User Login','1','1402327862IRBJ'),('Ask for HTML email','1','1402327862IRBK'),('If set to No, no user will be able to register or create an account.<div><font color=\"#cc0000\"><u>Important</u>:</font> some application might not work properly if user cannot register or subscribe.</div>','1','1402327862IRBL'),('Set to Yes to ask the user if their want HTML or text only emails.','1','1402327862IRBM'),('1401853439','1','1404175053SXGE'),('1401853196','1','1404175053SXGF'),('Username and password does not match!','1','1406645169SRMK'),('Login landing page','1','1406645170POVD'),('Define a URL for the registration page.<div>Leave empty for default registration page.</div><div><u>Warning:</u> for this preference to be active user management needs to be “Users” or \"Contacts\"</div>','1','1406645171LJLM'),('Only Login','1','1406858734GTFR'),('Login & registration','1','1406858734GTFS'),('Login & Registration','1','1406858734GTFT'),('My Account page','1','1406858734GTFU'),('Logout landing page','1','1406858734GTFV'),('Login Page Style','1','1406858734GTFW'),('Define a URL for the login page.<div>Leave empty for default login page.</div><div><u>Warning:</u>&nbsp;for this preference to be active user management needs to be “Users” or \"Contacts\"</div>','1','1406858734GTFX'),('Define a URL for the landing page after logout.<div>Leave empty for Home page.</div>','1','1406858734GTFY'),('Define if the login page should include a registration form or simply a login page.','1','1406858734GTFZ'),('View sales commission created from the orders.','1','1407183443BJQU'),('The activation is not correct. make sure the link you clicked on is not broken','1','1407807686JAZD'),('Your account is now activated and you can login.','1','1407807686JAZE'),('1407806908','1','1407807688RGBP'),('1407800076','1','1407807688RGBR'),('1407800027','1','1407807688RGBS'),('1407809500','1','1407877167CEQY'),('The credentials provided do not match!','1','1408041590EIQX'),('Register User','1','1409189814MIGS'),('Events Registration','1','1409189814MIGT'),('Events Login','1','1409189814MIGU'),('There is no email specified','1','1410373233CVZL'),('The following email address is not valid: $EMAIL','1','1410373233CVZM'),('The specified email was not found!','1','1410373233CVZN'),('Reset Your Password','1','1410373235PUIM'),('Your account information for {widget:sitename}','1','1410373235PUIN'),('Your new password for {widget:sitename}','1','1410373235PUIO');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Hello {widget:name} welcome to {widget:sitename},\r\n\r\nHere are your account information.\r\n\r\nUsername: {widget:param|name=username}\r\nPassword: {widget:param|name=password}\r\nEmail: {widget:param|name=email}\r\n\r\nPlease make sure you keep those credentials in a secure and safe place. You will need them to login again on our website. \r\n\r\nBest regards,\r\n{widget:sitename} Team','1','1410373235PUIP'),('<p>Hello {widget:name} welcome to {widget:sitename},</p><p>&nbsp;</p><p><strong>Here is your account information.</strong></p><p><span style=\"text-decoration: underline;\">Username:</span> {widget:param|name=username}</p><p><span style=\"text-decoration: underline;\">Password:</span> {widget:param|name=password}</p><p><span style=\"text-decoration: underline;\">Email:</span> {widget:param|name=email}</p><p>&nbsp;</p><p>Please make sure you keep those credentials in a secure and safe place. You will need them to login again on our website.&nbsp;</p><p>Best regards,</p><p>{widget:sitename} Team</p>','1','1410373235PUIQ'),('1410358281','1','1410373235PUIS'),('An email with a new passowrd has been sent to to your email. Please check your inbox!','1','1410384292GWRX'),('Enter Your Email','1','1410384293KGZU'),('Please enter your email address.','1','1410384294EKCN'),('1411005554','1','1411021264NDMH'),('Enter your full name','1','1411145556CLAN'),('Confirm you password','1','1411145556CLAP'),('Enter your desired password. Minimum 4 characters.','1','1411145556CLAQ'),('Enter your phone number.','1','1411145556CLAW'),('State / Province / Region','1','1411145556CLAY'),('The information provided was not found!','1','1414741764AKJF'),('No credentials provided!','1','1415722221IUIO'),('Define the maximum number of time a user can enter a wrong password before their account get blocked.','1','1417629901BWSE'),('Registration page','1','1417651524CODW'),('Login page','1','1417651524CODX'),('Define a URL for the landing page after registration.<div>Leave empty for default landing page.</div>','1','1417651524CODY'),('Define a URL for the landing page after login.<div>Leave empty for default landing page.</div>','1','1417651524CODZ'),('<div style=\"width: 414px; border-width: 0pt 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color rgb(204, 204, 204) rgb(204, 204, 204); overflow-y: auto; overflow-x: hidden;\"><div class=\" nicEdit-main  nicEdit-selected\" style=\"width: 406px; margin: 4px; min-height: 87px; overflow: hidden;\" contenteditable=\"true\">Specify the height that the thumbnail should be resized to (in pixels).<br>Leave empty for original height.<br></div></div>','1','1418159422PCRS'),('Allow Login with Email','1','1419461935EXSJ'),('Yes to allow user to login using their email or username.<div>No, only login with username allowed.</div>','1','1419461936BSHK'),('The username $USERNAME is already taken please choose another username!','1','1424728189PIMT'),('We could not load the model for the language $code. Please synchronize your languages.','1','1426609899QDEC'),('Enter the email address you want to use to receive notification from the administrator.<br>','1','1427292714DFWB'),('Render information about a user.\nName, First name, Last name, etc...','1','1433381333KDQJ'),('Enter your first name','1','1433954805HOYU'),('Enter your middle name','1','1433954805HOYV'),('Enter your last name','1','1433954805HOYW');
SET @dbcid_34 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_node' LIMIT 1),'1','0',@dbcid_34);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_language_uid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264uid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_language_uid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_members_node_name' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232name' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_username' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232username' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_email' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232email' 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)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_members_details|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1009uid' LIMIT 1));
SET @pk_77_306 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'264uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_485 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_5 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'264lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_353 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_5 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10372 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10691 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_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_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'702rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10837 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'currency.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'curid232\' LIMIT 1' LIMIT 1 );
SET @pk_77_11168 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.countries\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'ctyid232\' LIMIT 1' LIMIT 1 );
SET @pk_77_11170 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1009uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11169 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'organization.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'vendid1009\' LIMIT 1' LIMIT 1 );
SET @pk_77_11342 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.files\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'filid232\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('uid','1','FK_members_lang_uid',@pk_77_306,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264uid' LIMIT 1),@dbcid_34,'3','3','uid',@dbtid_1,@dbtid_2,'99');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('lgid','1','FK_members_lang_lgid',@pk_77_485,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='264lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',@dbtid_5,@dbtid_2,'99'),('lgid','1','FK_members_node_lgid',@pk_77_353,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','1','lgid',@dbtid_5,@dbtid_1,'3'),('rolid','1','FK_members_rolid',@pk_77_10372,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','',@dbtid_6,@dbtid_1,'2'),('uid','1','FK_role_members_uid',@pk_77_10691,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='702uid' LIMIT 1),@dbcid_34,'3','3','uid',@dbtid_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_6,@dbtid_3,'2'),('curid','1','FK_members_curid',@pk_77_10837,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='curid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='624curid' LIMIT 1),'3','3','curid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1),@dbtid_1,'1'),('ctyid','1','FK_members_ctyid',@pk_77_11168,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctyid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1),'1','1','ctyid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),@dbtid_1,'4'),('uid','1','FK_members_details_uid',@pk_77_11170,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1009uid' LIMIT 1),@dbcid_34,'3','3','uid',@dbtid_1,@dbtid_4,'1'),('vendid','1','FK_members_details_vendid',@pk_77_11169,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='vendid1009' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1004vendid' LIMIT 1),'1','1','vendid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='organization.node' LIMIT 1),@dbtid_4,'2'),('filid','1','FK_members_node_filid',@pk_77_11342,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1),'3','3','filid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),@dbtid_1,'5');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_9,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_9,'2','1206732372QTKJ'),(@wid_9,'1','1206732392OZVB'),(@wid_9,'1','1206732410ICCI'),(@wid_9,'1','1206732410ICCJ'),(@wid_9,'1','1206732411EGQX'),(@wid_9,'1','1206732411EGRV'),(@wid_9,'1','1206732412DABT'),(@wid_9,'1','1206732412DABX'),(@wid_9,'1','1206732412DADP'),(@wid_9,'1','1206961899DDKP'),(@wid_9,'0','1212843293BKVD'),(@wid_9,'1','1229653442FEQZ'),(@wid_9,'0','1298350399EIUD'),(@wid_9,'0','1299148902FYMY'),(@wid_9,'1','1331164428MGHN'),(@wid_9,'1','1338404831MNYL'),(@wid_9,'0','1377734782BTNQ'),(@wid_9,'0','1377828382KXRU'),(@wid_9,'0','1401195620IMUD'),(@wid_9,'1','1401465958GTFC'),(@wid_9,'1','1401465958GTFD'),(@wid_9,'1','1401465958GTFE'),(@wid_9,'1','1401465958GTFF'),(@wid_9,'1','1401465958GTFG'),(@wid_9,'1','1401465958GTFH'),(@wid_9,'1','1401465958GTFI'),(@wid_9,'1','1401465958GTFJ'),(@wid_9,'1','1401465958GTFK'),(@wid_9,'1','1401465958GTFL'),(@wid_9,'0','1401465958GTFM'),(@wid_9,'0','1401465958GTFN'),(@wid_9,'0','1401465958GTFO'),(@wid_9,'0','1401465958GTFP'),(@wid_9,'0','1401465958GTFQ'),(@wid_9,'0','1401818484FRIA'),(@wid_9,'0','1401855798FZFQ'),(@wid_9,'0','1401855798FZFR'),(@wid_9,'0','1401855798FZFS'),(@wid_9,'0','1401908086NTVF'),(@wid_9,'0','1401908086NTVG'),(@wid_9,'0','1401908086NTVH'),(@wid_9,'0','1401908086NTVI'),(@wid_9,'0','1401908086NTVJ'),(@wid_9,'0','1401908086NTVK'),(@wid_9,'0','1402327858JCQW'),(@wid_9,'0','1402327860NWWL'),(@wid_9,'0','1402327860NWWM'),(@wid_9,'0','1406645169SRMK'),(@wid_9,'0','1407807686JAZD'),(@wid_9,'0','1407807686JAZE'),(@wid_9,'0','1408041590EIQX'),(@wid_9,'0','1410373233CVZL'),(@wid_9,'0','1410373233CVZM'),(@wid_9,'0','1410373233CVZN'),(@wid_9,'0','1410384292GWRX'),(@wid_9,'0','1414741764AKJF'),(@wid_9,'0','1415722221IUIO'),(@wid_9,'0','1424728189PIMT'),(@wid_9,'0','1426609899QDEC'),(@wid_9,'1','1433381333KDQJ');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('users_ghost_account',@rolid_0,'1','0','',@wid_9,'Guest Account Information','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=firstName}\r\n{widget:param|name=username}\r\n{widget:param|name=email}\r\n{widget:param|name=password}\r\n','0','0','1','1','0','3','0','1');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('users_new_password',@rolid_0,'1','0','',@wid_9,'Sending password','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=email}\r\n{widget:param|name=password}\r\n','0','0','1','1','0','3','0','1'),('users_new_registration',@rolid_0,'1','2','',@wid_9,'Notify Admin of new registration','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=username}\r\n{widget:param|name=email}\r\n{widget:param|name=language}\r\n{widget:param|name=country}\r\n{widget:param|name=timezone}','0','0','1','1','0','3','0','1'),('users_approval',@rolid_0,'1','2','',@wid_9,'User registration admin approval email','0','{widget:sitename}\r\n{widget:param|name=approvalLink}\r\n{widget:param|name=name}\r\n{widget:param|name=username}\r\n{widget:param|name=email}\r\n{widget:param|name=language}\r\n{widget:param|name=country}\r\n{widget:param|name=timezone}','0','0','1','1','0','3','0','1'),('users_approved',@rolid_0,'1','2','',@wid_9,'User approved','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=username}\r\n{widget:param|name=email}\r\n','0','0','1','1','0','3','0','1'),('users_disapproved',@rolid_0,'1','2','',@wid_9,'User disapproved','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=username}\r\n{widget:param|name=email}\r\n{widget:param|name=password}\r\n','0','0','1','1','0','3','0','1'),('users_self_approval',@rolid_0,'1','0','',@wid_9,'User self approval email','0','{widget:sitename}\r\n{widget:siteurl}\r\n{widget:param|name=name}\r\n{widget:param|name=selfApprovalLink}\r\n{widget:param|name=credentials}','0','0','1','1','0','3','0','1'),('users_reset_password',@rolid_0,'1','0','',@wid_9,'Sending reset password','0','{widget:sitename}\r\n{widget:param|name=name}\r\n{widget:param|name=email}\r\n{widget:param|name=password}\r\n','0','0','1','1','0','3','0','1');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_9),'','','','','','','','','','','0','');
SET @dbcid_35 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
SET @dbcid_36 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1);
SET @dbcid_37 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1);
SET @dbcid_38 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1);
SET @dbcid_39 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1);
SET @dbcid_40 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1);
SET @dbcid_41 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1);
SET @dbcid_42 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1);
SET @dbcid_43 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1);
SET @dbcid_44 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1);
SET @dbcid_45 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_35,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.users' LIMIT 1),'1298350334ECWR',@wid_9);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_35,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1),'1229653442FEQZ',@wid_9),(@dbcid_35,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.role' LIMIT 1),'1298350400ESTE',@wid_9),(@dbcid_35,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.language' LIMIT 1),'1299729469KOHO',@wid_9),(@dbcid_35,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.details' LIMIT 1),'1229653442FEQZ',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1380048183BXIY',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1410373235PUIN',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1401855800NDHG',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1401855800NDHH',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1401855800NDHI',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1401465960RGMS',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1401855800NDHJ',@wid_9),(@dbcid_36,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1410373235PUIO',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1401908088KSZQ',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1410373235PUIP',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_37,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1401908088KSZR',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1401908088KSZS',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1410373235PUIQ',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1401855800NDHK',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1401855800NDHL',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1401855800NDHM',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1401465960RGMV',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1401855800NDHN',@wid_9),(@dbcid_38,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1401908088KSZT',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_39,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_40,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1219856743ELFT',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1407807688RGBP',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1411021264NDMH',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1407877167CEQY',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1407807688RGBR',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1404175053SXGE',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1404175053SXGF',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1407807688RGBS',@wid_9),(@dbcid_41,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1410373235PUIS',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_42,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_43,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_44,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_ghost_account' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_password' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_new_registration' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_approved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_disapproved' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_self_approval' LIMIT 1),'1304525968YBL',@wid_9),(@dbcid_45,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='users_reset_password' LIMIT 1),'1304525968YBL',@wid_9);