Untitled query #64627

SQL

select
  i.img_name,
  group_concat(cl.cl_to) as categories
from
  image as i
  inner join page as p on p.page_title = i.img_name
  right join categorylinks as cl on cl.cl_from = p.page_id
  left join page as pp on pp.page_title = cl.cl_to
where
  #i.img_name = "Waldmüller_-_Blick_auf_Mödling.jpeg" AND
  pp.page_namespace = 14
  AND (
    lower(pp.page_title) like "%post_box%"
    -- or lower(pp.page_title) like "%painter%"
  )
  AND i.img_width >= 128
  and i.img_height >= 128
  and i.img_size < 100000000
group by 1
-- limit 100
SQL

Checking query status...
