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='CPM01103CT' AND S.enIsActive = 'YES'
GROUP BY S.vcSKU, S.decNumStars, S.vcHeader, S.vcComments, S.dtCreated
ORDER BY S.dtCreated DESC
The gentle, natural formula of this floor cleaner is ideal for mopping wood floors and paneling. Plus, it leaves no dulling residue, but does provide a fresh scent. Simply use 1/4 cup per gallon of water. Cleaner/Detergent Type: Floor; Application: Floors; Applicable Material: Wood; Chemical Compound: Alkaline. Weight: 39 lbs. Sold As: 1 CT
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
