Another one on COUNT / SQL
If you look at the site listed in the private area...
The value in the 'Matches' column should be counting the number of matching keywords between the user logged in, and the product listed.
So if you sort by Product so that Leopard Camp is at the top with 10 matches, and click on Leopard Camp, and then the Keyword Profile on the left, you can see that it only has four - Africa, Botswana, AberdareNP and Safari Tented Camp (< 20 rooms).
So the maximum matches the user logged in could have is 4.
If you click on 'Your Keyword Profile' at the top, you can see the keywords for the user, of which there are just 2: Africa and Botswana.
So the count in the original table should really just be 2, not 10 - i.e. the two keywords that are common to the user and the product, i.e. Africa and Botswana.
This is one I thought was working in testing, but isn't looking right now a few more people are using it - some double counting probably.
Details below....
I have attached a copy of the page for reference.
Thanks again.
