https://bugzilla.wikimedia.org/show_bug.cgi?id=24166
--- Comment #3 from Reedy <[email protected]> 2010-09-01 16:35:15 UTC --- SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest,ts_tags,old_id,old_text,old_flags FROM `mw_page`,`mw_revision` JOIN `mw_text` LEFT JOIN `mw_tag_summary` ON ((rev_id=ts_rev_id)) WHERE (page_id = rev_page) AND (rev_text_id=old_id) AND rev_id = '33' ORDER BY rev_id LIMIT 2; Fixes it Per http://www.delphifaq.com/faq/databases/mysql/f1110.shtml a join before the last table before the left join :/ Mmmm, Hax? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
