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