Untitled query #16567

SQL

use svwiki_p;
/*SELECT page_title, COUNT(*) AS Antal FROM page
INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id
#WHERE page_title='Brandy_Norwood'
WHERE (cl_to = 'Amerikanska_skådespelare' OR cl_to = 'Skådespelare_från_Kalifornien') AND page_namespace = 0
GROUP BY page_title
HAVING Antal > 1
ORDER BY page_title
LIMIT 100
*/
SHOW TABLES;
SELECT gt_page_id, page_id, page_title, gt_type, gt_name, gt_lat, gt_lon, gt_primary FROM geo_tags 
INNER JOIN page ON gt_page_id = page_id
WHERE page_namespace = 0 AND page_is_redirect = 0
LIMIT 1000
SQL

Checking query status...
