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