homelocationabout usCACHE_REPLACE_LOGINBUTTONcontact us
Quick Card Finder
1137 S. Robertson Blvd
Los Angeles, CA 90035
(310) 278-0887
What's New?  
New cards are always hitting the market in every sport, and it happens faster than we can keep up with it. So check here for our latest additions, and we'll do our best to keep you informed about the exciting new inventory we're getting before we're able to categorize it. Remember, at CaliforniaSportsCards.com, your satisfaction is our number one concern!
1067 - Invalid default value for 'products_date_added'

create temporary table tmp_products_new select p.products_id, pd.products_name, p.products_image, p.products_price, products_has_special, products_price_original, p.products_tax_class_id, p.products_date_added, p.products_model,p.products_quantity,p.products_weight,products_is_card,p.has_image,p.has_description,has_graded,has_grade_1,has_grade_2,has_grade_3,has_grade_4,has_grade_5,has_grade_6,has_grade_7,listing_data,p.products_upc,products_manufacturer,products_year_start,products_year_end from products p, products_description pd where products_is_card = 1 and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_date_added > '2023-11-25' and products_quantity > 0 order by p.products_id DESC limit 1000