use commonswiki_p;

  SELECT page_title

   FROM /*image, */page, categorylinks 

   WHERE page.page_id=categorylinks.cl_from 

AND page_namespace = 6 AND page_is_redirect = 0

#       AND image.img_name = page.page_title

       AND categorylinks.cl_to like "Media_needing_categories%"

       AND page_title like "Kit%" AND (page_title like "%home%" or page_title like "%away%"

            or page_title like "%left%" or page_title like "%right%")