Please contact the admin and include the following SQL Code:
SELECT
P.vcSKU AS cartpid,
P.vcSKU AS pid,
P.vcSKU AS sku,
P.LIST_PR_AMT AS msrp,
IFNULL(P.decConsumerPriceOverride, CASE WHEN ( IFNULL(P.decConsumerPrice,0.00) <= 0.00 ) THEN P.LIST_PR_AMT ELSE P.decConsumerPrice END) AS price,
P.ITM_TXT AS name,
P.CAT_TXT AS description,
P.RTL_WGT_QTY AS weight,
P.vcUrl AS url,
P.UPS_IND AS ups,
P.intInStockQuantity AS stockquantity,
P.vcManufacturer AS manufacturer,
P.vcImageName AS image,
'/images/thumbnails/' AS imagedir,
C.intQuantity AS quantity,
P.decNumStars AS num_stars,
P.intNumCustomerReviews AS num_reviews,
0 AS alt_supplier,
P.enIsTaxFree AS taxfree,
P.enIsShippingFree AS shipfree,
P.enIsAlternateSupplier AS alt_supplier
FROM CART C, ITEM P
WHERE
C.vcSessionID ='54cfd93eed517c3e8ce7fe2eb27046f3'
AND C.vcProductCode = P.vcSKU
AND P.enIsActive = 'YES'
ORDER BY 1
ERROR ():
Please contact the admin and include the following SQL Code:
SELECT S.vcSKU, S.decNumStars, S.vcHeader, S.vcComments, DATE_FORMAT(MAX(S.dtCreated),'%M %D, %Y') AS dtCreated,
MAX(A.vcCity) AS vcCity, MAX(A.vcState) AS vcState,
S.intTransactionID AS intCustomerID
FROM CUSTOMER_ITEM_STARS S LEFT OUTER JOIN CUSTOMERS C ON (
UCASE(S.vcCustomerID) = LCASE(S.vcCustomerID) AND S.vcCustomerID = C.intCustomerID)
LEFT OUTER JOIN CUSTOMER_ADDRESSES A ON (A.intCustomerID = C.intCustomerID AND A.enLastUsed IN ('BOTH','SHIPPING'))
WHERE S.vcSKU='SJMT1790TBK' AND S.enIsActive = 'YES'
GROUP BY S.vcSKU, S.decNumStars, S.vcHeader, S.vcComments, S.dtCreated
ORDER BY S.dtCreated DESC
SJMT1790TBK - Oceans Ultrafold Towel Dispenser, Transparent Black, 11-3/4w x 6-1/4d x 18h
Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0
Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
Printable View
