SELECT * FROM ip_properties WHERE prActive = 1 AND (((prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Germany{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Germany{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Germany') OR (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Deutschland{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Deutschland' OR prZip = 'Deutschland' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Deutschland{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Deutschland')) AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Aachen{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Aachen{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Aachen') AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}/{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}/{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = '/') AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Eilendorf{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Eilendorf' OR prZip = 'Eilendorf' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Eilendorf{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Eilendorf'))
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 '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Germany{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Germany{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Germany') OR (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Deutschland{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Deutschland' OR prZip = 'Deutschland' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Deutschland{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Deutschland')) AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Aachen{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Aachen{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Aachen') AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}/{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}/{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = '/') AND (prLocation LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Eilendorf{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCity = 'Eilendorf' OR prZip = 'Eilendorf' OR prStreet LIKE '{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}Eilendorf{4fc5782d17afe2eb3deb7f5de897fbe0c5a3eeaccbc6cc083607268a5f35091b}' OR prCountry = 'Eilendorf'))
ORDER BY
CASE
WHEN uActiveOrderID != 0 AND uActive = 1 AND uPaidUntil > CURDATE() THEN 0
ELSE 1
END,
prPaidPorAdv DESC,
prID DESC
LIMIT
0, 12
