SQL:SELECT *, ((CASE WHEN cloud LIKE '%Private%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Islands%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%sale%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Ionian%' THEN 1 ELSE 0 END)+(CASE WHEN cloud LIKE '%Sea%' THEN 1 ELSE 0 END)) AS relevance FROM properties WHERE (cloud LIKE '%Private%') AND (cloud LIKE '%Islands%') AND (cloud LIKE '%sale%') AND (cloud LIKE '%Ionian%') AND (cloud LIKE '%Sea%') AND cloud LIKE '% %' ORDER BY pid DESC