SQL
AخA
SELECT pl_from, lt_title, cl1.cl_to
FROM page , categorylinks as cl1, categorylinks as cl2, pagelinks, linktarget
Where cl2.cl_to = 'Begriffsklärung'
AND cl2.cl_from= page_id
AND pl_from_namespace = 0
AND pl_target_id = lt_id
AND lt_title=page_title
AND lt_namespace = 0
AND lt_title not like '%Begriffsklärung%'
AND cl1.cl_to like '%cup%'
AND cl1.cl_to not like '%Occupy%'
AND cl1.cl_from= pl_from
ORDER BY pl_from DESC
Limit 300;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.