select spe_id,specials.CottageId,DATE_FORMAT(specials.spe_enddate,'%d-%m-%Y') as enddate1, specials.spe_price,specials.spe_text,specials.spe_currency,specials.spe_startdate, specials.spe_enddate,specials.spe_normalprice, specials.ownerid,cottages.Cottage,cottages.summary as Description, phone,mobile,MainPhoto,WebAddress,Description1,email,county.countyname as Cottcounty from specials left join cottages on cottages.CottageId=specials.CottageId ,owners,county where specials.ownerid=owners.ownerid and cottages.Cottcounty=county.countyid and '2024-06-18' between specials.spe_startdate and specials.spe_enddate order by spe_added