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 '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Deutschland{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCity = 'Deutschland' OR prZip = 'Deutschland' OR prStreet LIKE '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Deutschland{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCountry = 'Deutschland') OR (prLocation LIKE '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Germany{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Germany{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCountry = 'Germany')) AND (prLocation LIKE '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Darmstadt{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCity = 'Darmstadt' OR prZip = 'Darmstadt' OR prStreet LIKE '{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}Darmstadt{3e24a5dfcfd9c566bade50675918b6ee86d61c373d83e9079b5f286748621b13}' OR prCountry = 'Darmstadt')) ORDER BY CASE WHEN uActiveOrderID != 0 AND uActive = 1 AND uPaidUntil > CURDATE() THEN 0 ELSE 1 END, prPaidPorAdv DESC, prID DESC LIMIT 0, 12