SELECT * , COUNT( photos.name ) AS 'numPics'
FROM `properties`
INNER JOIN `photos` ON properties.id = photos.property_id
WHERE (
`city_id` = '25'
OR `zipcode` = '0'
)
AND 'numPics' !=0
AND `bathrooms` > '0'
GROUP BY properties.id
LIMIT 0 , 30