User:Jean-Frédéric/WmFr/2013/QI round2 Q2

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é