SQL:SELECT *, ((CASE WHEN cloud LIKE '%naxos%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%naxos%') AND munic LIKE 'naxos%' AND munic = 'Naxos' AND cloud LIKE '% %' ORDER BY pid DESC
Loading your selected locations...