Ray Komka Coins, Inc  
 Quick Find more

Advanced Search

View All Items
 What's New? more
Sorry, product image is currently not available
1848 Large Cent Good (G) Condition
About Us
Shipping & Returns
Gift Voucher FAQ
Privacy Notice
Contact Us
Printable Catalog
01.1976-D CH BU Washington Quarter Singles
02.Dansco 5/8" Slipcase, Album slipcover
03.Peace Dollars AU-50 to AU-58, in Bulk
04.1982-P Copper S.D. CH BU Lincoln Cent Singles
05.2007 Presidential $1 Coin Proof Set 4 Coins PD0
06.2009-P CH BU Jefferson Nickel Singles
07.Walking Liberty Half Dollar Rolls VG-XF, 20 coins
08.1976-P CH BU Washington Quarter Singles
09.2005 Complete Mint Set
10.1989 U.S. Proof Set
Latest Products
View as GridView as Grid
Previous 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 100, 25