Untitled query #17569

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

USE svwiki_p;

DESCRIBE geo_tags;

SELECT SELECT p1.page_title, gt_lat, gt_lon FROM geo_tags INNER JOIN page AS p1 ON gt_page_id=p1.page_id INNER JOIN categorylinks AS cl1 ON p1.page_id=cl1.cl_from 
INNER JOIN page AS p2 ON p2.page_title=cl1.cl_to INNER JOIN categorylinks AS cl2 ON p2.page_id=cl2.cl_from WHERE
cl2.cl_to='Orter_i_Irland'

/*
SELECT  cl_from, page_title FROM geo_tags INNER JOIN page ON gt_page_id=page_id INNER JOIN
*/
/*
SELECT *, page_title FROM categorylinks INNER JOIN page on page_id=cl_from WHERE
cl_to='Orter_i_Irland'
*/

/*
SELECT * FROM user WHERE
user_id = 649138
*/ 

/*
SELECT * FROM logging
WHERE log_user=0
AND log_action='create'
AND (log_title LIKE '%Ogrodzeni%' OR log_title LIKE '%Sztachety%')
AND log_namespace=0
AND LENGTH(log_title)>0
ORDER BY LENGTH(log_title)
*/

/*
SELECT * FROM categorylinks INNER JOIN page on cl_from=page_id WHERE
  cl_to = page_title 
  AND page_namespace = 14
*/

/*
SELECT * FROM page WHERE
page_id = 1441071
*/


/*
SELECT * FROM pagelinks WHERE
pl_title LIKE '%Upper_Bavaria%' OR
pl_title LIKE '%Lower_Bavaria%' OR
pl_title LIKE '%Upper_Palatinate%' OR
pl_title LIKE '%Upper_Franconia%' OR
pl_title LIKE '%Swabia' OR
pl_title LIKE '%Middle_Franconia%' OR
pl_title LIKE '%Lower_Franconia%'
/*

/*
SELECT rc_timestamp AS Tid, CONCAT('[[',REPLACE(rc_title,'_',' '),']]') AS Artikel, CONCAT('align="right"|{{nts|',page_len,'}}') AS Storlek, GROUP_CONCAT(cl_to) AS Kategori, rc_user_text AS Skapare 
FROM recentchanges INNER JOIN categorylinks ON rc_cur_id=cl_from INNER JOIN page on cl_from=page_id
WHERE rc_new=1 
AND rc_namespace=0
AND cl_to LIKE '%chackspelare%'
GROUP BY rc_timestamp, rc_title, rc_user_text
ORDER BY rc_timestamp
*/

/*
SELECT rc_user_text AS användare, COUNT(*) AS antal_red,
        SUM(IF(rc_new_len>rc_old_len+19,1,0)) AS antal_plusred, 
        SUM(IF(rc_new_len>rc_old_len+19,rc_new_len-rc_old_len,0)) AS volym_plusred, 
        SUM(IF(ABS(rc_new_len-rc_old_len)<20,1,0)) AS antal_putsred,
        SUM(IF(ABS(rc_new_len-rc_old_len)<20,ABS(rc_new_len-rc_old_len),0)) AS volym_putsred,
        SUM(IF(rc_new_len<rc_old_len-19,1,0)) AS antal_minusred, 
        SUM(IF(rc_new_len<rc_old_len-19,rc_old_len-rc_new_len,0)) AS volym_minusred FROM recentchanges WHERE
rc_title='Artikelnomineringar' 
AND rc_namespace=4
AND rc_type<5
GROUP BY användare
ORDER BY volym_plusred DESC
*/

/*
SELECT tl_title, COUNT(page_id) AS antal FROM templatelinks INNER JOIN page on tl_from=page_id WHERE
tl_title LIKE 'Illustrationsbehov%'
AND tl_namespace=10
AND page_namespace=0
GROUP BY tl_title
ORDER BY tl_title
*/

/*
SELECT page_title, rev_timestamp, rev_user_text FROM categorylinks INNER JOIN page ON cl_from=page_id INNER JOIN revision on page_id=rev_page 
WHERE cl_to = 'Mallar_för_illustrationsbehov'
AND rev_parent_id=0
ORDER BY rev_timestamp
*/

/*
SELECT * FROM recentchanges WHERE
rc_user_text LIKE 'Larske%' 
*/

/*
SELECT el_to FROM externallinks WHERE el_to LIKE '%www.iucnredlist%' AND
LENGTH(el_to)>27
*/

/*
SELECT NOW();
SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%www.iucnredlist%';
SELECT NOW();
SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%oldredlist%';
SELECT NOW();
*/

/*
SELECT rev_user_text, rev_timestamp FROM revision WHERE
rev_comment LIKE '%WP:HG%'
*
/*
SELECT log_action,log_title, log_user, user_name, log_timestamp, log_params FROM logging INNER JOIN user ON log_user=user_id WHERE
#log_action = 'block'
log_timestamp > '20160701000000'
#AND log_timestamp < '20180201000000'
#AND log_title = '213.204.35.226'
AND log_params LIKE '%06-15%'
#AND log_title LIKE '%:%'
#AND LENGTH(log_title)>30
#AND SUBSTR(log_title,5,1)=':'
#log_timestamp > '20180518000000'
ORDER BY log_timestamp DESC
#GROUP BY log_title
#ORDER BY log_title
*/
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 Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
