Welcome to The Uttermost Company, manufacturers of wall décor, lamps and decorative accessories. In keeping with our tradition of innovative products and services, we're pleased to offer our catalog online to assist in your product selection.
New From Market
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_id, pd.products_name, p.products_image, IFNULL(s.specials_new_products_price,p.products_price) as products_price from products p, products_description pd left join specials_retail s on p.products_id = s.products_id where DATE_SUB(CURDATE(),INTERVAL 180 DAY) <= p.products_date_added and products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc, pd.products_name limit 200
