| SQLSTATE |
08S01 |
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
COOLSite |
| SQL |
SELECT top 1
t.stylefolder AS TemplateStyle, c.colorname AS TemplateColor, t.menu_orientation,
t.Version as TemplateVersion, s.ecommerceEnabled, s.chargeSalesTax, s.chargeSalesTaxforShipping,
s.orderConfirmationPage,
s.dataPurged,
s.intlshiprateseditable, s.showintlshipinstructions, sgn.email, sgn.websitetype,
s.metadescription, s.metakeywords, s.includeCOInstr, s.intlshippinginstructions, casT(s.htmlheadtext as varchar(8000)) htmlheadtext,
s.PaymentProcessorID,
s.showCartLinkInNav, s.shippingActive, s.is4charity,
s.pageaccess_notification_email, sgn.firstname siteownerfirstname, sgn.lastname siteownerlastname,
sgn.phone as siteownerphone, s.itemsorderedemailcc, s.siteidhashed, s.atv_vwmylstng, s.shw_vwmylstng_btn,
s.realestate_contactbutton_config, s.viewlist_btn_name, sgn.company siteownercompany,
s.realestate_contactbutton_showagentlist, s.parentsiteid, s.automarkproductasnew, s.newproductvalidityperiod,
s.paypal_username, s.siteLoginPanel, s.siteLoginPanelType, s.siteActivityTracker, s.siteHomeScout, s.siteActivityTrackerLabel, s.siteHomeScoutFromEmail,
s.showminicart, s.showcategorylist, s.showmanufacturerlist, s.shownewitems, s.shownav, s.templateid, s.themeid, s.showCrumbs
FROM Sites s WITH (NOLOCK) JOIN Signups sgn WITH (NOLOCK) ON s.siteid = sgn.siteid
JOIN Templates t WITH (NOLOCK) ON s.templateid = t.templateid
JOIN TemplateColors c WITH (NOLOCK) ON s.colorid = c.colorid
WHERE s.SiteID = 9293 |
|