This query is marked as a draft This query has been published by Larske.

SQL

​x
 
use nowiki_p;
SELECT DISTINCT(page_title), COUNT(*) FROM page 
WHERE page_namespace = 0
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
*/
​
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...