SQL:SELECT *, ((CASE WHEN cloud LIKE '%hotels%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%agios-nikolaos%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%hotels%') AND (cloud LIKE '%agios-nikolaos%') AND (cloud LIKE '%%') AND proptype LIKE '%Hotels%' AND cloud LIKE '% %' ORDER BY pid DESC
Loading your selected locations...