Within the United States: Spend $119 or more and use coupon code FREEUS to get free shipping.
Outside the United States: Spend $199 or more and use coupon code FREEINT to get free shipping.
Terms and Conditions: *Free Standard Shipping is only valid on orders with a merchandise total of $119 or more for orders within the continental 48 United States or $199 or more for all other locations. Only one coupon code can be applied per order; can't be combined with other offers. Standard rates apply to all other shipping methods offered. Orders need to be placed by 12:00 pm PST (Monday-Friday) in order to ensure same day shipping.
[Rated of 5 Stars!]
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 '' at line 15
a.products_id as pID,
products_description b ON a.products_id = b.products_id
LEFT OUTER JOIN
categories_description c ON a.products_category_main = c.categories_id
b.language_id = '1'