                      <h4>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
cottages.CottCountry=3 and
 specials.ownerid=owners.ownerid

and cottages.Cottcounty=county.countyid and 

'2024-11-21' between specials.spe_startdate and specials.spe_enddate

order by spe_added     </h4>