Untitled query #44150

SQL

#use commonswiki_p;
#select * from commonswiki_p.globalimagelinks
#join itwiki_p.page on gil_page = page_id
#where gil_to = 'Fabio_Cannavaro.jpg' and gil_wiki = 'itwiki'# and il_from_namespace = 6
select * from itwiki_p.imagelinks as itim
join commonswiki_p.globalimagelinks as cmgb on il_from = gil_page and il_to = gil_to
where il_from = 2756416 and gil_wiki = 'itwiki'# and il_from_namespace = 0
#where il_from = 2756416
#where page_title = 'Roberto_Baggio' and page_namespace = 0

#page_id = 2756416 #Baggio itwiki
# page_id = 168067 #Beckham itwiki
# page_id = 49796 #Brighton
SQL

Checking query status...
