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='HON34002RML' AND S.enIsActive = 'YES'
GROUP BY S.vcSKU, S.decNumStars, S.vcHeader, S.vcComments, S.dtCreated
ORDER BY S.dtCreated DESC
HON34002RML - 34000 Series Single Right Pedestal Metal Desk, Med Oak/Putty, 45-1/4W X 24D
A high-quality steel desk that excels at the basics. Full-extension high-sided file drawer, with triple-tied suspension, accommodates hanging files without hangrails. Three-quarter extension box drawer with nylon roller suspension. Three-quarter modesty panel for privacy. Heavy-duty frame design promises years of optimum performance. Strong chrome legs for added stability. Desk Type: Single Right Pedestal Desk; Width : 45 1/4 in; Depth : 24 in; Height : N\A. Weight: 83 lbs. Sold As: 1 EA
Product Codes: HON34002RML, HON 34002RML, HON-34002RML
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
