/*Export of the extension catalog.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1206732365OQJI','1257243215EFTP','1274069015PAEF','1206961869IGND','1206961936HCWM','1206732392OZVB','1206732392OZVG','1242282445BFOC','1263009962GUBB','1304253972QWCK','1206961911NYAN','1206961996STBF','1260242517PUPK','1206961996STBG','1206961911NYAP','1299679334KKDF','1305262836FVNQ','1240888718QMAF','1314356569KRWI','1206732372QTKR','1337142843EQKV','1220793715LTKS','1206732411EGQQ','1220793707SOED','1206732411EGRU','1206732400OXCG','1206732412DAGD','1206732421RJQC','1233642085PNTA','1377829024SGVX','1377829024SGVY','1377829024SGVZ','1377829024SGWA','1373216472CELB','1377829024SGWB','1382068744SDQA','1242282447PGIE','1418425903PUFF','1382068744SDQC','1418425903PUFG','1382068744SDQD','1422551410GYSX','1242282412EEQP','1383926465JMKU','1206961922ESOX','1206961922ESPA','1395715518SVNL','1398366200CQIB','1418425903PUFH','1308888990BUDU','1206732423RNTL','1412810072CYUB','1418425903PUFI','1304525968YBL','1206961996STBE','1314356574CWTZ','1369751040JKYL','1377829025LPSD','1377829025LPSE','1377829025LPSF','1377829025LPSG','1398366308BYCL','1377829025LPSI','1383926466MFHG','1382068744SDQF','1382068744SDQG','1422551410GYSY','1383926466MFHH','1383926466MFHI','1398366308BYCM','1377829025LPSH','1398366308BYCN','1412810072CYUC','1242282449PIPC','1228820287MBVC','1337142843EQKU','1206732405TIXA','1206732405TIXB','1206732361LXFD','1206732361LXFE','1206732372QTKK','1206732399EINF','1206732372QTKL','1206732392OZUP','1206732400OWXC','1206732399EINB','1206732393CXVV','1396671201CESO','1206732391QBUR','1257243217NMXH','1206961911NYAK','1206961996STAV','1257243217NMXI','1206961995OYFZ','1208194156GWQH','1246243851IGLH','1260525862SZWB','1263480669ALUN','1206961879ZPV','1257243218GPNH','1206961936HCWR','1221228435BYUA','1215603987EKZQ','1206732392OZVA','1206961936HCWJ','1206732372QTKN','1211811583DBTA','1241506531DZAL','1206732400OWXG','1206961911NYAJ','1206961996STAF','1206732366OVMC','1231158811CQTV','1206732392OZVD','1206961854HENV','1206732412DAEO','1256629159GBCH','1246518570RHDZ','1206961996STAE','1258793662GTJM','1206734818GVVM','1237279953JKRV','1257243216EZSY','1206961995OYEW','1206961995OYES','1207846305OLYS','1304253971PIKJ','1340148835KAVE','1257243220BKUA','1251253307TGGG','1206732411EGQO','1206732431CQBG','1304528962BBKI','1305262842ORST','1337142845IUSU','1206961997BSZK','1369751040JKYM','1373216618BXTU','1377829025LPSJ','1382068744SDQH','1412810072CYUD','1257243215EFTS','1397876875IFBX','1373216617PSME','1373216617PSMF','1373216617PSMG','1373216617PSMH','1422551411THJZ','1422568699KCSF','1420682141FBXO','1426131994AWRI','1298350963FZPI','1298350963FZPJ','1298350963FZPK','1298350963FZPL','1298350963FZPM','1308827362DZPN','1314356578MCIW','1337142845IUSV','1337142845IUSW','1337142845IUSX','1369751041RZAC','1369751041RZAD','1206732411EGSA','1298350963FZPN','1369751041RZAE','1380027886ELRK','1380027886ELRL','1219856743ELFT','1206732392OZUV','1206732410ICCJ','1206732421RJQW','1206961854HENY','1206961870KLAD','1206961870KLAF','1206961954EAMT','1206961954EAMU','1211811587EZNL','1219769904NDIK','1219769913SSOH','1227580115NTZC','1227580983RNJM','1228709711HLFW','1240388999GQSW','1241592274CBNQ','1242282415NZTN','1242282416HAPS','1242282416HAPT','1257243215EFTI','1257243215EFTU','1298350856KAZP','1298350868MINW','1298350952HBRP','1298350953EMXE','1298350953EMXF','1298350953EMXG','1298507271ARKT','1304253943KWEJ','1304253944ERYB','1304526870NAKE','1304526971HCDU','1304526973ACEV','1304527165QGOS','1304918557EIYL','1305198010FCNE','1305198010FCNF','1307083039FLMV','1307606755CNOQ','1307606756SRYP','1307606756SRYQ','1308888986AJEG','1308888992TDMY','1310465461SODV','1310465461SODW','1310465461SODX','1310465461SODY','1311592756JOUI','1314356540SWBD','1314356541MEMH','1314356550DDJA','1316670030MXBL','1317275062QZVL','1328998982ELSR','1329161759BGNY','1329167048IDAO','1329167048IDAP','1329167048IDAQ','1329167048IDAR','1329167048IDAS','1329167048IDAT','1329167048IDAU','1330393750MKNF','1337142832RTXT','1337142833PRBG','1337142833PRBH','1338493593SACO','1338493593SACP','1338493593SACQ','1338493593SACR','1338493594RCKG','1340850244HVHU','1341517732AHOH','1351633860HQEN','1351876536QFDB','1369751032MHQT','1369751032MHQU','1369751032MHQV','1369751032MHQW','1369751032MHQY','1369751035FRTG','1369751035FRTH','1373216613LQOL','1373216613LQOM','1373904180MYWC','1373904181EMBL','1375896154QSFL','1382068739BXVL','1382068739BXVM','1382068739BXVN','1395715485CICC','1395715489LVAP','1398702488PGTJ','1398811857OWHA','1398811857OWHB','1404917846GHCT','1404917846GHCU','1404917848OWCY','1405649272JBFN','1410373233CVZM','1412376020TDFY','1412810068PUSV','1412810070CKJS','1415146133GKRN','1418425899SRHO','1418425899SRHP','1420549772RZVB','1420549772RZVC','1431384452JEQE' );
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','dropset.valuestrans','eguillage.trans','mailing.trans') AND `#__dataset_columns`.`namekey` NOT IN ('382mgid','382lgid','382name','382ctext','382chtml','382smail','382sname','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','382rname','382remail','541vid','541name','541lgid','481wname','481wdescription','714ctrid','714lgid','name714','description714','description485','auto382','fromlgid382','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto714','fromlgid714','bouncemail382','authorid382','modified382','intro382','smsmessage382','title382','subtitle382','message485') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('catalog.node') ;
SET @rolid_0 = (1);
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_306 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1 );
SET @pk_549_310 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.node' LIMIT 1 );
SET @pk_549_1014 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1 );
SET @pk_549_200 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1 );
SET @pk_549_338 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1 );
SET @pk_549_309 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1 );
SET @pk_549_314 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.type' LIMIT 1 );
SET @pk_549_335 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.trans' LIMIT 1 );
SET @pk_549_928 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.price' 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_324 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.images' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_652 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.node' LIMIT 1 );
SET @pk_549_923 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.typetrans' LIMIT 1 );
SET @pk_549_989 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.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_976 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='item.terms' 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 ('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('product_node','product.node',@pk_549_306,'','1.0.0',@rolid_0,'0','1','pid','node','product','51','2','0','0','7'),('productcat_node','productcat.node',@pk_549_310,'','1.0.0',@rolid_0,'0','40','catid','node','productcat','51','2','0','0','7'),('widgets_node','widgets.node',@pk_549_1014,'','',@rolid_0,'0','1','widgetid','','','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'),('productcat_product','productcat.product',@pk_549_338,'','1.0.0',@rolid_0,'0','30','catid,pid','product','productcat','51','2','0','0','7'),('product_trans','product.trans',@pk_549_309,'','1.0.0',@rolid_0,'0','20','pid,lgid','trans','product','51','2','0','0','5'),('product_type','product.type',@pk_549_314,'','1.0.0',@rolid_0,'0','1','prodtypid','type','product','51','2','0','0','7'),('productcat_trans','productcat.trans',@pk_549_335,'','1.0.0',@rolid_0,'0','20','catid,lgid','trans','productcat','51','2','0','0','7'),('product_price','product.price',@pk_549_928,'','',@rolid_0,'0','1','priceid','price','product','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_images','product.images',@pk_549_324,'','1.0.0',@rolid_0,'0','30','filid,pid','images','product','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'),('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('vendor_node','vendor.node',@pk_549_652,'','',@rolid_0,'0','1','vendid','node','vendor','51','1','0','0','7'),('product_typetrans','product.typetrans',@pk_549_923,'','',@rolid_0,'0','20','prodtypid,lgid','typetrans','product','51','0','0','0','7'),('vendor_trans','vendor.trans',@pk_549_989,'','',@rolid_0,'0','20','vendid,lgid','','','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'),('item_terms','item.terms',@pk_549_976,'','',@rolid_0,'0','1','termid','','','51','2','0','0','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`='mailing.trans' 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_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');
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_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_1,'name','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','382name','1','0','0'),(@pk_616_2218,@dbtid_1,'ctext','0','0','19','0','1','','8','1',@rolid_0,'0','0','1','382ctext','1','0','0'),(@pk_616_2219,@dbtid_1,'chtml','0','0','19','0','1','','7','1',@rolid_0,'0','0','1','382chtml','1','0','0'),(@pk_616_8616,@dbtid_1,'bouncemail','0','1','14','0','1','','11','0','0','0','100','1','bouncemail382','1','0','0'),(@pk_616_8617,@dbtid_1,'authorid','0','1','4','1','1','0','14','0','0','0','0','1','authorid382','1','0','0'),(@pk_616_8618,@dbtid_1,'modified','0','1','4','1','1','0','15','0','0','0','0','1','modified382','1','1','0'),(@pk_616_8678,@dbtid_1,'intro','0','1','16','0','1','','6','0','0','0','0','1','intro382','1','0','0'),(@pk_616_10120,@dbtid_1,'smsmessage','0','1','16','0','1','','16','0','0','0','0','1','smsmessage382','1','0','0'),(@pk_616_10801,@dbtid_1,'title','0','1','14','0','1','','17','0','0','0','255','1','title382','1','0','0'),(@pk_616_10802,@dbtid_1,'subtitle','0','1','14','0','1','','18','0','0','0','255','1','subtitle382','1','0','0');
SET @pk_5_1486 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='catalog.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='catalog',`wid`=@pk_5_1486,`params`='',`status`='1',`type`='150',`name`='Catalog',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='catalog.node',`version`='2777',`lversion`='2777',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='catalog.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','catalog',@pk_5_1486,'','1','150','Catalog','node','0','1','0','catalog.node','2777','2777','1','','1','1','0');

SET @pk_621_306 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product' LIMIT 1 );
SET @pk_621_1091 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item' LIMIT 1 );
SET @pk_621_1099 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.category' LIMIT 1 );
SET @pk_621_1180 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1 );
SET @pk_621_200 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='countries' LIMIT 1 );
SET @pk_621_310 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.category' LIMIT 1 );
SET @pk_621_1100 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.categoryitem' LIMIT 1 );
SET @pk_621_309 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='producttrans' LIMIT 1 );
SET @pk_621_314 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.type' LIMIT 1 );
SET @pk_621_1034 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.price' LIMIT 1 );
SET @pk_621_1101 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.categorytrans' LIMIT 1 );
SET @pk_621_324 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.images' LIMIT 1 );
SET @pk_621_90 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='files' LIMIT 1 );
SET @pk_621_338 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.categoryproduct' LIMIT 1 );
SET @pk_621_644 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='vendor' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_1088 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.type' LIMIT 1 );
SET @pk_621_1089 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.typetrans' LIMIT 1 );
SET @pk_621_1092 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='itemtrans' LIMIT 1 );
SET @pk_621_1097 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.images' LIMIT 1 );
SET @pk_621_1106 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.price' LIMIT 1 );
SET @pk_621_1134 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='vendortrans' LIMIT 1 );
SET @pk_621_1026 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='auction' LIMIT 1 );
SET @pk_621_1086 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.terms' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_306,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),`path`='1',`namekey`='product',`folder`='product',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\ngrptable=product.categoryproduct\ncachedata=1\nautofld=1\ncategorymodel=product.category',`alias`='',`prefix`='product',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-laptop',`pnamekey`='' WHERE  `namekey`='product';
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_306,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),'1','product','product',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\ngrptable=product.categoryproduct\ncachedata=1\nautofld=1\ncategorymodel=product.category','','product','1','0','1','fa-laptop','');
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','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1099,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.node' LIMIT 1),`path`='1',`namekey`='item.category',`folder`='item.category',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=parent\nprtname=item.categorytrans\ncachedata=1\nautofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='item.category';
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_1099,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.node' LIMIT 1),'1','item.category','item.category',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=parent\nprtname=item.categorytrans\ncachedata=1\nautofld=1','','item','0','0','1','fa-folder-open','');
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_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_310,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.node' LIMIT 1),`path`='1',`namekey`='product.category',`folder`='product.category',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=parent\nprtname=product.categorytrans\nautofld=1',`alias`='',`prefix`='productcat',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='product.category';
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_310,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.node' LIMIT 1),'1','product.category','product.category',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=parent\nprtname=product.categorytrans\nautofld=1','','productcat','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1100,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),`path`='0',`namekey`='item.categoryitem',`folder`='item.categoryitem',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\nautofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='item.categoryitem';
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_1100,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),'0','item.categoryitem','item.categoryitem',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\nautofld=1','','item','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_309,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),`path`='0',`namekey`='producttrans',`folder`='producttrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=product',`alias`='',`prefix`='product',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-laptop',`pnamekey`='' WHERE  `namekey`='producttrans';
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_309,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),'0','producttrans','producttrans',@rolid_0,'0','1','0','0','\nmainmodel=product','','product','0','0','1','fa-laptop','');
UPDATE `#__model_node`  SET `sid`=@pk_621_314,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.type' LIMIT 1),`path`='0',`namekey`='product.type',`folder`='product.type',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\ncachedata=1\nautofld=1',`alias`='',`prefix`='product',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='product.type';
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_314,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.type' LIMIT 1),'0','product.type','product.type',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\ncachedata=1\nautofld=1','','product','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1034,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.price' LIMIT 1),`path`='1',`namekey`='product.price',`folder`='product.price',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\nautofld=1',`alias`='',`prefix`='product',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-usd',`pnamekey`='' WHERE  `namekey`='product.price';
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_1034,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.price' LIMIT 1),'1','product.price','product.price',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\nautofld=1','','product','0','0','1','fa-usd','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1101,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.trans' LIMIT 1),`path`='0',`namekey`='item.categorytrans',`folder`='item.categorytrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=item.category',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='item.categorytrans';
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_1101,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.trans' LIMIT 1),'0','item.categorytrans','item.categorytrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=item.category','','item','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_324,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.images' LIMIT 1),`path`='0',`namekey`='product.images',`folder`='product.images',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=pid',`alias`='',`prefix`='product',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-picture-o',`pnamekey`='item.images' WHERE  `namekey`='product.images';
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_324,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.images' LIMIT 1),'0','product.images','product.images',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=pid','','product','0','0','1','fa-picture-o','item.images');
UPDATE `#__model_node`  SET `sid`=@pk_621_90,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),`path`='1',`namekey`='files',`folder`='files',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='files';
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_90,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),'1','files','files',@rolid_0,'0','1','0','0','autofld=1','','joobi','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_338,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),`path`='0',`namekey`='product.categoryproduct',`folder`='product.categoryproduct',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\nautofld=1',`alias`='',`prefix`='productcat',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='product.categoryproduct';
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_338,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),'0','product.categoryproduct','product.categoryproduct',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\nautofld=1','','productcat','0','0','1','fa-folder-open','');
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_1015,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='users';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1015,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1088,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.type' LIMIT 1),`path`='1',`namekey`='item.type',`folder`='item.type',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\ncachedata=1\nautofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='item.type';
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_1088,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.type' LIMIT 1),'1','item.type','item.type',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\ncachedata=1\nautofld=1','','item','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1089,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.typetrans' LIMIT 1),`path`='0',`namekey`='item.typetrans',`folder`='item',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=item.type',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='item.typetrans';
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_1089,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.typetrans' LIMIT 1),'0','item.typetrans','item',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=item.type','','item','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1092,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),`path`='0',`namekey`='itemtrans',`folder`='item.trans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=item',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-bookmark',`pnamekey`='' WHERE  `namekey`='itemtrans';
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_1092,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),'0','itemtrans','item.trans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=item','','item','0','0','1','fa-bookmark','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1097,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.images' LIMIT 1),`path`='1',`namekey`='item.images',`folder`='item.images',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=ordering\nautofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-picture-o',`pnamekey`='' WHERE  `namekey`='item.images';
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_1097,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.images' LIMIT 1),'1','item.images','item.images',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=ordering\nautofld=1','','item','0','0','1','fa-picture-o','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1106,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.price' LIMIT 1),`path`='0',`namekey`='item.price',`folder`='item.price',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\nautofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-usd',`pnamekey`='' WHERE  `namekey`='item.price';
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_1106,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.price' LIMIT 1),'0','item.price','item.price',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\nautofld=1','','item','0','0','1','fa-usd','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1134,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.trans' LIMIT 1),`path`='0',`namekey`='vendortrans',`folder`='vendor',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=vendor',`alias`='',`prefix`='vendor',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-user-md',`pnamekey`='' WHERE  `namekey`='vendortrans';
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_1134,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='vendor.trans' LIMIT 1),'0','vendortrans','vendor',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=vendor','','vendor','0','0','1','fa-user-md','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1026,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),`path`='1',`namekey`='auction',`folder`='auction',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1\ncategorymodel=product.category',`alias`='',`prefix`='auction',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-gavel',`pnamekey`='' WHERE  `namekey`='auction';
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_1026,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),'1','auction','auction',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1\ncategorymodel=product.category','','auction','1','0','1','fa-gavel','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1086,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='item.terms' LIMIT 1),`path`='1',`namekey`='item.terms',`folder`='item.terms',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='item',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-legal',`pnamekey`='' WHERE  `namekey`='item.terms';
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_1086,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='item.terms' LIMIT 1),'1','item.terms','item.terms',@rolid_0,'0','1','0','0','autofld=1','','item','0','0','1','fa-legal','');

SET @wid_2 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='catalog.node' LIMIT 1);
SET @wid_3 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='item.node' LIMIT 1);
SET @sid_4 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item' LIMIT 1);
SET @sid_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.category' LIMIT 1);
SET @sid_6 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product' LIMIT 1);
SET @sid_7 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1);
SET @sid_8 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.images' LIMIT 1);
SET @rolid_9 = (13);
SET @rolid_10 = (3);
SET @sid_11 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.categoryproduct' LIMIT 1);
SET @sid_12 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.type' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_advancesearch_module' LIMIT 1);
SET @yid_14 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_filter_form' LIMIT 1);
SET @yid_15 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_item_search' LIMIT 1);
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_page_category' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_home_main' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_price_quantity' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_item_syndication' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_wall_comment' LIMIT 1);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_home_search' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_search_module' LIMIT 1);
SET @did_24 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='catalog_radius_search' LIMIT 1);
SET @did_25 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='catalog_advance_search_auto_hide_widget' LIMIT 1);
SET @sid_26 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.categorytrans' LIMIT 1);
SET @sid_27 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='producttrans' LIMIT 1);
SET @ref_yid_28 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_home_items' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='catalog_advancesearch_module_fields_standard' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('catalog_advancesearch_module_search_name','catalog_advancesearch_module_search_introduction','catalog_advancesearch_module_search_description','catalog_advancesearch_module_ordering_name') LIMIT 4;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='catalog_filter_form_tab' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('catalog_filter_form_filter') LIMIT 1;
SET @yid_29 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_listing_item' LIMIT 1);
SET @rolid_30 = (21);
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_product_front_listing' LIMIT 1);
SET @yid_32 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_product_listing_div_fe' LIMIT 1);
SET @yid_33 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='catalog_search_listing' LIMIT 1);
SET @yid_34 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='product_subimg_listing' LIMIT 1);
SET @yid_35 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='str_front_img' LIMIT 1);
SET @sid_36 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='itemtrans' LIMIT 1);
SET @sid_37 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='item.images' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='product_listing_div_fe_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('product_listing_div_fe_producttrans_introduction_1','product_listing_div_fe_producttrans_name','product_listing_div_fe_product_vendid','product_listing_div_fe_product_price','product_listing_div_fe_product_pid','product_listing_div_fe_product_comment') LIMIT 6;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='product_front_listing_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('product_front_listing_users_name','product_front_listing_producttrans_name','product_front_listing_product_price') LIMIT 3;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='product_front_listing_producttrans_introduction' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('product_front_listing_producttrans_description') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='product_front_listing_rating' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('product_front_listing_product_comment') LIMIT 1;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='product_listing_div_fe_producttrans_introduction_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('product_listing_div_fe_producttrans_introduction') LIMIT 1;
SET @p_3_5 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_search_listing_itemtrans_nameheader' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_5 WHERE `namekey` IN ('catalog_search_listing_itemtrans_name','catalog_search_listing_itemtrans_introduction','catalog_search_listing_vendors_name','catalog_search_listing_itemtrans_description') LIMIT 4;
SET @p_3_6 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_search_listing_item_details' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_6 WHERE `namekey` IN ('catalog_search_listing_item_price','catalog_search_listing_item_score','catalog_search_listing_item_nbreviews','catalog_search_listing_item_modified') LIMIT 4;
SET @p_3_7 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_listing_item_item_name_column' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_7 WHERE `namekey` IN ('catalog_listing_item_item_name','catalog_listing_item_item_desccription','catalog_listing_item_item_alias','catalog_listing_item_item_namekey','catalog_listing_item_item_typename','catalog_listing_item_item_vendor_name') LIMIT 6;
SET @p_3_8 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_listing_item_item_properties' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_8 WHERE `namekey` IN ('catalog_listing_item_item_price','catalog_listing_item_item_availablestart','catalog_listing_item_item_publishstart','catalog_listing_item_item_publishend','catalog_listing_item_product_stock') LIMIT 5;
SET @p_3_9 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_listing_item_item_categories' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_9 WHERE `namekey` IN ('catalog_listing_item_item_numcat','catalog_listing_item_item_relnum') LIMIT 2;
SET @p_3_10 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='catalog_listing_item_hits' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_10 WHERE `namekey` IN ('catalog_listing_item_hits_nested','catalog_listing_item_product_hits_statistics') LIMIT 2;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE'),('Search','1','1206732365OQJI'),('Start','1','1206732366OVMC'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Publish','1','1206732372QTKN'),('Item','1','1206732372QTKR'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('Contact Us','1','1206732392OZUV'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Type','1','1206732392OZVD'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('Send','1','1206732400OWXC'),('ID','1','1206732400OWXG'),('Subject','1','1206732400OXCG'),('Import','1','1206732405TIXA'),('Export','1','1206732405TIXB'),('None','1','1206732410ICCJ'),('Category','1','1206732411EGQO'),('Categories','1','1206732411EGQQ'),('Email','1','1206732411EGRU'),('Subscription','1','1206732411EGSA'),('Access','1','1206732412DAEO'),('Body','1','1206732412DAGD'),('Location','1','1206732421RJQC'),('Ordering','1','1206732421RJQW'),('Filter','1','1206732423RNTL'),('Home','1','1206732431CQBG'),('Statistics','1','1206734818GVVM'),('Properties','1','1206961854HENV'),('Views','1','1206961854HENY'),('hidden','1','1206961869IGND'),('Width','1','1206961870KLAD'),('Height','1','1206961870KLAF'),('Updated','1','1206961879ZPV'),('SKU','1','1206961911NYAJ'),('pid','1','1206961911NYAK'),('Price','1','1206961911NYAN'),('Quantity','1','1206961911NYAP'),('Zip Code','1','1206961922ESOX'),('Country','1','1206961922ESPA'),('Picture','1','1206961936HCWJ'),('Image','1','1206961936HCWM'),('Details','1','1206961936HCWR'),('items','1','1206961954EAMT'),('Unlimited','1','1206961954EAMU'),('Product page subimages','1','1206961995OYES'),('Listing of products frontend list','1','1206961995OYEW'),('sub img','1','1206961995OYFZ'),('Stock','1','1206961996STAE'),('Available','1','1206961996STAF'),('Available since','1','1206961996STAV'),('Click here to add that product to the basket','1','1206961996STBE'),('Add to cart','1','1206961996STBF'),('Available options','1','1206961996STBG'),('Catalog','1','1206961997BSZK'),('product page image','1','1207846305OLYS'),('img','1','1208194156GWQH'),('Alias','1','1211811583DBTA'),('Preview','1','1211811587EZNL'),('Introduction','1','1215603987EKZQ'),('Alphabetic','1','1219769904NDIK'),('Pick-list','1','1219769913SSOH'),('0','1','1219856743ELFT'),('Types','1','1220793707SOED'),('Vendors','1','1220793715LTKS'),('Vendor','1','1221228435BYUA'),('Share','1','1227580115NTZC'),('Out of stock','1','1227580983RNJM'),('Badge','1','1228709711HLFW'),('Close','1','1228820287MBVC'),('Expire','1','1231158811CQTV'),('Items','1','1233642085PNTA'),('number of categories for this product','1','1237279953JKRV'),('download','1','1240388999GQSW'),('Total Price','1','1240888718QMAF'),('Hits','1','1241506531DZAL'),('Random','1','1241592274CBNQ'),('Item Description','1','1242282412EEQP'),('Most Popular','1','1242282415NZTN'),('Print','1','1242282416HAPS'),('Read more','1','1242282416HAPT'),('SEO','1','1242282445BFOC'),('Item Name','1','1242282447PGIE'),('Done','1','1242282449PIPC'),('Rating','1','1246243851IGLH'),('Approved','1','1246518570RHDZ'),('Categories List','1','1251253307TGGG'),('Featured','1','1256629159GBCH'),('Highest Rated','1','1257243215EFTI'),('Find','1','1257243215EFTP'),('Product Search','1','1257243215EFTS'),('Most Reviewed','1','1257243215EFTU'),('Add product to featured product list','1','1257243216EZSY'),('Short Description','1','1257243217NMXH'),('by','1','1257243217NMXI');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Reviews','1','1257243218GPNH'),('Listing of Products (frontend) - div','1','1257243220BKUA'),('Related','1','1258793662GTJM'),('Special Offers','1','1260242517PUPK'),('number','1','1260525862SZWB'),('rss','1','1263009962GUBB'),('Add to Cart','1','1263480669ALUN'),('Sub Categories','1','1274069015PAEF'),('Access to this page is restricted','1','1298350856KAZP'),('There is no product type available, please create at least one product type before creating a product.','1','1298350868MINW'),('The item Id is not specified in the link you clicked on. You have been redirected to the Home page.','1','1298350952HBRP'),('Favorite','1','1298350953EMXE'),('Wish','1','1298350953EMXF'),('Watch','1','1298350953EMXG'),('Display an Item','1','1298350963FZPI'),('Category Page in Frontend','1','1298350963FZPJ'),('Place a bid for auction','1','1298350963FZPK'),('Catalog Home Page','1','1298350963FZPL'),('Catalog Home Search','1','1298350963FZPM'),('Display an Item or product ( End-User ).<br>','1','1298350963FZPN'),('Vendor Name','1','1298507271ARKT'),('Booking','1','1299679334KKDF'),('Review','1','1304253943KWEJ'),('Item Type','1','1304253944ERYB'),('Featured Items','1','1304253971PIKJ'),('Items Search','1','1304253972QWCK'),('','1','1304525968YBL'),('Ask Question','1','1304526870NAKE'),('Carrousel','1','1304526971HCDU'),('Sub-Categories','1','1304526973ACEV'),('Bestselling','1','1304527165QGOS'),('Category Items','1','1304528962BBKI'),('Latest','1','1304918557EIYL'),('Highest Price','1','1305198010FCNE'),('Lowest Price','1','1305198010FCNF'),('Buy Shares','1','1305262836FVNQ'),('Product Price Quantity','1','1305262842ORST'),('View Inbox','1','1307083039FLMV'),('Oldest','1','1307606755CNOQ'),('Reverse Alphabetic','1','1307606756SRYP'),('Recently Updated','1','1307606756SRYQ'),('List of Items in the catalog','1','1308827362DZPN'),('Just Sold','1','1308888986AJEG'),('Tab','1','1308888990BUDU'),('No item found!','1','1308888992TDMY'),('No refund allowed.','1','1310465461SODV'),('days money back guarantee.','1','1310465461SODW'),('Privacy policy','1','1310465461SODX'),('Terms & conditions','1','1310465461SODY'),('Any category','1','1311592756JOUI'),('Syndicate Item','1','1314356540SWBD'),('Resell Product','1','1314356541MEMH'),('No items to display','1','1314356550DDJA'),('Choose Category','1','1314356569KRWI'),('Choose a category where to assign the syndicated item.<br>','1','1314356574CWTZ'),('Syndicate an item','1','1314356578MCIW'),('Vendor needs to create at least one category to use the syndication feature.','1','1316670030MXBL'),('Contact Us for Price','1','1317275062QZVL'),('Free Shipping','1','1328998982ELSR'),('The download is restricted!','1','1329161759BGNY'),('The access to this item is restricted!','1','1329167048IDAO'),('This item is not yet published!','1','1329167048IDAP'),('This item is not yet approved by the Store Manager!','1','1329167048IDAQ'),('This item is not yet published because the Start Display date has not yet arrived!','1','1329167048IDAR'),('This item is not published because the End Display date has passed!','1','1329167048IDAS'),('Only you see the item because you are the vendor of this item.','1','1329167048IDAT'),('Only you and the vendor can see the item because you are the Store Manager.','1','1329167048IDAU'),('Shipping: pickup item','1','1330393750MKNF'),('Like','1','1337142832RTXT'),('Your comment has been posted on the wall!','1','1337142833PRBG'),('Your comment is empty!','1','1337142833PRBH'),('Post Comment','1','1337142843EQKU'),('Wall Comment','1','1337142843EQKV'),('Post a comment to the wall','1','1337142845IUSU'),('Post a comment on the wall','1','1337142845IUSV'),('Save a comment on the wall','1','1337142845IUSW'),('Cancel post comment','1','1337142845IUSX'),('{tag:actor} posted the following comment about vendor $VENDOR_NAME{multiple} {count} times{/multiple}.','1','1338493593SACO'),('{tag:actor} posted the following comment about category $CATEGORY_NAME{multiple} {count} times{/multiple}.','1','1338493593SACP'),('{tag:actor} posted the following comment about item $ITEM_NAME{multiple} {count} times{/multiple}.','1','1338493593SACQ'),('{tag:actor} visited category $CATEGORY_NAME{multiple} {count} times{/multiple}.','1','1338493593SACR'),('{tag:actor} visited item $ITEM_NAME{multiple} {count} times{/multiple}.','1','1338493594RCKG'),('Item Search','1','1340148835KAVE'),('Sub-Category','1','1340850244HVHU'),('Return policy','1','1341517732AHOH'),('Social buttons','1','1351633860HQEN'),('Item name','1','1351876536QFDB'),('Please specify an email address.','1','1369751032MHQT'),('Please specify a subject.','1','1369751032MHQU'),('Please specify a text for the body of the email.','1','1369751032MHQV'),('Please specify an email address!','1','1369751032MHQW'),('An email has been sent to your friend with the item information','1','1369751032MHQY'),('$NAME thought you might be interested by this item: $ITEMNAME','1','1369751035FRTG'),('Hi, <br /><br />Check this item out: $ITEMNAME <br /><br />Here is the link: $LINK <br /><br />','1','1369751035FRTH'),('Enter the email of your friend.<br>Note: to send to several friends simply enter several emails, separated by a comma.<br>','1','1369751040JKYL'),('Email a friend','1','1369751040JKYM'),('Send page to a friend','1','1369751041RZAC'),('Display email to send to a friend','1','1369751041RZAD'),('Send an email to a friend.<br>','1','1369751041RZAE'),('Location Filter','1','1373216472CELB'),('Search results','1','1373216613LQOL');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('No result found!','1','1373216613LQOM'),('25 Km','1','1373216617PSME'),('10 Km','1','1373216617PSMF'),('50 Km','1','1373216617PSMG'),('100 Km','1','1373216617PSMH'),('Catalog Search','1','1373216618BXTU'),('Items\' Location','1','1373904180MYWC'),('Vendors\' Location','1','1373904181EMBL'),('Enter a location...','1','1375896154QSFL'),('Search Box Size','1','1377829024SGVX'),('Item Types picklist','1','1377829024SGVY'),('Categories picklist','1','1377829024SGVZ'),('Vendors picklist','1','1377829024SGWA'),('Itemid for search result','1','1377829024SGWB'),('Define the size of the search box','1','1377829025LPSD'),('Yes to show the Item Types picklist.','1','1377829025LPSE'),('Yes to show the Categories picklist.','1','1377829025LPSF'),('Yes to show the Vendors picklist.','1','1377829025LPSG'),('Yes to show a zip code search box to search for item in a certain area.','1','1377829025LPSH'),('Optional: define an Itemid for the result page of the search.','1','1377829025LPSI'),('Catalog search','1','1377829025LPSJ'),('{widget:param|name=subject}','1','1380027886ELRK'),('<p>{widget:param|name=body}</p>','1','1380027886ELRL'),('Search in the $NAME','1','1382068739BXVL'),('Ordering for $NAME','1','1382068739BXVM'),('Define what is the order in the filer list.','1','1382068739BXVN'),('Smart Filter','1','1382068744SDQA'),('Ordering for Name','1','1382068744SDQC'),('Attributes Fields','1','1382068744SDQD'),('Search in the item name<br>','1','1382068744SDQF'),('Define what is the order in the filer list.<br>','1','1382068744SDQG'),('Advance Search','1','1382068744SDQH'),('Item Introduction','1','1383926465JMKU'),('Define if the field get automatically added or removed based on the item type selected.<br>','1','1383926466MFHG'),('Search in the item description<br>','1','1383926466MFHH'),('Search in the item introduction<br>','1','1383926466MFHI'),('Add New Item','1','1395715485CICC'),('Dislike','1','1395715489LVAP'),('Zip Code Filter','1','1395715518SVNL'),('Assign a Vendor','1','1396671201CESO'),('<p>You can only search products here.</p>','1','1397876875IFBX'),('Country Filter','1','1398366200CQIB'),('Yes to show an address box and a distance picklist to search for item in a certain location.','1','1398366308BYCL'),('Select a country from the pick list to force the zip code search in the selected country only','1','1398366308BYCM'),('Yes to show a country filter in the front end','1','1398366308BYCN'),('zip code...','1','1398702488PGTJ'),('Return period not specified, ask vendor for details.','1','1398811857OWHA'),('Item is refundable.','1','1398811857OWHB'),('Change Units','1','1404917846GHCT'),('Length','1','1404917846GHCU'),('Change Unit','1','1404917848OWCY'),('$NAME thought you might be interested by this item.','1','1405649272JBFN'),('The following email address is not valid: $EMAIL','1','1410373233CVZM'),('Ending Soon','1','1412376020TDFY'),('The Advance search widget needs to be turn on.','1','1412810068PUSV'),('See all','1','1412810070CKJS'),('Show \"See All\"','1','1412810072CYUB'),('Show a \"See All” link to bring a popup with all the possible filters<br><div><br></div>','1','1412810072CYUC'),('Advance Filters','1','1412810072CYUD'),('Available Date','1','1415146133GKRN'),('Vendor name','1','1418425899SRHO'),('Vendor badge','1','1418425899SRHP'),('Item Fields','1','1418425903PUFF'),('Item Custom Fields','1','1418425903PUFG'),('Vendor Fields','1','1418425903PUFH'),('Vendor Custom Fields','1','1418425903PUFI'),('Recently Viewed','1','1420549772RZVB'),('My Top Viewed','1','1420549772RZVC'),('Only Catalog Home','1','1420682141FBXO'),('Display on Pages','1','1422551410GYSX'),('Define where to show the advance search widget.','1','1422551410GYSY'),('Everywhere','1','1422551411THJZ'),('All Catalog Pages','1','1422568699KCSF'),('Category and Home','1','1426131994AWRI'),('Second Image','1','1431384452JEQE');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'2','1206732365OQJI'),(@wid_2,'1','1206732372QTKR'),(@wid_2,'1','1206732392OZUV'),(@wid_2,'1','1206732392OZVB'),(@wid_2,'1','1206732392OZVG'),(@wid_2,'1','1206732410ICCJ'),(@wid_2,'1','1206732411EGQQ'),(@wid_2,'1','1206732411EGRU'),(@wid_2,'1','1206732421RJQW'),(@wid_2,'1','1206961854HENY'),(@wid_2,'1','1206961870KLAD'),(@wid_2,'1','1206961870KLAF'),(@wid_2,'1','1206961911NYAN'),(@wid_2,'1','1206961954EAMT'),(@wid_2,'1','1206961954EAMU'),(@wid_2,'1','1206961996STAE'),(@wid_2,'1','1211811587EZNL'),(@wid_2,'1','1215603987EKZQ'),(@wid_2,'1','1219769904NDIK'),(@wid_2,'1','1219769913SSOH'),(@wid_2,'1','1220793715LTKS'),(@wid_2,'1','1227580115NTZC'),(@wid_2,'1','1227580983RNJM'),(@wid_2,'1','1228709711HLFW'),(@wid_2,'1','1233642085PNTA'),(@wid_2,'1','1240388999GQSW'),(@wid_2,'1','1241592274CBNQ'),(@wid_2,'1','1242282415NZTN'),(@wid_2,'1','1242282416HAPS'),(@wid_2,'1','1242282416HAPT'),(@wid_2,'1','1246243851IGLH'),(@wid_2,'1','1256629159GBCH'),(@wid_2,'1','1257243215EFTI'),(@wid_2,'1','1257243215EFTU'),(@wid_2,'1','1257243218GPNH'),(@wid_2,'1','1263480669ALUN'),(@wid_2,'0','1298350856KAZP'),(@wid_2,'0','1298350868MINW'),(@wid_2,'0','1298350952HBRP'),(@wid_2,'1','1298350953EMXE'),(@wid_2,'1','1298350953EMXF'),(@wid_2,'1','1298350953EMXG'),(@wid_2,'1','1298507271ARKT'),(@wid_2,'1','1304253943KWEJ'),(@wid_2,'1','1304253944ERYB'),(@wid_2,'1','1304526870NAKE'),(@wid_2,'1','1304526971HCDU'),(@wid_2,'1','1304526973ACEV'),(@wid_2,'1','1304527165QGOS'),(@wid_2,'1','1304918557EIYL'),(@wid_2,'1','1305198010FCNE'),(@wid_2,'1','1305198010FCNF'),(@wid_2,'1','1307083039FLMV'),(@wid_2,'1','1307606755CNOQ'),(@wid_2,'1','1307606756SRYP'),(@wid_2,'1','1307606756SRYQ'),(@wid_2,'1','1308888986AJEG'),(@wid_2,'1','1308888990BUDU'),(@wid_2,'1','1308888992TDMY'),(@wid_2,'1','1310465461SODV'),(@wid_2,'1','1310465461SODW'),(@wid_2,'1','1310465461SODX'),(@wid_2,'1','1310465461SODY'),(@wid_2,'1','1311592756JOUI'),(@wid_2,'1','1314356540SWBD'),(@wid_2,'1','1314356541MEMH'),(@wid_2,'1','1314356550DDJA'),(@wid_2,'0','1316670030MXBL'),(@wid_2,'1','1317275062QZVL'),(@wid_2,'1','1328998982ELSR'),(@wid_2,'0','1329161759BGNY'),(@wid_2,'0','1329167048IDAO'),(@wid_2,'0','1329167048IDAP'),(@wid_2,'0','1329167048IDAQ'),(@wid_2,'0','1329167048IDAR'),(@wid_2,'0','1329167048IDAS'),(@wid_2,'0','1329167048IDAT'),(@wid_2,'0','1329167048IDAU'),(@wid_2,'1','1330393750MKNF'),(@wid_2,'1','1337142832RTXT'),(@wid_2,'0','1337142833PRBG'),(@wid_2,'0','1337142833PRBH'),(@wid_2,'1','1338493593SACO'),(@wid_2,'1','1338493593SACP'),(@wid_2,'1','1338493593SACQ'),(@wid_2,'1','1338493593SACR'),(@wid_2,'1','1338493594RCKG'),(@wid_2,'1','1340850244HVHU'),(@wid_2,'1','1341517732AHOH'),(@wid_2,'1','1351633860HQEN'),(@wid_2,'1','1351876536QFDB'),(@wid_2,'0','1369751032MHQT'),(@wid_2,'0','1369751032MHQU'),(@wid_2,'0','1369751032MHQV'),(@wid_2,'0','1369751032MHQW'),(@wid_2,'0','1369751032MHQY'),(@wid_2,'1','1369751035FRTG'),(@wid_2,'1','1369751035FRTH'),(@wid_2,'1','1373216613LQOL'),(@wid_2,'1','1373216613LQOM'),(@wid_2,'1','1373904180MYWC');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'1','1373904181EMBL'),(@wid_2,'1','1375896154QSFL'),(@wid_2,'1','1382068739BXVL'),(@wid_2,'1','1382068739BXVM'),(@wid_2,'1','1382068739BXVN'),(@wid_2,'1','1395715485CICC'),(@wid_2,'1','1395715489LVAP'),(@wid_2,'2','1398702488PGTJ'),(@wid_2,'1','1398811857OWHA'),(@wid_2,'1','1398811857OWHB'),(@wid_2,'1','1404917846GHCT'),(@wid_2,'1','1404917846GHCU'),(@wid_2,'1','1404917848OWCY'),(@wid_2,'1','1405649272JBFN'),(@wid_2,'0','1410373233CVZM'),(@wid_2,'1','1412376020TDFY'),(@wid_2,'0','1412810068PUSV'),(@wid_2,'1','1412810070CKJS'),(@wid_2,'1','1415146133GKRN'),(@wid_2,'1','1418425899SRHO'),(@wid_2,'1','1418425899SRHP'),(@wid_2,'1','1420549772RZVB'),(@wid_2,'1','1420549772RZVC'),(@wid_2,'1','1431384452JEQE');
SET @yid_38 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='item_edit_item' LIMIT 1);
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('catalog_email_friend',@rolid_0,'1','2','',@wid_2,'Email a friend','25','{widget:param|name=subject}\r\n{widget:param|name=body}','1','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_2),'','','','','','','','','','','0','');
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1380027886ELRK',@wid_2);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1380027886ELRL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1219856743ELFT',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1219856743ELFT',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2),(( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1),( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='catalog_email_friend' LIMIT 1),'1304525968YBL',@wid_2);