User:Jean-Frédéric/WmFr/2012/QI

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search 
SELECT /* SLOW_OK */ image.img_name, img_user_text
      FROM page
          JOIN categorylinks AS cl1 ON page_id=cl1.cl_from
          JOIN categorylinks AS cl2 ON page_id=cl2.cl_from
          JOIN image ON image.img_name = page.page_title
      WHERE cl1.cl_to="All_medias_supported_by_Wikimedia_France"
           AND cl2.cl_to="Quality_images"
           AND img_timestamp BETWEEN 20120101000000 AND 20130101000000
      ORDER BY img_timestamp ASC;
Retrieved from "https://commons.wikimedia.org/w/index.php?title=User:Jean-Frédéric/WmFr/2012/QI&oldid=228275079"