SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Cala{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Cala{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'Cala') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Llombards{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'Llombards' OR prZip = 'Llombards' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Llombards{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'Llombards') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}/{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}/{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = '/') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Palma{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'Palma' OR prZip = 'Palma' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Palma{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'Palma') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}de{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}de{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'de') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Mallorca{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'Mallorca' OR prZip = 'Mallorca' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Mallorca{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'Mallorca') AND (prLocation LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Spain{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}Spain{14f61abd5fd9f4959821ed132e9e991484282a67783179fb82fa52383ee073e4}' OR prCountry = 'Spain')