This is what worked for me:-

SELECT cc.cn

, sum(a.visits) as total_visits

FROM (

SELECT hostname

, COUNT( DISTINCT...

Hi Livingston,

Thank you for your reply.

This is what I made uptill now:-

SELECT cc.cn

, a.visits

FROM (

SELECT hostname

...

Thanks a lot Livingston,

I changed your query to

It gave...

Hi Luis,

I changed the country tables for better Indexing and wrote the completely new posts and what I tried here :-

http://www.sqlservercentral.com/Forums/Topic1466508-391-1.aspx

I will be very very very very thankful if you...

Hi,

I really appreciate your assistance. I am using MySQL with PHP.

SELECT cn As 'Country Visited', count(0) AS 'No. of Times'

FROM mslop_login_activity a

INNER JOIN ip ON ( INET_ATON(a.hostname) BETWEEN START AND...

Hi Luis,

Sorry it showed wrong results.

All I want is to see total visits for each country; how many visits have been made per country.

Country ...

Thank you very much Luis.

There is a slight problem, the query gives

Do you have an idea, what could be the problem?

Should I...

Thank you very much Luis,

The query does work but it shows wrong results for the IP.

For example, it shows me wrong country for the provided IP.

Lets say if I say...