(Property ID: )

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