query
RESULTSET
query
  APP_NAME BLOGID BRANDKEY CACHEID COMPANY CUSTOMERID DNS_VERIFIED DOMAINID DOMAIN_ACTIVE DOMAIN_DNS DOMAIN_EMAILS DOMAIN_EMAILS_QTY DOMAIN_NAME DOMAIN_NAMEID DOMAIN_NAME_UPDATED DOMAIN_REGISTRARID EMAIL_PROVIDERID FRAME_FORWARD HTML5_IMPORTED HTMLTEMPLATEID IMAGE_FOLDER MAIN MINISITE MINISITE MOBILETEMPLATEID PARENTID PHOTOGRAPHERID PORTFOLIO_TEMPLATEID PORTFOLIO_WEBSITEID PUBLISHED RACKSPACE_DOMAINID ROBOTSTXT ROW_NUMBER SERVERID SITEID SSLATTEMPTS SSLDATEFINALIZED SSLDATEVERIFIED SSLDNSVERIFIED SSLEXPIRATION SSLLASTATTEMPT SSLLASTFINALIZATIONATTEMPT SSLREQUIRED SSLRESPONSEFROMGETCERTIFICATE SSLRESPONSEFROMGETTXT SSLTIMEUPDATED SSLVERIFICATIONKEY SSLVERIFICATIONSTATUSURL SSLVERIFICATIONVALUE STOREID TABLEPARTITION TEMPLATEID TIME_CREATED TIME_EXPIRATION TYPE WEBSITEID WEBSITE_TYPEID WWW
1 [empty string] 1606 photobiz 0 Sample Account [empty string] [empty string] [empty string] 1 1 [empty string] 0 fitzgerald.photographerflashwebsites.com 5206159 [empty string] 1 1 0 0 [empty string] image2 0 0 0 [empty string] 0 20228 [empty string] 0 0 0 [empty string] 1 2 400 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3079 25 [empty string] 2017-12-26 09:15:52.0 [empty string] UserShared 0 11 0
CACHED false
EXECUTIONTIME 36
SQL SET @numz = 0; SELECT dom.domain_nameID, dom.minisite,dom.domain_active, dom.photographerID, dom.serverID, dom.domain_name, dom.domain_name_updated, dom.domain_dns, dom.domain_registrarID, dom.domain_emails, dom.domain_emails_qty, dom.website_typeID, dom.type, dom.published, dom.main, dom.parentID, dom.email_providerID, dom.websiteID, dom.dns_verified, dom.minisite, dom.time_expiration, dom.time_created, dom.frame_forward, dom.cacheID, wt.app_name, sn.image_folder, dom.storeID, dom.portfolio_websiteID, dom.rackspace_domainID, dom.robotsTxt ,certs.* , ld.tablepartition , ld.sslRequired , brands.key as brandKey , kw.company , ws.templateID, ws.htmltemplateID, ws.customerID, ws.mobiletemplateID, ws.html5_imported , pds.templateID as portfolio_templateID , st.siteId , bl.blogId ,(@numz:=@numz+1) AS row_number FROM domain_names dom LEFT JOIN website_type wt ON dom.website_typeID = wt.website_typeID LEFT JOIN server_name as sn ON dom.serverID = sn.serverID LEFT JOIN ssl_certs certs ON dom.domain_nameID = certs.domainId LEFT JOIN photobiz_001.logindata ld ON dom.photographerID = ld.photographerID LEFT JOIN photobiz_001.account acct ON dom.photographerID = acct.photographerID LEFT JOIN photobiz_001.brands brands ON acct.brandID = brands.brandID LEFT JOIN photobiz_001.keyweb kw ON dom.photographerID = kw.photographerID LEFT JOIN templates2.website ws ON dom.websiteID = ws.websiteID LEFT JOIN portfolio.website pws ON dom.portfolio_websiteID = pws.websiteID LEFT JOIN portfolio.designs pds ON pws.designID = pds.designID LEFT JOIN sites.sites st ON dom.photographerId = st.accountId LEFT JOIN blog.blogs bl ON dom.storeId = bl.storeId WHERE 0 = 0 AND domain_name = 'fitzgerald.photographerflashwebsites.com' ORDER BY dom.domain_nameID