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 = 168067 and gil_wiki = 'itwiki'# and il_from_namespace = 0
#where il_from = 168067
where page_title = 'Roberto_Baggio' and page_namespace = 0

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

Checking query status...
