INSERTINTOStatItemVALUES(0,'In-Portal','SELECT count(*) FROM <%prefix%>Category WHERE Status=1 ',NULL,'la_prompt_ActiveCategories','0','1');
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT count(*) FROM <%prefix%>PortalUser WHERE Status=1 ',NULL,'la_prompt_ActiveUsers','0','1');
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT count(*) FROM <%prefix%>UserSession',NULL,'la_prompt_CurrentSessions','0','1');
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) as CategoryCount FROM <%prefix%>Category',NULL,'la_prompt_TotalCategories',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS ActiveCategories FROM <%prefix%>Category WHERE Status = 1',NULL,'la_prompt_ActiveCategories',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS PendingCategories FROM <%prefix%>Category WHERE Status = 2',NULL,'la_prompt_PendingCategories',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS DisabledCategories FROM <%prefix%>Category WHERE Status = 0',NULL,'la_prompt_DisabledCategories',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS NewCategories FROM <%prefix%>Category WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Category_DaysNew"%>*86400 AND (NewItem = 2) )',NULL,'la_prompt_NewCategories',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) FROM <%prefix%>Category WHERE EditorsPick = 1',NULL,'la_prompt_CategoryEditorsPick',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Category',NULL,'la_prompt_NewestCategoryDate',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Category',NULL,'la_prompt_LastCategoryUpdate',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS TotalUsers FROM <%prefix%>PortalUser',NULL,'la_prompt_TopicsUsers',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS ActiveUsers FROM <%prefix%>PortalUser WHERE Status = 1',NULL,'la_prompt_UsersActive',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS PendingUsers FROM <%prefix%>PortalUser WHERE Status = 2',NULL,'la_prompt_UsersPending',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS DisabledUsers FROM <%prefix%>PortalUser WHERE Status = 0',NULL,'la_prompt_UsersDisabled',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>PortalUser',NULL,'la_prompt_NewestUserDate',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT( DISTINCT LOWER( Country ) ) FROM <%prefix%>PortalUser WHERE LENGTH(Country) > 0',NULL,'la_prompt_UsersUniqueCountries',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT( DISTINCT LOWER( State ) ) FROM <%prefix%>PortalUser WHERE LENGTH(State) > 0',NULL,'la_prompt_UsersUniqueStates',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS TotalUserGroups FROM <%prefix%>PortalGroup',NULL,'la_prompt_TotalUserGroups',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS BannedUsers FROM <%prefix%>PortalUser WHERE IsBanned = 1',NULL,'la_prompt_BannedUsers',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS NonExipedSessions FROM <%prefix%>UserSession WHERE Status = 1',NULL,'la_prompt_NonExpiredSessions',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS ThemeCount FROM <%prefix%>Theme',NULL,'la_prompt_ThemeCount',0,2);
INSERTINTOStatItemVALUES(0,'In-Portal','SELECT COUNT(*) AS RegionsCount FROM <%prefix%>Language',NULL,'la_prompt_RegionsCount',0,2);
INSERTINTOStylesheetSelectorsVALUES(46,8,'Product title link','a.link-product1','a:0:{}','Product title link',1,'color: #62A1DE;\r\nfont-size: 14px;\r\nfont-weight: bold;\r\nline-height: 20px;\r\npadding-bottom: 10px;',0);
INSERTINTOStylesheetSelectorsVALUES(75,8,'Copy of Main path link','table.main-path td a:hover','a:0:{}','',1,'color: #ffffff;',0);
INSERTINTOStylesheetSelectorsVALUES(160,8,'Current item in navigation bar','.checkout-step-current','a:0:{}','',1,'color: #A20303;\r\nfont-weight: bold;',0);
INSERTINTOStylesheetSelectorsVALUES(67,8,'Pagination bar: text','table.block-pagination td','a:3:{s:5:"color";s:7:"#8B898B";s:9:"font-size";s:4:"12px";s:11:"font-weight";s:6:"normal";}','',1,'',0);
INSERTINTOStylesheetSelectorsVALUES(68,8,'Pagination bar: link','table.block-pagination td a','a:3:{s:5:"color";s:7:"#8B898B";s:9:"font-size";s:5:"12px;";s:11:"font-weight";s:6:"normal";}','',1,'',0);
INSERTINTOStylesheetSelectorsVALUES(69,8,'Product description in product list','.product-list-description','a:2:{s:5:"color";s:7:"#8B898B";s:9:"font-size";s:4:"12px";}','',1,'',0);
INSERTINTOStylesheetSelectorsVALUES(83,8,'Product title link in list (shopping cart)','a.link-product-cart','a:0:{}','Product title link',1,'color: #18559C;\r\nfont-size: 12px;\r\nfont-weight: bold;\r\ntext-decoration: none;\r\n\r\n',0);
INSERTINTOStylesheetSelectorsVALUES(61,8,'Block: header of data table','td.block-data-grid-header','a:6:{s:4:"font";s:28:"Arial, Helvetica, sans-serif";s:5:"color";s:7:"#009DF6";s:9:"font-size";s:4:"12px";s:11:"font-weight";s:4:"bold";s:16:"background-color";s:7:"#E6EEFF";s:7:"padding";s:3:"6px";}','',1,'white-space: nowrap;\r\npadding-left: 10px;\r\n/*\r\nbackground-image: url(/in-commerce4/themes/default/img/bullet1.gif);\r\nbackground-position: 10px 12px;\r\nbackground-repeat: no-repeat;\r\n*/',0);
INSERTINTOStylesheetSelectorsVALUES(65,8,'Link in product list additional row','td.product-list-additional a','a:1:{s:5:"color";s:7:"#8B898B";}','',2,'',64);
INSERTINTOStylesheetSelectorsVALUES(55,8,'Main table, left column','td.main-column-left','a:0:{}','',1,'width:180px;\r\nborder: 1px solid #62A1DE;\r\nborder-top: 0px;',0);
INSERTINTOStylesheetSelectorsVALUES(70,8,'Product title link in list (category)','a.link-product-category','a:0:{}','Product title link',1,'color: #18559C;\r\nfont-size: 12px;\r\nfont-weight: bold;\r\ntext-decoration: none;\r\n\r\n',0);
INSERTINTOStylesheetSelectorsVALUES(66,8,'Pagination bar block','table.block-pagination','a:0:{}','',1,'',0);
INSERTINTOStylesheetSelectorsVALUES(49,8,'Bulleted list inside block','td.block-data ul li','a:0:{}','',1,' list-style-image: url(/in-commerce4/themes/default/img/bullet2.gif);\r\n margin-bottom: 10px;\r\n font-size: 11px;',0);
INSERTINTOStylesheetSelectorsVALUES(87,8,'Cart item input form element','td.cart-item-atributes input','a:0:{}','',1,'border: 1px solid #7BB2E6;',0);
INSERTINTOStylesheetSelectorsVALUES(119,8,'Data grid row header','td.block-data-row-hdr','a:0:{}','Used in order preview',2,'background-color: #eeeeee;\r\nborder-bottom: 1px solid #dddddd;\r\nborder-top: 1px solid #cccccc;\r\nfont-weight: bold;',48);
INSERTINTOStylesheetSelectorsVALUES(82,8,'"More" link image','a.link-more img','a:0:{}','',2,'text-decoration: none;\r\npadding-left: 5px;',64);
INSERTINTOStylesheetSelectorsVALUES(63,8,'Additional info under product description in list','td.product-list-additional','a:5:{s:5:"color";s:7:"#8B898B";s:9:"font-size";s:4:"11px";s:11:"font-weight";s:6:"normal";s:10:"border-top";s:18:"1px dashed #8B898B";s:13:"border-bottom";s:18:"1px dashed #8B898B";}','',2,'',48);
INSERTINTOStylesheetSelectorsVALUES(57,8,'Main table, right column','td.main-column-right','a:0:{}','',1,'width:220px;\r\nborder: 1px solid #62A1DE;\r\nborder-top: 0px;',0);
INSERTINTOStylesheetSelectorsVALUES(161,8,'Block for sub categories','td.block-data-subcats','a:0:{}','',2,' background: #FFFFFF\r\nurl(/in-commerce4/themes/default/in-commerce/img/bgr_categories.jpg);\r\n background-repeat: no-repeat;\r\n background-position: top right;\r\nborder-bottom: 5px solid #DEEAFF;\r\npadding-left: 10px;',48);
INSERTINTOStylesheetSelectorsVALUES(47,8,'Block content of featured product','td.featured-block-data','a:0:{}','',1,'font-family: Arial,Helvetica,sans-serif;\r\nfont-size: 12px;',0);
INSERTINTOStylesheetSelectorsVALUES(50,8,'Product title link in list','a.link-product2','a:0:{}','Product title link',1,'color: #62A1DE;\r\nfont-size: 12px;\r\nfont-weight: bold;\r\ntext-decoration: none;\r\n\r\n',0);
INSERTINTOStylesheetSelectorsVALUES(62,8,'Block: columns header for data table','table.block-no-border th','a:6:{s:4:"font";s:28:"Arial, Helvetica, sans-serif";s:5:"color";s:7:"#18559C";s:9:"font-size";s:4:"11px";s:11:"font-weight";s:4:"bold";s:16:"background-color";s:7:"#B4D2EE";s:7:"padding";s:3:"6px";}','',1,'text-align: left;',0);
INSERTINTOStylesheetSelectorsVALUES(59,8,'Block without border','table.block-no-border','a:0:{}','',1,'border: 0px; \r\nmargin-bottom: 10px;\r\nwidth: 100%;',0);
INSERTINTOStylesheetSelectorsVALUES(74,8,'Main path language selector cell','td.main-path-language','a:0:{}','',1,'vertical-align: middle;\r\ntext-align: right;\r\npadding-right: 6px;',0);