|
RUBBERMAID COMMERCIAL PRODUCTS 40-Gallon Brute® Square Container (Container Only) Gray |
Container; Shpg. Wt. is 14.75-lbs.
Square shape offers up to 14% more capacity than round containers. Durable plastic will not leak; withstands repeated commercial cleanings. Container has molded handles and bottom grip. Lid sold separately (RCP 3539 GRA).1/2 sq. x 283/4h.
Description: Gray
Unit Weight: ~13 lbs.
Product Number: RCP 3536 GRA
Quantity: Each
<< Go Back
|
|
|
Reviews
| Customer Number: 14037 | Reviewer From: Westhampton Beach, NY |
|
|
|
|
| |
RUBBERMAID COMMERCIAL PRODUCTS 40-Gallon Container 40-Gallon Brute® Square Container (Container Only)
Item: RCP3536GRA
Catalog Page: 345
ERROR WHILE PULLING DATA FROM (execute)
(mysql_errno): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3539 GRA)
AND M.MANUFACTURER_NAME = I.MANUFACTURER
AND I.IS_ACTIVE ' at line 30
SELECT DISTINCT
I.ITEM_ID, REPLACE(' ','',I.ITEM_NUMBER) AS item, M.MANUFACTURER_NAME,
I.ITEM_ID_NAME,
SKU_DESCRIPTION_1, SKU_DESCRIPTION_2,
CONCAT(
IFNULL(I.SKU_GROUP_DESCRIPTION,''),' ',
IFNULL(I.SKU_DESCRIPTION_1,''), ' ',
IFNULL(I.SKU_DESCRIPTION_2,'')
) AS SKU_GROUP_DESCRIPTION,
IFNULL(I.PAGE_GRAY_BOX,
CONCAT(
IFNULL(I.SKU_GROUP_DESCRIPTION,''), ' ',
IFNULL(I.BREAKOUT_HEADER,'')
)
) AS PAGE_GRAY_BOX,
TRUNCATE(I.LIST_PRICE,2) AS LIST_PRICE, TRUNCATE(I.DIST_NET_PRICE,2) AS DIST_NET_PRICE,
ROUND(
CASE WHEN (CUSTOM_SALE_PRICE IS NOT NULL) THEN
LEAST(CUSTOM_SALE_PRICE, IFNULL(decPriceOverride, DIST_NET_PRICE*(1+(decDiscountRate/100))))
ELSE IFNULL(decPriceOverride, DIST_NET_PRICE*(1+(decDiscountRate/100)))
END
,2) AS PURCHASE_PRICE,
I.vcPictureName,
I.SKU_GROUP_DESCRIPTION AS SKU_GROUP_DESCRIPTION_ORIG, I.ITEM_ID_NAME,
I.BREAKOUT_HEADER,
I.PAGE_ITEM_QUANTITY,
I.UOM AS UNIT, U.NAME AS UOM_NAME
FROM LIVE_Products I, MANUFACTURER_LIST M, REF_UOM U
WHERE
I.ITEM_ID IN (RCP 3539 GRA)
AND M.MANUFACTURER_NAME = I.MANUFACTURER
AND I.IS_ACTIVE = 'YES'
AND U.UOM = I.UOM
 |
|
 |
 |
|
We could not execute commands on the database.
Please try again later.
We are sorry for this inconvenience.
Actual DB Error: string(227) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3539 GRA)
AND M.MANUFACTURER_NAME = I.MANUFACTURER
AND I.IS_ACTIVE ' at line 30"
SELECT DISTINCT
I.ITEM_ID, REPLACE(' ','',I.ITEM_NUMBER) AS item, M.MANUFACTURER_NAME,
I.ITEM_ID_NAME,
SKU_DESCRIPTION_1, SKU_DESCRIPTION_2,
CONCAT(
IFNULL(I.SKU_GROUP_DESCRIPTION,''),' ',
IFNULL(I.SKU_DESCRIPTION_1,''), ' ',
IFNULL(I.SKU_DESCRIPTION_2,'')
) AS SKU_GROUP_DESCRIPTION,
IFNULL(I.PAGE_GRAY_BOX,
CONCAT(
IFNULL(I.SKU_GROUP_DESCRIPTION,''), ' ',
IFNULL(I.BREAKOUT_HEADER,'')
)
) AS PAGE_GRAY_BOX,
TRUNCATE(I.LIST_PRICE,2) AS LIST_PRICE, TRUNCATE(I.DIST_NET_PRICE,2) AS DIST_NET_PRICE,
ROUND(
CASE WHEN (CUSTOM_SALE_PRICE IS NOT NULL) THEN
LEAST(CUSTOM_SALE_PRICE, IFNULL(decPriceOverride, DIST_NET_PRICE*(1+(decDiscountRate/100))))
ELSE IFNULL(decPriceOverride, DIST_NET_PRICE*(1+(decDiscountRate/100)))
END
,2) AS PURCHASE_PRICE,
I.vcPictureName,
I.SKU_GROUP_DESCRIPTION AS SKU_GROUP_DESCRIPTION_ORIG, I.ITEM_ID_NAME,
I.BREAKOUT_HEADER,
I.PAGE_ITEM_QUANTITY,
I.UOM AS UNIT, U.NAME AS UOM_NAME
FROM LIVE_Products I, MANUFACTURER_LIST M, REF_UOM U
WHERE
I.ITEM_ID IN (RCP 3539 GRA)
AND M.MANUFACTURER_NAME = I.MANUFACTURER
AND I.IS_ACTIVE = 'YES'
AND U.UOM = I.UOM
|
|
|
|
 |
|
 |
|
| |
Printable View
