/*Export of the extension main.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1212761242DPBP','1212761286RZAR','1206732388KEHZ','1206732390BJLA','1347652451NUQI','1206732389NXTF','1355852779ARKR','1357948997CAPK','1251697929ABZD','1377041435CPNQ','1377041435CPNR','1256875165AXAH','1256627132RZYQ','1206732366OVMC','1206732366OVMF','1256627132RZYR','1256875165AXAI','1256627133IVDA','1206732400OWXE','1260156216DOTJ','1206961869IGND','1206961869IGNC','1206732372QTKN','1398436917DTKC','1206732391QBUR','1421684732GOVY','1211811583DBTA','1206732346KLSC','1206732412DAGC','1206732392OZVG','1206961869IGNP','1206732412DAEO','1206732412DAEM','1219769904NDJG','1219769904NDIO','1206732392OZVD','1219769905FKRC','1206732392OZVB','1206961869IGNI','1206732388KEHV','1206732389NXTO','1213200894KHAM','1405349619AOWV','1349726937BUMN','1350048904IJUH','1349726937BUMK','1355852783DYRD','1225819494GKOC','1357309003EWPW','1357309003EWPX','1357309003EWPY','1206732400OWZR','1356733768PTQP','1233297975SESK','1206961869IGOF','1356733768PTQQ','1227580858CXTV','1206961870KLAJ','1206961870KLAD','1356733768PTQR','1206961877KAKC','1233298081OPDQ','1356733768PTQU','1356733768PTQV','1356733768PTQW','1356733768PTQX','1206732400OWYY','1206732421RJQZ','1356733768PTQY','1356733768PTQZ','1356733768PTRA','1309938358AMXW','1242282437ISIO','1356733768PTRB','1356733768PTRC','1206961868QEVB','1357296145DBZG','1357296145DBZH','1373209080EJXY','1206732411EGQO','1358294812QEQR','1358294812QEQS','1356733768PTQS','1206732390BJKP','1217601376NASF','1219769904NDIF','1219769904NDJE','1356733768PTQT','1242179632IZKM','1358294812QEQU','1358294812QEQV','1360166005IDUM','1360366419PVEQ','1360366419PVER','1219769910HXKO','1242282439OJUW','1206961882TDGU','1206961869IGNB','1206961869IGNE','1206961850KLRL','1206961899DDKS','1206732411EGRY','1347652452OQAE','1211811528BLZA','1377703397QFCW','1219769904NDJH','1379525590FHQN','1206732392OZUQ','1206732366OVLZ','1377703397QFCV','1242179630OEQT','1242282413PMNG','1234467596QADS','1380567395OUTL','1382068744SDQH','1394069593IQAS','1394069593IQAT','1400174181LTIR','1395886787SVJW','1407528942DMEQ','1407528942DMER','1206732366OVLY','1409709084ILIV','1409709084ILIW','1415125832CRQP','1415377877PTRF','1416948599JVQT','1302090354NZFX','1425007246IWYI','1392733055LQQF','1392733055LQQG','1220446694TBPU','1309938388REBZ','1206961912MJQB','1252569179LCYJ','1304525968YBL','1434680167LAGD','1421684733OMTP','1434680167LAGE','1347652452OQAI','1347652452OQAH','1356733768PTRF','1356733768PTRG','1358294813IZVY','1356733768PTRH','1356733768PTRI','1358294813IZVZ','1347652452OQAJ','1356733769MIBX','1356733769MIBY','1356733769MIBZ','1356733769MICA','1358294813IZWA','1384994595QDWU','1414104730SWZC','1356733769MICE','1356733769MICF','1405349619AOWW','1425489474KFSW','1356733769MICG','1356733769MICH','1219769906LJON','1219769906LJOM','1356733769MICI','1356733769MICJ','1356733769MICV','1356733769MICS','1356733769MICT','1357059111JYQD','1356733769MICW','1356733769MICX','1356733769MICY','1356733769MICZ','1356733769MIDA','1356733769MIDB','1356733769MIDC','1356733769MIDD','1356733769MIDE','1358294813IZWB','1358294813IZWC','1358508735IITK','1356733769MICN','1356733769MICL','1356733769MICM','1356733769MICP','1356733769MICQ','1356733769MICO','1356733769MICK','1358294813IZWE','1358294813IZWF','1360166005IDUN','1360366420ERXG','1379004885AWBD','1379004885AWBE','1398536034AXNW','1379004885AWBG','1379004885AWBH','1234467591PVUV','1377744895PJNN','1380064817JISO','1358294813IZWD','1380567396OSFZ','1380567396OSGA','1380567396OSGB','1356733769MICC','1400176087FPTT','1409690310HZWW','1407528942DMET','1409709084ILIX','1409709084ILIY','1409709084ILIZ','1409709084ILJA','1415125832CRQQ','1415378022OZRU','1434680167LAGF','1434764997FCPY','1434764997FCPZ','1434767164BOLQ','1206732361LXFE','1206732372QTKK','1206732372QTKL','1242282449PIPC','1206732399EINB','1206732393CXVV','1206732361LXFD','1206961882TDHA','1206732400OWXQ','1206732399EINF','1220793707SOED','1206732411EGRN','1206732392OZUP','1228820287MBVC','1408042170ATLE','1206732420EIUT','1217608861BKDT','1417652012LVWX','1206732392OZVA','1206732400OWXG','1206732400OWXH','1347652451NUQJ','1206961869IGNG','1206961869IGNA','1206961868QEYD','1206961850KLQZ','1236926427LMQA','1206732411EGRV','1206732425HINT','1206961850KLRI','1206732400OWZO','1379039272DOEH','1380567395OUTJ','1233298082QODE','1380567395OUTK','1242178314RNWI','1208359284QWNS','1230531895KYXK','1243392688MXHE','1217603897AYYA','1379004130IRAI','1379039272DOEI','1256627134RCAS','1340773357RFYR','1206961854HENY','1347652452OQAK','1347652452OQAL','1206732389NXTG','1347652452OQAM','1340666912COKC','1355852785AMCF','1225317223AXHH','1356733769MIDK','1206961869IGNO','1357296145DBZI','1373209081MPUH','1357948999CZIZ','1242822624LPVJ','1359067423AOHL','1359067423AOHM','1360193670QXOO','1206732392OZUO','1379614096IGWC','1221157725EYVU','1206961868QEYE','1206961868QEYF','1380567396OSGC','1379006374DSAT','1414744018EIML','1416665748MZJC','1242178310INQS','1425007249TGNU','1434764999FJEM','1347652452OQAO','1359486683BCQF','1340745649OCDR','1359486683BCQG','1359486683BCQH','1355852785AMCG','1380567396OSGD','1347652452OQAP','1418159573ASQG','1359486683BCQJ','1359486683BCQK','1359486683BCQL','1359486683BCQM','1355852786JPZC','1400171641CFYI','1357059110IPWM','1357059110IPWN','1349726937BUMG','1255339744MGTH','1246509032AGXF','1242282437ISFV','1379525589DYXL','1213180343CQIB','1206732410ICCJ','1380064816PMFL','1380064816PMFM','1380064816PMFN','1380228948FANI','1380228948FANJ','1380228948FANK','1229653442FEQZ','1233642085PNTA','1242282438KRJW','1380027946LBCD','1375971621IIJU','1220793715LTKS','1393515934QLIQ','1393515934QLIR','1393515934QLIS','1231731000EGWA','1206732372QTKI','1206732372QTKJ','1396671423GHXG','1396671423GHXH','1253939321KJPL','1242282413PMOC','1242282416HAPX','1234467597SEYB','1396671424DMOJ','1396671424DMOK','1396671424DMOL','1396671424DMOM','1400708937BNOL','1400708937BNOM','1396671424DMOP','1227581114PJBX','1242282444LHMW','1400708937BNON','1347896707AYYK','1400708937BNOO','1400708937BNOP','1402625931RQFO','1407528940CUSY','1406380323COMI','1406380323COMJ','1407528941QTXC','1242282449PIOD','1242282412EESC','1407528941QTXD','1407528941QTXE','1407528941QTXF','1360922680DLQR','1356715487MNCI','1242282448EVJO','1414744016SROW','1414744016SROX','1414744016SROY','1414744016SROZ','1414744016SRPA','1206732405TIXC','1415378020IIPY','1415378020IIPZ','1418398780RXKS','1405139930SCQX','1418398780RXKT','1421684737PPWJ','1421684737PPWK','1421684737PPWL','1421684737PPWM','1421684737PPWN','1421684737PPWO','1421684737PPWP','1421684737PPWQ','1424997302FRPR','1206961936HCWM','1425008364MFCI','1418690424RJPQ','1322125538SPUI','1370648554FHZC','1358508736RVYL','1391449458SRZS','1380064818QMSW','1380064818QMSX','1415678513OMNE','1415654678EXBP','1380064818QMSZ','1380064818QMSY','1219856743ELFT','1413480085HVBR','1415678513OMNF','1395500527LEDU','1425043740DAHV','1426258023BVGO','1425043740DAHW','1416948600KVDI','1423683949RWKE','1426258023BVGP','1425043741BMAQ','1356715487MNCJ','1356715487MNCK','1206732411EGRU','1304918318NWFN','1206732412DADP','1356715487MNCL','1219769913SSOH','1359067424EXKS','1434765001GPUG','1356715487MNCM','1356715487MNCN','1359067424EXKT','1356715487MNCP','1356715487MNCQ','1356715488JSXQ','1356715488JSXR','1356715488JSXS','1356715488JSXT','1356715488JSXU','1356715488JSXV','1418159573ASQH','1359067424EXKU','1359067424EXKV','1434765001GPUH','1206732357ILFK','1206732357ILFL','1206732357ILFM','1206732357ILFN','1206732363AOLD','1206732365OQJJ','1206732372QTKM','1206732372QTKR','1206732374FDLR','1206732399EIMV','1206732405TIXB','1206732406SEHE','1206732411EGRI','1206732412DACF','1206961869IGNH','1206961870KLBH','1206961899DDKO','1206961954EAMZ','1207306697RNME','1212761197FHZN','1213107666IZKC','1215507788CYDF','1219769904NDKA','1219769905FKPR','1224166212FTLB','1240888718QMAD','1241490506ODOB','1242179646EPJF','1242282415NZVT','1242282416HAQB','1242282417SQNH','1242282444LHMX','1242282444LHMY','1242282444LHMZ','1242282444LHNB','1242282450QJDL','1242282452RPKS','1246518570RHDZ','1256627134RCAT','1256627134RCAU','1256627134RCAV','1256627134RCAX','1256627134RCAY','1256627135RQMP','1256627135RQMQ','1256627135RQMR','1256627135RQMS','1256627135RQMT','1259308004LCOJ','1260434893HJHQ','1298294174MWVC','1299084287SIMJ','1302502965PLCE','1302519272IRLM','1303355093GUFG','1308292311QGYK','1310529911CSAV','1315191208QKMR','1315191208QKMS','1325473020QNJX','1327708944HAPH','1337266385HCKZ','1339210773JBLQ','1339210773JBLR','1339210951DJSU','1343426232QZMG','1343426232QZMH','1347652450ENIY','1347916591IUDQ','1348621436PSCH','1350003540HDZY','1356733766RKBF','1356733767TFPZ','1356733767TFQA','1356733767TFQB','1357059105KDVU','1357343462IBXT','1358294811IVXF','1358294811IVXH','1358294811IVXI','1358294811IVXK','1359165829EPZO','1359430178PKKA','1360240327QUAB','1360289390KMBD','1360289390KMBE','1360366414NJAI','1360366414NJAJ','1360366414NJAK','1360630221KYCU','1360711865IYJW','1360711865IYJX','1360922681PNPQ','1369749782AJAF','1370648536RVAD','1373209094YQB','1373935459SQDD','1374276934ANBO','1374608348GDGV','1374608348GDGW','1375977738AJMS','1375977738AJMT','1375977746FUII','1375977746FUIJ','1377041362DLCC','1377546988CHLS','1377546988CHLT','1379039266OOHC','1379039270QKLD','1380143302RHWW','1380143302RHWX','1380143302RHWZ','1391607531FXMD','1391607531FXME','1393290131DEFB','1395500509GSSS','1395500511PPJW','1395500511PPJX','1398110833SALX','1398110833SALY','1400811120SUCB','1400811120SUCC','1401377882ETOG','1401377882ETOH','1404917671CVDL','1408059813TBDS','1408059813TBDT','1410185409ETKT','1414093502MVHU','1416948592JPZB','1416948594GBIZ','1416948594GBJA','1416948594GBJB','1416948594GBJC','1416948594GBJD','1418159563RQJB','1419342002KFBC','1420121260PTWF','1420121260PTWG','1420854481TJBT','1420854481TJBU','1420854481TJBV','1423415282OGNM','1423415282OGNN','1424997296GVOP','1424997296GVOQ','1424997297STJG','1425922198CPJX','1433250437OEYO','1434036710ZKH','1434036710ZKI' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('layout.node','layout.mlinks','layout.listings','layout.multiforms','layout.trans','layout.multiformstrans','layout.listingstrans','layout.mlinkstrans','message.queue','credentials.node','credentials.type','widgets.node','widgets.trans','widgets.type','widgets.type.trans') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('layout.multiforms','layout.node','layout.listings','layout.mlinks','layout.trans','layout.multiformstrans','layout.listingstrans','layout.mlinkstrans','message.queue','credentials.node','credentials.type','widgets.node','widgets.trans','widgets.type','widgets.type.trans','dropset.node','extension.node','members.node','joobi.languages','mailing.node','theme.node','role.node','model.node','model.fields','captcha.node','model.trans','dropset.valuestrans','eguillage.trans','mailing.trans','theme.trans','fields.trans') AND `#__dataset_columns`.`namekey` NOT IN ('1yid','1type','1sid','1required','1readonly','1publish','1parent','1params','1ordering','1modified','1map','1level','1initial','1hidden','1fid','1core','2yid','2wizard','2wid','2type','2publish','2params','2namekey','2modified','2menu','2frontend','2created','2level','3yid','3type','3sid','3search','3publish','3parent','3params','3ordering','3modified','3map','3lid','3level','3hidden','3core','4wid','4core','4outype','4map','4params','4modified','4publish','4type','4did','5publish','5folder','5wid','5params','5status','5type','5name','9yid','9type','9publish','9parent','9params','9ordering','9level','9icon','9action','2subtype','4namekey','4ref_sid','4first_all','4first_value','4first_caption','4external','2dropdown','4lib_ext','2pagination','2filters','1did','232uid','4sid','199lgid','199code','199premium','9mid','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','374mgid','374namekey','374rolid','374type','374created','374uid','374senddate','382mgid','382lgid','382name','382ctext','382chtml','382smail','382sname','374html','4level','232html','2private','1private','232registered','9private','199name','199main','199publish','199real','1area','1ref_yid','1frame','451tmid','451type','451namekey','451publish','456cptid','456created','456password','456addon','456crypt','456used','456image','456params','9position','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','3did','5parent','5trans','484description','5certify','2core','2sid','5namekey','9core','374params','382rname','382remail','232login','5version','2form','5lversion','2icon','199rtl','451premium','541vid','541name','5pref','559tmid','559name','559description','559lgid','541lgid','1ref_wid','3ref_wid','451core','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','2tmid','2rolid','4rolid','3rolid','1rolid','9rolid','5rolid','566type','2alias','5install','374wid','374alias','451wid','451alias','590mgqid','590mgid','590uid','590nextdate','590priority','590expirationdate','590params','9namekey','3namekey','1namekey','199availadmin','199availsite','618sid','618lgid','618name','621sid','621dbtid','621path','621namekey','621folder','621rolid','621level','621publish','621created','621extended','621checkval','621params','621alias','199locale','566depth','621prefix','199localeconv','621ordering','ordering5','core5','suffix621','ref_wid9','level374','visibility232','modified5','tags374','714ctrid','714lgid','name714','description714','description485','auto382','fromlgid382','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto559','fromlgid559','auto618','fromlgid618','auto714','fromlgid714','type590','curid232','extstid621','filid451','created451','modified451','availability451','archive374','status374','attach374','modified374','folder451','j16566','publishstart374','publishend374','bouncemail382','authorid382','modified382','publish374','intro382','params451','ip232','ctyid232','994fdid','namekey994','type994','rolid994','uid994','core994','publish994','created994','modified994','996fieldid','996lgid','name996','description996','auto996','fromlgid996','fields621','sid994','997crdid','namekey997','alias997','type997','rolid997','uid997','modifiedby997','publish997','created997','modified997','params997','directory997','username997','passcode997','url997','searchable994','rolid_edit994','params994','initialvalue994','column994','required994','fields2','fdid3','fdid1','ordering994','parentdft1','parentdft3','updateall994','parent2','dbcid994','ordering997','1003crdidtype','namekey1003','alias1003','rolid1003','uid1003','modifiedby1003','core1003','publish1003','created1003','modified1003','crdidtype997','category1003','premium997','translate994','checkout621','trash621','audit621','modified621','checktype1','totalcustom621','1014widgetid','namekey1014','alias1014','rolid1014','uid1014','modifiedby1014','core1014','publish1014','created1014','modified1014','ref_type1014','red_id1014','catid1014','params1014','1015widgetid','1015lgid','name1015','description1015','auto1015','fromlgid1015','wid1014','reload5','reload2','reload621','created4','reload4','1030wgtypeid','1031wgtypeid','1031lgid','name1031','description1031','auto1031','fromlgid1031','namekey1030','alias1030','type1030','rolid1030','uid1030','core1030','publish1030','created1030','modified1030','wgtypeid1014','core199','core374','core621','widgets2','groupid1030','advsearch3','advordering3','advsearchable994','created5','sms374','smsmessage382','mobile232','icon621','faicon9','color9','faicon2','rolid451','uid451','ordering451','filid232','automatic199','template374','xsvisible9','xshidden9','xsvisible1','xshidden1','xsvisible3','xshidden3','useredit2','devicevisible9','devicehidden9','devicevisible1','devicehidden1','devicevisible3','devicehidden3','parent4','isparent4','format374','content590','read590','title590','subtitle590','title382','subtitle382','notify374','pnamekey621','showconfig5','framework5','allowothers4','message485','colorstyle4','parentkey2','framework451','link590','custom2') 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 ('2wid','1yid','9yid','3yid','1did','1sid','481lgid','482fid','482lgid','484lid','484lgid','485mid','485lgid','3did','2sid','3sid','481yid','2tmid','2rolid','3rolid','1rolid','9rolid','590mgid','590uid','1parent','3parent','9parent','1ref_yid','rolid997','modifiedby997','fdid3','fdid1','parent2','rolid1003','uid1003','crdidtype997','rolid1014','uid1014','1015widgetid','1015lgid','wid1014','1031wgtypeid','1031lgid','wgtypeid1014') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_widget_node_lgid','FK_widget_node_widgetid','FK_widgets_type_trans_lgid','FK_widgets_type_trans_wgtypeid','FK_layout_multiforms_did','FKParent_fid','FK_multiforms_layout_nestedlayout','FK_view_forms_rolid','FK_layout_multiforms_sid','FK_layout_multiforms_yid','FK_view_rolid','FK_view_sid','FK_view_tmid','FK_layout_node_wid','FK_listings_dropset_did','FK_Parent3_parentlid','FK_view_listings_rolid','FK_view_listings_sid','FK_layout_listings_yid','FK_layout_trans_lgid','FK_layout_trans_yis','FK_layout_multiformstrans_fid','FK_layout_multiformstrans_lgid','FK_layout_listingstrans_lgid','FK_layout_listingstrans_lid','FK_layout_mlinkstrans_lgid','FK_layout_mlinkstrans_mid','FK_message_queue_mgid','FK_message_queue_uid','FK_Parent9_parentmid','FK_view_menus_rolid','FK_layout_menus_yid','FK_credentials_node_crdidtype','FK_layout_forms_fdid','FK_layout_listings_fdid','FK_credentials_node_uid','FK_layout_node_parent','FK_credentials_type_rolid','FK_widgets_node_rolid','FK_credentials_node_rolid','FK_credentials_type_uid','FK_widgets_node_uid','FK_widgets_node_wgtypeid','FK_widgets_node_wid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('main.node') ;
SET @rolid_0 = (1);
SET @pk_549_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1 );
SET @pk_549_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1 );
SET @pk_549_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1 );
SET @pk_549_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_590 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='message.queue' LIMIT 1 );
SET @pk_549_997 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='credentials.node' LIMIT 1 );
SET @pk_549_1003 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='credentials.type' LIMIT 1 );
SET @pk_549_1014 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1 );
SET @pk_549_1015 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.trans' LIMIT 1 );
SET @pk_549_1030 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type' LIMIT 1 );
SET @pk_549_1031 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type.trans' LIMIT 1 );
SET @pk_549_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_374 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.node' LIMIT 1 );
SET @pk_549_451 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_621 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' LIMIT 1 );
SET @pk_549_994 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1 );
SET @pk_549_456 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='captcha.node' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_715 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sesion.node' LIMIT 1 );
SET @pk_549_475 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.node' LIMIT 1 );
SET @pk_549_541 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
SET @pk_549_382 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1 );
SET @pk_549_559 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.trans' LIMIT 1 );
SET @pk_549_996 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.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_multiforms','layout.multiforms',@pk_549_1,'','1.0.0',@rolid_0,'0','10','fid','multiforms','layout','9','0','1','1','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('layout_node','layout.node',@pk_549_2,'','1.0.0',@rolid_0,'0','1','yid','node','layout','9','0','0','1','7'),('layout_listings','layout.listings',@pk_549_3,'','1.0.0',@rolid_0,'0','10','lid','listings','layout','9','0','1','1','7'),('layout_mlinks','layout.mlinks',@pk_549_9,'','1.0.0',@rolid_0,'0','10','mid','mlinks','layout','9','0','1','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('message_queue','message.queue',@pk_549_590,'','1.0.0',@rolid_0,'0','1','mgqid','queue','message','51','2','0','0','7'),('credentials_node','credentials.node',@pk_549_997,'','',@rolid_0,'0','1','crdid','','','51','2','0','0','7'),('credentials_type','credentials.type',@pk_549_1003,'','',@rolid_0,'0','1','crdidtype','','','51','2','0','0','7'),('widgets_node','widgets.node',@pk_549_1014,'','',@rolid_0,'0','1','widgetid','','','51','2','0','0','7'),('widgets_trans','widgets.trans',@pk_549_1015,'','',@rolid_0,'0','20','widgetid,lgid','','','51','2','0','0','7'),('widgets_type','widgets.type',@pk_549_1030,'','',@rolid_0,'0','1','wgtypeid','','','51','2','0','0','7'),('widgets_type_trans','widgets.type.trans',@pk_549_1031,'','',@rolid_0,'0','20','wgtypeid,lgid','','','51','2','0','0','7'),('dropset_node','dropset.node',@pk_549_4,'','1.0.0',@rolid_0,'0','1','did','node','dropset','9','0','0','1','7'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('mailing_node','mailing.node',@pk_549_374,'','1.0.0',@rolid_0,'0','1','mgid','node','mailing','51','0','0','0','7'),('theme_node','theme.node',@pk_549_451,'','1.0.0',@rolid_0,'0','1','tmid','node','theme','51','0','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('model_node','model.node',@pk_549_621,'','1.0.0',@rolid_0,'0','1','sid','node','model','9','0','0','1','7'),('model_fields','model.fields',@pk_549_994,'','',@rolid_0,'0','1','fdid','','','9','2','0','1','7'),('captcha_node','captcha.node',@pk_549_456,'','1.0.0',@rolid_0,'0','1','cptid','node','captcha','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'),('sesion_node','sesion.node',@pk_549_715,'','',@rolid_0,'0','1','sessid','node','sesion','51','2','0','0','7'),('eguillage_node','eguillage.node',@pk_549_475,'','1.0.0',@rolid_0,'0','1','ctrid','node','eguillage','9','0','0','1','7'),('dropset_valuestrans','dropset.valuestrans',@pk_549_541,'','1.0.0',@rolid_0,'0','20','vid,lgid','valuestrans','dropset','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7'),('mailing_trans','mailing.trans',@pk_549_382,'','1.0.0',@rolid_0,'0','20','mgid,lgid','trans','mailing','51','0','0','0','7'),('theme_trans','theme.trans',@pk_549_559,'','1.0.0',@rolid_0,'0','20','tmid,lgid','trans','theme','51','0','0','0','7'),('fields_trans','fields.trans',@pk_549_996,'','',@rolid_0,'0','20','fieldid,lgid','','','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='message.queue' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='credentials.node' LIMIT 1);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='credentials.type' LIMIT 1);
SET @dbtid_12 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1);
SET @dbtid_13 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.trans' LIMIT 1);
SET @dbtid_14 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type' LIMIT 1);
SET @dbtid_15 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type.trans' LIMIT 1);
SET @pk_454_44 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_node_namekey' LIMIT 1 );
SET @pk_454_1004 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_node_wid_type_publish_level_rolid' LIMIT 1 );
SET @pk_454_1006 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='layout_mlinks_index_yid_publish_level_rolid_ordering' LIMIT 1 );
SET @pk_454_1012 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_listing_yid_publish_level_rolid_hidden_ordering' LIMIT 1 );
SET @pk_454_1014 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_multiform_yid_publish_level_rolid_ordering' LIMIT 1 );
SET @pk_454_47962 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_listings_namekey' LIMIT 1 );
SET @pk_454_47963 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_menus_namekey' LIMIT 1 );
SET @pk_454_47964 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_forms_namekey' LIMIT 1 );
SET @pk_454_65430 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_viewtrans_yid_lgid' LIMIT 1 );
SET @pk_454_65431 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1 );
SET @pk_454_65432 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1 );
SET @pk_454_65433 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_menustrans_mid_lgid' LIMIT 1 );
SET @pk_454_65539 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_node_yid' LIMIT 1 );
SET @pk_454_65544 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_listings_lid' LIMIT 1 );
SET @pk_454_65546 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_message_queue' LIMIT 1 );
SET @pk_454_65667 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_multiforms_fid' LIMIT 1 );
SET @pk_454_65976 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_credentials_node|main_userdata' LIMIT 1 );
SET @pk_454_65977 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_credentials_node' LIMIT 1 );
SET @pk_454_65982 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_credentials_type|main_userdata' LIMIT 1 );
SET @pk_454_65983 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_credentials_namekey' LIMIT 1 );
SET @pk_454_65996 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_node' LIMIT 1 );
SET @pk_454_65997 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_node_namekey' LIMIT 1 );
SET @pk_454_65998 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_widget_trans|main_userdata' LIMIT 1 );
SET @pk_454_66026 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type' LIMIT 1 );
SET @pk_454_66027 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1 );
SET @pk_454_66028 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_type_namekey' LIMIT 1 );
SET @pk_454_66033 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_widgets_node_framework_type_publish_core' LIMIT 1 );
SET @pk_454_66147 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_node_sid' LIMIT 1 );
SET @pk_454_66224 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_message_queue_uid_read_create' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_44,'1','UK_layout_node_namekey',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_1004,'2','IX_layout_node_wid_type_publish_level_rolid',@dbtid_1),(@pk_454_1006,'2','layout_mlinks_index_yid_publish_level_rolid_ordering',@dbtid_2),(@pk_454_1012,'2','IX_layout_listing_yid_publish_level_rolid_hidden_ordering',@dbtid_3),(@pk_454_1014,'2','IX_layout_multiform_yid_publish_level_rolid_ordering',@dbtid_4),(@pk_454_47962,'1','UK_layout_listings_namekey',@dbtid_3),(@pk_454_47963,'1','UK_layout_menus_namekey',@dbtid_2),(@pk_454_47964,'1','UK_layout_forms_namekey',@dbtid_4),(@pk_454_65430,'3','PK_viewtrans_yid_lgid',@dbtid_5),(@pk_454_65431,'3','PK_view_formstrans_fid_lgid',@dbtid_6),(@pk_454_65432,'3','PK_view_listingstrans_lid_lgid',@dbtid_7),(@pk_454_65433,'3','PK_view_menustrans_mid_lgid',@dbtid_8),(@pk_454_65539,'3','PK_layout_node_yid',@dbtid_1),(@pk_454_65544,'3','PK_layout_listings_lid',@dbtid_3),(@pk_454_65546,'3','PK_message_queue',@dbtid_9),(@pk_454_65667,'3','PK_layout_multiforms_fid',@dbtid_4),(@pk_454_65976,'3','PK_jos_credentials_node|main_userdata',@dbtid_10),(@pk_454_65977,'1','UK_namekey_jos_credentials_node',@dbtid_10),(@pk_454_65982,'3','PK_jos_credentials_type|main_userdata',@dbtid_11),(@pk_454_65983,'1','UK_namekey_jos_credentials_namekey',@dbtid_11),(@pk_454_65996,'3','PK_widgets_node',@dbtid_12),(@pk_454_65997,'1','UK_widgets_node_namekey',@dbtid_12),(@pk_454_65998,'3','PK_jos_widget_trans|main_userdata',@dbtid_13),(@pk_454_66026,'3','PK_widgets_type',@dbtid_14),(@pk_454_66027,'3','PK_widgets_type_trans',@dbtid_15),(@pk_454_66028,'1','UK_widgets_type_namekey',@dbtid_14),(@pk_454_66033,'2','IX_widgets_node_framework_type_publish_core',@dbtid_12),(@pk_454_66147,'2','IX_layout_node_sid',@dbtid_1),(@pk_454_66224,'2','IX_message_queue_uid_read_create',@dbtid_9);
SET @dbtid_16 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1);
SET @dbtid_17 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1);
SET @dbtid_18 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @dbtid_19 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_20 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' LIMIT 1);
SET @dbtid_21 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='captcha.node' LIMIT 1);
SET @dbtid_22 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1);
SET @pk_616_1 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1 );
SET @pk_616_6 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1publish' LIMIT 1 );
SET @pk_616_9 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ordering' LIMIT 1 );
SET @pk_616_13 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1level' LIMIT 1 );
SET @pk_616_16 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1 );
SET @pk_616_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1 );
SET @pk_616_23 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2wid' LIMIT 1 );
SET @pk_616_24 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2type' LIMIT 1 );
SET @pk_616_26 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2publish' LIMIT 1 );
SET @pk_616_29 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2namekey' LIMIT 1 );
SET @pk_616_36 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2level' LIMIT 1 );
SET @pk_616_41 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1 );
SET @pk_616_45 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3publish' LIMIT 1 );
SET @pk_616_48 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ordering' LIMIT 1 );
SET @pk_616_52 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1 );
SET @pk_616_53 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3level' LIMIT 1 );
SET @pk_616_54 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3hidden' LIMIT 1 );
SET @pk_616_126 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9yid' LIMIT 1 );
SET @pk_616_128 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9publish' LIMIT 1 );
SET @pk_616_131 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9ordering' LIMIT 1 );
SET @pk_616_134 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9level' LIMIT 1 );
SET @pk_616_3406 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481yid' LIMIT 1 );
SET @pk_616_3407 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481lgid' LIMIT 1 );
SET @pk_616_3410 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1 );
SET @pk_616_3411 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1 );
SET @pk_616_3414 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1 );
SET @pk_616_3415 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1 );
SET @pk_616_3417 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485mid' LIMIT 1 );
SET @pk_616_3418 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485lgid' LIMIT 1 );
SET @pk_616_3528 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2sid' LIMIT 1 );
SET @pk_616_5651 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2rolid' LIMIT 1 );
SET @pk_616_5653 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1 );
SET @pk_616_5654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1 );
SET @pk_616_5656 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9rolid' LIMIT 1 );
SET @pk_616_5726 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590mgqid' LIMIT 1 );
SET @pk_616_5728 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590uid' LIMIT 1 );
SET @pk_616_5729 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590nextdate' LIMIT 1 );
SET @pk_616_5752 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9namekey' LIMIT 1 );
SET @pk_616_5753 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3namekey' LIMIT 1 );
SET @pk_616_5754 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1namekey' LIMIT 1 );
SET @pk_616_9085 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='997crdid' LIMIT 1 );
SET @pk_616_9086 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey997' LIMIT 1 );
SET @pk_616_9209 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1003crdidtype' LIMIT 1 );
SET @pk_616_9210 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1003' LIMIT 1 );
SET @pk_616_9385 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1014widgetid' LIMIT 1 );
SET @pk_616_9386 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1014' LIMIT 1 );
SET @pk_616_9392 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1014' LIMIT 1 );
SET @pk_616_9393 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1014' LIMIT 1 );
SET @pk_616_9396 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ref_type1014' LIMIT 1 );
SET @pk_616_9400 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015widgetid' LIMIT 1 );
SET @pk_616_9401 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015lgid' LIMIT 1 );
SET @pk_616_9581 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1 );
SET @pk_616_9582 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1 );
SET @pk_616_9583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1 );
SET @pk_616_9588 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1030' LIMIT 1 );
SET @pk_616_10798 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='read590' LIMIT 1 );
SET @pk_616_73 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4did' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_1702 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9mid' LIMIT 1 );
SET @pk_616_2142 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='374mgid' LIMIT 1 );
SET @pk_616_3037 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_6055 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1 );
SET @pk_616_9055 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='994fdid' LIMIT 1 );
SET @pk_616_9148 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent2' LIMIT 1 );
SET @pk_616_3 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1sid' LIMIT 1 );
SET @pk_616_7 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1parent' LIMIT 1 );
SET @pk_616_43 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3sid' LIMIT 1 );
SET @pk_616_46 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3parent' LIMIT 1 );
SET @pk_616_129 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9parent' LIMIT 1 );
SET @pk_616_1349 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1did' LIMIT 1 );
SET @pk_616_2990 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_yid' LIMIT 1 );
SET @pk_616_3437 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3did' LIMIT 1 );
SET @pk_616_5640 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2tmid' LIMIT 1 );
SET @pk_616_5727 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590mgid' LIMIT 1 );
SET @pk_616_9089 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid997' LIMIT 1 );
SET @pk_616_9091 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby997' LIMIT 1 );
SET @pk_616_9127 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid3' LIMIT 1 );
SET @pk_616_9128 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid1' LIMIT 1 );
SET @pk_616_9212 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1003' LIMIT 1 );
SET @pk_616_9213 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1003' LIMIT 1 );
SET @pk_616_9219 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='crdidtype997' LIMIT 1 );
SET @pk_616_9389 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1014' LIMIT 1 );
SET @pk_616_9390 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1014' LIMIT 1 );
SET @pk_616_9406 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid1014' LIMIT 1 );
SET @pk_616_9597 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wgtypeid1014' LIMIT 1 );
SET @pk_616_2 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1type' LIMIT 1 );
SET @pk_616_4 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1required' LIMIT 1 );
SET @pk_616_5 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1readonly' LIMIT 1 );
SET @pk_616_8 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1params' LIMIT 1 );
SET @pk_616_11 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1modified' LIMIT 1 );
SET @pk_616_12 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1map' LIMIT 1 );
SET @pk_616_14 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1initial' LIMIT 1 );
SET @pk_616_15 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1hidden' LIMIT 1 );
SET @pk_616_19 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1core' LIMIT 1 );
SET @pk_616_22 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2wizard' LIMIT 1 );
SET @pk_616_28 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2params' LIMIT 1 );
SET @pk_616_31 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2modified' LIMIT 1 );
SET @pk_616_32 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2menu' LIMIT 1 );
SET @pk_616_33 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2frontend' LIMIT 1 );
SET @pk_616_35 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2created' LIMIT 1 );
SET @pk_616_42 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3type' LIMIT 1 );
SET @pk_616_44 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3search' LIMIT 1 );
SET @pk_616_47 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3params' LIMIT 1 );
SET @pk_616_50 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3modified' LIMIT 1 );
SET @pk_616_51 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3map' LIMIT 1 );
SET @pk_616_56 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3core' LIMIT 1 );
SET @pk_616_127 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9type' LIMIT 1 );
SET @pk_616_130 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9params' LIMIT 1 );
SET @pk_616_136 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9icon' LIMIT 1 );
SET @pk_616_138 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9action' LIMIT 1 );
SET @pk_616_466 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2subtype' LIMIT 1 );
SET @pk_616_1094 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2dropdown' LIMIT 1 );
SET @pk_616_1097 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2pagination' LIMIT 1 );
SET @pk_616_1226 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2filters' LIMIT 1 );
SET @pk_616_2481 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2private' LIMIT 1 );
SET @pk_616_2482 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1private' LIMIT 1 );
SET @pk_616_2484 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9private' LIMIT 1 );
SET @pk_616_2989 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1area' LIMIT 1 );
SET @pk_616_3014 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1frame' LIMIT 1 );
SET @pk_616_3170 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456cptid' LIMIT 1 );
SET @pk_616_3171 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456created' LIMIT 1 );
SET @pk_616_3172 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456password' LIMIT 1 );
SET @pk_616_3173 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456addon' LIMIT 1 );
SET @pk_616_3174 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456crypt' LIMIT 1 );
SET @pk_616_3175 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456used' LIMIT 1 );
SET @pk_616_3176 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456image' LIMIT 1 );
SET @pk_616_3177 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='456params' LIMIT 1 );
SET @pk_616_3240 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9position' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_3409 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481description' 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_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3526 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2core' LIMIT 1 );
SET @pk_616_3551 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9core' LIMIT 1 );
SET @pk_616_3593 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2form' LIMIT 1 );
SET @pk_616_3595 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2icon' LIMIT 1 );
SET @pk_616_5523 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_wid' LIMIT 1 );
SET @pk_616_5524 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ref_wid' 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_5670 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2alias' LIMIT 1 );
SET @pk_616_5730 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590priority' LIMIT 1 );
SET @pk_616_5731 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590expirationdate' LIMIT 1 );
SET @pk_616_5734 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590params' LIMIT 1 );
SET @pk_616_6331 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ref_wid9' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_6814 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto481' LIMIT 1 );
SET @pk_616_6815 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid481' LIMIT 1 );
SET @pk_616_6824 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto482' LIMIT 1 );
SET @pk_616_6825 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid482' LIMIT 1 );
SET @pk_616_6826 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto484' LIMIT 1 );
SET @pk_616_6827 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid484' LIMIT 1 );
SET @pk_616_6828 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto485' LIMIT 1 );
SET @pk_616_6829 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid485' LIMIT 1 );
SET @pk_616_7061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type590' LIMIT 1 );
SET @pk_616_9087 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias997' LIMIT 1 );
SET @pk_616_9088 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type997' LIMIT 1 );
SET @pk_616_9090 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid997' LIMIT 1 );
SET @pk_616_9092 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish997' LIMIT 1 );
SET @pk_616_9093 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created997' LIMIT 1 );
SET @pk_616_9094 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified997' LIMIT 1 );
SET @pk_616_9095 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params997' LIMIT 1 );
SET @pk_616_9096 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='directory997' LIMIT 1 );
SET @pk_616_9097 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='username997' LIMIT 1 );
SET @pk_616_9098 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='passcode997' LIMIT 1 );
SET @pk_616_9099 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='url997' LIMIT 1 );
SET @pk_616_9123 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fields2' LIMIT 1 );
SET @pk_616_9130 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentdft1' LIMIT 1 );
SET @pk_616_9131 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentdft3' LIMIT 1 );
SET @pk_616_9207 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering997' LIMIT 1 );
SET @pk_616_9211 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias1003' LIMIT 1 );
SET @pk_616_9214 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby1003' LIMIT 1 );
SET @pk_616_9215 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1003' LIMIT 1 );
SET @pk_616_9216 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1003' LIMIT 1 );
SET @pk_616_9217 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created1003' LIMIT 1 );
SET @pk_616_9218 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified1003' LIMIT 1 );
SET @pk_616_9220 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='category1003' LIMIT 1 );
SET @pk_616_9221 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='premium997' LIMIT 1 );
SET @pk_616_9298 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checktype1' LIMIT 1 );
SET @pk_616_9387 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias1014' LIMIT 1 );
SET @pk_616_9391 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby1014' LIMIT 1 );
SET @pk_616_9394 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created1014' LIMIT 1 );
SET @pk_616_9395 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified1014' LIMIT 1 );
SET @pk_616_9397 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='red_id1014' LIMIT 1 );
SET @pk_616_9398 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='catid1014' LIMIT 1 );
SET @pk_616_9399 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params1014' LIMIT 1 );
SET @pk_616_9402 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1015' LIMIT 1 );
SET @pk_616_9403 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1015' LIMIT 1 );
SET @pk_616_9404 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto1015' LIMIT 1 );
SET @pk_616_9405 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid1015' LIMIT 1 );
SET @pk_616_9505 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload2' LIMIT 1 );
SET @pk_616_9584 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1031' LIMIT 1 );
SET @pk_616_9585 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1031' LIMIT 1 );
SET @pk_616_9586 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto1031' LIMIT 1 );
SET @pk_616_9587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid1031' LIMIT 1 );
SET @pk_616_9589 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias1030' LIMIT 1 );
SET @pk_616_9590 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type1030' LIMIT 1 );
SET @pk_616_9591 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1030' LIMIT 1 );
SET @pk_616_9592 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1030' LIMIT 1 );
SET @pk_616_9593 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1030' LIMIT 1 );
SET @pk_616_9594 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1030' LIMIT 1 );
SET @pk_616_9595 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created1030' LIMIT 1 );
SET @pk_616_9596 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified1030' LIMIT 1 );
SET @pk_616_9673 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='widgets2' LIMIT 1 );
SET @pk_616_9678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='groupid1030' LIMIT 1 );
SET @pk_616_9708 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='advsearch3' LIMIT 1 );
SET @pk_616_9709 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='advordering3' LIMIT 1 );
SET @pk_616_10179 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='faicon9' LIMIT 1 );
SET @pk_616_10180 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='color9' LIMIT 1 );
SET @pk_616_10181 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='faicon2' LIMIT 1 );
SET @pk_616_10671 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xsvisible9' LIMIT 1 );
SET @pk_616_10672 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xshidden9' LIMIT 1 );
SET @pk_616_10673 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xsvisible1' LIMIT 1 );
SET @pk_616_10674 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xshidden1' LIMIT 1 );
SET @pk_616_10675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xsvisible3' LIMIT 1 );
SET @pk_616_10676 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xshidden3' LIMIT 1 );
SET @pk_616_10679 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='useredit2' LIMIT 1 );
SET @pk_616_10719 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicevisible9' LIMIT 1 );
SET @pk_616_10720 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicehidden9' LIMIT 1 );
SET @pk_616_10721 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicevisible1' LIMIT 1 );
SET @pk_616_10722 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicehidden1' LIMIT 1 );
SET @pk_616_10723 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicevisible3' LIMIT 1 );
SET @pk_616_10724 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicehidden3' LIMIT 1 );
SET @pk_616_10795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='content590' LIMIT 1 );
SET @pk_616_10799 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title590' LIMIT 1 );
SET @pk_616_10800 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle590' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_10842 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentkey2' LIMIT 1 );
SET @pk_616_10896 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='link590' LIMIT 1 );
SET @pk_616_10955 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='custom2' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' 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 );
SET @pk_616_5473 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559name' LIMIT 1 );
SET @pk_616_5474 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559description' LIMIT 1 );
SET @pk_616_9067 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name996' LIMIT 1 );
SET @pk_616_9068 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description996' 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_1,@dbtid_4,'yid','0','0','3','1','1','','2','1',@rolid_0,'0','0','1','1yid','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_6,@dbtid_4,'publish','0','1','1','0','1','0','11','1',@rolid_0,'0','0','1','1publish','1','0','0'),(@pk_616_9,@dbtid_4,'ordering','0','0','2','1','1','99','9','1',@rolid_0,'0','0','1','1ordering','1','0','0'),(@pk_616_13,@dbtid_4,'level','0','0','1','1','1','0','18','1',@rolid_0,'0','0','1','1level','1','0','0'),(@pk_616_16,@dbtid_4,'fid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','1fid','1','0','0'),(@pk_616_21,@dbtid_1,'yid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','2yid','1','0','0'),(@pk_616_23,@dbtid_1,'wid','0','0','2','1','1','0','2','1',@rolid_0,'0','0','1','2wid','1','0','0'),(@pk_616_24,@dbtid_1,'type','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','2type','1','0','0'),(@pk_616_26,@dbtid_1,'publish','0','0','1','0','1','1','8','1',@rolid_0,'0','0','1','2publish','1','0','0'),(@pk_616_29,@dbtid_1,'namekey','0','1','14','0','1','','12','1',@rolid_0,'0','100','1','2namekey','1','0','0'),(@pk_616_36,@dbtid_1,'level','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','2level','1','0','0'),(@pk_616_41,@dbtid_3,'yid','0','0','3','1','1','0','2','1',@rolid_0,'0','0','1','3yid','1','0','0'),(@pk_616_45,@dbtid_3,'publish','0','0','1','0','1','1','15','1',@rolid_0,'0','0','1','3publish','1','0','0'),(@pk_616_48,@dbtid_3,'ordering','0','0','1','1','1','99','13','1',@rolid_0,'0','0','1','3ordering','1','0','0'),(@pk_616_52,@dbtid_3,'lid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','3lid','1','0','0'),(@pk_616_53,@dbtid_3,'level','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','3level','1','0','0'),(@pk_616_54,@dbtid_3,'hidden','0','0','1','1','1','0','9','1',@rolid_0,'0','0','1','3hidden','1','0','0'),(@pk_616_126,@dbtid_2,'yid','0','0','3','1','1','0','2','1',@rolid_0,'0','0','1','9yid','1','0','0'),(@pk_616_128,@dbtid_2,'publish','0','0','1','0','1','1','12','1',@rolid_0,'0','0','1','9publish','1','0','0'),(@pk_616_131,@dbtid_2,'ordering','0','0','1','1','1','99','9','1',@rolid_0,'1','0','1','9ordering','1','0','0'),(@pk_616_134,@dbtid_2,'level','0','0','1','1','1','0','11','1',@rolid_0,'0','0','1','9level','1','0','0'),(@pk_616_3406,@dbtid_5,'yid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','481yid','1','0','0'),(@pk_616_3407,@dbtid_5,'lgid','1','0','1','1','1','1','2','1',@rolid_0,'0','0','1','481lgid','1','0','0'),(@pk_616_3410,@dbtid_6,'fid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','482fid','1','0','0'),(@pk_616_3411,@dbtid_6,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','482lgid','1','0','0'),(@pk_616_3414,@dbtid_7,'lid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','484lid','1','0','0'),(@pk_616_3415,@dbtid_7,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','484lgid','1','0','0'),(@pk_616_3417,@dbtid_8,'mid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','485mid','1','0','0'),(@pk_616_3418,@dbtid_8,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','485lgid','1','0','0'),(@pk_616_3528,@dbtid_1,'sid','0','0','2','1','1','0','3','1',@rolid_0,'0','0','1','2sid','1','0','0'),(@pk_616_5651,@dbtid_1,'rolid','0','0','2','1','1','1','5','1',@rolid_0,'0','0','1','2rolid','1','0','0'),(@pk_616_5653,@dbtid_3,'rolid','0','0','2','1','1','1','7','1',@rolid_0,'0','0','1','3rolid','1','0','0'),(@pk_616_5654,@dbtid_4,'rolid','0','0','2','1','1','1','6','1',@rolid_0,'0','0','1','1rolid','1','0','0'),(@pk_616_5656,@dbtid_2,'rolid','0','0','2','1','1','1','3','1',@rolid_0,'0','0','1','9rolid','1','0','0'),(@pk_616_5726,@dbtid_9,'mgqid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','590mgqid','1','0','0'),(@pk_616_5728,@dbtid_9,'uid','0','0','4','1','1','0','3','1',@rolid_0,'0','0','1','590uid','1','0','0'),(@pk_616_5729,@dbtid_9,'created','0','1','4','1','1','0','4','1',@rolid_0,'0','0','1','590nextdate','1','1','0'),(@pk_616_5752,@dbtid_2,'namekey','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','9namekey','1','0','0'),(@pk_616_5753,@dbtid_3,'namekey','0','1','14','0','1','','3','1',@rolid_0,'0','100','1','3namekey','1','0','0'),(@pk_616_5754,@dbtid_4,'namekey','0','1','14','0','1','','7','1',@rolid_0,'0','100','1','1namekey','1','0','0'),(@pk_616_9085,@dbtid_10,'crdid','1','0','4','1','1','','1','0','0','1','0','1','997crdid','1','0','0'),(@pk_616_9086,@dbtid_10,'namekey','0','1','14','0','1','','5','0','0','0','150','1','namekey997','1','0','0'),(@pk_616_9209,@dbtid_11,'crdidtype','1','0','2','1','1','','1','0','0','1','0','1','1003crdidtype','1','0','0'),(@pk_616_9210,@dbtid_11,'namekey','0','1','14','0','1','','3','0','0','0','150','1','namekey1003','1','0','0'),(@pk_616_9385,@dbtid_12,'widgetid','1','0','4','1','1','','1','0','0','1','0','1','1014widgetid','1','0','0'),(@pk_616_9386,@dbtid_12,'namekey','0','1','14','0','1','','6','0','0','0','150','1','namekey1014','1','0','0'),(@pk_616_9392,@dbtid_12,'core','0','1','25','0','1','0','10','0','0','0','0','1','core1014','1','0','0'),(@pk_616_9393,@dbtid_12,'publish','0','1','1','0','1','0','12','0','0','0','0','1','publish1014','1','0','0'),(@pk_616_9396,@dbtid_12,'framework_type','0','1','1','1','1','1','13','0','0','0','0','1','ref_type1014','1','0','0'),(@pk_616_9400,@dbtid_13,'widgetid','1','0','4','1','1','','0','0','0','0','0','1','1015widgetid','1','0','0'),(@pk_616_9401,@dbtid_13,'lgid','1','0','4','1','1','','1','0','0','0','0','1','1015lgid','1','0','0'),(@pk_616_9581,@dbtid_14,'wgtypeid','1','0','3','1','1','','1','0','0','1','0','0','1030wgtypeid','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_9582,@dbtid_15,'wgtypeid','1','0','3','1','1','','1','0','0','0','0','1','1031wgtypeid','1','0','0'),(@pk_616_9583,@dbtid_15,'lgid','1','0','2','1','1','','2','0','0','0','0','1','1031lgid','1','0','0'),(@pk_616_9588,@dbtid_14,'namekey','0','0','14','0','1','','3','0','0','0','100','0','namekey1030','1','0','0'),(@pk_616_10798,@dbtid_9,'isread','0','1','1','1','1','0','10','0','0','0','0','1','read590','1','0','0'),(@pk_616_73,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1),'did','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','4did','1','0','0'),(@pk_616_81,@dbtid_16,'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_1468,@dbtid_17,'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_1698,@dbtid_18,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_1702,@dbtid_2,'mid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','9mid','1','0','0'),(@pk_616_2142,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.node' LIMIT 1),'mgid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','374mgid','1','0','0'),(@pk_616_3037,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1),'tmid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','451tmid','1','0','0'),(@pk_616_5532,@dbtid_19,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_6055,@dbtid_20,'sid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','621sid','1','0','0'),(@pk_616_9055,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1),'fdid','1','0','4','1','1','','1','0','0','1','0','1','994fdid','1','0','0'),(@pk_616_9148,@dbtid_1,'parent','0','1','14','0','1','','24','0','0','0','100','1','parent2','1','0','0'),(@pk_616_3,@dbtid_4,'sid','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','1sid','1','0','0'),(@pk_616_7,@dbtid_4,'parent','0','0','3','1','1','0','10','1',@rolid_0,'0','0','1','1parent','1','0','0'),(@pk_616_43,@dbtid_3,'sid','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','3sid','1','0','0'),(@pk_616_46,@dbtid_3,'parent','0','0','3','1','1','0','14','1',@rolid_0,'0','0','1','3parent','1','0','0'),(@pk_616_129,@dbtid_2,'parent','0','1','3','1','1','0','10','1',@rolid_0,'0','0','1','9parent','1','0','0'),(@pk_616_1349,@dbtid_4,'did','0','1','3','1','1','0','4','1',@rolid_0,'0','0','1','1did','1','0','0'),(@pk_616_2990,@dbtid_4,'ref_yid','0','0','3','1','1','0','21','1',@rolid_0,'0','0','1','1ref_yid','1','0','0'),(@pk_616_3437,@dbtid_3,'did','0','0','3','1','1','0','6','1',@rolid_0,'0','0','1','3did','1','0','0'),(@pk_616_5640,@dbtid_1,'tmid','0','0','2','1','1','0','4','1',@rolid_0,'0','0','1','2tmid','1','0','0'),(@pk_616_5727,@dbtid_9,'mgid','0','0','4','1','1','0','2','1',@rolid_0,'0','0','1','590mgid','1','0','0'),(@pk_616_9089,@dbtid_10,'rolid','0','1','2','1','1','1','2','0','0','0','0','1','rolid997','1','0','0'),(@pk_616_9091,@dbtid_10,'modifiedby','0','1','4','1','1','0','8','0','0','0','0','1','modifiedby997','1','0','0'),(@pk_616_9127,@dbtid_3,'fdid','0','1','4','1','1','0','20','0','0','0','0','1','fdid3','1','0','0'),(@pk_616_9128,@dbtid_4,'fdid','0','1','4','1','1','0','25','0','0','0','0','1','fdid1','1','0','0'),(@pk_616_9212,@dbtid_11,'rolid','0','0','2','1','1','1','5','0','0','0','0','1','rolid1003','1','0','0'),(@pk_616_9213,@dbtid_11,'uid','0','0','4','1','1','0','10','0','0','0','0','0','uid1003','1','0','0'),(@pk_616_9219,@dbtid_10,'crdidtype','0','1','2','1','1','0','17','0','0','0','0','1','crdidtype997','1','0','0'),(@pk_616_9389,@dbtid_12,'rolid','0','1','2','1','1','1','4','0','0','0','0','1','rolid1014','1','0','0'),(@pk_616_9390,@dbtid_12,'uid','0','1','4','1','1','0','7','0','0','0','0','0','uid1014','1','0','0'),(@pk_616_9406,@dbtid_12,'wid','0','1','3','1','1','0','3','0','0','0','0','1','wid1014','1','0','0'),(@pk_616_9597,@dbtid_12,'wgtypeid','0','1','3','1','1','0','2','0','0','0','0','1','wgtypeid1014','1','0','0'),(@pk_616_2,@dbtid_4,'type','0','0','14','0','1','','3','1',@rolid_0,'0','100','1','1type','1','0','0'),(@pk_616_4,@dbtid_4,'required','0','0','1','1','1','0','13','1',@rolid_0,'0','0','1','1required','1','0','0'),(@pk_616_5,@dbtid_4,'readonly','0','0','1','1','1','0','12','1',@rolid_0,'0','0','1','1readonly','1','0','0'),(@pk_616_8,@dbtid_4,'params','0','1','16','0','1','','24','1',@rolid_0,'0','0','1','1params','1','0','0'),(@pk_616_11,@dbtid_4,'modified','0','1','4','1','1','0','14','1',@rolid_0,'0','0','0','1modified','1','1','0'),(@pk_616_12,@dbtid_4,'map','0','1','14','0','1','','8','1',@rolid_0,'0','100','1','1map','1','0','0'),(@pk_616_14,@dbtid_4,'initial','0','1','14','0','1','','17','1',@rolid_0,'0','255','1','1initial','1','0','0'),(@pk_616_15,@dbtid_4,'hidden','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','1hidden','1','0','0'),(@pk_616_19,@dbtid_4,'core','0','1','25','0','1','1','15','1',@rolid_0,'0','0','1','1core','1','0','0'),(@pk_616_22,@dbtid_1,'wizard','0','0','25','0','1','0','11','1',@rolid_0,'0','0','1','2wizard','1','0','0'),(@pk_616_28,@dbtid_1,'params','0','0','16','0','1','','7','1',@rolid_0,'0','0','1','2params','1','0','0'),(@pk_616_31,@dbtid_1,'modified','0','1','4','1','1','0','25','1',@rolid_0,'0','0','0','2modified','1','1','0'),(@pk_616_32,@dbtid_1,'menu','0','0','25','0','1','1','17','1',@rolid_0,'0','0','1','2menu','1','0','0'),(@pk_616_33,@dbtid_1,'frontend','0','0','25','0','1','0','15','1',@rolid_0,'0','0','1','2frontend','1','0','0'),(@pk_616_35,@dbtid_1,'created','0','1','4','1','1','0','26','1',@rolid_0,'0','0','0','2created','1','1','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_42,@dbtid_3,'type','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','3type','1','0','0'),(@pk_616_44,@dbtid_3,'search','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','3search','1','0','0'),(@pk_616_47,@dbtid_3,'params','0','0','16','0','1','','22','1',@rolid_0,'0','0','1','3params','1','0','0'),(@pk_616_50,@dbtid_3,'modified','0','1','4','1','1','0','12','1',@rolid_0,'0','0','0','3modified','1','1','0'),(@pk_616_51,@dbtid_3,'map','0','1','14','0','1','','11','1',@rolid_0,'0','30','1','3map','1','0','0'),(@pk_616_56,@dbtid_3,'core','0','0','25','0','1','1','8','1',@rolid_0,'0','0','1','3core','1','0','0'),(@pk_616_127,@dbtid_2,'type','0','0','1','1','1','1','8','1',@rolid_0,'0','0','1','9type','1','0','0'),(@pk_616_130,@dbtid_2,'params','0','0','16','0','1','','15','1',@rolid_0,'0','0','1','9params','1','0','0'),(@pk_616_136,@dbtid_2,'icon','0','1','14','1','1','','6','1',@rolid_0,'0','50','1','9icon','1','0','0'),(@pk_616_138,@dbtid_2,'action','0','1','14','1','1','','5','1',@rolid_0,'0','150','1','9action','1','0','0'),(@pk_616_466,@dbtid_1,'subtype','0','0','1','1','1','0','9','1',@rolid_0,'0','0','1','2subtype','1','0','0'),(@pk_616_1094,@dbtid_1,'dropdown','0','0','25','0','1','0','13','1',@rolid_0,'0','0','1','2dropdown','1','0','0'),(@pk_616_1097,@dbtid_1,'pagination','0','0','25','0','1','0','6','1',@rolid_0,'0','0','1','2pagination','1','0','0'),(@pk_616_1226,@dbtid_1,'filters','0','1','25','0','1','0','14','1',@rolid_0,'0','0','1','2filters','1','0','0'),(@pk_616_2481,@dbtid_1,'private','0','0','25','0','1','0','18','1',@rolid_0,'0','0','1','2private','1','0','0'),(@pk_616_2482,@dbtid_4,'private','0','0','25','0','1','0','19','1',@rolid_0,'0','0','1','1private','1','0','0'),(@pk_616_2484,@dbtid_2,'private','0','0','25','0','1','0','13','1',@rolid_0,'0','0','1','9private','1','0','0'),(@pk_616_2989,@dbtid_4,'area','0','0','14','0','1','','20','1',@rolid_0,'0','20','1','1area','1','0','0'),(@pk_616_3014,@dbtid_4,'frame','0','0','1','1','1','0','22','1',@rolid_0,'0','0','1','1frame','1','0','0'),(@pk_616_3170,@dbtid_21,'cptid','1','0','4','1','1','','0','1',@rolid_0,'1','0','1','456cptid','1','0','0'),(@pk_616_3171,@dbtid_21,'created','0','1','4','1','1','0','99','1',@rolid_0,'1','0','1','456created','1','1','0'),(@pk_616_3172,@dbtid_21,'password','0','0','14','0','1','','99','1',@rolid_0,'0','255','1','456password','1','0','0'),(@pk_616_3173,@dbtid_21,'addon','0','0','4','0','1','0','99','1',@rolid_0,'0','0','1','456addon','1','0','0'),(@pk_616_3174,@dbtid_21,'crypt','0','0','14','0','1','','99','1',@rolid_0,'0','10','1','456crypt','1','0','0'),(@pk_616_3175,@dbtid_21,'used','0','0','4','0','1','0','99','1',@rolid_0,'0','0','1','456used','1','0','0'),(@pk_616_3176,@dbtid_21,'image','0','0','14','0','1','','99','1',@rolid_0,'0','40','1','456image','1','0','0'),(@pk_616_3177,@dbtid_21,'params','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','456params','1','0','0'),(@pk_616_3240,@dbtid_2,'position','0','0','1','1','1','0','7','1',@rolid_0,'0','0','1','9position','1','0','0'),(@pk_616_3408,@dbtid_5,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_3409,@dbtid_5,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','0','481description','1','0','0'),(@pk_616_3412,@dbtid_6,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,@dbtid_6,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3416,@dbtid_7,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3419,@dbtid_8,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_3507,@dbtid_7,'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3526,@dbtid_1,'core','0','0','25','0','1','1','19','1',@rolid_0,'0','0','1','2core','1','0','0'),(@pk_616_3551,@dbtid_2,'core','0','0','25','0','1','1','14','1',@rolid_0,'0','0','1','9core','1','0','0'),(@pk_616_3593,@dbtid_1,'form','0','0','25','0','1','1','20','1',@rolid_0,'0','0','1','2form','1','0','0'),(@pk_616_3595,@dbtid_1,'icon','0','0','14','0','1','','21','1',@rolid_0,'0','50','1','2icon','1','0','0'),(@pk_616_5523,@dbtid_4,'ref_wid','0','0','2','1','1','0','23','1',@rolid_0,'0','0','1','1ref_wid','1','0','0'),(@pk_616_5524,@dbtid_3,'ref_wid','0','0','2','1','1','0','19','1',@rolid_0,'0','0','1','3ref_wid','1','0','0'),(@pk_616_5579,@dbtid_5,'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,@dbtid_5,'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_5670,@dbtid_1,'alias','0','0','14','0','1','','22','1',@rolid_0,'0','255','1','2alias','1','0','0'),(@pk_616_5730,@dbtid_9,'priority','0','0','1','1','1','254','5','1',@rolid_0,'0','0','1','590priority','1','0','0'),(@pk_616_5731,@dbtid_9,'expirationdate','0','0','4','1','1','0','6','1',@rolid_0,'0','0','1','590expirationdate','1','0','0'),(@pk_616_5734,@dbtid_9,'params','0','0','16','0','1','','7','1',@rolid_0,'0','0','1','590params','1','0','0'),(@pk_616_6331,@dbtid_2,'ref_wid','0','1','2','1','1','0','16','0','0','0','0','1','ref_wid9','1','0','0'),(@pk_616_6797,@dbtid_8,'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_6814,@dbtid_5,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto481','1','0','0'),(@pk_616_6815,@dbtid_5,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid481','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_6824,@dbtid_6,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto482','1','0','0'),(@pk_616_6825,@dbtid_6,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid482','1','0','0'),(@pk_616_6826,@dbtid_7,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto484','1','0','0'),(@pk_616_6827,@dbtid_7,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid484','1','0','0'),(@pk_616_6828,@dbtid_8,'auto','0','0','1','0','1','2','7','0','0','0','0','0','auto485','1','0','0'),(@pk_616_6829,@dbtid_8,'fromlgid','0','0','1','1','1','0','6','0','0','0','0','0','fromlgid485','1','0','0'),(@pk_616_7061,@dbtid_9,'type','0','0','1','1','1','0','8','0','0','0','0','1','type590','1','0','0'),(@pk_616_9087,@dbtid_10,'alias','0','1','14','0','1','','4','0','0','0','150','1','alias997','1','0','0'),(@pk_616_9088,@dbtid_10,'type','0','0','1','1','1','0','3','0','0','0','0','1','type997','1','0','0'),(@pk_616_9090,@dbtid_10,'uid','0','0','4','1','1','0','6','0','0','0','0','1','uid997','1','0','0'),(@pk_616_9092,@dbtid_10,'publish','0','0','1','0','1','1','10','0','0','0','0','1','publish997','1','0','0'),(@pk_616_9093,@dbtid_10,'created','0','1','4','1','1','0','9','0','0','0','0','1','created997','1','1','0'),(@pk_616_9094,@dbtid_10,'modified','0','1','4','1','1','0','7','0','0','0','0','1','modified997','1','1','0'),(@pk_616_9095,@dbtid_10,'params','0','1','16','0','1','','11','0','0','0','0','1','params997','1','0','0'),(@pk_616_9096,@dbtid_10,'directory','0','1','14','0','1','','12','0','0','0','255','1','directory997','1','0','0'),(@pk_616_9097,@dbtid_10,'username','0','1','14','0','1','','13','0','0','0','200','1','username997','1','0','0'),(@pk_616_9098,@dbtid_10,'passcode','0','1','14','0','1','','14','0','0','0','200','1','passcode997','1','0','0'),(@pk_616_9099,@dbtid_10,'url','0','1','14','0','1','','15','0','0','0','250','1','url997','1','0','0'),(@pk_616_9123,@dbtid_1,'fields','0','1','1','1','1','0','23','0','0','0','0','1','fields2','1','0','0'),(@pk_616_9130,@dbtid_4,'parentdft','0','1','1','1','1','0','26','0','0','0','0','1','parentdft1','1','0','0'),(@pk_616_9131,@dbtid_3,'parentdft','0','1','1','1','1','0','21','0','0','0','0','1','parentdft3','1','0','0'),(@pk_616_9207,@dbtid_10,'ordering','0','1','4','1','1','1','16','0','0','0','0','1','ordering997','1','0','0'),(@pk_616_9211,@dbtid_11,'alias','0','1','14','0','1','','2','0','0','0','150','1','alias1003','1','0','0'),(@pk_616_9214,@dbtid_11,'modifiedby','0','0','4','1','1','0','6','0','0','0','0','0','modifiedby1003','1','0','0'),(@pk_616_9215,@dbtid_11,'core','0','0','25','0','1','0','9','0','0','0','0','1','core1003','1','0','0'),(@pk_616_9216,@dbtid_11,'publish','0','0','1','0','1','0','8','0','0','0','0','1','publish1003','1','0','0'),(@pk_616_9217,@dbtid_11,'created','0','1','4','1','1','0','7','0','0','0','0','0','created1003','1','1','0'),(@pk_616_9218,@dbtid_11,'modified','0','1','4','1','1','0','4','0','0','0','0','0','modified1003','1','1','0'),(@pk_616_9220,@dbtid_11,'category','0','1','1','1','1','0','11','0','0','0','0','1','category1003','1','0','0'),(@pk_616_9221,@dbtid_10,'premium','0','1','25','0','1','0','18','0','0','0','0','1','premium997','1','0','0'),(@pk_616_9298,@dbtid_4,'checktype','0','1','1','1','1','0','27','0','0','0','0','1','checktype1','1','0','0'),(@pk_616_9387,@dbtid_12,'alias','0','1','14','0','1','','5','0','0','0','150','1','alias1014','1','0','0'),(@pk_616_9391,@dbtid_12,'modifiedby','0','1','4','1','1','0','8','0','0','0','0','0','modifiedby1014','1','0','0'),(@pk_616_9394,@dbtid_12,'created','0','1','4','1','1','0','11','0','0','0','0','0','created1014','1','1','0'),(@pk_616_9395,@dbtid_12,'modified','0','1','4','1','1','0','9','0','0','0','0','0','modified1014','1','1','0'),(@pk_616_9397,@dbtid_12,'framework_id','0','1','4','1','1','0','14','0','0','0','0','1','red_id1014','1','0','0'),(@pk_616_9398,@dbtid_12,'catid','0','1','2','1','1','0','15','0','0','0','0','1','catid1014','1','0','0'),(@pk_616_9399,@dbtid_12,'params','0','1','16','0','1','','16','0','0','0','0','1','params1014','1','0','0'),(@pk_616_9402,@dbtid_13,'name','0','0','14','0','1','','4','0','0','0','255','1','name1015','1','0','0'),(@pk_616_9403,@dbtid_13,'description','0','0','16','0','1','','5','0','0','0','0','1','description1015','1','0','0'),(@pk_616_9404,@dbtid_13,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto1015','1','0','0'),(@pk_616_9405,@dbtid_13,'fromlgid','0','0','1','1','1','0','7','0','0','0','0','0','fromlgid1015','1','0','0'),(@pk_616_9505,@dbtid_1,'reload','0','1','1','1','1','1','27','0','0','0','0','0','reload2','1','0','0'),(@pk_616_9584,@dbtid_15,'name','0','0','14','0','1','','3','0','0','0','255','1','name1031','1','0','0'),(@pk_616_9585,@dbtid_15,'description','0','0','16','0','1','','4','0','0','0','0','1','description1031','1','0','0'),(@pk_616_9586,@dbtid_15,'auto','0','0','1','0','1','2','5','0','0','0','0','0','auto1031','1','0','0'),(@pk_616_9587,@dbtid_15,'fromlgid','0','0','1','1','0','0','6','0','0','0','0','0','fromlgid1031','1','0','0'),(@pk_616_9589,@dbtid_14,'alias','0','0','14','0','1','','2','0','0','0','150','0','alias1030','1','0','0'),(@pk_616_9590,@dbtid_14,'type','0','0','1','1','1','0','5','0','0','0','0','0','type1030','1','0','0'),(@pk_616_9591,@dbtid_14,'rolid','0','0','2','1','1','1','10','0','0','0','0','0','rolid1030','1','0','0'),(@pk_616_9592,@dbtid_14,'uid','0','0','4','1','1','0','6','0','0','0','0','0','uid1030','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_9593,@dbtid_14,'core','0','0','25','0','1','0','9','0','0','0','0','0','core1030','1','0','0'),(@pk_616_9594,@dbtid_14,'publish','0','0','1','0','1','0','8','0','0','0','0','0','publish1030','1','0','0'),(@pk_616_9595,@dbtid_14,'created','0','1','4','1','1','0','7','0','0','0','0','0','created1030','1','1','0'),(@pk_616_9596,@dbtid_14,'modified','0','1','4','1','1','0','4','0','0','0','0','0','modified1030','1','1','0'),(@pk_616_9673,@dbtid_1,'widgets','0','1','1','1','1','0','28','0','0','0','0','1','widgets2','1','0','0'),(@pk_616_9678,@dbtid_14,'groupid','0','1','1','1','1','0','12','0','0','0','0','0','groupid1030','1','0','0'),(@pk_616_9708,@dbtid_3,'advsearch','0','1','1','1','1','0','17','0','0','0','0','1','advsearch3','1','0','0'),(@pk_616_9709,@dbtid_3,'advordering','0','1','1','1','1','0','18','0','0','0','0','1','advordering3','1','0','0'),(@pk_616_10179,@dbtid_2,'faicon','0','1','14','0','1','','17','0','0','0','50','1','faicon9','1','0','0'),(@pk_616_10180,@dbtid_2,'color','0','1','14','0','1','','18','0','0','0','15','1','color9','1','0','0'),(@pk_616_10181,@dbtid_1,'faicon','0','1','14','0','1','','29','0','0','0','50','1','faicon2','1','0','0'),(@pk_616_10671,@dbtid_2,'xsvisible','0','1','1','1','1','0','19','0','0','0','0','1','xsvisible9','1','0','0'),(@pk_616_10672,@dbtid_2,'xshidden','0','1','1','1','1','0','20','0','0','0','0','1','xshidden9','1','0','0'),(@pk_616_10673,@dbtid_4,'xsvisible','0','1','1','1','1','0','28','0','0','0','0','1','xsvisible1','1','0','0'),(@pk_616_10674,@dbtid_4,'xshidden','0','1','1','1','1','0','29','0','0','0','0','1','xshidden1','1','0','0'),(@pk_616_10675,@dbtid_3,'xsvisible','0','1','1','1','1','0','23','0','0','0','0','1','xsvisible3','1','0','0'),(@pk_616_10676,@dbtid_3,'xshidden','0','1','1','1','1','0','24','0','0','0','0','1','xshidden3','1','0','0'),(@pk_616_10679,@dbtid_1,'useredit','0','1','1','1','1','1','30','0','0','0','0','1','useredit2','1','0','0'),(@pk_616_10719,@dbtid_2,'devicevisible','0','1','14','0','1','','21','0','0','0','100','1','devicevisible9','1','0','0'),(@pk_616_10720,@dbtid_2,'devicehidden','0','1','14','0','1','','22','0','0','0','100','1','devicehidden9','1','0','0'),(@pk_616_10721,@dbtid_4,'devicevisible','0','1','14','0','1','','30','0','0','0','100','1','devicevisible1','1','0','0'),(@pk_616_10722,@dbtid_4,'devicehidden','0','1','14','0','1','','31','0','0','0','100','1','devicehidden1','1','0','0'),(@pk_616_10723,@dbtid_3,'devicevisible','0','1','14','0','1','','25','0','0','0','100','1','devicevisible3','1','0','0'),(@pk_616_10724,@dbtid_3,'devicehidden','0','1','14','0','1','','26','0','0','0','100','1','devicehidden3','1','0','0'),(@pk_616_10795,@dbtid_9,'content','0','1','16','0','1','','9','0','0','0','0','1','content590','1','0','0'),(@pk_616_10799,@dbtid_9,'title','0','1','14','0','1','','11','0','0','0','255','1','title590','1','0','0'),(@pk_616_10800,@dbtid_9,'subtitle','0','1','14','0','1','','12','0','0','0','255','1','subtitle590','1','0','0'),(@pk_616_10823,@dbtid_8,'message','0','1','16','0','1','','5','0','0','0','0','1','message485','1','0','0'),(@pk_616_10842,@dbtid_1,'pnamekey','0','1','14','0','1','','31','0','0','0','100','1','parentkey2','1','0','0'),(@pk_616_10896,@dbtid_9,'link','0','1','14','0','1','','13','0','0','0','254','1','link590','1','0','0'),(@pk_616_10955,@dbtid_1,'custom','0','1','1','1','1','0','32','0','0','0','0','1','custom2','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_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_22,'name','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','382name','1','0','0'),(@pk_616_2218,@dbtid_22,'ctext','0','0','19','0','1','','8','1',@rolid_0,'0','0','1','382ctext','1','0','0'),(@pk_616_2219,@dbtid_22,'chtml','0','0','19','0','1','','7','1',@rolid_0,'0','0','1','382chtml','1','0','0'),(@pk_616_8616,@dbtid_22,'bouncemail','0','1','14','0','1','','11','0','0','0','100','1','bouncemail382','1','0','0'),(@pk_616_8617,@dbtid_22,'authorid','0','1','4','1','1','0','14','0','0','0','0','1','authorid382','1','0','0'),(@pk_616_8618,@dbtid_22,'modified','0','1','4','1','1','0','15','0','0','0','0','1','modified382','1','1','0'),(@pk_616_8678,@dbtid_22,'intro','0','1','16','0','1','','6','0','0','0','0','1','intro382','1','0','0'),(@pk_616_10120,@dbtid_22,'smsmessage','0','1','16','0','1','','16','0','0','0','0','1','smsmessage382','1','0','0'),(@pk_616_10801,@dbtid_22,'title','0','1','14','0','1','','17','0','0','0','255','1','title382','1','0','0'),(@pk_616_10802,@dbtid_22,'subtitle','0','1','14','0','1','','18','0','0','0','255','1','subtitle382','1','0','0'),(@pk_616_5473,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','559name','1','0','0'),(@pk_616_5474,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.trans' LIMIT 1),'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','559description','1','0','0'),(@pk_616_9067,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.trans' LIMIT 1),'name','0','0','14','0','1','','4','0','0','0','255','1','name996','1','0','0'),(@pk_616_9068,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.trans' LIMIT 1),'description','0','0','16','0','1','','5','0','0','0','0','1','description996','1','0','0');
SET @pk_5_1749 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='main.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='main',`wid`=@pk_5_1749,`params`='',`status`='1',`type`='150',`name`='Main',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='main.node',`version`='2690',`lversion`='2690',`pref`='1',`install`='',`core`='1',`showconfig`='0',`framework`='0' WHERE  `namekey`='main.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','main',@pk_5_1749,'','1','150','Main','node','0','1','1','main.node','2690','2690','1','','1','0','0');

SET @pk_621_456 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.captcha' LIMIT 1 );
SET @pk_621_590 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.messagequeue' LIMIT 1 );
SET @pk_621_1126 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.view' LIMIT 1 );
SET @pk_621_1127 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewtrans' LIMIT 1 );
SET @pk_621_1128 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewform' LIMIT 1 );
SET @pk_621_1129 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewformtrans' LIMIT 1 );
SET @pk_621_1130 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlisting' LIMIT 1 );
SET @pk_621_1131 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlistingtrans' LIMIT 1 );
SET @pk_621_1132 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenu' LIMIT 1 );
SET @pk_621_1133 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenutrans' LIMIT 1 );
SET @pk_621_1146 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credential' LIMIT 1 );
SET @pk_621_1161 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credentialtype' LIMIT 1 );
SET @pk_621_1180 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1 );
SET @pk_621_1181 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettrans' LIMIT 1 );
SET @pk_621_1212 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettype' LIMIT 1 );
SET @pk_621_1213 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettypetrans' LIMIT 1 );
SET @pk_621_2 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='view' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_749 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.session' LIMIT 1 );
SET @pk_621_733 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controller' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_456,`dbtid`=@dbtid_21,`path`='0',`namekey`='main.captcha',`folder`='captcha',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='captcha',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='main.captcha';
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_456,@dbtid_21,'0','main.captcha','captcha',@rolid_0,'0','1','0','0','autofld=1','','captcha','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_590,`dbtid`=@dbtid_9,`path`='0',`namekey`='main.messagequeue',`folder`='main.messagequeue',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='message',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-envelope-o',`pnamekey`='' WHERE  `namekey`='main.messagequeue';
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_590,@dbtid_9,'0','main.messagequeue','main.messagequeue',@rolid_0,'0','1','0','0','autofld=1','','message','0','0','1','fa-envelope-o','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1126,`dbtid`=@dbtid_1,`path`='1',`namekey`='main.view',`folder`='main.view',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='validtoggle=1\nverifld=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='main.view';
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_1126,@dbtid_1,'1','main.view','main.view',@rolid_0,'0','1','0','0','validtoggle=1\nverifld=1\nautofld=1','','main','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1127,`dbtid`=@dbtid_5,`path`='1',`namekey`='main.viewtrans',`folder`='main.viewtrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=main.view',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='main.viewtrans';
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_1127,@dbtid_5,'1','main.viewtrans','main.viewtrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=main.view','','main','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1128,`dbtid`=@dbtid_4,`path`='1',`namekey`='main.viewform',`folder`='main.viewform',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nprtname=main.viewformtrans\nvalidtoggle=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='main.viewform';
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_1128,@dbtid_4,'1','main.viewform','main.viewform',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nprtname=main.viewformtrans\nvalidtoggle=1\nautofld=1','','main','0','0','1','fa-th-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1129,`dbtid`=@dbtid_6,`path`='1',`namekey`='main.viewformtrans',`folder`='main.viewformtrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=main.viewform',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='main.viewformtrans';
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_1129,@dbtid_6,'1','main.viewformtrans','main.viewformtrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=main.viewform','','main','0','0','1','fa-th-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1130,`dbtid`=@dbtid_3,`path`='1',`namekey`='main.viewlisting',`folder`='main.viewlisting',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nprtname=main.viewlistingtrans\nvalidtoggle=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list',`pnamekey`='' WHERE  `namekey`='main.viewlisting';
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_1130,@dbtid_3,'1','main.viewlisting','main.viewlisting',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nprtname=main.viewlistingtrans\nvalidtoggle=1\nautofld=1','','main','0','0','1','fa-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1131,`dbtid`=@dbtid_7,`path`='1',`namekey`='main.viewlistingtrans',`folder`='main.viewlistingtrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=main.viewlisting',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list',`pnamekey`='' WHERE  `namekey`='main.viewlistingtrans';
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_1131,@dbtid_7,'1','main.viewlistingtrans','main.viewlistingtrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=main.viewlisting','','main','0','0','1','fa-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1132,`dbtid`=@dbtid_2,`path`='1',`namekey`='main.viewmenu',`folder`='main.viewmenu',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nprtname=main.viewmenutrans\nvalidtoggle=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-link',`pnamekey`='' WHERE  `namekey`='main.viewmenu';
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_1132,@dbtid_2,'1','main.viewmenu','main.viewmenu',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nprtname=main.viewmenutrans\nvalidtoggle=1\nautofld=1','','main','0','0','1','fa-link','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1133,`dbtid`=@dbtid_8,`path`='1',`namekey`='main.viewmenutrans',`folder`='main.viewmenutrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=main.viewmenu',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-link',`pnamekey`='' WHERE  `namekey`='main.viewmenutrans';
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_1133,@dbtid_8,'1','main.viewmenutrans','main.viewmenutrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=main.viewmenu','','main','0','0','1','fa-link','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1146,`dbtid`=@dbtid_10,`path`='1',`namekey`='main.credential',`folder`='main.credential',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-key',`pnamekey`='' WHERE  `namekey`='main.credential';
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_1146,@dbtid_10,'1','main.credential','main.credential',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\nautofld=1','','main','0','0','1','fa-key','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1161,`dbtid`=@dbtid_11,`path`='0',`namekey`='main.credentialtype',`folder`='main.credentialtype',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='main.credentialtype';
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_1161,@dbtid_11,'0','main.credentialtype','main.credentialtype',@rolid_0,'0','1','0','0','autofld=1','','main','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1180,`dbtid`=@dbtid_12,`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,@dbtid_12,'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_1181,`dbtid`=@dbtid_13,`path`='0',`namekey`='main.widgettrans',`folder`='main.widgettrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=main.widget\nautofld=1',`alias`='',`prefix`='widget',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-puzzle-piece',`pnamekey`='' WHERE  `namekey`='main.widgettrans';
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_1181,@dbtid_13,'0','main.widgettrans','main.widgettrans',@rolid_0,'0','1','0','0','mainmodel=main.widget\nautofld=1','','widget','0','0','1','fa-puzzle-piece','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1212,`dbtid`=@dbtid_14,`path`='0',`namekey`='main.widgettype',`folder`='',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='widget',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='main.widgettype';
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_1212,@dbtid_14,'0','main.widgettype','',@rolid_0,'0','1','0','0','autofld=1','','widget','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1213,`dbtid`=@dbtid_15,`path`='0',`namekey`='main.widgettypetrans',`folder`='',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=main.widgettype\nautofld=1',`alias`='',`prefix`='widget',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='main.widgettypetrans';
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_1213,@dbtid_15,'0','main.widgettypetrans','',@rolid_0,'0','1','0','0','mainmodel=main.widgettype\nautofld=1','','widget','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_2,`dbtid`=@dbtid_1,`path`='1',`namekey`='view',`folder`='view',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='grpmap=wid\nprtname=viewtrans\ncachedata=1\nautofld=1',`alias`='',`prefix`='layout',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='view';
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_2,@dbtid_1,'1','view','view',@rolid_0,'0','1','0','0','grpmap=wid\nprtname=viewtrans\ncachedata=1\nautofld=1','','layout','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=@dbtid_16,`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
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_5,@dbtid_16,'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_19,`path`='1',`namekey`='role',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='prtname=roletrans\ncachedata=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_566,@dbtid_19,'1','role','role',@rolid_0,'0','1','0','0','prtname=roletrans\ncachedata=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_999,`dbtid`=@dbtid_16,`path`='0',`namekey`='apps',`folder`='apps',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='apps';
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_999,@dbtid_16,'0','apps','apps',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','apps','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=@dbtid_17,`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='users';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1015,@dbtid_17,'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');
UPDATE `#__model_node`  SET `sid`=@pk_621_749,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sesion.node' LIMIT 1),`path`='0',`namekey`='library.session',`folder`='library.session',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='session',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-bullseye',`pnamekey`='' WHERE  `namekey`='library.session';
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_749,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sesion.node' LIMIT 1),'0','library.session','library.session',@rolid_0,'0','1','0','0','autofld=1','','session','0','0','1','fa-bullseye','');
UPDATE `#__model_node`  SET `sid`=@pk_621_733,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.node' LIMIT 1),`path`='0',`namekey`='library.controller',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-random',`pnamekey`='' WHERE  `namekey`='library.controller';
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_733,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.node' LIMIT 1),'0','library.controller','library',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','fa-random','');

SET @wid_23 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='main.node' LIMIT 1);
SET @sid_24 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.view' LIMIT 1);
SET @sid_25 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewform' LIMIT 1);
SET @sid_26 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlisting' LIMIT 1);
SET @sid_27 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenu' LIMIT 1);
SET @sid_28 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credential' LIMIT 1);
SET @sid_29 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credentialtype' LIMIT 1);
SET @sid_30 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1);
SET @sid_31 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettype' LIMIT 1);
SET @sid_32 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.session' LIMIT 1);
SET @sid_33 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controller' LIMIT 1);
SET @rolid_34 = (3);
SET @rolid_35 = (9);
SET @rolid_36 = (7);
SET @rolid_37 = (8);
SET @sid_38 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @sid_39 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1);
SET @yid_40 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_report_header' LIMIT 1);
SET @yid_41 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_report_header_no_internval' LIMIT 1);
SET @yid_42 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_form' LIMIT 1);
SET @yid_43 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewlisting_form' LIMIT 1);
SET @yid_44 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewform_form' LIMIT 1);
SET @yid_45 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_form' LIMIT 1);
SET @yid_46 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewmenu_form' LIMIT 1);
SET @yid_47 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_tag_form' LIMIT 1);
SET @yid_48 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_report_header_mini' LIMIT 1);
SET @yid_49 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_form_core' LIMIT 1);
SET @yid_50 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_default' LIMIT 1);
SET @yid_51 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_new' LIMIT 1);
SET @yid_52 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_s3' LIMIT 1);
SET @yid_53 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_dropbox' LIMIT 1);
SET @yid_54 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_params_form_main_url' LIMIT 1);
SET @yid_55 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_infusionsoft' LIMIT 1);
SET @yid_56 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_googleapi' LIMIT 1);
SET @yid_57 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credentialtype_form' LIMIT 1);
SET @yid_58 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_direct_translate_form' LIMIT 1);
SET @yid_59 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_params_form_main_transarea' LIMIT 1);
SET @yid_60 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_type_form' LIMIT 1);
SET @yid_61 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='widget_type_show_main_widgets_type' LIMIT 1);
SET @yid_62 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_form_joomla' LIMIT 1);
SET @yid_63 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_time_widget' LIMIT 1);
SET @yid_64 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_facebook' LIMIT 1);
SET @yid_65 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_form_recaptcha' LIMIT 1);
SET @did_66 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_view_header_display' LIMIT 1);
SET @did_67 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='role_user_access' LIMIT 1);
SET @did_68 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_screen_size' LIMIT 1);
SET @did_69 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_device_type' LIMIT 1);
SET @did_70 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_form_edit_when_to_edit' LIMIT 1);
SET @did_71 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_tooltip_style' LIMIT 1);
SET @did_72 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_listing_type' LIMIT 1);
SET @did_73 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_credentials_type' LIMIT 1);
SET @did_74 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_credential_category' LIMIT 1);
SET @did_75 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_widget_list' LIMIT 1);
SET @did_76 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_widgets_ref_type_usage' LIMIT 1);
SET @did_77 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_nodes' LIMIT 1);
SET @sid_78 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewtrans' LIMIT 1);
SET @sid_79 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewformtrans' LIMIT 1);
SET @sid_80 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlistingtrans' LIMIT 1);
SET @sid_81 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenutrans' LIMIT 1);
SET @sid_82 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettrans' LIMIT 1);
SET @sid_83 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettypetrans' LIMIT 1);
SET @rolid_84 = (48);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('report_header_predefined_date') LIMIT 1;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('report_header_specified_date') LIMIT 1;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('main_report_header_no_internval_date') LIMIT 1;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('main_report_header_no_internval_specified_date') LIMIT 1;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_view_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('main_view_form_wizard_fielset','main_view_form_main_view_name','main_view_form_main_view_main_view_alias','main_view_form_main_view_description','main_view_form_main_view_main_view_publish','main_view_form_main_view_main_view_namekey','main_view_form_main_view_main_view_menu') LIMIT 7;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_attributes' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('main_viewlisting_form_main_viewlisting_nested','main_viewlisting_form_main_viewlisting_data_sorting','main_viewlisting_form_main_viewlisting_nosort') LIMIT 3;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_tag_form_general_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('main_widget_tag_form_general') LIMIT 1;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_row_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('main_report_header_no_internval_column1','main_report_header_no_internval_column2') LIMIT 2;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_row_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('main_report_header_column1','main_report_header_column2') LIMIT 2;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_display' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('main_viewlisting_form_mobile','main_viewlisting_form_xsvisible','main_viewlisting_form_xshidden','main_viewlisting_form_devicevisible','main_viewlisting_form_devicehidden') LIMIT 5;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_tag_form_parameters' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('main_widget_tag_form_parameters_1') LIMIT 1;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_row1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('main_report_header_report_type') LIMIT 1;
SET @p_1_12 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_row_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_12 WHERE `namekey` IN ('main_report_header_no_internval_report_type') LIMIT 1;
SET @p_1_13 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_report_type' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_13 WHERE `namekey` IN ('report_header_jdoctype') LIMIT 1;
SET @p_1_14 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='report_header_predefined_date' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_14 WHERE `namekey` IN ('report_header_interval','report_header_presetdate','report_header_refresh') LIMIT 3;
SET @p_1_15 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='report_header_specified_date' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_15 WHERE `namekey` IN ('report_header_startdate','report_header_enddate','report_header_generate') LIMIT 3;
SET @p_1_16 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_mini_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_16 WHERE `namekey` IN ('main_report_header_mini_type') LIMIT 1;
SET @p_1_17 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_mini_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_17 WHERE `namekey` IN ('main_report_header_mini_interval','main_report_header_mini_range') LIMIT 2;
SET @p_1_18 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_report_type' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_18 WHERE `namekey` IN ('main_report_header_no_internval_type') LIMIT 1;
SET @p_1_19 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_date' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_19 WHERE `namekey` IN ('250av5z723','250av5z724') LIMIT 2;
SET @p_1_20 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_report_header_no_internval_specified_date' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_20 WHERE `namekey` IN ('250av5z727','250av5z728','250av5z729') LIMIT 3;
SET @p_1_21 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_view_form_wizard_fielset' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_21 WHERE `namekey` IN ('main_view_form_main_view_wname','main_view_form_main_view_wdescription') LIMIT 2;
SET @p_1_22 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_view_form_code' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_22 WHERE `namekey` IN ('view_edit_view_1_copy1434751417','view_edit_view_copy1434751417') LIMIT 2;
SET @p_1_23 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewform_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_23 WHERE `namekey` IN ('main_viewform_form_main_form_main_viewformtrans_name','main_viewform_form_main_viewformtrans_description','main_viewform_form_main_form_main_viewform_type','main_viewform_form_main_form_main_viewform_ordering','main_viewform_form_main_form_main_viewform_parent','main_viewform_form_main_form_main_viewform_area2','main_viewform_form_main_form_main_viewform_required','main_viewform_form_main_form_main_viewform_readonly','main_viewform_form_main_form_main_viewform_initial','main_viewform_form_main_form_main_viewform_rolid','main_viewform_form_main_form_main_viewform_namekey','main_viewform_form_main_form_main_viewform_publish') LIMIT 12;
SET @p_1_24 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewform_form_display' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_24 WHERE `namekey` IN ('main_viewform_form_xsvisible','main_viewform_form_xshidden','main_viewform_form_devicevisible','main_viewform_form_devicehidden') LIMIT 4;
SET @p_1_25 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewform_form_field_specific' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_25 WHERE `namekey` IN ('main_viewform_form_nested') LIMIT 1;
SET @p_1_26 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewform_form_attributes' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_26 WHERE `namekey` IN ('main_viewform_form_parentdft','main_viewform_form_notitle','main_viewform_form_spantit','main_viewform_form_onlynew','main_viewform_form_tipstyle') LIMIT 5;
SET @p_1_27 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewform_form_style' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_27 WHERE `namekey` IN ('main_viewform_form_style_classes','main_viewform_form_style_style') LIMIT 2;
SET @p_1_28 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_28 WHERE `namekey` IN ('main_viewlisting_form_main_listing_main_viewlisting_name','main_viewlisting_form_main_listing_main_viewlisting_description','main_viewlisting_form_main_listing_main_viewlisting_sid','main_viewlisting_form_main_listing_main_viewlisting_map','main_viewlisting_form_main_listing_main_viewlisting_ordering','main_viewlisting_form_main_listing_main_viewlisting_search','main_viewlisting_form_main_listing_main_viewlisting_advsearch','main_viewlisting_form_main_listing_main_viewlisting_rolid','main_viewlisting_form_main_listing_main_viewlisting_parent','main_viewlisting_form_main_listing_main_viewlisting_type','main_viewlisting_form_main_listing_main_viewlisting_namekey','main_viewlisting_form_main_listing_main_viewlisting_publish') LIMIT 12;
SET @p_1_29 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_mobile' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_29 WHERE `namekey` IN ('main_viewlisting_form_mb_showtitle') LIMIT 1;
SET @p_1_30 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_field_specific' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_30 WHERE `namekey` IN ('main_viewlisting_form_field_specific_nested') LIMIT 1;
SET @p_1_31 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_main_viewlisting_data_sorting' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_31 WHERE `namekey` IN ('main_viewlisting_form_main_viewlisting_order','main_viewlisting_form_main_viewlisting_direction') LIMIT 2;
SET @p_1_32 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_main_viewlisting_nested' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_32 WHERE `namekey` IN ('main_viewlisting_form_main_viewlisting_ovly','main_viewlisting_form_main_viewlisting_caption','main_viewlisting_form_main_viewlisting_spc') LIMIT 3;
SET @p_1_33 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewlisting_form_field_style' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_33 WHERE `namekey` IN ('main_viewlisting_form_style_align','main_viewlisting_form_style_width','main_viewlisting_form_style_classes','main_viewlisting_form_style_style') LIMIT 4;
SET @p_1_34 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewmenu_form_display' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_34 WHERE `namekey` IN ('main_viewmenu_form_xsvisible','main_viewmenu_form_xshidden','main_viewmenu_form_devicevisible','main_viewmenu_form_devicehidden') LIMIT 4;
SET @p_1_35 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_viewmenu_form_advanced' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_35 WHERE `namekey` IN ('main_viewmenu_form_advanced_message','main_viewmenu_form_main_action','main_view_menu_form_view_menus_parent','main_viewmenu_form_main_menu_main_viewmenu_icon','main_viewmenu_form_main_menu_color','main_viewmenu_form_main_menu_main_viewmenu_namekey') LIMIT 6;
SET @p_1_36 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_36 WHERE `namekey` IN ('main_widget_form_main_widget_name','main_widget_form_main_widgets_main_widget_namekey','main_widget_form_main_widgets_main_widget_alias','main_widget_form_main_widget_description','main_widget_form_main_widgets_main_widget_type','main_widget_form_main_widgets_main_widget_framework_type','main_widget_form_main_widgets_main_widget_rolid','main_widget_form_main_widgets_main_widget_publish') LIMIT 8;
SET @p_1_37 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_form_position_fieldset' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_37 WHERE `namekey` IN ('main_widget_form_position_ramework_id','main_widget_form_p_suffixclass') LIMIT 2;
SET @p_1_38 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_form_preferences' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_38 WHERE `namekey` IN ('main_widget_form_preferences_nested') LIMIT 1;
SET @p_1_39 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_tag_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_39 WHERE `namekey` IN ('main_widget_form_main_widget_name_copy6633','main_widget_form_main_widgets_main_widget_namekey_copy4086','main_widget_form_main_type','main_widget_form_main_widgets_main_widget_alias_copy7892','main_widget_form_main_widget_description_copy8762','main_widget_form_main_widgets_main_widget_rolid_copy6337','main_widget_form_main_widgets_main_widget_publish_copy3635') LIMIT 7;
SET @p_1_40 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_widget_tag_form_parameters_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_40 WHERE `namekey` IN ('main_widget_tag_form_nested') LIMIT 1;
SET @p_1_41 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_configuration_form_pane' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_41 WHERE `namekey` IN ('main_configuration_form_library_node_test') LIMIT 1;
SET @p_1_42 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='main_view_core_form_wizard_fielset' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_42 WHERE `namekey` IN ('main_view_core_form_main_view_wname','main_view_core_form_main_view_wdescription') LIMIT 2;
SET @yid_85 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_listing' LIMIT 1);
SET @yid_86 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewform_listing' LIMIT 1);
SET @yid_87 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewlisting_listing' LIMIT 1);
SET @yid_88 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_viewmenu_listing' LIMIT 1);
SET @yid_89 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credential_listing_main_credentials' LIMIT 1);
SET @yid_90 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_credentialtype_listing' LIMIT 1);
SET @yid_91 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_listing' LIMIT 1);
SET @yid_92 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_type_listing' LIMIT 1);
SET @yid_93 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_widget_tag_listing' LIMIT 1);
SET @yid_94 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_menu_listing' LIMIT 1);
SET @yid_95 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_listings_listing' LIMIT 1);
SET @yid_96 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_view_forms_listing' LIMIT 1);
SET @yid_97 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_listing_session' LIMIT 1);
SET @yid_98 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_cache_listing' LIMIT 1);
SET @yid_99 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='main_preferences_listing' LIMIT 1);
SET @did_100 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_session_framework' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_view_listing_main_view_trans' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('main_view_listing_main_view_trans_description') LIMIT 1;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_viewform_listing_main_form_main_viewform_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('main_viewform_listing_main_form_main_viewform_name2','main_viewform_listing_main_form_main_viewform_namekey','main_viewform_listing_main_form_main_viewform_description') LIMIT 3;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_viewlisting_listing_main_listing_main_viewlisting_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('main_viewlisting_listing_main_listing_main_viewlisting_description') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_viewmenu_listing_main_menu_main_viewmenu_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('main_viewmenu_listing_main_menu_main_viewmenu_description') LIMIT 1;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_widget_listing_main_widget_alias' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('main_widget_listing_main_widgets_main_widget_alias','main_widget_listing_main_widget_name','main_widget_listing_main_widget_description') LIMIT 3;
SET @p_3_5 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_widget_listing_main_widgets_main_widget_ref_type_container' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_5 WHERE `namekey` IN ('main_widget_listing_main_widgets_main_widget_ref_type','main_widget_listing_main_widgets_main_widget_red_id') LIMIT 2;
SET @p_3_6 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='widget_type_listing_main_widgets_type_widget_type_alias' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_6 WHERE `namekey` IN ('widget_type_listing_main_widgets_type_widget_type_description') LIMIT 1;
SET @p_3_7 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_widget_tag_listing_main_widgets_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_7 WHERE `namekey` IN ('main_widget_tag_listing_main_widgets_name_nested','main_widget_tag_listing_main_widgets_description') LIMIT 2;
SET @p_3_8 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_view_listing_main_view_trans_copy5105' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_8 WHERE `namekey` IN ('main_view_listing_main_view_trans_description_copy4576') LIMIT 1;
SET @p_3_9 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_view_listing_main_view_trans_copy5613' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_9 WHERE `namekey` IN ('main_view_listing_main_view_trans_description_copy3933') LIMIT 1;
SET @p_3_10 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_view_listing_main_view_trans_copy4494' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_10 WHERE `namekey` IN ('main_view_listing_main_view_trans_description_copy6759') LIMIT 1;
SET @p_3_11 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_preferences_listing_main_viewtrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_11 WHERE `namekey` IN ('main_preferences_listing_main_viewtrans_description') LIMIT 1;
SET @did_101 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_widget_group' LIMIT 1);
SET @did_102 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_container_widgets' LIMIT 1);
SET @did_103 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_view_direction' LIMIT 1);
SET @did_104 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_image_style' LIMIT 1);
SET @did_105 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_button_size' LIMIT 1);
SET @did_106 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_picklist_color_style' LIMIT 1);
SET @did_107 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_captcha' LIMIT 1);
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Tips','1','1206732346KLSC');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Days','1','1206732357ILFK'),('Hours','1','1206732357ILFL'),('Minutes','1','1206732357ILFM'),('Seconds','1','1206732357ILFN'),('New','1','1206732361LXFD'),('Edit','1','1206732361LXFE'),('Save Order','1','1206732363AOLD'),('Go','1','1206732365OQJJ'),('Display','1','1206732366OVLY'),('Page','1','1206732366OVLZ'),('Start','1','1206732366OVMC'),('End','1','1206732366OVMF'),('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Show','1','1206732372QTKM'),('Publish','1','1206732372QTKN'),('Item','1','1206732372QTKR'),('Click to translate this!','1','1206732374FDLR'),('Model','1','1206732388KEHV'),('View','1','1206732388KEHZ'),('Menu Element','1','1206732389NXTF'),('Listing Element','1','1206732389NXTG'),('Column','1','1206732389NXTO'),('Columns','1','1206732390BJKP'),('Form Element','1','1206732390BJLA'),('Wizard','1','1206732391QBUR'),('Widgets','1','1206732392OZUO'),('Help','1','1206732392OZUP'),('Preferences','1','1206732392OZUQ'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Type','1','1206732392OZVD'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Extensions','1','1206732399EIMV'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('Refresh','1','1206732400OWXE'),('ID','1','1206732400OWXG'),('Extension','1','1206732400OWXH'),('Direct Edit','1','1206732400OWXQ'),('Text','1','1206732400OWYY'),('Author','1','1206732400OWZO'),('General','1','1206732400OWZR'),('Export','1','1206732405TIXB'),('Standard','1','1206732405TIXC'),('The captcha value entered is not correct!','1','1206732406SEHE'),('None','1','1206732410ICCJ'),('Category','1','1206732411EGQO'),('Lock','1','1206732411EGRI'),('divider','1','1206732411EGRN'),('Email','1','1206732411EGRU'),('Username','1','1206732411EGRV'),('Created','1','1206732411EGRY'),('Locked','1','1206732412DACF'),('Password','1','1206732412DADP'),('Parent','1','1206732412DAEM'),('Access','1','1206732412DAEO'),('Title','1','1206732412DAGC'),('Delete All','1','1206732420EIUT'),('Attributes','1','1206732421RJQZ'),('Default','1','1206732425HINT'),('Last Modified','1','1206961850KLQZ'),('Date','1','1206961850KLRI'),('Modified','1','1206961850KLRL'),('Views','1','1206961854HENY'),('Order Direction','1','1206961868QEVB'),('Menus','1','1206961868QEYD'),('Listings','1','1206961868QEYE'),('Forms','1','1206961868QEYF'),('Action','1','1206961869IGNA'),('Icon','1','1206961869IGNB'),('Header','1','1206961869IGNC'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Elements','1','1206961869IGNG'),('Form','1','1206961869IGNH'),('Area','1','1206961869IGNI'),('Link','1','1206961869IGNO'),('Order','1','1206961869IGNP'),('Style','1','1206961869IGOF'),('Width','1','1206961870KLAD'),('Class','1','1206961870KLAJ'),('Menu','1','1206961870KLBH'),('Size','1','1206961877KAKC'),('Message','1','1206961882TDGU'),('Back','1','1206961882TDHA'),('Report','1','1206961899DDKO'),('Uid','1','1206961899DDKS'),('Code','1','1206961912MJQB'),('Image','1','1206961936HCWM'),('days','1','1206961954EAMZ'),('Theme','1','1207306697RNME'),('User','1','1208359284QWNS'),('Node','1','1211811528BLZA'),('Alias','1','1211811583DBTA'),('Listing','1','1212761197FHZN'),('Captcha','1','1212761242DPBP'),('Queue','1','1212761286RZAR');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Couldn\'t write the captcha in the folder $FOLDER','1','1213107666IZKC'),('Tag','1','1213180343CQIB'),('Searchable','1','1213200894KHAM'),('hours','1','1215507788CYDF'),('Rows','1','1217601376NASF'),('Folder','1','1217603897AYYA'),('Restore','1','1217608861BKDT'),('Field Width','1','1219769904NDIF'),('Required','1','1219769904NDIO'),('Field Height','1','1219769904NDJE'),('Read Only','1','1219769904NDJG'),('Parameters','1','1219769904NDJH'),('Data','1','1219769904NDKA'),('Private','1','1219769905FKPR'),('Default value','1','1219769905FKRC'),('Specify the class name to use for the column.<br>Blank for default.<br>','1','1219769906LJOM'),('Defines the width of the column.<br>Use either a value to represent the pixels or a percent using the percent sign %.<br>','1','1219769906LJON'),('Layout','1','1219769910HXKO'),('Pick-list','1','1219769913SSOH'),('0','1','1219856743ELFT'),('Extends','1','1220446694TBPU'),('Types','1','1220793707SOED'),('Vendors','1','1220793715LTKS'),('Module','1','1221157725EYVU'),('Public','1','1224166212FTLB'),('Number','1','1225317223AXHH'),('Secret Key','1','1225819494GKOC'),('nested','1','1227580858CXTV'),('Medium','1','1227581114PJBX'),('Close','1','1228820287MBVC'),('Users','1','1229653442FEQZ'),('IP','1','1230531895KYXK'),('Automatic','1','1231731000EGWA'),('Nested','1','1233297975SESK'),('Truncate','1','1233298081OPDQ'),('Listing Columns','1','1233298082QODE'),('Items','1','1233642085PNTA'),('Specify the menu parent if any.','1','1234467591PVUV'),('Date format','1','1234467596QADS'),('Left','1','1234467597SEYB'),('Modified By','1','1236926427LMQA'),('Unlocked','1','1240888718QMAD'),('Preference','1','1241490506ODOB'),('Cache','1','1242178310INQS'),('All Preferences','1','1242178314RNWI'),('When to Edit','1','1242179630OEQT'),('Use Node Preference','1','1242179632IZKM'),('Not Visible','1','1242179646EPJF'),('Phone','1','1242282412EESC'),('Time','1','1242282413PMNG'),('Horizontal','1','1242282413PMOC'),('Today','1','1242282415NZVT'),('Right','1','1242282416HAPX'),('Select Language','1','1242282416HAQB'),('Green','1','1242282417SQNH'),('Miscellaneous','1','1242282437ISFV'),('Separator','1','1242282437ISIO'),('System','1','1242282438KRJW'),('Advanced','1','1242282439OJUW'),('Small','1','1242282444LHMW'),('Blue','1','1242282444LHMX'),('Red','1','1242282444LHMY'),('White','1','1242282444LHMZ'),('Orange','1','1242282444LHNB'),('Any','1','1242282448EVJO'),('Browser','1','1242282449PIOD'),('Done','1','1242282449PIPC'),('or','1','1242282450QJDL'),('to','1','1242282452RPKS'),('Translate','1','1242822624LPVJ'),('Framework','1','1243392688MXHE'),('Integration','1','1246509032AGXF'),('Approved','1','1246518570RHDZ'),('Widget','1','1251697929ABZD'),('File Name','1','1252569179LCYJ'),('Thumbnail','1','1253939321KJPL'),('Communication','1','1255339744MGTH'),('Set Interval','1','1256627132RZYQ'),('Generate Report','1','1256627132RZYR'),('Date Range','1','1256627133IVDA'),('Report Header','1','1256627134RCAS'),('Daily','1','1256627134RCAT'),('Weekly','1','1256627134RCAU'),('Monthly','1','1256627134RCAV'),('Last Week','1','1256627134RCAX'),('Last 2 Weeks','1','1256627134RCAY'),('This Month','1','1256627135RQMP'),('Last Month','1','1256627135RQMQ'),('This Year','1','1256627135RQMR'),('Last Year','1','1256627135RQMS'),('Yearly','1','1256627135RQMT'),('Predefined Date','1','1256875165AXAH'),('Specified Date','1','1256875165AXAI'),('Yesterday','1','1259308004LCOJ'),('Report Type','1','1260156216DOTJ'),('There are no logs available at this time. Please check again later.','1','1260434893HJHQ'),('Choose Type','1','1298294174MWVC'),('$TEXT already exist!','1','1299084287SIMJ'),('Sample','1','1302090354NZFX'),('Space','1','1302502965PLCE'),('Check if there is an new version for any app installed on the website.','1','1302519272IRLM');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Rating is required!','1','1303355093GUFG'),('','1','1304525968YBL'),('Percentage','1','1304918318NWFN'),('$TEXT does not exist!','1','1308292311QGYK'),('Overlay','1','1309938358AMXW'),('View PHP code','1','1309938388REBZ'),('Disapproved','1','1310529911CSAV'),('Incl. Tax','1','1315191208QKMR'),('Excl. Tax','1','1315191208QKMS'),('Check Captcha','1','1322125538SPUI'),('Sorry, this file is no longer available on our servers. Please inform Administrator!','1','1325473020QNJX'),('Any Type','1','1327708944HAPH'),('This Week','1','1337266385HCKZ'),('Translation of $TRANSLATED_NAME','1','1339210773JBLQ'),('Please click here to translate $TRANSLATED_NAME. A popup will show up and allow you to input the translation in different languages.','1','1339210773JBLR'),('the namekey of the view is too long to be used for the namekey of the menu, please check the namekey of the view.','1','1339210951DJSU'),('Credentials','1','1340666912COKC'),('Hints','1','1340745649OCDR'),('Mini Report Header','1','1340773357RFYR'),('months','1','1343426232QZMG'),('years','1','1343426232QZMH'),('Undefined','1','1347652450ENIY'),('List Element','1','1347652451NUQI'),('Read only','1','1347652451NUQJ'),('Rolid','1','1347652452OQAE'),('Define the tips or description of the field.<br>','1','1347652452OQAH'),('The title of the wizard<br>','1','1347652452OQAI'),('The default value for new element.<br>','1','1347652452OQAJ'),('Form Elements','1','1347652452OQAK'),('Listing Elements','1','1347652452OQAL'),('Menu Elements','1','1347652452OQAM'),('List of Views','1','1347652452OQAO'),('<p>This is a list of all views available in the applications.<br />\r\n<br />\r\n<strong>Core:</strong> A view which is marked as Core is an original view from the application vendor. If the view is marked as NOT Core it means you have made some modification or customization.<br />\r\n<br />\r\n<strong>Publish:</strong> If a view is unpublished it will not be accessible by the user.<br />\r\n<br />\r\n<strong>Edit:</strong> Use the edit button to change the title of the view or the wizard displayed to the user.</p>','1','1347652452OQAP'),('Design','1','1347896707AYYK'),('Check for Apps update','1','1347916591IUDQ'),('The file can not be downloaded because it is too big.','1','1348621436PSCH'),('Storage','1','1349726937BUMG'),('Bucket Name','1','1349726937BUMK'),('Storage class','1','1349726937BUMN'),('The Amazon S3 credentials are incorrect! Please correct then in the General Preferences','1','1350003540HDZY'),('Web Service URL','1','1350048904IJUH'),('Credential','1','1355852779ARKR'),('Access Key','1','1355852783DYRD'),('New Credential','1','1355852785AMCF'),('Secret Credentials','1','1355852785AMCG'),('This is the list of all the credentials used to connect through API to external applications.<br>this list is only visible and accessible by Super Administrator.<br>You can create several credentials of for the same application if necessary.<br><br>','1','1355852786JPZC'),('Yes / No','1','1356715487MNCI'),('Textarea','1','1356715487MNCJ'),('Date and Time','1','1356715487MNCK'),('Yes / No Reversed','1','1356715487MNCL'),('Create a publish field.','1','1356715487MNCM'),('Create a Yes / No radio button.','1','1356715487MNCN'),('Create a single line text box field.','1','1356715487MNCP'),('Create a field with date and time.','1','1356715487MNCQ'),('Create a field with only a date.','1','1356715488JSXQ'),('Create an email field.','1','1356715488JSXR'),('Create a number field.','1','1356715488JSXS'),('Create a percentage field.','1','1356715488JSXT'),('Create a password field.','1','1356715488JSXU'),('Create a Yes / No radio button but icon reversed.','1','1356715488JSXV'),('In the same windows','1','1356733766RKBF'),('In a new windows','1','1356733767TFPZ'),('In the parent frameset','1','1356733767TFQA'),('In the current frame','1','1356733767TFQB'),('Field Specific','1','1356733768PTQP'),('Field specific','1','1356733768PTQQ'),('Alignment','1','1356733768PTQR'),('Editor Type','1','1356733768PTQS'),('Show Editor Buttons','1','1356733768PTQT'),('Ending characters','1','1356733768PTQU'),('Make clickable link','1','1356733768PTQV'),('Link target','1','1356733768PTQW'),('Default string','1','1356733768PTQX'),('Not header sorting','1','1356733768PTQY'),('Nested Column','1','1356733768PTQZ'),('Remove caption','1','1356733768PTRA'),('Data Sorting','1','1356733768PTRB'),('Order By Priority','1','1356733768PTRC'),('Define the ordering of the field.<br>','1','1356733768PTRF'),('Defines who can access the field.<br>','1','1356733768PTRG'),('Defines if the field should be read only.<br>','1','1356733768PTRH'),('Defines if the field should be required.<br>','1','1356733768PTRI'),('Name of the field.<br>','1','1356733769MIBX'),('A tip or description to explain the field to the user.<br>','1','1356733769MIBY'),('Defines the ordering of columns.<br>','1','1356733769MIBZ'),('Defines who can access the column.<br>','1','1356733769MICA'),('Defines if the column should be searchable through the advance search functionality. <div>If any column is searchable an advance search button will appear automatically.<br></div>','1','1356733769MICC'),('Header of the column<br>','1','1356733769MICE'),('A tip or description to appear on the column header.<br>','1','1356733769MICF'),('Specify the class name to use for the field.<br>Blank for default.<br>','1','1356733769MICG'),('Specify some custom style to apply to the field.','1','1356733769MICH'),('Specify some custom style to apply to the column.','1','1356733769MICI'),('Defines the alignment of the column.','1','1356733769MICJ'),('Yes to use the node\'s preference to decide which editor to use.<br>','1','1356733769MICK'),('Number of columns for the Text Area.<br>','1','1356733769MICL'),('Number of rows for the Text Area.<br>','1','1356733769MICM'),('Choose what kind of editor you want to use.<br>','1','1356733769MICN'),('Yes to show the Framework editor buttons.<br>','1','1356733769MICO'),('The width of the field ( eg: text or text area)<br>','1','1356733769MICP'),('The height of the field ( eg: text area )<br>','1','1356733769MICQ'),('Specify the maximum of characters if you want to truncate the text.<br>','1','1356733769MICS');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Specify some ending characters if necessary.<br>Applied only when the text is truncated.<br>','1','1356733769MICT'),('Specify the number of digits to enter.<br>','1','1356733769MICV'),('Yes to have a click-able link.<br>No to simply show the link URL.<br>','1','1356733769MICW'),('Define the target windows when user click on the link.<br>','1','1356733769MICX'),('Define the text to appear for the link.<br>By default the URL of the link will be shown.<br>','1','1356733769MICY'),('By default a column can be sorted by clicking on the header of the column.<br>Click Yes to disable the sorting by this column.<br>','1','1356733769MICZ'),('Click Yes to remove the caption when the column is nested.<br>','1','1356733769MIDA'),('Click Yes show this column as an overlay of the current column value.<br>','1','1356733769MIDB'),('By default each nested column is separated by a return to the line.<br>However you can specify another character to separate the nested column ( e.g.: a space, to concatenate string )<br>','1','1356733769MIDC'),('Define the priority of the ordering of data.<br>','1','1356733769MIDD'),('Define the direction for the ordering of data.<br>','1','1356733769MIDE'),('Text Area','1','1356733769MIDK'),('New / Edit','1','1357059105KDVU'),('Single','1','1357059110IPWM'),('Multiple','1','1357059110IPWN'),('Specify the size of the input box in number of characters.<br>','1','1357059111JYQD'),('API Name','1','1357296145DBZG'),('API Key','1','1357296145DBZH'),('InfusionSoft Credential','1','1357296145DBZI'),('App Folder','1','1357309003EWPW'),('App Key','1','1357309003EWPX'),('App Secret','1','1357309003EWPY'),('- Select crendentials -','1','1357343462IBXT'),('Credential Type','1','1357948997CAPK'),('Credentials Types','1','1357948999CZIZ'),('Tab container','1','1358294811IVXF'),('Create column','1','1358294811IVXH'),('Create row','1','1358294811IVXI'),('Div container','1','1358294811IVXK'),('No Title','1','1358294812QEQR'),('Remove title area','1','1358294812QEQS'),('Process CMS Content','1','1358294812QEQU'),('Process Joobi tags','1','1358294812QEQV'),('Choose the parent element, to organize the field.<br>','1','1358294813IZVY'),('Type of field.<br>','1','1358294813IZVZ'),('Use to nest column into other column.<br>','1','1358294813IZWA'),('Remove the title and simply leave blank.<br>','1','1358294813IZWB'),('Yes to remove the entire title area and span the value area to the full width..<br>','1','1358294813IZWC'),('Specify when a property can be edited.<br>Will be gray out when editing is not possible.<br>','1','1358294813IZWD'),('Yes to process the content through the CMS content plugin.<br>eg: Joomla articles.<br>','1','1358294813IZWE'),('Yes to process any tags in the content.<br>','1','1358294813IZWF'),('Change the text.<br>','1','1358508735IITK'),('Edit a text translation','1','1358508736RVYL'),('Translated Text','1','1359067423AOHL'),('Translated Textarea','1','1359067423AOHM'),('Translated textarea','1','1359067424EXKS'),('Create a text area for long text (e.g. description).','1','1359067424EXKT'),('Create a short text which needs to be translated in multiple languages.','1','1359067424EXKU'),('Create a translated text area for long text (e.g. description).','1','1359067424EXKV'),('Widget box','1','1359165829EPZO'),('The PDF library is not available, the system cannot generate PDF files.','1','1359430178PKKA'),('Modifying a form','1','1359486683BCQF'),('Listing element or column customization','1','1359486683BCQG'),('Buttons tips','1','1359486683BCQH'),('The information on the General tab is the same for any kind of form element, also called field.<br>The Field Specific depends on what type of field you are editing and for more detailed information please refer to the documentation.<br>The attribute let you change the rendering of the form, for instance if you don\'t want to show the title of the field.<br>The Style tab let you specify some specific style or class to customize the CSS.<br><br>','1','1359486683BCQJ'),('Each \"Listing element\" represent a column into the listing.<br>You can change the ordering of each column or rename the header.<br><br>If the column is specified as searchable, the column will be automatically search when the user enter a keyword in the search box.<br>','1','1359486683BCQK'),('The information on the General tab is the same for any kind of listing element or column.<br>The Field Specific information depends on what type of field you are editing and for more detailed information please refer to the documentation.<br>The attribute let you change the rendering of the column, for instance changing the data sorting or created nested column.<br>The Style tab let you specify some specific style or class to customize the CSS. It allows also to change the column alignment and width.<br><br>','1','1359486683BCQL'),('This is a list of all button for your view.<br>You can change order, rename button or modify the access level of a button.<br>If you unpublish a button it will not longer be accessible to the user.<br>','1','1359486683BCQM'),('Use as Parent','1','1360166005IDUM'),('Let you define this container field as a parent for the custom fields.<br>If different than zero this container will appear in the possible container in the custom field form.<br>The value indicate the order in which it will appear.<br>','1','1360166005IDUN'),('Translated Text Area','1','1360193670QXOO'),('Visible & Order','1','1360240327QUAB'),('duration','1','1360289390KMBD'),('Count down','1','1360289390KMBE'),('minutes','1','1360366414NJAI'),('seconds','1','1360366414NJAJ'),('stop','1','1360366414NJAK'),('Use SSL','1','1360366419PVEQ'),('Bucket Name after /','1','1360366419PVER'),('Default No, define how to write the URL. The bucket name will be in the beginning of the URL before the dot.<br>Yes to put the bucket name after the /.<br>Do not change this setting if you are not sure.<br>','1','1360366420ERXG'),('The font file for the captcha could not be found!','1','1360630221KYCU'),('The file could not be writen on Amazon S3.','1','1360711865IYJW'),('The file could not be uploaded on Amazon S3.','1','1360711865IYJX'),('Select a type','1','1360922680DLQR'),('Reserved Pick-list','1','1360922681PNPQ'),('The GD library needs to be installed!','1','1369749782AJAF'),('To restore a view that you deleted, simply re-install the application.','1','1370648536RVAD'),('Delete an entire view','1','1370648554FHZC'),('IPs','1','1373209080EJXY'),('Google Credential','1','1373209081MPUH'),('The map feature requires PHP 5.3 or higher.','1','1373209094YQB'),('Up To Now','1','1373935459SQDD'),('Chart','1','1374276934ANBO'),('Mailing queue','1','1374608348GDGV'),('Trigger the processing of the mailing queue.','1','1374608348GDGW'),('Mails','1','1375971621IIJU'),('If you do not know what you are doing do not touch the settings below. You can damage your application!','1','1375977738AJMS'),('Read the documentation for further information.','1','1375977738AJMT'),('The form element could not be saved because there is no reference to a view.','1','1375977746FUII'),('The menu could not be saved because there is no reference to a view.','1','1375977746FUIJ'),('Allow you to add formatted time in any content.','1','1377041362DLCC'),('Widget type','1','1377041435CPNQ'),('Widget Type','1','1377041435CPNR'),('2 Years ago','1','1377546988CHLS'),('3 Years ago','1','1377546988CHLT'),('Class suffix','1','1377703397QFCV'),('Module params','1','1377703397QFCW'),('We need a dummy param so that the form get saved.<br>Since we have a nested form with params.<br>','1','1377744895PJNN'),('Modified date','1','1379004130IRAI'),('Define the required role to see the widget.<br>','1','1379004885AWBD'),('This name might be shown to the user is the preferences is set to do so.<br>','1','1379004885AWBE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('If not specified the name will be used. The alias is only used for administration purpose to identify the widget, when many of them have similar names.<br>','1','1379004885AWBG'),('Detailed description of the widget purpose.<br>','1','1379004885AWBH'),('Time widget','1','1379006374DSAT'),('Choose type','1','1379039266OOHC'),('Insert Widget','1','1379039270QKLD'),('Insert widget','1','1379039272DOEH'),('Click on the link to insert the widget','1','1379039272DOEI'),('- Select usage -','1','1379525589DYXL'),('Usage','1','1379525590FHQN'),('Widget\'s Types','1','1379614096IGWC'),('Discussions','1','1380027946LBCD'),('WidgetBox','1','1380064816PMFL'),('Joomla Module','1','1380064816PMFM'),('Simple Div','1','1380064816PMFN'),('Optional: add a class suffix to differentiate the widget from others.<br>','1','1380064817JISO'),('Test e-mail sent from {widget:sitename}','1','1380064818QMSW'),('New updates are available on {widget:param|name=site} !','1','1380064818QMSX'),('<p>An email has been sent with the following information:</p><p><br></p><p>Email: {widget:param|name=email}</p><p>Subject: {widget:param|name=subject}</p><p>Body: {widget:param|name=body}</p><div><br></div><div><br></div><p><br></p><div style=\"text-align: center;\"><a href=\"http://www.joobi.co/\" title=\"Joobi\">Powered by Joobi</a></div>','1','1380064818QMSY'),('<p>Hi {widget:name},</p><p>There are new updates on your website.<br><br>New updates available:<br><br></p><ul><li>{widget:param|name=applicationupdates}</li></ul><p><br>New apps available:<br><br></p><ul><li>{widget:param|name=newapplications}</li></ul><p><br><br>Enjoy!<br><br><br><span style=\"text-decoration: underline;\">Information:</span> To turn off this reminder you have an option in jCenter-&gt;Preferences-&gt;Advance<br><br></p><div style=\"text-align: center;\"><a href=\"http://www.joobi.co\" title=\"Joobi\">Powered by Joobi</a></div>','1','1380064818QMSZ'),('The page widget can only be used with PHP 5','1','1380143302RHWW'),('Please specify the url of the page you want to include','1','1380143302RHWX'),('Can not load the page $URL','1','1380143302RHWZ'),('Any time','1','1380228948FANI'),('Only new','1','1380228948FANJ'),('Only edit','1','1380228948FANK'),('Menus Elements','1','1380567395OUTJ'),('Form elements','1','1380567395OUTK'),('Time zone','1','1380567395OUTL'),('Enter a string containing an English date format.<br>eg: 10 September 2000<br>+1 day<br>+1 week 2 days 4 hours 2 seconds<br>next Thursday<br>last Monday<br>Use now or empty for the current time.<br>','1','1380567396OSFZ'),('Choose the format of the date to render.<br>','1','1380567396OSGA'),('Choose the timezone to use.<br>','1','1380567396OSGB'),('Preferences List','1','1380567396OSGC'),('How to insert the widget?','1','1380567396OSGD'),('Advance Search','1','1382068744SDQH'),('Defines if the column should be searchable. If any column is searchable a search box will appear automatically.<br>','1','1384994595QDWU'),('Refresh Captcha','1','1391449458SRZS'),('Clean Email Statistics','1','1391607531FXMD'),('Delete the email statistics older than a predefine period.','1','1391607531FXME'),('Row 1','1','1392733055LQQF'),('Row 2','1','1392733055LQQG'),('Light Blue','1','1393290131DEFB'),('Basic','1','1393515934QLIQ'),('Honrizontal','1','1393515934QLIR'),('Inline','1','1393515934QLIS'),('column1','1','1394069593IQAS'),('column2','1','1394069593IQAT'),('Loading','1','1395500509GSSS'),('Pane container','1','1395500511PPJW'),('Collapsable Pane container','1','1395500511PPJX'),('Joomla 3.2 Responsive Theme','1','1395500527LEDU'),('Color','1','1395886787SVJW'),('Rounded','1','1396671423GHXG'),('Circle','1','1396671423GHXH'),('On-Input','1','1396671424DMOJ'),('On-Name','1','1396671424DMOK'),('Panel','1','1396671424DMOL'),('Box','1','1396671424DMOM'),('Large','1','1396671424DMOP'),('Token not valid to get original files, it requires a valid plan.','1','1398110833SALX'),('Action not possible :$RETURN','1','1398110833SALY'),('Identifier','1','1398436917DTKC'),('The identifier is important as it it used to identify the widget.<br>','1','1398536034AXNW'),('<p>Click on the link &quot;<strong>Insert widget</strong>&quot; to insert the widget into the content.</p>','1','1400171641CFYI'),('App ID','1','1400174181LTIR'),('The facebook App ID that you can find at the following URL: https://developers.facebook.com/apps','1','1400176087FPTT'),('2X Large','1','1400708937BNOL'),('X Large','1','1400708937BNOM'),('X Small','1','1400708937BNON'),('3X Large','1','1400708937BNOO'),('4X Large','1','1400708937BNOP'),('Animated','1','1400811120SUCB'),('Animated On Mouse Hover','1','1400811120SUCC'),('Unlock','1','1401377882ETOG'),('unLock','1','1401377882ETOH'),('N / A','1','1402625931RQFO'),('Reset Price','1','1404917671CVDL'),('Badge color','1','1405139930SCQX'),('Link or Event','1','1405349619AOWV'),('Specify either an URL or an event to be triggered.','1','1405349619AOWW'),('Small ( Tablet )','1','1406380323COMI'),('Medium ( Desktop )','1','1406380323COMJ'),('Extra Small ( Phone )','1','1407528940CUSY'),('Large ( DeskTop )','1','1407528941QTXC'),('Tablet','1','1407528941QTXD'),('Desktop','1','1407528941QTXE'),('TV','1','1407528941QTXF'),('Visible on Screen','1','1407528942DMEQ'),('Hidden on Screen','1','1407528942DMER'),('<div>Define for what screen size ( device ) the menu will be hidden.</div><div><u>Hint</u>: The menu will be hidden  on that screen size and every lower resolution.</div>','1','1407528942DMET'),('Re-Core','1','1408042170ATLE'),('The views have been successfully updated!','1','1408059813TBDS'),('The view has been successfully updated!','1','1408059813TBDT'),('<div>Define on what screen size ( device ) the menu will be visible.</div><div><u>Hint</u>: The menu will be visible on that screen size and every higher resolution.</div>','1','1409690310HZWW'),('Visible on Device','1','1409709084ILIV'),('Hidden on Device','1','1409709084ILIW'),('Define on what device the menu will be visible.','1','1409709084ILIX'),('Define on what device the menu will be hidden.','1','1409709084ILIY'),('Define on what device the column will be visible.','1','1409709084ILIZ'),('Define on what device the column will be hidden.','1','1409709084ILJA'),('There is no type of $TYPEpublished so the system got one by default.','1','1410185409ETKT'),('1413402828','1','1413480085HVBR');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Select Model','1','1414093502MVHU'),('Define the type of column.','1','1414104730SWZC'),('Joomla 1.6','1','1414744016SROW'),('Joomla 3.0','1','1414744016SROX'),('WordPress 4','1','1414744016SROY'),('Mobile V.1','1','1414744016SROZ'),('Netcom','1','1414744016SRPA'),('Users\' Sessions','1','1414744018EIML'),('Mobile Specific','1','1415125832CRQP'),('Yes, to show the column header in the listing.','1','1415125832CRQQ'),('Tooltip Style','1','1415377877PTRF'),('Tips Above Field','1','1415378020IIPY'),('Tips Below Field','1','1415378020IIPZ'),('Choose the tooltip style','1','1415378022OZRU'),('<p>This e-mail has been sent at <span style=\"font-weight: bold;\">{widget:time} </span>from the website <span style=\"font-weight: bold;\">{widget:sitename} </span>( {widget:site} ) to test your mail configuration.<br /><br /></p>\r\n<div style=\"text-align: center;\"><span style=\"color: #cc0000; font-weight: bold;\">If you receive this e-mail, it means that you will be able to send any other e-mail from the website.</span></div>\r\n<p><br /><br /><br /><br /><br /></p>\r\n<div style=\"text-align: center;\"><a href=\"http://www.joobi.co/\" title=\"Joobi\">Powered by Joobi</a></div>','1','1415654678EXBP'),('An e-mail has been sent by API to {widget:param|name=email}','1','1415678513OMNE'),('1415663813','1','1415678513OMNF'),('Configuration','1','1416665748MZJC'),('Type the proof here','1','1416948592JPZB'),('This is the configuration pane, and it is visible only by the Administrator!','1','1416948594GBIZ'),('Below you will find all the Preferences used to render the page.','1','1416948594GBJA'),('If you do not get the expected result, verify all the Preferences are in accordance with the desired setup.','1','1416948594GBJB'),('View details','1','1416948594GBJC'),('Is Core','1','1416948594GBJD'),('Pane','1','1416948599JVQT'),('The main theme to integrate Joobi Apps to Joomla 3.2.\r\nThe theme responsive and built with bootstrap.','1','1416948600KVDI'),('Are you sure you want to RE-Core the View? If the view is set back to a core view the custom fields on that view will be lost and will have to be added again to the view.','1','1417652012LVWX'),('Example : {widget:page|url=\"http://www.joobi.co\"}','1','1418159563RQJB'),('This is a list of all \"form elements\" or also called fields in the form.<br>The indentation represent the hierarchy of elements. There are elements that we call \"layout element\" like Tabs, Fieldset, and others which are used to define the layout of your form. Those you can modification and even create new ones.<br>The other elements are used to hold you data.<br><br>The area represent the specific area in the theme where the field will be rendered. Those area can be modified in the themes.<br><br>The type is there for information and can\'t not be changed.<br><br>If you unpublish an element it will not be visible to the user any more.<br>','1','1418159573ASQG'),('Create a link field. \r\nEnable to enter an URL.\r\nDisplay a click-able link.','1','1418159573ASQH'),('Bootstrap','1','1418398780RXKS'),('Color picker','1','1418398780RXKT'),('WordPress','1','1418690424RJPQ'),('None SEF URL','1','1419342002KFBC'),('Cache $FOLDER successfully deleted!','1','1420121260PTWF'),('All the cache has been deleted!','1','1420121260PTWG'),('Now you can click on \"Restore\" button to restore the view!','1','1420854481TJBT'),('The views have been successfully restored!','1','1420854481TJBU'),('The view has been successfully restored!','1','1420854481TJBV'),('Buttons & Header','1','1421684732GOVY'),('Define how the buttons and the title of the page should be presented.','1','1421684733OMTP'),('No Header, No Title, No Menu','1','1421684737PPWJ'),('Just Title','1','1421684737PPWK'),('Title - Top Menu','1','1421684737PPWL'),('No Title - Top Menu','1','1421684737PPWM'),('Title - Top & Bottom Menu','1','1421684737PPWN'),('No Title - Top & Bottom Menu','1','1421684737PPWO'),('Title - Bottom Menu','1','1421684737PPWP'),('No Title - Bottom Menu','1','1421684737PPWQ'),('The proof value entered is not correct!','1','1423415282OGNM'),('Proof is Correct!','1','1423415282OGNN'),('The main theme to integrate Joobi Apps to WordPress native theme.','1','1423683949RWKE'),('Solve this question please','1','1424997296GVOP'),('Lowest value','1','1424997296GVOQ'),('Highest value','1','1424997297STJG'),('Re-Captcha','1','1424997302FRPR'),('Site Key','1','1425007246IWYI'),('Google reCaptcha','1','1425007249TGNU'),('Math','1','1425008364MFCI'),('WordPress 4 Native Theme','1','1425043740DAHV'),('WordPress 4 Bootstrap Responsive Theme','1','1425043740DAHW'),('A theme specially designed to support WordPress theme designed with Bootstrap','1','1425043741BMAQ'),('<b><font color=\"#cc0000\">In most of the case leave this empty.</font>&nbsp;</b><div>If you have a different end point than&nbsp;s3.amazonaws.com, you can specify it here.<div><br></div></div>','1','1425489474KFSW'),('reCaptcha require a Site Key! Once you have the keys please enter them into the Credentials menu in the administrator area of your site.','1','1425922198CPJX'),('Virtuemart 3 Starter Theme','1','1426258023BVGO'),('A Joobi store theme specifically designed to integrate to Virtuemart 3 theme styles. \r\nIt uses Virtuemart classes to get started with your theme customization using Joomla templates designed for Virtuemart.\r\nIt allows you to use any Virtuemart 3 compatible templates within the Joobi eCommerce Applications.','1','1426258023BVGP'),('php-xml extension is not installed in your PHP server, it is highly recommanded.','1','1433250437OEYO'),('The plugin \"Joobi - Repalce Widgets in Articles\" is not published!','1','1434036710ZKH'),('Make sure to publish the plugin for the widget to work!','1','1434036710ZKI'),('The header of the view.','1','1434680167LAGD'),('Define the tips or description of the field.','1','1434680167LAGE'),('The title of the wizard','1','1434680167LAGF'),('Specify a file name&nbsp;','1','1434764997FCPY'),('Define a file name where to PHP code will be saved.','1','1434764997FCPZ'),('Custom','1','1434764999FJEM'),('Custom PHP','1','1434765001GPUG'),('Field enabling to write some PHP code.','1','1434765001GPUH'),('Write PHP code','1','1434767164BOLQ');
SET @ctid_108 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_multiform_yid_publish_level_rolid_ordering' LIMIT 1);
SET @ctid_109 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_node_wid_type_publish_level_rolid' LIMIT 1);
SET @ctid_110 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_listing_yid_publish_level_rolid_hidden_ordering' LIMIT 1);
SET @ctid_111 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='layout_mlinks_index_yid_publish_level_rolid_ordering' LIMIT 1);
SET @dbcid_112 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (@ctid_108,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (@ctid_108,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1publish' LIMIT 1)),(@ctid_108,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ordering' LIMIT 1)),(@ctid_108,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_multiforms_fid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_node_yid' LIMIT 1),'1','0',@dbcid_112),(@ctid_109,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2wid' LIMIT 1)),(@ctid_109,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2type' LIMIT 1)),(@ctid_109,'0','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_node_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2namekey' LIMIT 1)),(@ctid_109,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2level' LIMIT 1)),(@ctid_110,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1)),(@ctid_110,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3publish' LIMIT 1)),(@ctid_110,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ordering' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_listings_lid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1)),(@ctid_110,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3level' LIMIT 1)),(@ctid_110,'6','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3hidden' LIMIT 1)),(@ctid_111,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9yid' LIMIT 1)),(@ctid_111,'0','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9publish' LIMIT 1)),(@ctid_111,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9ordering' LIMIT 1)),(@ctid_111,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_viewtrans_yid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481yid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_viewtrans_yid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_menustrans_mid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485mid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_menustrans_mid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_node_sid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2sid' LIMIT 1)),(@ctid_109,'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2rolid' LIMIT 1)),(@ctid_110,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1)),(@ctid_108,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1)),(@ctid_111,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9rolid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_message_queue' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590mgqid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_message_queue_uid_read_create' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590uid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_message_queue_uid_read_create' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590nextdate' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_menus_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_listings_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_forms_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_credentials_node|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='997crdid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_credentials_node' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey997' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_credentials_type|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1003crdidtype' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_credentials_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1003' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1014widgetid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_node_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1014' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_widgets_node_framework_type_publish_core' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1014' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_widgets_node_framework_type_publish_core' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1014' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_widgets_node_framework_type_publish_core' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ref_type1014' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_widget_trans|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015widgetid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_widget_trans|main_userdata' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_type_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1030' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_message_queue_uid_read_create' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='read590' LIMIT 1)),((44647),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590nextdate' LIMIT 1));
SET @ref_feid_113 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1);
SET @ref_feid_114 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1);
SET @ref_feid_115 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1);
SET @pk_77_231 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'2wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_235 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_237 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'9yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_238 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_286 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dropset.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1did\' LIMIT 1' LIMIT 1 );
SET @pk_77_474 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_544 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'481lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_545 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'482fid\' LIMIT 1' LIMIT 1 );
SET @pk_77_546 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'482lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_547 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'484lid\' LIMIT 1' LIMIT 1 );
SET @pk_77_548 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'484lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_549 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'485mid\' LIMIT 1' LIMIT 1 );
SET @pk_77_550 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'485lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_558 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dropset.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3did\' LIMIT 1' LIMIT 1 );
SET @pk_77_624 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'2sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_1004 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10000 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'481yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10380 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'theme.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'2tmid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10386 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'2rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10388 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10389 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10391 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'9rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10431 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'mailing.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'590mgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10432 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_17 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'590uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10570 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.multiforms\' LIMIT 1' AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10571 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.listings\' LIMIT 1' AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10576 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.mlinks\' LIMIT 1' AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'9parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10600 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1ref_yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11141 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid997\' LIMIT 1' LIMIT 1 );
SET @pk_77_11142 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_17 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'modifiedby997\' LIMIT 1' LIMIT 1 );
SET @pk_77_11147 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'model.fields\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'fdid3\' LIMIT 1' LIMIT 1 );
SET @pk_77_11148 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'model.fields\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'fdid1\' LIMIT 1' LIMIT 1 );
SET @pk_77_11151 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'parent2\' LIMIT 1' LIMIT 1 );
SET @pk_77_11156 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid1003\' LIMIT 1' LIMIT 1 );
SET @pk_77_11157 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_17 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid1003\' LIMIT 1' LIMIT 1 );
SET @pk_77_11158 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'crdidtype997\' LIMIT 1' LIMIT 1 );
SET @pk_77_11178 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid1014\' LIMIT 1' LIMIT 1 );
SET @pk_77_11179 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_17 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid1014\' LIMIT 1' LIMIT 1 );
SET @pk_77_11181 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1015widgetid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11182 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1015lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11183 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'wid1014\' LIMIT 1' LIMIT 1 );
SET @pk_77_11216 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_15 AND `ref_dbtid`=@dbtid_14 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1031wgtypeid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11217 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_15 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1031lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11218 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_14 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'wgtypeid1014\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','1','FK_layout_node_wid',@pk_77_231,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',@dbtid_16,@dbtid_1,'4');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('yid','1','FK_layout_multiforms_yid',@pk_77_235,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1),@dbcid_112,'3','3','yid',@dbtid_1,@dbtid_4,'2'),('yid','1','FK_layout_menus_yid',@pk_77_237,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9yid' LIMIT 1),@dbcid_112,'3','3','yid',@dbtid_1,@dbtid_2,'1'),('yid','1','FK_layout_listings_yid',@pk_77_238,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1),@dbcid_112,'3','3','yid',@dbtid_1,@dbtid_3,'5'),('did','1','FK_layout_multiforms_did',@pk_77_286,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1did' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4did' LIMIT 1),'1','1','did',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1),@dbtid_4,'4'),('sid','1','FK_layout_multiforms_sid',@pk_77_474,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1sid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1),'1','1','sid',@dbtid_20,@dbtid_4,'6'),('lgid','1','FK_layout_trans_lgid',@pk_77_544,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481lgid' LIMIT 1),@ref_feid_113,'1','1','lgid',@dbtid_18,@dbtid_5,'99'),('fid','1','FK_layout_multiformstrans_fid',@pk_77_545,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1),'3','3','fid',@dbtid_4,@dbtid_6,'1'),('lgid','1','FK_layout_multiformstrans_lgid',@pk_77_546,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1),@ref_feid_113,'1','3','lgid',@dbtid_18,@dbtid_6,'2'),('lid','1','FK_layout_listingstrans_lid',@pk_77_547,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1),'3','3','lid',@dbtid_3,@dbtid_7,'1'),('lgid','1','FK_layout_listingstrans_lgid',@pk_77_548,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1),@ref_feid_113,'1','1','lgid',@dbtid_18,@dbtid_7,'2'),('mid','1','FK_layout_mlinkstrans_mid',@pk_77_549,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485mid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9mid' LIMIT 1),'3','3','mid',@dbtid_2,@dbtid_8,'1'),('lgid','1','FK_layout_mlinkstrans_lgid',@pk_77_550,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485lgid' LIMIT 1),@ref_feid_113,'1','3','lgid',@dbtid_18,@dbtid_8,'2'),('did','1','FK_listings_dropset_did',@pk_77_558,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3did' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4did' LIMIT 1),'1','1','did',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1),@dbtid_3,'3'),('sid','1','FK_view_sid',@pk_77_624,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2sid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1),'1','3','sid',@dbtid_20,@dbtid_1,'1'),('sid','1','FK_view_listings_sid',@pk_77_1004,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3sid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1),'1','1','sid',@dbtid_20,@dbtid_3,'2'),('yid','1','FK_layout_trans_yis',@pk_77_10000,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481yid' LIMIT 1),@dbcid_112,'3','3','yid',@dbtid_1,@dbtid_5,'99'),('tmid','0','FK_view_tmid',@pk_77_10380,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2tmid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1),'1','1','',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1),@dbtid_1,'3'),('rolid','1','FK_view_rolid',@pk_77_10386,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2rolid' LIMIT 1),@ref_feid_114,'1','1','',@dbtid_19,@dbtid_1,'2'),('rolid','1','FK_view_listings_rolid',@pk_77_10388,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1),@ref_feid_114,'1','1','',@dbtid_19,@dbtid_3,'1'),('rolid','1','FK_view_forms_rolid',@pk_77_10389,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1),@ref_feid_114,'1','1','',@dbtid_19,@dbtid_4,'5'),('rolid','1','FK_view_menus_rolid',@pk_77_10391,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9rolid' LIMIT 1),@ref_feid_114,'1','1','',@dbtid_19,@dbtid_2,'3'),('mgid','1','FK_message_queue_mgid',@pk_77_10431,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590mgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='374mgid' LIMIT 1),'3','3','mgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.node' LIMIT 1),@dbtid_9,'2'),('uid','1','FK_message_queue_uid',@pk_77_10432,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='590uid' LIMIT 1),@ref_feid_115,'3','3','',@dbtid_17,@dbtid_9,'1'),('parent','1','FKParent_fid',@pk_77_10570,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1),'1','1','fid',@dbtid_4,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1),'1'),('parent','1','FK_Parent3_parentlid',@pk_77_10571,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1),'1','1','lid',@dbtid_3,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1),'4'),('parent','1','FK_Parent9_parentmid',@pk_77_10576,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='9mid' LIMIT 1),'1','1','mid',@dbtid_2,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' LIMIT 1),'2'),('ref_yid','1','FK_multiforms_layout_nestedlayout',@pk_77_10600,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_yid' LIMIT 1),@dbcid_112,'1','3','yid',@dbtid_1,@dbtid_4,'3'),('rolid','1','FK_credentials_node_rolid',@pk_77_11141,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid997' LIMIT 1),@ref_feid_114,'1','1','rolid',@dbtid_19,@dbtid_10,'2'),('modifiedby','1','FK_credentials_node_uid',@pk_77_11142,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby997' LIMIT 1),@ref_feid_115,'1','1','uid',@dbtid_17,@dbtid_10,'1'),('fdid','1','FK_layout_listings_fdid',@pk_77_11147,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid3' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='994fdid' LIMIT 1),'3','3','fdid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1),@dbtid_3,'6'),('fdid','1','FK_layout_forms_fdid',@pk_77_11148,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid1' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='994fdid' LIMIT 1),'3','3','fdid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1),@dbtid_4,'7'),('parent','1','FK_layout_node_parent',@pk_77_11151,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent2' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent2' LIMIT 1),'1','1','parent',@dbtid_1,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1),'99'),('rolid','1','FK_credentials_type_rolid',@pk_77_11156,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1003' LIMIT 1),@ref_feid_114,'1','1','rolid',@dbtid_19,@dbtid_11,'99'),('uid','1','FK_credentials_type_uid',@pk_77_11157,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1003' LIMIT 1),@ref_feid_115,'1','1','uid',@dbtid_17,@dbtid_11,'99'),('crdidtype','1','FK_credentials_node_crdidtype',@pk_77_11158,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='crdidtype997' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1003crdidtype' LIMIT 1),'3','3','crdidtype',@dbtid_11,@dbtid_10,'3'),('rolid','1','FK_widgets_node_rolid',@pk_77_11178,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1014' LIMIT 1),@ref_feid_114,'1','1','rolid',@dbtid_19,@dbtid_12,'3'),('uid','1','FK_widgets_node_uid',@pk_77_11179,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1014' LIMIT 1),@ref_feid_115,'1','1','uid',@dbtid_17,@dbtid_12,'2'),('widgetid','1','FK_widget_node_widgetid',@pk_77_11181,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015widgetid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1014widgetid' LIMIT 1),'3','3','widgetid',@dbtid_12,@dbtid_13,'1'),('lgid','1','FK_widget_node_lgid',@pk_77_11182,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1015lgid' LIMIT 1),@ref_feid_113,'1','1','lgid',@dbtid_18,@dbtid_13,'2'),('wid','1','FK_widgets_node_wid',@pk_77_11183,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid1014' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',@dbtid_16,@dbtid_12,'1'),('wgtypeid','1','FK_widgets_type_trans_wgtypeid',@pk_77_11216,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1),'3','3','wgtypeid',@dbtid_14,@dbtid_15,'1'),('lgid','1','FK_widgets_type_trans_lgid',@pk_77_11217,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1),@ref_feid_113,'3','3','lgid',@dbtid_18,@dbtid_15,'2'),('wgtypeid','1','FK_widgets_node_wgtypeid',@pk_77_11218,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wgtypeid1014' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1),'1','1','wgtypeid',@dbtid_14,@dbtid_12,'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_23,'1','1206732357ILFK');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_23,'1','1206732357ILFL'),(@wid_23,'1','1206732357ILFM'),(@wid_23,'1','1206732357ILFN'),(@wid_23,'2','1206732363AOLD'),(@wid_23,'2','1206732365OQJJ'),(@wid_23,'2','1206732366OVLY'),(@wid_23,'1','1206732366OVLZ'),(@wid_23,'2','1206732372QTKI'),(@wid_23,'2','1206732372QTKJ'),(@wid_23,'1','1206732372QTKL'),(@wid_23,'1','1206732372QTKM'),(@wid_23,'2','1206732372QTKR'),(@wid_23,'1','1206732374FDLR'),(@wid_23,'1','1206732392OZUO'),(@wid_23,'1','1206732399EIMV'),(@wid_23,'1','1206732400OWXE'),(@wid_23,'1','1206732400OWXH'),(@wid_23,'1','1206732405TIXB'),(@wid_23,'0','1206732406SEHE'),(@wid_23,'2','1206732410ICCJ'),(@wid_23,'2','1206732411EGRI'),(@wid_23,'2','1206732412DACF'),(@wid_23,'1','1206732425HINT'),(@wid_23,'1','1206961869IGNG'),(@wid_23,'1','1206961869IGNH'),(@wid_23,'1','1206961870KLBH'),(@wid_23,'1','1206961899DDKO'),(@wid_23,'1','1206961954EAMZ'),(@wid_23,'1','1207306697RNME'),(@wid_23,'1','1212761197FHZN'),(@wid_23,'0','1213107666IZKC'),(@wid_23,'1','1215507788CYDF'),(@wid_23,'1','1219769904NDKA'),(@wid_23,'2','1219769905FKPR'),(@wid_23,'2','1224166212FTLB'),(@wid_23,'2','1240888718QMAD'),(@wid_23,'1','1241490506ODOB'),(@wid_23,'1','1242179646EPJF'),(@wid_23,'1','1242282413PMNG'),(@wid_23,'1','1242282415NZVT'),(@wid_23,'1','1242282416HAQB'),(@wid_23,'1','1242282417SQNH'),(@wid_23,'1','1242282444LHMX'),(@wid_23,'1','1242282444LHMY'),(@wid_23,'1','1242282444LHMZ'),(@wid_23,'1','1242282444LHNB'),(@wid_23,'1','1242282450QJDL'),(@wid_23,'2','1242282452RPKS'),(@wid_23,'2','1246518570RHDZ'),(@wid_23,'1','1256627134RCAT'),(@wid_23,'1','1256627134RCAU'),(@wid_23,'1','1256627134RCAV'),(@wid_23,'1','1256627134RCAX'),(@wid_23,'1','1256627134RCAY'),(@wid_23,'1','1256627135RQMP'),(@wid_23,'1','1256627135RQMQ'),(@wid_23,'1','1256627135RQMR'),(@wid_23,'1','1256627135RQMS'),(@wid_23,'1','1256627135RQMT'),(@wid_23,'1','1259308004LCOJ'),(@wid_23,'0','1260434893HJHQ'),(@wid_23,'1','1298294174MWVC'),(@wid_23,'1','1299084287SIMJ'),(@wid_23,'1','1302502965PLCE'),(@wid_23,'1','1302519272IRLM'),(@wid_23,'1','1303355093GUFG'),(@wid_23,'1','1308292311QGYK'),(@wid_23,'2','1310529911CSAV'),(@wid_23,'1','1315191208QKMR'),(@wid_23,'1','1315191208QKMS'),(@wid_23,'0','1325473020QNJX'),(@wid_23,'1','1327708944HAPH'),(@wid_23,'1','1337266385HCKZ'),(@wid_23,'1','1339210773JBLQ'),(@wid_23,'1','1339210773JBLR'),(@wid_23,'0','1339210951DJSU'),(@wid_23,'1','1343426232QZMG'),(@wid_23,'1','1343426232QZMH'),(@wid_23,'1','1347652450ENIY'),(@wid_23,'1','1347916591IUDQ'),(@wid_23,'0','1348621436PSCH'),(@wid_23,'0','1350003540HDZY'),(@wid_23,'1','1356733766RKBF'),(@wid_23,'1','1356733767TFPZ'),(@wid_23,'1','1356733767TFQA'),(@wid_23,'1','1356733767TFQB'),(@wid_23,'1','1357059105KDVU'),(@wid_23,'1','1357343462IBXT'),(@wid_23,'1','1358294811IVXF'),(@wid_23,'1','1358294811IVXH'),(@wid_23,'1','1358294811IVXI'),(@wid_23,'1','1358294811IVXK'),(@wid_23,'1','1359165829EPZO'),(@wid_23,'0','1359430178PKKA'),(@wid_23,'1','1360240327QUAB'),(@wid_23,'1','1360289390KMBD'),(@wid_23,'1','1360289390KMBE'),(@wid_23,'1','1360366414NJAI'),(@wid_23,'1','1360366414NJAJ'),(@wid_23,'1','1360366414NJAK'),(@wid_23,'0','1360630221KYCU');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_23,'0','1360711865IYJW'),(@wid_23,'0','1360711865IYJX'),(@wid_23,'1','1360922680DLQR'),(@wid_23,'1','1360922681PNPQ'),(@wid_23,'0','1369749782AJAF'),(@wid_23,'0','1370648536RVAD'),(@wid_23,'0','1373209094YQB'),(@wid_23,'1','1373935459SQDD'),(@wid_23,'1','1374276934ANBO'),(@wid_23,'1','1374608348GDGV'),(@wid_23,'1','1374608348GDGW'),(@wid_23,'1','1375977738AJMS'),(@wid_23,'1','1375977738AJMT'),(@wid_23,'0','1375977746FUII'),(@wid_23,'0','1375977746FUIJ'),(@wid_23,'1','1377041362DLCC'),(@wid_23,'1','1377546988CHLS'),(@wid_23,'1','1377546988CHLT'),(@wid_23,'1','1379039266OOHC'),(@wid_23,'1','1379039270QKLD'),(@wid_23,'0','1380143302RHWW'),(@wid_23,'0','1380143302RHWX'),(@wid_23,'0','1380143302RHWZ'),(@wid_23,'1','1391607531FXMD'),(@wid_23,'1','1391607531FXME'),(@wid_23,'1','1393290131DEFB'),(@wid_23,'1','1395500509GSSS'),(@wid_23,'1','1395500511PPJW'),(@wid_23,'1','1395500511PPJX'),(@wid_23,'0','1398110833SALX'),(@wid_23,'0','1398110833SALY'),(@wid_23,'1','1400811120SUCB'),(@wid_23,'1','1400811120SUCC'),(@wid_23,'2','1401377882ETOG'),(@wid_23,'2','1401377882ETOH'),(@wid_23,'2','1404917671CVDL'),(@wid_23,'0','1408059813TBDS'),(@wid_23,'0','1408059813TBDT'),(@wid_23,'0','1410185409ETKT'),(@wid_23,'1','1414093502MVHU'),(@wid_23,'1','1416948592JPZB'),(@wid_23,'1','1416948594GBIZ'),(@wid_23,'1','1416948594GBJA'),(@wid_23,'1','1416948594GBJB'),(@wid_23,'1','1416948594GBJC'),(@wid_23,'1','1416948594GBJD'),(@wid_23,'0','1418159563RQJB'),(@wid_23,'1','1419342002KFBC'),(@wid_23,'0','1420121260PTWF'),(@wid_23,'0','1420121260PTWG'),(@wid_23,'0','1420854481TJBT'),(@wid_23,'0','1420854481TJBU'),(@wid_23,'0','1420854481TJBV'),(@wid_23,'1','1423415282OGNM'),(@wid_23,'1','1423415282OGNN'),(@wid_23,'1','1424997296GVOP'),(@wid_23,'1','1424997296GVOQ'),(@wid_23,'1','1424997297STJG'),(@wid_23,'0','1425922198CPJX'),(@wid_23,'0','1433250437OEYO'),(@wid_23,'0','1434036710ZKH'),(@wid_23,'0','1434036710ZKI');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('main_test_email',@rolid_0,'1','1','',@wid_23,'Test e-mail','0','','0','0','1','1','0','3','0','1');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('main_update_apps_available',@rolid_0,'1','1','',@wid_23,'Notification of apps update available','0','{widget:param|name=applicationupdates}\r\n{widget:param|name=newapplications}\r\n{widget:param|name=site}','0','0','1','1','0','3','0','1'),('email_notify_admin',@rolid_0,'1','1','',@wid_23,'Notify Admin for API email sent','0','{widget:param|name=email}\r\n{widget:param|name=subject}\r\n{widget:param|name=body}\r\n','0','0','1','1','0','3','0','1');
INSERT IGNORE INTO `#__theme_node` (`type`,`namekey`,`publish`,`core`,`wid`,`alias`,`filid`,`created`,`modified`,`folder`,`rolid`,`uid`,`ordering`,`framework`) VALUES ('1','joomla30.site.theme','1','1',@wid_23,'Joomla 3.2 Responsive Theme','0','1394145129','1423665810','joomla30',@rolid_0,'0','20','20');
INSERT IGNORE INTO `#__theme_node` (`type`,`namekey`,`publish`,`core`,`wid`,`alias`,`filid`,`created`,`modified`,`folder`,`rolid`,`uid`,`ordering`,`framework`) VALUES ('1','wp40.site.theme','1','1',@wid_23,'WordPress 4 Native Theme','0','1416703144','1423665810','wp40',@rolid_0,'0','22','10'),('1','virtuemart.site.theme','1','1',@wid_23,'VirtueMart compatible theme','0','1423662205','1423665810','virtuemart',@rolid_0,'0','19','20'),('1','wpbootstrap.site.theme','1','1',@wid_23,'WordPress 4 Bootstrap Responsive Theme','0','1425041624','1423665810','wpbootstrap',@rolid_0,'0','21','10');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_23),'','','','','','','','','','','0','');
SET @pk_995_1 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.publish' LIMIT 1 );
SET @pk_995_2 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.yesno' LIMIT 1 );
SET @pk_995_3 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.textarea' LIMIT 1 );
SET @pk_995_4 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.text' LIMIT 1 );
SET @pk_995_6 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.datetime' LIMIT 1 );
SET @pk_995_7 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.dateonly' LIMIT 1 );
SET @pk_995_12 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.email' LIMIT 1 );
SET @pk_995_13 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.numeric' LIMIT 1 );
SET @pk_995_14 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.percent' LIMIT 1 );
SET @pk_995_15 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.password' LIMIT 1 );
SET @pk_995_16 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.yesnoreverse' LIMIT 1 );
SET @pk_995_17 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.url' LIMIT 1 );
SET @pk_995_18 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.select' LIMIT 1 );
SET @pk_995_19 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.trans' LIMIT 1 );
SET @pk_995_20 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.transarea' LIMIT 1 );
SET @pk_995_22 = ( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.custom' LIMIT 1 );
REPLACE INTO `#__fields_node` (`fieldid`,`namekey`,`alias`,`rolid`,`core`,`publish`,`wid`,`params`,`listing`,`form`,`real`,`ordering`,`category`,`visible`,`translate`) VALUES (@pk_995_1,'output.publish','Publish',@rolid_0,'1','1',@wid_23,'columntype=1\ncolumnmamdatory=1','output.publish','output.publish','0','1','70','1','0');
REPLACE INTO `#__fields_node` (`fieldid`,`namekey`,`alias`,`rolid`,`core`,`publish`,`wid`,`params`,`listing`,`form`,`real`,`ordering`,`category`,`visible`,`translate`) VALUES (@pk_995_2,'output.yesno','Yes / No',@rolid_0,'1','1',@wid_23,'columntype=1\ncolumnattributes=1\ncolumnmamdatory=1','output.yesno','output.yesno','0','8','1','1','0'),(@pk_995_3,'output.textarea','Textarea',@rolid_0,'1','1',@wid_23,'columntype=16\ncolumnmamdatory=1','main.textarea','output.textarea','0','3','1','1','0'),(@pk_995_4,'output.text','text',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=255\ntrunchar=...','output.text','output.text','0','1','1','1','0'),(@pk_995_6,'output.datetime','Date and Time',@rolid_0,'1','1',@wid_23,'columntype=4\ncolumnattributes=1\ncolumnmamdatory=1\nformatdate=8\ndateformat=2','output.datetime','output.datetime','0','7','1','1','0'),(@pk_995_7,'output.dateonly','Date',@rolid_0,'1','1',@wid_23,'columntype=4\ncolumnattributes=1\ncolumnmamdatory=1\nformatdate=7\ndateformat=1','output.dateonly','output.dateonly','0','6','1','1','0'),(@pk_995_12,'output.email','Email',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=150','output.email','output.email','0','2','70','1','0'),(@pk_995_13,'output.numeric','Number',@rolid_0,'1','1',@wid_23,'columntype=4\ncolumnattributes=1\ncolumnmamdatory=1','main.simple','output.numeric','0','1','20','1','0'),(@pk_995_14,'main.percent','Percentage',@rolid_0,'1','1',@wid_23,'columntype=1\ncolumnattributes=1\ncolumnmamdatory=1','main.percent','main.percent','0','2','20','1','0'),(@pk_995_15,'output.password','Password',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=100','main.password','output.password','0','3','70','1','0'),(@pk_995_16,'main.yesnoreverse','Yes / No Reversed',@rolid_0,'1','1',@wid_23,'columntype=1\ncolumnattributes=1\ncolumnmamdatory=1\ncolumndefault=1','main.yesnoreverse','main.yesnoreverse','0','4','70','1','0'),(@pk_995_17,'main.url','URL',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=255\nurllstclickable=1\nurllisttext=Link\nurllsttarget=_blank\nwidth=60\nurlclickable=1\nurltarget=_blank\nurldefault=http://','main.url','main.url','0','9','1','1','0'),(@pk_995_18,'output.select','Pick-list',@rolid_0,'1','1',@wid_23,'columntype=14\r\ncolumnmamdatory=1\r\ncolumnsize=254\r\nselectype=3\r\nselectstyle=7','output.selectone','output.select','0','5','1','1','0'),(@pk_995_19,'main.trans','Translated Text',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=255','output.text','main.trans','0','2','1','1','1'),(@pk_995_20,'main.transarea','Translated textarea',@rolid_0,'1','1',@wid_23,'columntype=16\ncolumnmamdatory=1','main.textarea','main.transarea','0','4','1','1','1'),(@pk_995_22,'main.custom','Custom PHP',@rolid_0,'1','1',@wid_23,'columntype=14\ncolumnmamdatory=1\ncolumnsize=254','main.custom','main.custom','0','9','90','1','0');
SET @dbcid_116 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
SET @dbcid_117 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559name' LIMIT 1);
SET @dbcid_118 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559description' LIMIT 1);
SET @dbcid_119 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name996' LIMIT 1);
SET @dbcid_120 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description996' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_23,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1015' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_23,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1015' LIMIT 1)),(@wid_23,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1031' LIMIT 1)),(@wid_23,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1031' LIMIT 1)),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.captcha' LIMIT 1),'1212761242DPBP',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.messagequeue' LIMIT 1),'1212761286RZAR',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.view' LIMIT 1),'1206732388KEHZ',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewtrans' LIMIT 1),'1206732388KEHZ',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewform' LIMIT 1),'1206732390BJLA',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewformtrans' LIMIT 1),'1206732390BJLA',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlisting' LIMIT 1),'1347652451NUQI',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewlistingtrans' LIMIT 1),'1347652451NUQI',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenu' LIMIT 1),'1206732389NXTF',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.viewmenutrans' LIMIT 1),'1206732389NXTF',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credential' LIMIT 1),'1355852779ARKR',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.credentialtype' LIMIT 1),'1357948997CAPK',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1),'1251697929ABZD',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettrans' LIMIT 1),'1251697929ABZD',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettype' LIMIT 1),'1377041435CPNQ',@dbcid_116),(@wid_23,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widgettypetrans' LIMIT 1),'1377041435CPNR',@dbcid_116),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1380064818QMSW',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1380064818QMSX',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1415678513OMNE',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1415654678EXBP',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1380064818QMSZ',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1380064818QMSY',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1413480085HVBR',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1415678513OMNF',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_test_email' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='main_update_apps_available' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1)),(@wid_23,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='email_notify_admin' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1)),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='joomla30.site.theme' LIMIT 1),'1395500527LEDU',@dbcid_117),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='wp40.site.theme' LIMIT 1),'1425043740DAHV',@dbcid_117),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='virtuemart.site.theme' LIMIT 1),'1426258023BVGO',@dbcid_117),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='wpbootstrap.site.theme' LIMIT 1),'1425043740DAHW',@dbcid_117),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='joomla30.site.theme' LIMIT 1),'1416948600KVDI',@dbcid_118),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='wp40.site.theme' LIMIT 1),'1423683949RWKE',@dbcid_118),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='virtuemart.site.theme' LIMIT 1),'1426258023BVGP',@dbcid_118),(@wid_23,( SELECT `tmid` FROM `#__theme_node`  WHERE `namekey`='wpbootstrap.site.theme' LIMIT 1),'1425043741BMAQ',@dbcid_118),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.publish' LIMIT 1),'1206732372QTKN',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.yesno' LIMIT 1),'1356715487MNCI',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.textarea' LIMIT 1),'1356715487MNCJ',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.text' LIMIT 1),'1206732400OWYY',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.datetime' LIMIT 1),'1356715487MNCK',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.dateonly' LIMIT 1),'1206961850KLRI',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.email' LIMIT 1),'1206732411EGRU',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.numeric' LIMIT 1),'1225317223AXHH',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.percent' LIMIT 1),'1304918318NWFN',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.password' LIMIT 1),'1206732412DADP',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.yesnoreverse' LIMIT 1),'1356715487MNCL',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.url' LIMIT 1),'1206961869IGNO',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.select' LIMIT 1),'1219769913SSOH',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.trans' LIMIT 1),'1359067423AOHL',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.transarea' LIMIT 1),'1359067424EXKS',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.custom' LIMIT 1),'1434765001GPUG',@dbcid_119),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.publish' LIMIT 1),'1356715487MNCM',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.yesno' LIMIT 1),'1356715487MNCN',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.textarea' LIMIT 1),'1359067424EXKT',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.text' LIMIT 1),'1356715487MNCP',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.datetime' LIMIT 1),'1356715487MNCQ',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.dateonly' LIMIT 1),'1356715488JSXQ',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.email' LIMIT 1),'1356715488JSXR',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.numeric' LIMIT 1),'1356715488JSXS',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.percent' LIMIT 1),'1356715488JSXT',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.password' LIMIT 1),'1356715488JSXU',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.yesnoreverse' LIMIT 1),'1356715488JSXV',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.url' LIMIT 1),'1418159573ASQH',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='output.select' LIMIT 1),'1304525968YBL',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.trans' LIMIT 1),'1359067424EXKU',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.transarea' LIMIT 1),'1359067424EXKV',@dbcid_120),(@wid_23,( SELECT `fieldid` FROM `#__fields_node`  WHERE `namekey`='main.custom' LIMIT 1),'1434765001GPUH',@dbcid_120);