Newport House to Rent for Ryder Cup 2010 (Property ID: 1789)

SELECT PHOTO_ID,PHOTO,CAPTION FROM photos WHERE PHOTO!='' AND PROPERTY_ID='1789' AND STATUS='GO' ORDER BY MAINPHOTO DESC
SELECT properties.PROPERTY_ID,properties.ADVERT_TITLE,properties.EVENTLEASING_URL,properties.PROPERTY_CITY,properties.PROPERTY_COUNTY,properties.PROPERTY_COUNTRY,properties.ACCOUNT_TYPE,events.EVENT_TXTID FROM properties INNER JOIN events ON properties.EVENT_ID=events.EVENT_ID WHERE properties.STATUS='ONLINE' AND properties.EVENTLEASING_URL='less-than-3-miles-from-celtic-manor' AND properties.DATE_EXPIRATION>=CAST(NOW() as DATETIME) LIMIT 1