SQL
AخA
/*
Test
*/
SELECT
page_title,
(COUNT(DISTINCT eu_entity_id)) as ct
FROM
page,
page_props,
wbc_entity_usage
WHERE
page_namespace = 14
AND page_id = pp_page
AND pp_propname = "unexpectedUnconnectedPage"
AND page_id = eu_page_id
AND eu_aspect = "S"
AND NOT EXISTS
(
SELECT null
FROM templatelinks
WHERE page_id = tl_from
)
AND page_title = "Naupliastraße_(München)"
GROUP BY
page_title
HAVING
ct = 1
LIMIT 2
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.