SELECT * FROM `lpdotcom`.`sold_data` WHERE `publish_to_internet` = 1 AND ((`mls` = 'fresno' AND (`list_agent_id` = '27726' OR `sold_agent_id` = '27726' OR `co_list_agent_id` = '27726' OR `co_sold_agent_id` = '27726')) OR (`mls` = 'crmls' AND (`list_agent_id` = 'FR27726' OR `sold_agent_id` = 'FR27726' OR `co_list_agent_id` = 'FR27726' OR `co_sold_agent_id` = 'FR27726')) OR (`mls` = 'kings' AND (`list_agent_id` = '01774472' OR `sold_agent_id` = '01774472' OR `co_list_agent_id` = '01774472' OR `co_sold_agent_id` = '01774472')) OR (`mls` = 'metrolist' AND (`list_agent_id` = 'RGOODSTA' OR `sold_agent_id` = 'RGOODSTA' OR `co_list_agent_id` = 'RGOODSTA' OR `co_sold_agent_id` = 'RGOODSTA'))) AND `saledate` >= '2025-05-18' AND `is_dupe` = 0 ORDER BY `saledate` DESC