From Wikimedia Commons, the free media repository
Jump to navigation
Jump to search
Queries
|
SET @t1 = 20131001000000, @t2 = 20140101000000;
SELECT /* SLOW_OK */ page_title, img_user_text AS uploader
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="Media_supported_by_Wikimedia_France"
AND cl2.cl_to="Quality_images"
AND img_timestamp BETWEEN @t1 AND @t2
ORDER BY img_timestamp ASC;
|
-
Pymouss
-
Jastrow
-
Jastrow
-
Ctruongngoc
-
Pymouss
-
Jastrow
-
Jastrow
-
Ercé
-
Coyau
-
Coyau
-
Coyau
-
Ctruongngoc
-
Coyau
-
Jastrow
-
Pymouss
-
Ercé
-
Jastrow
-
Jastrow
-
Jastrow
-
Jastrow
-
Pymouss
-
Pymouss
-
Jastrow
-
Archaeodontosaurus
-
Jastrow
-
Jastrow
-
Jastrow
-
Archaeodontosaurus
-
Pymouss
-
Pymouss
-
Jastrow
-
Coyau
-
Thesupermat
-
Jastrow
-
Jastrow
-
Jastrow
-
Jastrow
-
Archaeodontosaurus
-
Ercé
-
Ercé
-
Jastrow
-
Jastrow
-
Ercé
-
Jastrow
-
Archaeodontosaurus
-
EdouardHue
-
Jastrow
-
Ercé
-
Ercé
-
Ercé
-
Ercé
-
Thesupermat
-
Thesupermat
-
Thesupermat
-
Thesupermat
-
Ercé
-
Ercé
-
Ercé
-
Archaeodontosaurus
-
Archaeodontosaurus
-
Ercé