Identify and list media files with specific geographic coordinates that require categorization

SQL

set @cat1 := "All_media_needing_categories_as_of_20%";
set @cat2 := "Media_needing_category_review_as_of_%";

select distinct
    (select page_title from page where page_id = gt_page_id) as title
    ,gt_page_id, gt_lat, gt_lon
  from
    geo_tags, categorylinks
  where 
    gt_page_id = cl_from and
    (cl_to like @cat1 or cl_to like @cat2) and cl_type = "file" and 
    (
      (gt_lat > 6.755 and gt_lat < 35.674 and gt_lon > 68.162 and gt_lon < 97.395) # India bounding box
      and not (gt_lat > 35.674 and gt_lon < 68.162) # Exclude North of India
    )
  order by title;

SQL

Checking query status...