Community Wishlist wishes

Fork of Community Wishlist wishes by MusikAnimal

This query is marked as a draft This query has been published by JWheeler-WMF.

All wishes in the wishlist tool's database s55926__wishlist_p.

SQL

SELECT wish_title AS `Title`,
	CONCAT('https://meta.wikimedia.org/wiki/', REPLACE(wish_page, ' ', '_')) AS `URL`,
	wish_base_lang AS `Base lang`,
    wish_description AS `Description`,
    wish_type AS `Type`,
    wish_status AS `Status`,
    wish_proposer AS `Proposer`,
    wish_created_dt AS `Created`,
    wish_updated_dt AS `Updated`,
    wish_projects AS `Projects`,
    wish_other_project AS `Other project`
FROM s55926__wishlist_p.wish
WHERE wish_lang IN ('en', '')
ORDER BY wish_page_id DESC;

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...