SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Calvià{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Calvià{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCountry = 'Calvià') AND (prLocation LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}/{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}/{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCountry = '/') AND (prLocation LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Bendinat/Cas{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCity = 'Bendinat/Cas' OR prZip = 'Bendinat/Cas' OR prStreet LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Bendinat/Cas{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCountry = 'Bendinat/Cas') AND (prLocation LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Catala{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCity = 'Catala' OR prZip = 'Catala' OR prStreet LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Catala{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCountry = 'Catala') AND (prLocation LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Spain{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}Spain{6ec723d8309b1864c016ccbec25d2f876bb72b7992bbd8208b29c6b90b5b3b2b}' OR prCountry = 'Spain')
