Nautical Compass by Raisons Nautical Instruments Co. offering an impressive collection of of Compass that range from Brunton compass to Round sundial compass, Brass wheel compass and Gimble compass to Butterfield Suntimer compass, and nautical compass with more specialized features - the engineering compass (also called as British officer) and round sundial compass. Most of our compass are polished to a bright high-luster finish, and some compass are available in an antique brass patina.
Compass is a simple device used to know directions. The magnetic needle used is pivoted over a smooth pointed base to make it move freely. This needle points to Geographic North and South directions. In ancient times voyagers used compass to know their direction of sailing in sea. These compass are beautiful solid brass antique reproductions of antique compass. They are fully functional and beautifully made.
We are one of the best manufacturer exporter and wholesales suppliers of Nautical Compasses. Top quality nautical compass manufacturers, nautical compass suppliers, nautical instruments, antique compass, sundial compass, nautical gifts
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'raisonsb_newdb.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '34' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10