string(1501) "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 '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Polop{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prCity LIKE '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Polop{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prZip = 'Polop' OR prStreet LIKE '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Polop{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prCountry = 'Polop') AND (prLocation LIKE '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Spain{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prCity LIKE '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Spain{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prZip = 'Spain' OR prStreet LIKE '{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}Spain{30eb01857cc04723003b7c7826132bfc49d1e026e5653b4172a861b82df5267a}' OR prCountry = 'Spain')) ORDER BY CASE WHEN uActiveOrderID != 0 AND uActive = 1 AND uPaidUntil > CURDATE() THEN 0 ELSE 1 END, prPaidPorAdv DESC, prID DESC LIMIT 0, 12 "