Cardiff Bay - Luxury Two storey apartment (Property ID: 1801)

SELECT PHOTO_ID,PHOTO,CAPTION FROM photos WHERE PHOTO!='' AND PROPERTY_ID='1801' 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='cardiff-bay' AND properties.DATE_EXPIRATION>=CAST(NOW() as DATETIME) LIMIT 1