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