Untitled

SELECT Extracted_Cores_0.Core_UUID, Extracted_Cores_0.Core_ID, Extracted_Cores_0.Serial_ID, Extracted_Cores_0.Farm_name, Extracted_Cores_0.Corer_depth, Extracted_Cores_0.Soil_core_length, Extracted_Cores_0.Num_pictures, Extracted_Cores_0.Lat_pos, Cores.Latitude as Original_Lat_pos,  Extracted_Cores_0.Lon_pos, 
Cores.Longitude as Original_Lon_pos,
Extracted_Cores_0.Core_cutting_type, Extracted_Cores_0.Extraction_date, Extracted_Cores_0.Comments, Extracted_Cores_0.Problem, Extracted_Cores_0.created_at, Extracted_Cores_0.created_by, Extracted_Cores_0.glue_wf_id, Extracted_Cores_0.status, Extracted_Cores_0.Cf_platform, Extracted_Cores_0.status_reason
FROM agriprod.Extracted_Cores Extracted_Cores_0 
join agriprod.Cores Cores
on Extracted_Cores_0.Core_ID = Cores.Core_ID
where DATE(Extracted_Cores_0.Extraction_date) >= ? order by Extracted_Cores_0.Extraction_date