ERROR: SELECT properties.id, properties.price, IF(locations.label_en='',locations.label_en,locations.label_en) AS location FROM locations, properties WHERE properties.location = locations.id AND properties.flag = 1 AND properties.active = 1 AND properties.price > 0 ORDER BY RAND() LIMIT 1