multiple identical names in coordinate

SQL

set @ns:=0;
SELECT gt_name, gt_lat, gt_lon, COUNT(*),
       gt_type,
       p1.page_namespace as ns,
       p1.page_title as title,
       gt_country,gt_region FROM geo_tags AS g1 JOIN page AS p1 ON g1.gt_page_id = p1.page_id
where gt_name != ''
GROUP BY gt_name, gt_lat, gt_lon, gt_type, ns, title, gt_country,gt_region
HAVING COUNT(*) > 3 and ns = @ns
ORDER BY COUNT(*) DESC;

SET @ns:=0;
SELECT gt_name, COUNT(*),
       (SELECT GROUP_CONCAT(p1.page_title)
        FROM geo_tags AS g2 JOIN page AS p1 ON g2.gt_page_id = p1.page_id
        WHERE g2.gt_page_id = g1.gt_page_id
        AND p1.page_namespace = g1.ns
        AND p1.page_title = g1.title) AS titles,
       FROM geo_tags AS g1 JOIN page AS p1 ON g1.gt_page_id = p1.page_id
WHERE gt_name != ''
GROUP BY gt_name, titles
HAVING COUNT(*) > 3 AND ns = @ns
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
