SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Cala{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Cala{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCountry = 'Cala') AND (prLocation LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Major{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Major{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCountry = 'Major') AND (prLocation LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Spain{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}Spain{be55e1f212dcbb45d551450a26d90373e7f3f30dc588dcb9591ab8af7a9cf232}' OR prCountry = 'Spain')