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