Change Details

[[ https://quarry.wmflabs.org/query/6855 | This query ]] returns different (i.e. incorrect) results when run against labsdb1003, while 001 and 002 are fine. For instance, the result should NOT contain Image:Taylor_Swift_-_Wildest_Dreams_(Official_Single_Cover).png but it does for labsdb003.

This query: ``` SELECT page_title FROM fawiki_p.categorylinks JOIN page ON cl_from = page_id LEFT JOIN fawiki_p.imagelinks ON il_to = page_title WHERE cl_to = 'محتویات_غیر_آزاد' and page_namespace = 6 and il_from is null; ``` returns different (i.e. incorrect) results when run against labsdb1003, while 001 and 002 are fine. For instance, the result should NOT contain Image:Taylor_Swift_-_Wildest_Dreams_(Official_Single_Cover).png but it does for labsdb003.

[[ https://quarry.wmflabs.org/query/6855 | This query ]] This query: ``` SELECT page_title FROM fawiki_p.categorylinks JOIN page ON cl_from = page_id LEFT JOIN fawiki_p.imagelinks ON il_to = page_title WHERE cl_to = 'محتویات_غیر_آزاد' and page_namespace = 6 and il_from is null; ``` returns different (i.e. incorrect) results when run against labsdb1003, while 001 and 002 are fine. For instance, the result should NOT contain Image:Taylor_Swift_-_Wildest_Dreams_(Official_Single_Cover).png but it does for labsdb003.