select '' as housetype,provider,sos.houseid,destination,adults,Housesize,pool,Jacuzzi,rooms,housesize,Petnumber,Foto1,Foto2,Foto3,dktekst,priceEUR as priceDKK,geo1,geo2 from sos inner join priceshort on priceshort.houseid = sos.houseid where PriceEUR <> 0 and Foto1 <> '' and fromdate = '' and todate = ''