SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Calvià{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Calvià{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCountry = 'Calvià') AND (prLocation LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}/{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}/{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCountry = '/') AND (prLocation LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Bendinat{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCity = 'Bendinat' OR prZip = 'Bendinat' OR prStreet LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Bendinat{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCountry = 'Bendinat') AND (prLocation LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Spain{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}Spain{abfbdd76382e8d2134c5c805feaea0efecca4bea05bb1c30ae2f94eb3b533af1}' OR prCountry = 'Spain')