SELECT DISTINCT I.img_name, I.img_timestamp, I.img_metadata

FROM commonswiki_p.image I

INNER JOIN commonswiki_p.page P ON I.img_name = P.page_title

WHERE img_metadata LIKE '%EX-S20%'

  AND P.page_namespace = 6

  AND NOT EXISTS (

      SELECT 1

      FROM commonswiki_p.categorylinks CL

      WHERE P.page_id = CL.cl_from

      AND CL.cl_to = 'Taken_with_Casio_Exilim_EX-S20'

  )

ORDER BY I.img_timestamp DESC;