Showing record sales in June 2023. View records from May 2023 or all of 2023.
SELECT site_id, site_title, site_modtitle, site_currency, site_hot_score, prd_id, prd_title, prd_image, prd_link, prd_price, prd_score, prd_numbids, prd_numwatchers, prd_enddate, prd_img_uploaded_to_s3, DATE_FORMAT(prd_enddate, '%d %M %Y') AS tdate, site_ebay_mkr_id, site_ebay_site_id, site_ebay_mkc_id, site_ebay_camp_id, site_ebay_tool_id, site_ebay_mk_evt FROM tbl_products_top_historic_1 JOIN tbl_sites ON prd_siteid = site_id JOIN tbl_website_sites ON websitesite_siteid = site_id AND websitesite_websiteid = 1 WHERE 1=1 AND prd_enddate LIKE '2023-06%' AND prd_banned = 0 AND prd_sold = 1 ORDER BY prd_price DESC LIMIT 100