/*Export of the extension address.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1206961922ESPA','1206961911NYAR','1211811583DBTA','1206961922ESOU','1206961922ESOV','1330731950JWCH','1206961922ESOY','1206961922ESOZ','1206732412DABZ','1206961869IGND','1342235342FNDR','1206732392OZVD','1242282412EESC','1251253394FBHH','1342235343DHUB','1304525968YBL','1206961922ESOT','1342235344MQRT','1436323692KTSG','1387587964JZGG','1206732391QBUR','1240915588CVPY','1220210441RSRF','1242282449PIPC','1206732393CXVV','1206732361LXFD','1228820287MBVC','1206961882TDHA','1206732392OZUP','1206732361LXFE','1206732372QTKL','1206732399EINB','1206961922ESOL','1206961922ESOM','1206961922ESON','1206961911NYAU','1206961911NYAT','1206961911NYAW','1206732392OZVA','1246681172BBHV','1246681172BBHW','1246681172BBHX','1206732372QTKN','1212062321PNLD','1242282416HAOE','1342235342FNDS','1220210441RSRG','1246681172BBHZ','1310464659GIBP','1342235344MQRU','1418159671APTD','1346186669QUYV','1373210366FFWR','1206732372QTKI','1206732372QTKJ','1206732424BJFR','1206961913QQBR','1337272977SYNA','1342235342FNDP','1342235342FNDQ','1373209094YQB','1373210357FEOT','1373210359RPSF','1379006374DSBD','1398304758MHHQ' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('address.node','joobi.countries') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('joobi.countries','address.node','members.node','vendor.node','joobi.states','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('232uid','323address1','323address2','323address3','323adid','323city','323ctyid','323publish','323state','323namekey','323zipcode','200ctyid','200isocod2','200isocod3','200name','200namekey','200numcode','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','232html','232registered','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','323name','232login','481wname','481wdescription','232rolid','618sid','618lgid','618name','652vendid','uid652','email652','curid652','adid652','stid652','alias652','namekey652','image652','website652','params652','modified652','created652','publish652','premium652','visibility232','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto618','fromlgid618','auto714','fromlgid714','timezone200','curid232','ordering652','affid652','contactno652','contactemail652','paypal652','otheraccount652','nbreviews652','score652','votes652','publish200','882stateid','name882','namekey882','code2882','code3882','publish882','ctyid882','stateid323','core882','core200','created323','modified323','vendid323','uid323','originctyid652','originstate652','originzipcode652','originaddress652','originaddress2652','origincity652','ordering200','ordering882','hits652','modified200','premium323','type323','business323','phone323','params323','latitude323','longitude323','taxnumber652','paypalverified652','ip232','ctyid232','type652','online323','found323','lastcheck323','mapservice323','longitude652','latitude652','usercreate323','mobile232','bannerid652','filid232','badge652','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 ('323ctyid','stateid323','vendid323','uid323') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_address_node_ctyid','FK_address_node_stateid','FK_address_node_uid','FK_address_node_vendid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('address.node') ;
SET @rolid_0 = (1);
SET @pk_549_200 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1 );
SET @pk_549_323 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.node' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_652 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1 );
SET @pk_549_882 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' 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_339 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.members' 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_306 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('joobi_countries','joobi.countries',@pk_549_200,'','1.0.0',@rolid_0,'0','1','ctyid','countries','joobi','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 ('address_node','address.node',@pk_549_323,'','1.0.0',@rolid_0,'0','1','adid','node','address','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('vendor_node','vendor.node',@pk_549_652,'','',@rolid_0,'0','1','vendid','node','vendor','51','1','0','0','7'),('joobi_states','joobi.states',@pk_549_882,'','',@rolid_0,'0','1','stateid','states','joobi','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('address_members','address.members',@pk_549_339,'','1.0.0',@rolid_0,'0','30','adid,uid','members','address','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'),('product_node','product.node',@pk_549_306,'','1.0.0',@rolid_0,'0','1','pid','node','product','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'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1);
SET @pk_454_48165 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_address_node_location' LIMIT 1 );
SET @pk_454_48166 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_200_namekey' LIMIT 1 );
SET @pk_454_65562 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_joobi_countries' LIMIT 1 );
SET @pk_454_66002 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_address_node_uid' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_48165,'2','IX_address_node_location',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_48166,'1','UK_200_namekey',@dbtid_2),(@pk_454_65562,'3','PK_joobi_countries',@dbtid_2),(@pk_454_66002,'2','IX_address_node_uid',@dbtid_1);
SET @pk_616_1929 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1 );
SET @pk_616_1933 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200namekey' LIMIT 1 );
SET @pk_616_8853 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid323' LIMIT 1 );
SET @pk_616_9424 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='online323' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_6309 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='652vendid' LIMIT 1 );
SET @pk_616_8026 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='882stateid' LIMIT 1 );
SET @pk_616_1817 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323ctyid' LIMIT 1 );
SET @pk_616_8061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='stateid323' LIMIT 1 );
SET @pk_616_8844 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='vendid323' LIMIT 1 );
SET @pk_616_1812 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323address1' LIMIT 1 );
SET @pk_616_1813 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323address2' LIMIT 1 );
SET @pk_616_1814 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323address3' LIMIT 1 );
SET @pk_616_1815 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323adid' LIMIT 1 );
SET @pk_616_1816 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323city' LIMIT 1 );
SET @pk_616_1818 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323publish' LIMIT 1 );
SET @pk_616_1819 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323state' LIMIT 1 );
SET @pk_616_1820 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323namekey' LIMIT 1 );
SET @pk_616_1821 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323zipcode' LIMIT 1 );
SET @pk_616_1930 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200isocod2' LIMIT 1 );
SET @pk_616_1931 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200isocod3' LIMIT 1 );
SET @pk_616_1932 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200name' LIMIT 1 );
SET @pk_616_1934 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200numcode' LIMIT 1 );
SET @pk_616_3518 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323name' LIMIT 1 );
SET @pk_616_7048 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='timezone200' LIMIT 1 );
SET @pk_616_8025 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish200' LIMIT 1 );
SET @pk_616_8761 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core200' LIMIT 1 );
SET @pk_616_8842 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created323' LIMIT 1 );
SET @pk_616_8843 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified323' LIMIT 1 );
SET @pk_616_8922 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering200' LIMIT 1 );
SET @pk_616_8945 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified200' LIMIT 1 );
SET @pk_616_8954 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='premium323' LIMIT 1 );
SET @pk_616_8955 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type323' LIMIT 1 );
SET @pk_616_8956 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='business323' LIMIT 1 );
SET @pk_616_8957 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='phone323' LIMIT 1 );
SET @pk_616_8958 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params323' LIMIT 1 );
SET @pk_616_8959 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='latitude323' LIMIT 1 );
SET @pk_616_8960 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='longitude323' LIMIT 1 );
SET @pk_616_9425 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='found323' LIMIT 1 );
SET @pk_616_9426 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lastcheck323' LIMIT 1 );
SET @pk_616_9427 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='mapservice323' LIMIT 1 );
SET @pk_616_10035 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='usercreate323' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_3412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482name' LIMIT 1 );
SET @pk_616_3413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482description' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_1929,@dbtid_2,'ctyid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','200ctyid','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_1933,@dbtid_2,'namekey','0','1','14','0','1','','4','1',@rolid_0,'0','80','1','200namekey','1','0','0'),(@pk_616_8853,@dbtid_1,'uid','0','1','4','1','1','0','16','0','0','0','0','1','uid323','1','0','0'),(@pk_616_9424,@dbtid_1,'location','0','1','14','0','1','','24','0','0','0','255','1','online323','1','0','0'),(@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_6309,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1),'vendid','1','0','4','1','1','','1','0','0','1','0','1','652vendid','1','0','0'),(@pk_616_8026,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' LIMIT 1),'stateid','1','0','2','1','1','','1','0','0','1','5','1','882stateid','1','0','0'),(@pk_616_1817,@dbtid_1,'ctyid','0','1','2','1','1','0','2','1',@rolid_0,'0','0','1','323ctyid','1','0','0'),(@pk_616_8061,@dbtid_1,'stateid','0','1','2','1','1','0','12','0','0','0','0','1','stateid323','1','0','0'),(@pk_616_8844,@dbtid_1,'vendid','0','1','4','1','1','0','15','0','0','0','0','1','vendid323','1','0','0'),(@pk_616_1812,@dbtid_1,'address1','0','1','14','0','1','','5','1',@rolid_0,'0','100','1','323address1','1','0','0'),(@pk_616_1813,@dbtid_1,'address2','0','1','14','0','1','','6','1',@rolid_0,'0','100','1','323address2','1','0','0'),(@pk_616_1814,@dbtid_1,'address3','0','1','14','0','1','','7','1',@rolid_0,'0','100','1','323address3','1','0','0'),(@pk_616_1815,@dbtid_1,'adid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','323adid','1','0','0'),(@pk_616_1816,@dbtid_1,'city','0','1','14','0','1','','10','1',@rolid_0,'0','40','1','323city','1','0','0'),(@pk_616_1818,@dbtid_1,'publish','0','0','1','0','1','1','9','1',@rolid_0,'0','0','1','323publish','1','0','0'),(@pk_616_1819,@dbtid_1,'state','0','1','14','0','1','','8','1',@rolid_0,'0','40','1','323state','1','0','0'),(@pk_616_1820,@dbtid_1,'alias','0','1','14','0','1','','4','1',@rolid_0,'0','150','1','323namekey','1','0','0'),(@pk_616_1821,@dbtid_1,'zipcode','0','1','14','0','1','','11','1',@rolid_0,'0','25','1','323zipcode','1','0','0'),(@pk_616_1930,@dbtid_2,'isocode2','0','0','15','0','1','','2','1',@rolid_0,'0','2','1','200isocod2','1','0','0'),(@pk_616_1931,@dbtid_2,'isocode3','0','0','15','0','1','','3','1',@rolid_0,'0','3','1','200isocod3','1','0','0'),(@pk_616_1932,@dbtid_2,'name','0','0','14','0','1','','5','1',@rolid_0,'0','80','1','200name','1','0','0'),(@pk_616_1934,@dbtid_2,'numcode','0','0','2','0','1','0','6','1',@rolid_0,'0','0','1','200numcode','1','0','0'),(@pk_616_3518,@dbtid_1,'name','0','1','14','0','1','default','3','1',@rolid_0,'0','255','1','323name','1','0','0'),(@pk_616_7048,@dbtid_2,'timezone','0','1','2','0','1','0','7','0','0','0','0','1','timezone200','1','0','0'),(@pk_616_8025,@dbtid_2,'publish','0','0','1','0','1','1','8','0','0','0','0','1','publish200','1','0','0'),(@pk_616_8761,@dbtid_2,'core','0','1','25','0','1','0','9','0','0','0','0','1','core200','1','0','0'),(@pk_616_8842,@dbtid_1,'created','0','1','4','1','1','0','13','0','0','0','0','1','created323','1','1','0'),(@pk_616_8843,@dbtid_1,'modified','0','1','4','1','1','0','14','0','0','0','0','1','modified323','1','1','0'),(@pk_616_8922,@dbtid_2,'ordering','0','1','2','1','1','1','10','0','0','0','0','1','ordering200','1','0','0'),(@pk_616_8945,@dbtid_2,'modified','0','1','4','1','1','0','11','0','0','0','0','1','modified200','1','1','0'),(@pk_616_8954,@dbtid_1,'premium','0','1','25','0','1','0','17','0','0','0','0','1','premium323','1','0','0'),(@pk_616_8955,@dbtid_1,'type','0','1','1','1','1','1','18','0','0','0','0','1','type323','1','0','0'),(@pk_616_8956,@dbtid_1,'business','0','1','1','1','1','0','19','0','0','0','0','1','business323','1','0','0'),(@pk_616_8957,@dbtid_1,'phone','0','1','14','0','1','','20','0','0','0','20','1','phone323','1','0','0'),(@pk_616_8958,@dbtid_1,'params','0','1','16','0','1','','23','0','0','0','0','1','params323','1','0','0'),(@pk_616_8959,@dbtid_1,'latitude','0','1','7','0','1','222','21','0','0','0','12','1','latitude323','1','0','0'),(@pk_616_8960,@dbtid_1,'longitude','0','1','7','0','1','222','22','0','0','0','12','1','longitude323','1','0','0'),(@pk_616_9425,@dbtid_1,'found','0','1','1','1','1','0','25','0','0','0','0','1','found323','1','0','0'),(@pk_616_9426,@dbtid_1,'lastcheck','0','1','4','1','1','0','26','0','0','0','0','1','lastcheck323','1','0','0'),(@pk_616_9427,@dbtid_1,'mapservice','0','1','1','1','1','0','27','0','0','0','0','1','mapservice323','1','0','0'),(@pk_616_10035,@dbtid_1,'usercreate','0','1','1','1','1','1','28','0','0','0','0','1','usercreate323','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');
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_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0');
SET @pk_5_57 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='address.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='address',`wid`=@pk_5_57,`params`='',`status`='1',`type`='150',`name`='Address',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='address.node',`version`='4218',`lversion`='4218',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='address.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','address',@pk_5_57,'','1','150','Address','node','0','1','1','address.node','4218','4218','1','','1','1','0');

SET @pk_621_200 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries' LIMIT 1 );
SET @pk_621_323 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address' LIMIT 1 );
SET @pk_621_946 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries.states' LIMIT 1 );
SET @pk_621_339 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address.members' LIMIT 1 );
SET @pk_621_644 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='vendor' LIMIT 1 );
SET @pk_621_1091 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_200,`dbtid`=@dbtid_2,`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,@dbtid_2,'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_323,`dbtid`=@dbtid_1,`path`='1',`namekey`='address',`folder`='address',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='premmap=premium\npremgroup=uid\ncachedata=1',`alias`='',`prefix`='address',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='address';
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_323,@dbtid_1,'1','address','address',@rolid_0,'0','1','0','0','premmap=premium\npremgroup=uid\ncachedata=1','','address','0','0','1','','');
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_339,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.members' LIMIT 1),`path`='0',`namekey`='address.members',`folder`='address.members',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='address',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='address.members';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_339,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.members' LIMIT 1),'0','address.members','address.members',@rolid_0,'0','1','0','0','autofld=1','','address','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_644,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1),`path`='1',`namekey`='vendor',`folder`='vendor',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='vendor',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-user-md',`pnamekey`='' WHERE  `namekey`='vendor';
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_644,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1),'1','vendor','vendor',@rolid_0,'0','1','0','0','autofld=1','','vendor','0','0','1','fa-user-md','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1091,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),`path`='1',`namekey`='item',`folder`='item',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\ngrptable=item.categoryitem\ncachedata=1\nautofld=1\ncategorymodel=item.category',`alias`='',`prefix`='item',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-bookmark',`pnamekey`='' WHERE  `namekey`='item';
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_1091,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),'1','item','item',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\ngrptable=item.categoryitem\ncachedata=1\nautofld=1\ncategorymodel=item.category','','item','1','0','1','fa-bookmark','');

SET @wid_3 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='address.node' LIMIT 1);
SET @sid_4 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address' LIMIT 1);
SET @rolid_5 = (3);
SET @rolid_6 = (13);
SET @rolid_7 = (43);
SET @sid_8 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries' LIMIT 1);
SET @yid_9 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='basket_address_edit' LIMIT 1);
SET @yid_10 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='new_address' LIMIT 1);
SET @yid_11 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_new_for_vendors' LIMIT 1);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_edit_form' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_edit_form_change' LIMIT 1);
SET @yid_14 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_new_for_contacts' LIMIT 1);
SET @did_15 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='address_type' LIMIT 1);
SET @did_16 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='countries_published_list' LIMIT 1);
SET @sid_17 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address.members' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_choose' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_list' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_list_for_vendors' LIMIT 1);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_listing' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='address_list_change_basket' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='customer_address' LIMIT 1);
SET @sid_24 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='address_choose_address_alias' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('address_choose_address_type','address_choose_address_alias2') LIMIT 2;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='address_choose_address' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('address_choose_address_address1','address_choose_address_address2','address_choose_address_address3','address_choose_address_city','address_choose_states_name','address_choose_address_state','address_choose_address_zipcode','address_choose_countries_name','address_choose_countries_phone') LIMIT 9;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='customer_address_address' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('customer_address_address_address1','customer_address_address_address2','customer_address_address_address3','customer_address_address_city','customer_address_address_state','customer_address_countries_name','customer_address_address_zipcode') LIMIT 7;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='address_list_address' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('address_list_address_address1','address_list_address_address2','address_list_address_address3','address_list_address_city','address_list_address_state','address_list_countries_name','address_list_address_zipcode') LIMIT 7;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='address_list_for_vendors_address' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('address_list_for_vendors_address_address1','address_list_for_vendors_address_address2','address_list_for_vendors_address_address3','address_list_for_vendors_address_city','address_list_for_vendors_address_state','address_list_for_vendors_countries_name','address_list_for_vendors_address_zipcode') LIMIT 7;
SET @p_3_5 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='235e9lz72d' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_5 WHERE `namekey` IN ('235e9lz72','235e9lz72e','235e9lz72e_copy2352') LIMIT 3;
SET @p_3_6 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='235e9lz723' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_6 WHERE `namekey` IN ('235e9lz724','235e9lz724_copy9109','235e9lz725','235e9lz726','235e9lz727','235e9lz729','235e9lz72a','235e9lz72b','235e9lz72c') LIMIT 9;
SET @p_3_7 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='235kg7z724' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_7 WHERE `namekey` IN ('235kg7z725','235kg7z726','235kg7z727','235kg7z728','235kg7z729','235kg7z72a','235kg7z72b','235kg7z72b_copy8354') LIMIT 8;
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'),('Publish','1','1206732372QTKN'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Type','1','1206732392OZVD'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Full Name','1','1206732412DABZ'),('Map','1','1206732424BJFR'),('hidden','1','1206961869IGND'),('Back','1','1206961882TDHA'),('Address','1','1206961911NYAR'),('zipcode','1','1206961911NYAT'),('city','1','1206961911NYAU'),('country','1','1206961911NYAW'),('Your account','1','1206961913QQBR'),('address1','1','1206961922ESOL'),('address2','1','1206961922ESOM'),('address3','1','1206961922ESON'),('Write here the address in the right country format','1','1206961922ESOT'),('Address2','1','1206961922ESOU'),('Address3','1','1206961922ESOV'),('City','1','1206961922ESOY'),('State','1','1206961922ESOZ'),('Country','1','1206961922ESPA'),('Alias','1','1211811583DBTA'),('Select','1','1212062321PNLD'),('New Address','1','1220210441RSRF'),('Choose an address','1','1220210441RSRG'),('Close','1','1228820287MBVC'),('Continue','1','1240915588CVPY'),('Phone','1','1242282412EESC'),('Last Updated','1','1242282416HAOE'),('Done','1','1242282449PIPC'),('Address 1','1','1246681172BBHV'),('Address 2','1','1246681172BBHW'),('Address 3','1','1246681172BBHX'),('Adress','1','1246681172BBHZ'),('Instruction','1','1251253394FBHH'),('','1','1304525968YBL'),('Choose an address for Vendors','1','1310464659GIBP'),('Postal code','1','1330731950JWCH'),('Delivery Address','1','1337272977SYNA'),('Residential','1','1342235342FNDP'),('Commercial','1','1342235342FNDQ'),('Primary','1','1342235342FNDR'),('Selected','1','1342235342FNDS'),('Define an alias to identify your address.<br>','1','1342235343DHUB'),('Delivery instruction, for instance security, access code.','1','1342235344MQRT'),('Addresses','1','1342235344MQRU'),('<p>Fields with a red asterisk <span style=\"color:rgb(204, 0, 0)\">*</span> are required.</p>','1','1346186669QUYV'),('The map feature requires PHP 5.3 or higher.','1','1373209094YQB'),('View Map','1','1373210357FEOT'),('The address specified could not be found!','1','1373210359RPSF'),('Show a map','1','1373210366FFWR'),('Widget to render a map of the specified address','1','1379006374DSBD'),('Specify a small description for the address','1','1387587964JZGG'),('The specified address could not be located. It is not possible to show a map of it for the moment.','1','1398304758MHHQ'),('Fields with a red asterisk <span style=\"color: rgb(204, 0, 0);\">*</span> are required.','1','1418159671APTD'),('Delivery instruction, for instance security, access code.<br>','1','1436323692KTSG');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_joobi_countries' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_200_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_address_node_uid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid323' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_address_node_location' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='online323' LIMIT 1));
SET @pk_77_336 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'323ctyid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10962 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.states\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'stateid323\' LIMIT 1' LIMIT 1 );
SET @pk_77_11104 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'vendor.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'vendid323\' LIMIT 1' LIMIT 1 );
SET @pk_77_11105 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid323\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('ctyid','1','FK_address_node_ctyid',@pk_77_336,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='323ctyid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1),'3','3','ctyid',@dbtid_2,@dbtid_1,'2');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('stateid','1','FK_address_node_stateid',@pk_77_10962,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='stateid323' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='882stateid' LIMIT 1),'3','3','stateid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.states' LIMIT 1),@dbtid_1,'3'),('vendid','1','FK_address_node_vendid',@pk_77_11104,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='vendid323' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='652vendid' LIMIT 1),'1','1','vendid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1),@dbtid_1,'4'),('uid','1','FK_address_node_uid',@pk_77_11105,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid323' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'1','1','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),@dbtid_1,'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_3,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_3,'2','1206732372QTKJ'),(@wid_3,'1','1206732424BJFR'),(@wid_3,'1','1206961913QQBR'),(@wid_3,'1','1242282412EESC'),(@wid_3,'1','1337272977SYNA'),(@wid_3,'1','1342235342FNDP'),(@wid_3,'1','1342235342FNDQ'),(@wid_3,'0','1373209094YQB'),(@wid_3,'1','1373210357FEOT'),(@wid_3,'0','1373210359RPSF'),(@wid_3,'1','1379006374DSBD'),(@wid_3,'1','1398304758MHHQ');
SET @rolid_25 = (7);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1),( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries' LIMIT 1),'1206961922ESPA',@wid_3);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1),( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address' LIMIT 1),'1206961911NYAR',@wid_3);