Ray Komka Coins, Inc  
 Quick Find more

Advanced Search

View All Items
 What's New? more
Sorry, product image is currently not available
1853 Half Cent MS 61 (Choice Uncirculated)
About Us
Shipping & Returns
Gift Voucher FAQ
Privacy Notice
Contact Us
Printable Catalog
01.Foreign Coins by the 1 lb Grab Bag
02.1976-D CH BU Washington Quarter Singles
03.Peace Dollars AU-50 to AU-58, in Bulk
04.2007 Presidential $1 Coin Proof Set 4 Coins PD0
05.1982-P Copper S.D. CH BU Lincoln Cent Singles
06.Walking Liberty Half Dollar Rolls VG-XF, 20 coins
07.2009-P CH BU Jefferson Nickel Singles
08.2005 Complete Mint Set
09.1989 U.S. Proof Set
10.2010 CH BU Silver Eagle Dollar Singles
Latest Products
View as GridView as Grid
1 2 3 4 5 ... Next 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'raykomka_oscmax.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_model, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_ordered, p.products_sort_order, pd.products_short, p.manufacturers_id, p.products_msrp, p.products_sort_order, p.products_status, p.products_price, p.products_tax_class_id, p.products_featured, p.products_quantity, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c using(categories_id) where (p.products_status = '1' OR p.products_status = '2') and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and find_in_set('0', p.products_hide_from_groups) = 0 order by products_date_added desc, p.products_sort_order asc, pd.products_name limit 0, 25