User:Ilmari Karonen/Queries/SVG 744x1052px

From Wikimedia Commons, the free media repository
Jump to: navigation, search

List of 744 × 1,052 pixel SVG files on Commons. This is the default page size in Inkscape, and so many of these files are likely to need resizing.

-- 2> /dev/null; date; echo '
/* InkScape default canvas (744x1052)
 * http://quarry.wmflabs.org/query/898
 * 
 * License: Public Domain
 * Run time: 2 min
 */
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  /* Portrait  */
-- OR img_width=1052 AND img_height=744 ) /* Landscape */
/* Whitelist of users who hopefully know what they are doing */
AND img_user_text NOT IN (
    "Abraham Vázquez", "Albedo-ukr", "Arch", "Archmedus", "CITY MVD",
    "Cameltrader", "Darwinjvega", "Eugenio Hansen, OFS", "Fluctuat~commonswiki",
    "Henk Boelens", "Luuva", "Maky", "Mate2Code", "RRZEicons", "Pobog1524",
    "Pomfuttge", "Sven-steffen arndt", "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


Results[edit]