SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Costa{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCity = 'Costa' OR prZip = 'Costa' OR prStreet LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Costa{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCountry = 'Costa') AND (prLocation LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}De{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCity = 'De' OR prZip = 'De' OR prStreet LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}De{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCountry = 'De') AND (prLocation LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}La{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCity = 'La' OR prZip = 'La' OR prStreet LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}La{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCountry = 'La') AND (prLocation LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Calma{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCity = 'Calma' OR prZip = 'Calma' OR prStreet LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Calma{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCountry = 'Calma') AND (prLocation LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Spain{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}Spain{42abaca26359cf6426496d5c117edf841b12c14dcba51fa5e3e0481d9047cc7b}' OR prCountry = 'Spain')