Non free files with template links

SQL

select DISTINCT

    tl_title,
    actor_name,
    LEFT(rev_timestamp,8) as date,
    page_title
  from  image as ss
  join  page ON  page_namespace=6  AND page_title=img_name
  join revision ON     rev_page = page_id AND  rev_parent_id = 0
  join actor ON    actor_id=rev_actor
  join categorylinks ON cl_from=page_id AND cl_type="file"
  join templatelinks ON tl_from=page_id AND tl_from_namespace=6 AND tl_namespace=10
  where
    page_is_redirect=0  AND cl_to ="సముచిత_వినియోగంగా_వాడిన_బొమ్మలు" AND
    (CONVERT(INT,LEFT(rev_timestamp,8)) > 20191118) AND
    tl_title in ("Non-free_use_rationale",
"Non-free_use_rationale_logo",
"Non-free_use_rationale_software_screenshot",
"Non-free_use_rationale_2",
"Non-free_use_rationale_poster",
"Book_rationale",
"Non-free_use_rationale_book_cover",
"Manga_rationale",
"Logo_fur",
"Non-free_use_rationale_video_cover",
                 "Non-free_use_rationale_title-card")
ORDER BY page_title
SQL

Checking query status...
