SELECT * FROM property_meta LEFT JOIN language ON language_id = property_meta_language_id WHERE property_meta_url = 'a' AND language_abbr = 'en'