SELECT DISTINCT

  page.page_title,

  page.page_len,

  cl.cl_to,

  ev.page_views

FROM page

JOIN categorylinks cl ON page.page_id = cl.cl_from

LEFT JOIN page_props pp ON page.page_id = pp.pp_page

  AND pp.pp_propname = 'wikibase_item'

LEFT JOIN s53311__wikidata_usage_and_views_p.entity_views ev

ON page.page_title = ev.entity_id

WHERE page.page_namespace = 0

  AND page.page_is_redirect = 0

  AND pp.pp_value IS NULL

  AND cl.cl_to LIKE '%సినిమాలు'

ORDER BY ev.page_views DESC;