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