Untitled query #16567

SQL

use nnwiki_p;
SELECT DISTINCT(page_title) COUNT(*) FROM page 
LIMIT 10;
/*
WHERE page_namespace = 0
*/
/*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
 
SELECT COUNT(DISTINCT page_title) AS Antal FROM geo_tags
INNER JOIN page ON gt_page_id = page_id
WHERE page_namespace = 0 AND page_is_redirect = 0
*/
SQL

Checking query status...
