GitHub PullRequestEvent at 2014-01-24 12:06:43
Repository: zamboni
Actor: diox
Payload: {"action":"closed","number":1667,"pull_request":{"url":"https://api.github.com/repos/mozilla/zamboni/pulls/1667","id":11766600,"html_url":"https://github.com/mozilla/zamboni/pull/1667","diff_url":"https://github.com/mozilla/zamboni/pull/1667.diff","patch_url":"https://github.com/mozilla/zamboni/pull/1667.patch","issue_url":"https://github.com/mozilla/zamboni/pull/1667","number":1667,"state":"closed","title":"Remove fields we don't need in Webapp._meta.translated_fields (bug 961719)","user":{"login":"diox","id":187006,"avatar_url":"https://gravatar.com/avatar/20b505802a9464e50eac02c1f5189666?d=https%3A%2F%2Fidenticons.github.com%2F19c23a35c7bdf8b6bed7ea7d8ea107fb.png&r=x","gravatar_id":"20b505802a9464e50eac02c1f5189666","url":"https://api.github.com/users/diox","html_url":"https://github.com/diox","followers_url":"https://api.github.com/users/diox/followers","following_url":"https://api.github.com/users/diox/following{/other_user}","gists_url":"https://api.github.com/users/diox/gists{/gist_id}","starred_url":"https://api.github.com/users/diox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diox/subscriptions","organizations_url":"https://api.github.com/users/diox/orgs","repos_url":"https://api.github.com/users/diox/repos","events_url":"https://api.github.com/users/diox/events{/privacy}","received_events_url":"https://api.github.com/users/diox/received_events","type":"User","site_admin":false},"body":"https://bugzilla.mozilla.org/show_bug.cgi?id=961719\r\n\r\nBefore:\r\n```\r\n SELECT `addons`.id, IF(!ISNULL(t1_homepage.localized_string), t1_homepage.created, t2_homepage.created)\r\n            AS homepage_created,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.modified, t2_homepage.modified)\r\n            AS homepage_modified,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.autoid, t2_homepage.autoid)\r\n            AS homepage_autoid,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.id, t2_homepage.id)\r\n            AS homepage_id,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.locale, t2_homepage.locale)\r\n            AS homepage_locale,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.localized_string, t2_homepage.localized_string)\r\n            AS homepage_localized_string,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.localized_string_clean, t2_homepage.localized_string_clean)\r\n            AS homepage_localized_string_clean,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.created, t2_privacypolicy.created)\r\n            AS privacypolicy_created,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.modified, t2_privacypolicy.modified)\r\n            AS privacypolicy_modified,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.autoid, t2_privacypolicy.autoid)\r\n            AS privacypolicy_autoid,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.id, t2_privacypolicy.id)\r\n            AS privacypolicy_id,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.locale, t2_privacypolicy.locale)\r\n            AS privacypolicy_locale,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.localized_string, t2_privacypolicy.localized_string)\r\n            AS privacypolicy_localized_string,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.localized_string_clean, t2_privacypolicy.localized_string_clean)\r\n            AS privacypolicy_localized_string_clean,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.created, t2_thankyou_note.created)\r\n            AS thankyou_note_created,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.modified, t2_thankyou_note.modified)\r\n            AS thankyou_note_modified,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.autoid, t2_thankyou_note.autoid)\r\n            AS thankyou_note_autoid,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.id, t2_thankyou_note.id)\r\n            AS thankyou_note_id,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.locale, t2_thankyou_note.locale)\r\n            AS thankyou_note_locale,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.localized_string, t2_thankyou_note.localized_string)\r\n            AS thankyou_note_localized_string,IF(!ISNULL(t1_thankyou_note.localized_string), t1_thankyou_note.localized_string_clean, t2_thankyou_note.localized_string_clean)\r\n            AS thankyou_note_localized_string_clean,IF(!ISNULL(t1_name.localized_string), t1_name.created, t2_name.created)\r\n            AS name_created,IF(!ISNULL(t1_name.localized_string), t1_name.modified, t2_name.modified)\r\n            AS name_modified,IF(!ISNULL(t1_name.localized_string), t1_name.autoid, t2_name.autoid)\r\n            AS name_autoid,IF(!ISNULL(t1_name.localized_string), t1_name.id, t2_name.id)\r\n            AS name_id,IF(!ISNULL(t1_name.localized_string), t1_name.locale, t2_name.locale)\r\n            AS name_locale,IF(!ISNULL(t1_name.localized_string), t1_name.localized_string, t2_name.localized_string)\r\n            AS name_localized_string,IF(!ISNULL(t1_name.localized_string), t1_name.localized_string_clean, t2_name.localized_string_clean)\r\n            AS name_localized_string_clean,IF(!ISNULL(t1_summary.localized_string), t1_summary.created, t2_summary.created)\r\n            AS summary_created,IF(!ISNULL(t1_summary.localized_string), t1_summary.modified, t2_summary.modified)\r\n            AS summary_modified,IF(!ISNULL(t1_summary.localized_string), t1_summary.autoid, t2_summary.autoid)\r\n            AS summary_autoid,IF(!ISNULL(t1_summary.localized_string), t1_summary.id, t2_summary.id)\r\n            AS summary_id,IF(!ISNULL(t1_summary.localized_string), t1_summary.locale, t2_summary.locale)\r\n            AS summary_locale,IF(!ISNULL(t1_summary.localized_string), t1_summary.localized_string, t2_summary.localized_string)\r\n            AS summary_localized_string,IF(!ISNULL(t1_summary.localized_string), t1_summary.localized_string_clean, t2_summary.localized_string_clean)\r\n            AS summary_localized_string_clean,IF(!ISNULL(t1_eula.localized_string), t1_eula.created, t2_eula.created)\r\n            AS eula_created,IF(!ISNULL(t1_eula.localized_string), t1_eula.modified, t2_eula.modified)\r\n            AS eula_modified,IF(!ISNULL(t1_eula.localized_string), t1_eula.autoid, t2_eula.autoid)\r\n            AS eula_autoid,IF(!ISNULL(t1_eula.localized_string), t1_eula.id, t2_eula.id)\r\n            AS eula_id,IF(!ISNULL(t1_eula.localized_string), t1_eula.locale, t2_eula.locale)\r\n            AS eula_locale,IF(!ISNULL(t1_eula.localized_string), t1_eula.localized_string, t2_eula.localized_string)\r\n            AS eula_localized_string,IF(!ISNULL(t1_eula.localized_string), t1_eula.localized_string_clean, t2_eula.localized_string_clean)\r\n            AS eula_localized_string_clean,IF(!ISNULL(t1_description.localized_string), t1_description.created, t2_description.created)\r\n            AS description_created,IF(!ISNULL(t1_description.localized_string), t1_description.modified, t2_description.modified)\r\n            AS description_modified,IF(!ISNULL(t1_description.localized_string), t1_description.autoid, t2_description.autoid)\r\n            AS description_autoid,IF(!ISNULL(t1_description.localized_string), t1_description.id, t2_description.id)\r\n            AS description_id,IF(!ISNULL(t1_description.localized_string), t1_description.locale, t2_description.locale)\r\n            AS description_locale,IF(!ISNULL(t1_description.localized_string), t1_description.localized_string, t2_description.localized_string)\r\n            AS description_localized_string,IF(!ISNULL(t1_description.localized_string), t1_description.localized_string_clean, t2_description.localized_string_clean)\r\n            AS description_localized_string_clean,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.created, t2_supportemail.created)\r\n            AS supportemail_created,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.modified, t2_supportemail.modified)\r\n            AS supportemail_modified,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.autoid, t2_supportemail.autoid)\r\n            AS supportemail_autoid,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.id, t2_supportemail.id)\r\n            AS supportemail_id,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.locale, t2_supportemail.locale)\r\n            AS supportemail_locale,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.localized_string, t2_supportemail.localized_string)\r\n            AS supportemail_localized_string,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.localized_string_clean, t2_supportemail.localized_string_clean)\r\n            AS supportemail_localized_string_clean,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.created, t2_developercomments.created)\r\n            AS developercomments_created,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.modified, t2_developercomments.modified)\r\n            AS developercomments_modified,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.autoid, t2_developercomments.autoid)\r\n            AS developercomments_autoid,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.id, t2_developercomments.id)\r\n            AS developercomments_id,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.locale, t2_developercomments.locale)\r\n            AS developercomments_locale,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.localized_string, t2_developercomments.localized_string)\r\n            AS developercomments_localized_string,IF(!ISNULL(t1_developercomments.localized_string), t1_developercomments.localized_string_clean, t2_developercomments.localized_string_clean)\r\n            AS developercomments_localized_string_clean,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.created, t2_supporturl.created)\r\n            AS supporturl_created,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.modified, t2_supporturl.modified)\r\n            AS supporturl_modified,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.autoid, t2_supporturl.autoid)\r\n            AS supporturl_autoid,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.id, t2_supporturl.id)\r\n            AS supporturl_id,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.locale, t2_supporturl.locale)\r\n            AS supporturl_locale,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.localized_string, t2_supporturl.localized_string)\r\n            AS supporturl_localized_string,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.localized_string_clean, t2_supporturl.localized_string_clean)\r\n            AS supporturl_localized_string_clean,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.created, t2_the_future.created)\r\n            AS the_future_created,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.modified, t2_the_future.modified)\r\n            AS the_future_modified,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.autoid, t2_the_future.autoid)\r\n            AS the_future_autoid,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.id, t2_the_future.id)\r\n            AS the_future_id,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.locale, t2_the_future.locale)\r\n            AS the_future_locale,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.localized_string, t2_the_future.localized_string)\r\n            AS the_future_localized_string,IF(!ISNULL(t1_the_future.localized_string), t1_the_future.localized_string_clean, t2_the_future.localized_string_clean)\r\n            AS the_future_localized_string_clean,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.created, t2_the_reason.created)\r\n            AS the_reason_created,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.modified, t2_the_reason.modified)\r\n            AS the_reason_modified,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.autoid, t2_the_reason.autoid)\r\n            AS the_reason_autoid,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.id, t2_the_reason.id)\r\n            AS the_reason_id,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.locale, t2_the_reason.locale)\r\n            AS the_reason_locale,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.localized_string, t2_the_reason.localized_string)\r\n            AS the_reason_localized_string,IF(!ISNULL(t1_the_reason.localized_string), t1_the_reason.localized_string_clean, t2_the_reason.localized_string_clean)\r\n            AS the_reason_localized_string_clean FROM `addons` LEFT OUTER JOIN translations t1_homepage\r\n          ON (t1_homepage.id=`addons`.homepage AND t1_homepage.locale='en-us')\r\nLEFT OUTER JOIN translations t2_homepage\r\n          ON (t2_homepage.id=`addons`.homepage AND t2_homepage.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_privacypolicy\r\n          ON (t1_privacypolicy.id=`addons`.privacypolicy AND t1_privacypolicy.locale='en-us')\r\nLEFT OUTER JOIN translations t2_privacypolicy\r\n          ON (t2_privacypolicy.id=`addons`.privacypolicy AND t2_privacypolicy.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_thankyou_note\r\n          ON (t1_thankyou_note.id=`addons`.thankyou_note AND t1_thankyou_note.locale='en-us')\r\nLEFT OUTER JOIN translations t2_thankyou_note\r\n          ON (t2_thankyou_note.id=`addons`.thankyou_note AND t2_thankyou_note.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_name\r\n          ON (t1_name.id=`addons`.name AND t1_name.locale='en-us')\r\nLEFT OUTER JOIN translations t2_name\r\n          ON (t2_name.id=`addons`.name AND t2_name.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_summary\r\n          ON (t1_summary.id=`addons`.summary AND t1_summary.locale='en-us')\r\nLEFT OUTER JOIN translations t2_summary\r\n          ON (t2_summary.id=`addons`.summary AND t2_summary.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_eula\r\n          ON (t1_eula.id=`addons`.eula AND t1_eula.locale='en-us')\r\nLEFT OUTER JOIN translations t2_eula\r\n          ON (t2_eula.id=`addons`.eula AND t2_eula.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_description\r\n          ON (t1_description.id=`addons`.description AND t1_description.locale='en-us')\r\nLEFT OUTER JOIN translations t2_description\r\n          ON (t2_description.id=`addons`.description AND t2_description.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_supportemail\r\n          ON (t1_supportemail.id=`addons`.supportemail AND t1_supportemail.locale='en-us')\r\nLEFT OUTER JOIN translations t2_supportemail\r\n          ON (t2_supportemail.id=`addons`.supportemail AND t2_supportemail.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_developercomments\r\n          ON (t1_developercomments.id=`addons`.developercomments AND t1_developercomments.locale='en-us')\r\nLEFT OUTER JOIN translations t2_developercomments\r\n          ON (t2_developercomments.id=`addons`.developercomments AND t2_developercomments.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_supporturl\r\n          ON (t1_supporturl.id=`addons`.supporturl AND t1_supporturl.locale='en-us')\r\nLEFT OUTER JOIN translations t2_supporturl\r\n          ON (t2_supporturl.id=`addons`.supporturl AND t2_supporturl.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_the_future\r\n          ON (t1_the_future.id=`addons`.the_future AND t1_the_future.locale='en-us')\r\nLEFT OUTER JOIN translations t2_the_future\r\n          ON (t2_the_future.id=`addons`.the_future AND t2_the_future.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_the_reason\r\n          ON (t1_the_reason.id=`addons`.the_reason AND t1_the_reason.locale='en-us')\r\nLEFT OUTER JOIN translations t2_the_reason\r\n          ON (t2_the_reason.id=`addons`.the_reason AND t2_the_reason.locale=`addons`.`defaultlocale`)\r\n             WHERE `addons`.id IN (87); args=('en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us')\r\n```\r\n\r\nAfter:\r\n```\r\nSELECT `addons`.id, IF(!ISNULL(t1_homepage.localized_string), t1_homepage.created, t2_homepage.created)\r\n            AS homepage_created,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.modified, t2_homepage.modified)\r\n            AS homepage_modified,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.autoid, t2_homepage.autoid)\r\n            AS homepage_autoid,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.id, t2_homepage.id)\r\n            AS homepage_id,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.locale, t2_homepage.locale)\r\n            AS homepage_locale,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.localized_string, t2_homepage.localized_string)\r\n            AS homepage_localized_string,IF(!ISNULL(t1_homepage.localized_string), t1_homepage.localized_string_clean, t2_homepage.localized_string_clean)\r\n            AS homepage_localized_string_clean,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.created, t2_privacypolicy.created)\r\n            AS privacypolicy_created,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.modified, t2_privacypolicy.modified)\r\n            AS privacypolicy_modified,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.autoid, t2_privacypolicy.autoid)\r\n            AS privacypolicy_autoid,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.id, t2_privacypolicy.id)\r\n            AS privacypolicy_id,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.locale, t2_privacypolicy.locale)\r\n            AS privacypolicy_locale,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.localized_string, t2_privacypolicy.localized_string)\r\n            AS privacypolicy_localized_string,IF(!ISNULL(t1_privacypolicy.localized_string), t1_privacypolicy.localized_string_clean, t2_privacypolicy.localized_string_clean)\r\n            AS privacypolicy_localized_string_clean,IF(!ISNULL(t1_name.localized_string), t1_name.created, t2_name.created)\r\n            AS name_created,IF(!ISNULL(t1_name.localized_string), t1_name.modified, t2_name.modified)\r\n            AS name_modified,IF(!ISNULL(t1_name.localized_string), t1_name.autoid, t2_name.autoid)\r\n            AS name_autoid,IF(!ISNULL(t1_name.localized_string), t1_name.id, t2_name.id)\r\n            AS name_id,IF(!ISNULL(t1_name.localized_string), t1_name.locale, t2_name.locale)\r\n            AS name_locale,IF(!ISNULL(t1_name.localized_string), t1_name.localized_string, t2_name.localized_string)\r\n            AS name_localized_string,IF(!ISNULL(t1_name.localized_string), t1_name.localized_string_clean, t2_name.localized_string_clean)\r\n            AS name_localized_string_clean,IF(!ISNULL(t1_description.localized_string), t1_description.created, t2_description.created)\r\n            AS description_created,IF(!ISNULL(t1_description.localized_string), t1_description.modified, t2_description.modified)\r\n            AS description_modified,IF(!ISNULL(t1_description.localized_string), t1_description.autoid, t2_description.autoid)\r\n            AS description_autoid,IF(!ISNULL(t1_description.localized_string), t1_description.id, t2_description.id)\r\n            AS description_id,IF(!ISNULL(t1_description.localized_string), t1_description.locale, t2_description.locale)\r\n            AS description_locale,IF(!ISNULL(t1_description.localized_string), t1_description.localized_string, t2_description.localized_string)\r\n            AS description_localized_string,IF(!ISNULL(t1_description.localized_string), t1_description.localized_string_clean, t2_description.localized_string_clean)\r\n            AS description_localized_string_clean,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.created, t2_supportemail.created)\r\n            AS supportemail_created,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.modified, t2_supportemail.modified)\r\n            AS supportemail_modified,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.autoid, t2_supportemail.autoid)\r\n            AS supportemail_autoid,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.id, t2_supportemail.id)\r\n            AS supportemail_id,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.locale, t2_supportemail.locale)\r\n            AS supportemail_locale,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.localized_string, t2_supportemail.localized_string)\r\n            AS supportemail_localized_string,IF(!ISNULL(t1_supportemail.localized_string), t1_supportemail.localized_string_clean, t2_supportemail.localized_string_clean)\r\n            AS supportemail_localized_string_clean,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.created, t2_supporturl.created)\r\n            AS supporturl_created,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.modified, t2_supporturl.modified)\r\n            AS supporturl_modified,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.autoid, t2_supporturl.autoid)\r\n            AS supporturl_autoid,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.id, t2_supporturl.id)\r\n            AS supporturl_id,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.locale, t2_supporturl.locale)\r\n            AS supporturl_locale,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.localized_string, t2_supporturl.localized_string)\r\n            AS supporturl_localized_string,IF(!ISNULL(t1_supporturl.localized_string), t1_supporturl.localized_string_clean, t2_supporturl.localized_string_clean)\r\n            AS supporturl_localized_string_clean FROM `addons` LEFT OUTER JOIN translations t1_homepage\r\n          ON (t1_homepage.id=`addons`.homepage AND t1_homepage.locale='en-us')\r\nLEFT OUTER JOIN translations t2_homepage\r\n          ON (t2_homepage.id=`addons`.homepage AND t2_homepage.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_privacypolicy\r\n          ON (t1_privacypolicy.id=`addons`.privacypolicy AND t1_privacypolicy.locale='en-us')\r\nLEFT OUTER JOIN translations t2_privacypolicy\r\n          ON (t2_privacypolicy.id=`addons`.privacypolicy AND t2_privacypolicy.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_name\r\n          ON (t1_name.id=`addons`.name AND t1_name.locale='en-us')\r\nLEFT OUTER JOIN translations t2_name\r\n          ON (t2_name.id=`addons`.name AND t2_name.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_description\r\n          ON (t1_description.id=`addons`.description AND t1_description.locale='en-us')\r\nLEFT OUTER JOIN translations t2_description\r\n          ON (t2_description.id=`addons`.description AND t2_description.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_supportemail\r\n          ON (t1_supportemail.id=`addons`.supportemail AND t1_supportemail.locale='en-us')\r\nLEFT OUTER JOIN translations t2_supportemail\r\n          ON (t2_supportemail.id=`addons`.supportemail AND t2_supportemail.locale=`addons`.`defaultlocale`)\r\nLEFT OUTER JOIN translations t1_supporturl\r\n          ON (t1_supporturl.id=`addons`.supporturl AND t1_supporturl.locale='en-us')\r\nLEFT OUTER JOIN translations t2_supporturl\r\n          ON (t2_supporturl.id=`addons`.supporturl AND t2_supporturl.locale=`addons`.`defaultlocale`)\r\n             WHERE `addons`.id IN (87); args=('en-us', 'en-us', 'en-us', 'en-us', 'en-us', 'en-us')\r\n```\r\n\r\nStill unreadable, buy a lot less useless `JOIN`s.","created_at":"2014-01-22T17:35:46Z","updated_at":"2014-01-24T12:06:43Z","closed_at":"2014-01-24T12:06:43Z","merged_at":"2014-01-24T12:06:43Z","merge_commit_sha":"301b1dddd91712b8534785dca0f0e6a708f6103d","assignee":null,"milestone":null,"commits_url":"https://github.com/mozilla/zamboni/pull/1667/commits","review_comments_url":"https://github.com/mozilla/zamboni/pull/1667/comments","review_comment_url":"/repos/mozilla/zamboni/pulls/comments/{number}","comments_url":"https://api.github.com/repos/mozilla/zamboni/issues/1667/comments","statuses_url":"https://api.github.com/repos/mozilla/zamboni/statuses/bb48535c21b40451df8f31848fe1d507292dda26","head":{"label":"diox:webapps-less-translated-fields","ref":"webapps-less-translated-fields","sha":"bb48535c21b40451df8f31848fe1d507292dda26","user":{"login":"diox","id":187006,"avatar_url":"https://gravatar.com/avatar/20b505802a9464e50eac02c1f5189666?d=https%3A%2F%2Fidenticons.github.com%2F19c23a35c7bdf8b6bed7ea7d8ea107fb.png&r=x","gravatar_id":"20b505802a9464e50eac02c1f5189666","url":"https://api.github.com/users/diox","html_url":"https://github.com/diox","followers_url":"https://api.github.com/users/diox/followers","following_url":"https://api.github.com/users/diox/following{/other_user}","gists_url":"https://api.github.com/users/diox/gists{/gist_id}","starred_url":"https://api.github.com/users/diox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diox/subscriptions","organizations_url":"https://api.github.com/users/diox/orgs","repos_url":"https://api.github.com/users/diox/repos","events_url":"https://api.github.com/users/diox/events{/privacy}","received_events_url":"https://api.github.com/users/diox/received_events","type":"User","site_admin":false},"repo":{"id":10216041,"name":"zamboni","full_name":"diox/zamboni","owner":{"login":"diox","id":187006,"avatar_url":"https://gravatar.com/avatar/20b505802a9464e50eac02c1f5189666?d=https%3A%2F%2Fidenticons.github.com%2F19c23a35c7bdf8b6bed7ea7d8ea107fb.png&r=x","gravatar_id":"20b505802a9464e50eac02c1f5189666","url":"https://api.github.com/users/diox","html_url":"https://github.com/diox","followers_url":"https://api.github.com/users/diox/followers","following_url":"https://api.github.com/users/diox/following{/other_user}","gists_url":"https://api.github.com/users/diox/gists{/gist_id}","starred_url":"https://api.github.com/users/diox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diox/subscriptions","organizations_url":"https://api.github.com/users/diox/orgs","repos_url":"https://api.github.com/users/diox/repos","events_url":"https://api.github.com/users/diox/events{/privacy}","received_events_url":"https://api.github.com/users/diox/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/diox/zamboni","description":"A clandestine operation to make AMO happy","fork":true,"url":"https://api.github.com/repos/diox/zamboni","forks_url":"https://api.github.com/repos/diox/zamboni/forks","keys_url":"https://api.github.com/repos/diox/zamboni/keys{/key_id}","collaborators_url":"https://api.github.com/repos/diox/zamboni/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/diox/zamboni/teams","hooks_url":"https://api.github.com/repos/diox/zamboni/hooks","issue_events_url":"https://api.github.com/repos/diox/zamboni/issues/events{/number}","events_url":"https://api.github.com/repos/diox/zamboni/events","assignees_url":"https://api.github.com/repos/diox/zamboni/assignees{/user}","branches_url":"https://api.github.com/repos/diox/zamboni/branches{/branch}","tags_url":"https://api.github.com/repos/diox/zamboni/tags","blobs_url":"https://api.github.com/repos/diox/zamboni/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/diox/zamboni/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/diox/zamboni/git/refs{/sha}","trees_url":"https://api.github.com/repos/diox/zamboni/git/trees{/sha}","statuses_url":"https://api.github.com/repos/diox/zamboni/statuses/{sha}","languages_url":"https://api.github.com/repos/diox/zamboni/languages","stargazers_url":"https://api.github.com/repos/diox/zamboni/stargazers","contributors_url":"https://api.github.com/repos/diox/zamboni/contributors","subscribers_url":"https://api.github.com/repos/diox/zamboni/subscribers","subscription_url":"https://api.github.com/repos/diox/zamboni/subscription","commits_url":"https://api.github.com/repos/diox/zamboni/commits{/sha}","git_commits_url":"https://api.github.com/repos/diox/zamboni/git/commits{/sha}","comments_url":"https://api.github.com/repos/diox/zamboni/comments{/number}","issue_comment_url":"https://api.github.com/repos/diox/zamboni/issues/comments/{number}","contents_url":"https://api.github.com/repos/diox/zamboni/contents/{+path}","compare_url":"https://api.github.com/repos/diox/zamboni/compare/{base}...{head}","merges_url":"https://api.github.com/repos/diox/zamboni/merges","archive_url":"https://api.github.com/repos/diox/zamboni/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/diox/zamboni/downloads","issues_url":"https://api.github.com/repos/diox/zamboni/issues{/number}","pulls_url":"https://api.github.com/repos/diox/zamboni/pulls{/number}","milestones_url":"https://api.github.com/repos/diox/zamboni/milestones{/number}","notifications_url":"https://api.github.com/repos/diox/zamboni/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/diox/zamboni/labels{/name}","releases_url":"https://api.github.com/repos/diox/zamboni/releases{/id}","created_at":"2013-05-22T09:07:50Z","updated_at":"2014-01-24T12:06:43Z","pushed_at":"2014-01-23T17:30:03Z","git_url":"git://github.com/diox/zamboni.git","ssh_url":"git@github.com:diox/zamboni.git","clone_url":"https://github.com/diox/zamboni.git","svn_url":"https://github.com/diox/zamboni","homepage":"http://zamboni.readthedocs.org/en/latest/","size":172869,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":false,"has_wiki":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master","master_branch":"master"}},"base":{"label":"mozilla:master","ref":"master","sha":"d711e880275deb1178e6bb6fc577708400d5ab0d","user":{"login":"mozilla","id":131524,"avatar_url":"https://gravatar.com/avatar/9ba739c8f3288e256b13553e4d257b5e?d=https%3A%2F%2Fidenticons.github.com%2Fe19b38694c8cd24cb8a5ff704c8d9ae1.png&r=x","gravatar_id":"9ba739c8f3288e256b13553e4d257b5e","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"repo":{"id":347655,"name":"zamboni","full_name":"mozilla/zamboni","owner":{"login":"mozilla","id":131524,"avatar_url":"https://gravatar.com/avatar/9ba739c8f3288e256b13553e4d257b5e?d=https%3A%2F%2Fidenticons.github.com%2Fe19b38694c8cd24cb8a5ff704c8d9ae1.png&r=x","gravatar_id":"9ba739c8f3288e256b13553e4d257b5e","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mozilla/zamboni","description":"The Firefox Marketplace and addons.mozilla.org","fork":false,"url":"https://api.github.com/repos/mozilla/zamboni","forks_url":"https://api.github.com/repos/mozilla/zamboni/forks","keys_url":"https://api.github.com/repos/mozilla/zamboni/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mozilla/zamboni/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mozilla/zamboni/teams","hooks_url":"https://api.github.com/repos/mozilla/zamboni/hooks","issue_events_url":"https://api.github.com/repos/mozilla/zamboni/issues/events{/number}","events_url":"https://api.github.com/repos/mozilla/zamboni/events","assignees_url":"https://api.github.com/repos/mozilla/zamboni/assignees{/user}","branches_url":"https://api.github.com/repos/mozilla/zamboni/branches{/branch}","tags_url":"https://api.github.com/repos/mozilla/zamboni/tags","blobs_url":"https://api.github.com/repos/mozilla/zamboni/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mozilla/zamboni/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mozilla/zamboni/git/refs{/sha}","trees_url":"https://api.github.com/repos/mozilla/zamboni/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mozilla/zamboni/statuses/{sha}","languages_url":"https://api.github.com/repos/mozilla/zamboni/languages","stargazers_url":"https://api.github.com/repos/mozilla/zamboni/stargazers","contributors_url":"https://api.github.com/repos/mozilla/zamboni/contributors","subscribers_url":"https://api.github.com/repos/mozilla/zamboni/subscribers","subscription_url":"https://api.github.com/repos/mozilla/zamboni/subscription","commits_url":"https://api.github.com/repos/mozilla/zamboni/commits{/sha}","git_commits_url":"https://api.github.com/repos/mozilla/zamboni/git/commits{/sha}","comments_url":"https://api.github.com/repos/mozilla/zamboni/comments{/number}","issue_comment_url":"https://api.github.com/repos/mozilla/zamboni/issues/comments/{number}","contents_url":"https://api.github.com/repos/mozilla/zamboni/contents/{+path}","compare_url":"https://api.github.com/repos/mozilla/zamboni/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mozilla/zamboni/merges","archive_url":"https://api.github.com/repos/mozilla/zamboni/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mozilla/zamboni/downloads","issues_url":"https://api.github.com/repos/mozilla/zamboni/issues{/number}","pulls_url":"https://api.github.com/repos/mozilla/zamboni/pulls{/number}","milestones_url":"https://api.github.com/repos/mozilla/zamboni/milestones{/number}","notifications_url":"https://api.github.com/repos/mozilla/zamboni/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mozilla/zamboni/labels{/name}","releases_url":"https://api.github.com/repos/mozilla/zamboni/releases{/id}","created_at":"2009-10-23T19:35:34Z","updated_at":"2014-01-24T12:06:43Z","pushed_at":"2014-01-24T12:06:43Z","git_url":"git://github.com/mozilla/zamboni.git","ssh_url":"git@github.com:mozilla/zamboni.git","clone_url":"https://github.com/mozilla/zamboni.git","svn_url":"https://github.com/mozilla/zamboni","homepage":"http://zamboni.readthedocs.org","size":229109,"stargazers_count":391,"watchers_count":391,"language":"Python","has_issues":true,"has_downloads":false,"has_wiki":false,"forks_count":204,"mirror_url":null,"open_issues_count":23,"forks":204,"open_issues":23,"watchers":391,"default_branch":"master","master_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/mozilla/zamboni/pulls/1667"},"html":{"href":"https://github.com/mozilla/zamboni/pull/1667"},"issue":{"href":"https://api.github.com/repos/mozilla/zamboni/issues/1667"},"comments":{"href":"https://api.github.com/repos/mozilla/zamboni/issues/1667/comments"},"review_comments":{"href":"https://api.github.com/repos/mozilla/zamboni/pulls/1667/comments"},"statuses":{"href":"https://api.github.com/repos/mozilla/zamboni/statuses/bb48535c21b40451df8f31848fe1d507292dda26"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"diox","id":187006,"avatar_url":"https://gravatar.com/avatar/20b505802a9464e50eac02c1f5189666?d=https%3A%2F%2Fidenticons.github.com%2F19c23a35c7bdf8b6bed7ea7d8ea107fb.png&r=x","gravatar_id":"20b505802a9464e50eac02c1f5189666","url":"https://api.github.com/users/diox","html_url":"https://github.com/diox","followers_url":"https://api.github.com/users/diox/followers","following_url":"https://api.github.com/users/diox/following{/other_user}","gists_url":"https://api.github.com/users/diox/gists{/gist_id}","starred_url":"https://api.github.com/users/diox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diox/subscriptions","organizations_url":"https://api.github.com/users/diox/orgs","repos_url":"https://api.github.com/users/diox/repos","events_url":"https://api.github.com/users/diox/events{/privacy}","received_events_url":"https://api.github.com/users/diox/received_events","type":"User","site_admin":false},"comments":2,"review_comments":0,"commits":1,"additions":46,"deletions":2,"changed_files":2}}