Untitled query #888

SQL

#SELECT CONCAT('# [[', page_title, ']]') FROM page
#JOIN page_props ON page_id = pp_page
#WHERE page_namespace = 0
#AND page_is_redirect = 0
#SELECT * FROM page_props
#JOIN page ON page_id = pp_page
#WHERE pp_propname='page_image'
# AND pp_value = 'Pig_farm_Vampula_9.jpg'
#AND pp_value = "Einstein1921_by_F_Schmutzer_4.jpg"
SELECT DISTINCT pp_value,page_id,page_namespace,page_title FROM page_props JOIN page ON pp_page = page_id
  WHERE pp_propname = 'page_image_free'
  AND pp_value = 'Pig_farm_Vampula_9.jpg'
SQL

Checking query status...
