SELECT * FROM ip_properties LEFT JOIN ip_users ON prUserID = uID WHERE pr_presentation_type = 0 AND prActive = 1 AND (prFeaturesJSON LIKE '%"109"%' OR (prFeaturesJSON NOT LIKE '%"109"%' AND prArea > 0)) AND (((prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Germany{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Germany{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'Germany') OR (prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Deutschland{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'Deutschland' OR prZip = 'Deutschland' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Deutschland{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'Deutschland')) AND (prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Mülheim{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'Mülheim' OR prZip = 'Mülheim' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Mülheim{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'Mülheim') AND (prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}an{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'an' OR prZip = 'an' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}an{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'an') AND (prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}der{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'der' OR prZip = 'der' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}der{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'der') AND (prLocation LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Ruhr{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCity = 'Ruhr' OR prZip = 'Ruhr' OR prStreet LIKE '{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}Ruhr{ef8dcba5f29a9f4544dbab8fa90557cdf7ec5cde94aad4e50901311ec9a2dc0c}' OR prCountry = 'Ruhr')) ORDER BY CASE WHEN uActiveOrderID != 0 AND uActive = 1 AND uPaidUntil > CURDATE() THEN 0 ELSE 1 END, prPaidPorAdv DESC, prID DESC LIMIT 0, 12