Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Dispenser
.
https://commons.wikimedia.org/wiki/User:Ilmari_Karonen/Queries/SVG_744x1052px
Toggle Highlighting
SQL
-- 2> /dev/null; date; echo ' /* InkScape default canvas (744x1052) * http://quarry.wmflabs.org/query/898 * * License: Public Domain * Run time: 1 min <SLOW_OK> */ USE commonswiki_p; SELECT CONCAT("File:", REPLACE(img_name, "_", " "), " | {{u|",img_user_text, DATE_FORMAT(img_timestamp,"}} on %Y-%m-%d") ) AS "<gallery mode=packed>" /*- CONCAT("[[:File:", REPLACE(img_name, "_", " "), "]]") AS "File", img_timestamp AS "Timestamp", CONCAT("{{u|",img_user_text,"}}") AS "Uploader" /*-*/ FROM image WHERE img_major_mime="image" AND img_minor_mime="svg+xml" AND img_media_type="DRAWING" AND img_width=744 AND img_height=1052 /* Landscape orientation is also a problem */ /* AND img_width=1052 AND img_height=744 */ /* White list users who hopefully know what they're doing */ AND img_user_text NOT IN ("Abraham Vázquez", "Arch", "Archmedus", "CITY MVD", "Cameltrader", "Darwinjvega", "Fluctuat", "Henk Boelens", "Luuva", "Mate2Code", "Pobog1524", "Waćpan") ORDER BY img_user_text, img_height>img_width, img_timestamp ;-- ' | mysql -ch commonswiki.labsdb commonswiki_p --html > ~/public_html/temp/svg_744x1052.html; date
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
.
Checking query status...