SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}La{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'La' OR prZip = 'La' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}La{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'La') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Finca{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'Finca' OR prZip = 'Finca' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Finca{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'Finca') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Golf{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'Golf' OR prZip = 'Golf' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Golf{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'Golf') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}and{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'and' OR prZip = 'and' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}and{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'and') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Spa{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'Spa' OR prZip = 'Spa' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Spa{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'Spa') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Resort{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'Resort' OR prZip = 'Resort' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Resort{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'Resort') AND (prLocation LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Spain{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}Spain{07ed6f7a09b9b93ebcdb7b8f48fd1fd782bd55d8de2a081364330d56a906570f}' OR prCountry = 'Spain')