The use of Nellies Trunk.Com website is based on your acceptance of the following conditions of use.
PRODUCT DESCRIPTIONS & PRICING
We at Nellies Trunk try to maintain accurate product desciptions, pricing & images shown on the web pages. However, images shown are for illustration purposes only and the product supplied may vary slightly.
Should for whatever reason an item be mispriced, we reserve the right to contact you using the details you supplied from setting up your account and notify you of the items correct price. The same applies to shipping costs.
PRODUCT AVAILABLITY
We try to maintain an accurate amount of stock available, however if an item ordered becomes out of stock, unavailable or difficult to source in reasonable time we will again contact you and inform you of the situation and, at our discretion, allow you to cancel the order or place the item on back order.
select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10
