Plastic Shopping Baskets


Plastic Shopping Baskets

Plastic shopping baskets and totes are a key line at Product Giant. Our baskets come in red, blue, green, yellow, black, orange, teal, grey, and rainbow colors. They also come in small and large sizes. We even carry an ergonomic design. The shopping totes/baskets we carry are made of a high-performance plastic that can resist temperatures up to 212 degrees and have metal handles. Need a logo on your plastic shopping baskets, Product Giant can arrange to have it imprinted on them.

1064 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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]