{"action":"created","comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/comments/23502086","id":23502086,"diff_hunk":"@@ -443,7 +443,8 @@ CREATE TABLE IF NOT EXISTS `#__contentitem_tag_map` (\n   KEY `idx_date_id` (`tag_date`,`tag_id`),\n   KEY `idx_tag` (`tag_id`),\n   KEY `idx_type` (`type_id`),\n-  KEY `idx_core_content_id` (`core_content_id`)\n+  KEY `idx_core_content_id` (`core_content_id`),\n+\tKEY 'idx_alias_item_id' ('type_alias','content_item_id')","path":"installation/sql/mysql/joomla.sql","position":6,"original_position":6,"commit_id":"c2b9533093fb753874f8dece3e4590ecbbaca0d4","original_commit_id":"c2b9533093fb753874f8dece3e4590ecbbaca0d4","user":{"login":"gunjanpatel","id":2002921,"avatar_url":"https://avatars.githubusercontent.com/u/2002921?v=3","gravatar_id":"","url":"https://api.github.com/users/gunjanpatel","html_url":"https://github.com/gunjanpatel","followers_url":"https://api.github.com/users/gunjanpatel/followers","following_url":"https://api.github.com/users/gunjanpatel/following{/other_user}","gists_url":"https://api.github.com/users/gunjanpatel/gists{/gist_id}","starred_url":"https://api.github.com/users/gunjanpatel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gunjanpatel/subscriptions","organizations_url":"https://api.github.com/users/gunjanpatel/orgs","repos_url":"https://api.github.com/users/gunjanpatel/repos","events_url":"https://api.github.com/users/gunjanpatel/events{/privacy}","received_events_url":"https://api.github.com/users/gunjanpatel/received_events","type":"User","site_admin":false},"body":"Thanks @Sophist-UK I will fix this issues.","created_at":"2015-01-25T05:41:53Z","updated_at":"2015-01-25T05:41:53Z","html_url":"https://github.com/joomla/joomla-cms/pull/4115#discussion_r23502086","pull_request_url":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115","_links":{"self":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/comments/23502086"},"html":{"href":"https://github.com/joomla/joomla-cms/pull/4115#discussion_r23502086"},"pull_request":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115"}}},"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115","id":19813766,"html_url":"https://github.com/joomla/joomla-cms/pull/4115","diff_url":"https://github.com/joomla/joomla-cms/pull/4115.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/4115.patch","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4115","number":4115,"state":"open","locked":false,"title":"Sql optimise new index merged branch","user":{"login":"nadeeshaan","id":1329674,"avatar_url":"https://avatars.githubusercontent.com/u/1329674?v=3","gravatar_id":"","url":"https://api.github.com/users/nadeeshaan","html_url":"https://github.com/nadeeshaan","followers_url":"https://api.github.com/users/nadeeshaan/followers","following_url":"https://api.github.com/users/nadeeshaan/following{/other_user}","gists_url":"https://api.github.com/users/nadeeshaan/gists{/gist_id}","starred_url":"https://api.github.com/users/nadeeshaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nadeeshaan/subscriptions","organizations_url":"https://api.github.com/users/nadeeshaan/orgs","repos_url":"https://api.github.com/users/nadeeshaan/repos","events_url":"https://api.github.com/users/nadeeshaan/events{/privacy}","received_events_url":"https://api.github.com/users/nadeeshaan/received_events","type":"User","site_admin":false},"body":"## Testing Instructions:\r\nThis PR consists all the PRs merged in to this one regarding the index additions. Two approaches can be followed in order to test this PR. One is in an already installed site and one is for fresh distributions.\r\n\r\n#### For already installed sites \r\nFor already installed sites first apply the PR and then add follow the bellow commands in order to add the indexes manually to the database\r\n\r\n* Index added to #_languages table (*You can see this query execution when you access the site*)\r\n\r\n`ALTER TABLE #__languages ADD INDEX 'idx_published_ordering' ('published','ordering');` (#11)\r\n      \r\n**Related Query Before changes**\r\n```sql\r\n  SELECT *\r\n  FROM #__languages\r\n  WHERE published=1\r\n  ORDER BY ordering ASC\r\n```\r\n\r\n**Related Query Before changes**\r\n```sql\r\n  SELECT lang_id,lang_code,title,title_native,sef,image,description,\r\n                 metakey,metadesc,sitename,published,access,ordering\r\n  FROM #__languages\r\n  WHERE published=1\r\n  ORDER BY ordering ASC\r\n```\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n* Index added to #_session table (*Query executes every time a user access a page*)\r\n\r\n`ALTER TABLE #__session DROP PRIMARY KEY, ADD PRIMARY KEY(session_id(32))` ( #8 )\r\n`ALTER TABLE #__session DROP INDEX time, ADD INDEX time(time(10))`\r\n\r\n**Index Description**\r\nThis Index added in order to speed up the session update query allowing the sub string index usages\r\n\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n\r\n* Index added to #_template_styles table (*You can see this query execution when you access the site*)\r\n\r\n`ALTER TABLE #__template_styles ADD INDEX idx_client_id('client_id')`  ( #13 )\r\n\r\n**Index Description**\r\nWithout applying this index the below query cannot use any index to retrieve the rows from the database. After applying this index it clearly shows in the explanation section that the query uses the index to retrieve the rows\r\n\r\n**Related Query**\r\n```sql\r\n    SELECT id, home, template, s.params \r\n    FROM #__template_styles as s \r\n    LEFT JOIN #__extensions as e \r\n    ON e.element=s.template \r\n    AND e.type='template' \r\n    AND e.client_id=s.client_id \r\n    WHERE s.client_id = 0 AND e.enabled = 1\r\n```\r\n\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n\r\n* Index added to #__contentitem_tag_map table (*You can see this query execution when you access the site*)\r\n\r\n`ALTER TABLE #__contentitem_tag_map ADD INDEX idx_alias_item_id ('type_alias','content_item_id')`  ( #14 )\r\n\r\n**Index Description**\r\nWithout applying this index the below query cannot use any index to retrieve the rows from the database. After applying this index it clearly shows in the explanation section that the query uses the index to retrieve the rows. Also one another change did relevant to this index changes. Which is removing the `t.*` from the relevant query and adding the table fields instead. This change can be found (#14) and please refer to that PR also.\r\n\r\n **Related Query Before changes**\r\n```sql\r\n    SELECT m.tag_id,t.*\r\n    FROM #__contentitem_tag_map AS m\r\n    INNER JOIN #__tags AS t ON m.tag_id = t.id\r\n    WHERE m.type_alias = 'com_content.article' AND m.content_item_id = 5196 AND t.published = 1\r\n    AND t.access IN (1,1,5)\r\n```\r\n**Related Query After changes**\r\n```sql\r\n    SELECT m.tag_id,'id',t.parent_id,t.lft,t.rgt,t.level,t.path,t.title,t.alias,t.note,t.description,t.published,\r\n    t.checked_out,t.checked_out_time,t.access,t.params,t.metadesc,t.metakey,t.metadata,\r\n    t.created_user_id,t.created_time,t.created_by_alias,t.modified_user_id,t.modified_time,\r\n    t.images,t.urls,t.hits,t.language,t.version,t.publish_up,t.publish_down\r\n    FROM #__contentitem_tag_map AS m\r\n    INNER JOIN #__tags AS t ON m.tag_id = t.id\r\n    WHERE m.type_alias = 'com_content.article' AND m.content_item_id = 5196 AND t.published = 1\r\n    AND t.access IN (1,1,5)\r\n```\r\n\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n\r\n* Index added to #_extensions table (*You can see this query execution when you access the site*)\r\n\r\n`ALTER TABLE #__extensions ADD INDEX 'idx_type_ordering' ('type','ordering')` ( #16 )\r\n\r\n**Index Description**\r\nWithout applying this index the below query uses `filesort` to retrieve the rows from the database, which is an expensive retrieval operation. After applying this index it clearly shows in the explanation section that the query uses the index to retrieve the rows except the `filesort`.\r\n\r\n**Related Query**\r\n```sql\r\n    SELECT folder AS type, element AS name, params\r\n    FROM #_extensions\r\n    WHERE enabled >= 1\r\n    AND type ='plugin'\r\n    AND state >= 0\r\n    AND access IN (1,1,5)\r\n    ORDER BY ordering\r\n```\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n* Index added to #_menu table (*You can see this query execution when you access the site*)\r\n\r\n`ALTER TABLE #__menu ADD INDEX 'idx_client_id_published_lft' ('client_id','published','lft')` ( #17 )\r\n\r\n**Index Description**\r\nWithout applying this index the below query uses `filesort` to retrieve the rows from the database, which is an expensive retrieval operation. After applying this index it clearly shows in the explanation section that the query uses the index to retrieve the rows except the `filesort`.\r\n\r\n**Related Query**\r\n```sql\r\n    FROM #_menu AS m\r\n    LEFT JOIN #_extensions AS e\r\n    ON m.component_id = e.extension_id\r\n    WHERE m.published = 1\r\n    AND m.parent_id > 0\r\n    AND m.client_id = 0\r\n    ORDER BY m.lft\r\n```\r\n-------------------------------------------------------------------------------------------------------------------------------\r\n* Index added to #__viewlevels table\r\n(*query Executes when clicking on the add new category in the admin console*)\r\n\r\n![Add New Category](https://cloud.githubusercontent.com/assets/1329674/3926574/a08d6d36-23f2-11e4-9e90-57f017940161.png)\r\n\r\n`ALTER TABLE #__viewlevels \r\n            ADD INDEX  `idx_ordering_title` (  `ordering` ,  `title` )`(  #21 )\r\n\r\n**Index Description**\r\nWithout applying this index the below query uses `filesort` to retrieve the rows from the database, which is an expensive retrieval operation. After applying this index it clearly shows in the explanation section that the query uses the index to retrieve the rows except the `filesort`. Also changed the ` JROOT/libraries/cms/html/access.php ` file's query which is shown below by removing the `GROUP BY` clause since the `PRIMARY KEY` includes in the selected fields. And this reduce the execution time\r\n\r\n**Related Query Before Change**\r\n```sql\r\n    SELECT a.id AS value, a.title AS text\r\n    FROM ltzvy_viewlevels AS a\r\n    GROUP BY a.id, a.title, a.ordering\r\n    ORDER BY a.ordering ASC,`title` ASC\r\n```\r\n\r\n**Related Query After Change**\r\n```sql\r\n    SELECT a.id AS value, a.title AS text\r\n    FROM ltzvy_viewlevels AS a\r\n    ORDER BY a.ordering ASC,`title` ASC\r\n```","created_at":"2014-08-14T20:46:38Z","updated_at":"2015-01-25T05:41:53Z","closed_at":null,"merged_at":null,"merge_commit_sha":"61f41834b15eb39caa9fcfdd930bee62e7ab1c51","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115/commits","review_comments_url":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115/comments","review_comment_url":"https://api.github.com/repos/joomla/joomla-cms/pulls/comments/{number}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/4115/comments","statuses_url":"https://api.github.com/repos/joomla/joomla-cms/statuses/c2b9533093fb753874f8dece3e4590ecbbaca0d4","head":{"label":"nadeeshaan:SqlOptimise_new_index_merged_branch","ref":"SqlOptimise_new_index_merged_branch","sha":"c2b9533093fb753874f8dece3e4590ecbbaca0d4","user":{"login":"nadeeshaan","id":1329674,"avatar_url":"https://avatars.githubusercontent.com/u/1329674?v=3","gravatar_id":"","url":"https://api.github.com/users/nadeeshaan","html_url":"https://github.com/nadeeshaan","followers_url":"https://api.github.com/users/nadeeshaan/followers","following_url":"https://api.github.com/users/nadeeshaan/following{/other_user}","gists_url":"https://api.github.com/users/nadeeshaan/gists{/gist_id}","starred_url":"https://api.github.com/users/nadeeshaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nadeeshaan/subscriptions","organizations_url":"https://api.github.com/users/nadeeshaan/orgs","repos_url":"https://api.github.com/users/nadeeshaan/repos","events_url":"https://api.github.com/users/nadeeshaan/events{/privacy}","received_events_url":"https://api.github.com/users/nadeeshaan/received_events","type":"User","site_admin":false},"repo":{"id":19560585,"name":"JGSoC-SQL-Optimisation","full_name":"nadeeshaan/JGSoC-SQL-Optimisation","owner":{"login":"nadeeshaan","id":1329674,"avatar_url":"https://avatars.githubusercontent.com/u/1329674?v=3","gravatar_id":"","url":"https://api.github.com/users/nadeeshaan","html_url":"https://github.com/nadeeshaan","followers_url":"https://api.github.com/users/nadeeshaan/followers","following_url":"https://api.github.com/users/nadeeshaan/following{/other_user}","gists_url":"https://api.github.com/users/nadeeshaan/gists{/gist_id}","starred_url":"https://api.github.com/users/nadeeshaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nadeeshaan/subscriptions","organizations_url":"https://api.github.com/users/nadeeshaan/orgs","repos_url":"https://api.github.com/users/nadeeshaan/repos","events_url":"https://api.github.com/users/nadeeshaan/events{/privacy}","received_events_url":"https://api.github.com/users/nadeeshaan/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/nadeeshaan/JGSoC-SQL-Optimisation","description":"Home of the Joomla! Content Management System","fork":true,"url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation","forks_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/forks","keys_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/teams","hooks_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/hooks","issue_events_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/issues/events{/number}","events_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/events","assignees_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/assignees{/user}","branches_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/branches{/branch}","tags_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/tags","blobs_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/git/refs{/sha}","trees_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/statuses/{sha}","languages_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/languages","stargazers_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/stargazers","contributors_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/contributors","subscribers_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/subscribers","subscription_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/subscription","commits_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/commits{/sha}","git_commits_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/git/commits{/sha}","comments_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/comments{/number}","issue_comment_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/issues/comments/{number}","contents_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/contents/{+path}","compare_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/merges","archive_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/downloads","issues_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/issues{/number}","pulls_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/pulls{/number}","milestones_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/milestones{/number}","notifications_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/labels{/name}","releases_url":"https://api.github.com/repos/nadeeshaan/JGSoC-SQL-Optimisation/releases{/id}","created_at":"2014-05-08T04:32:37Z","updated_at":"2014-10-01T07:09:51Z","pushed_at":"2015-01-25T05:34:20Z","git_url":"git://github.com/nadeeshaan/JGSoC-SQL-Optimisation.git","ssh_url":"git@github.com:nadeeshaan/JGSoC-SQL-Optimisation.git","clone_url":"https://github.com/nadeeshaan/JGSoC-SQL-Optimisation.git","svn_url":"https://github.com/nadeeshaan/JGSoC-SQL-Optimisation","homepage":"http://joomla.org","size":115356,"stargazers_count":2,"watchers_count":2,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":10,"forks":0,"open_issues":10,"watchers":2,"default_branch":"SqlOptimise"}},"base":{"label":"joomla:staging","ref":"staging","sha":"5c2221f8aebe079b0b0908253f10d058055d62ce","user":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"repo":{"id":2464908,"name":"joomla-cms","full_name":"joomla/joomla-cms","owner":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/joomla/joomla-cms","description":"Home of the Joomla! Content Management System","fork":false,"url":"https://api.github.com/repos/joomla/joomla-cms","forks_url":"https://api.github.com/repos/joomla/joomla-cms/forks","keys_url":"https://api.github.com/repos/joomla/joomla-cms/keys{/key_id}","collaborators_url":"https://api.github.com/repos/joomla/joomla-cms/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/joomla/joomla-cms/teams","hooks_url":"https://api.github.com/repos/joomla/joomla-cms/hooks","issue_events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/events{/number}","events_url":"https://api.github.com/repos/joomla/joomla-cms/events","assignees_url":"https://api.github.com/repos/joomla/joomla-cms/assignees{/user}","branches_url":"https://api.github.com/repos/joomla/joomla-cms/branches{/branch}","tags_url":"https://api.github.com/repos/joomla/joomla-cms/tags","blobs_url":"https://api.github.com/repos/joomla/joomla-cms/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/joomla/joomla-cms/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/joomla/joomla-cms/git/refs{/sha}","trees_url":"https://api.github.com/repos/joomla/joomla-cms/git/trees{/sha}","statuses_url":"https://api.github.com/repos/joomla/joomla-cms/statuses/{sha}","languages_url":"https://api.github.com/repos/joomla/joomla-cms/languages","stargazers_url":"https://api.github.com/repos/joomla/joomla-cms/stargazers","contributors_url":"https://api.github.com/repos/joomla/joomla-cms/contributors","subscribers_url":"https://api.github.com/repos/joomla/joomla-cms/subscribers","subscription_url":"https://api.github.com/repos/joomla/joomla-cms/subscription","commits_url":"https://api.github.com/repos/joomla/joomla-cms/commits{/sha}","git_commits_url":"https://api.github.com/repos/joomla/joomla-cms/git/commits{/sha}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/comments{/number}","issue_comment_url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/{number}","contents_url":"https://api.github.com/repos/joomla/joomla-cms/contents/{+path}","compare_url":"https://api.github.com/repos/joomla/joomla-cms/compare/{base}...{head}","merges_url":"https://api.github.com/repos/joomla/joomla-cms/merges","archive_url":"https://api.github.com/repos/joomla/joomla-cms/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/joomla/joomla-cms/downloads","issues_url":"https://api.github.com/repos/joomla/joomla-cms/issues{/number}","pulls_url":"https://api.github.com/repos/joomla/joomla-cms/pulls{/number}","milestones_url":"https://api.github.com/repos/joomla/joomla-cms/milestones{/number}","notifications_url":"https://api.github.com/repos/joomla/joomla-cms/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/joomla/joomla-cms/labels{/name}","releases_url":"https://api.github.com/repos/joomla/joomla-cms/releases{/id}","created_at":"2011-09-27T02:07:38Z","updated_at":"2015-01-25T02:07:03Z","pushed_at":"2015-01-25T02:20:24Z","git_url":"git://github.com/joomla/joomla-cms.git","ssh_url":"git@github.com:joomla/joomla-cms.git","clone_url":"https://github.com/joomla/joomla-cms.git","svn_url":"https://github.com/joomla/joomla-cms","homepage":"http://joomla.org","size":295878,"stargazers_count":1416,"watchers_count":1416,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1570,"mirror_url":null,"open_issues_count":487,"forks":1570,"open_issues":487,"watchers":1416,"default_branch":"staging"}},"_links":{"self":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115"},"html":{"href":"https://github.com/joomla/joomla-cms/pull/4115"},"issue":{"href":"https://api.github.com/repos/joomla/joomla-cms/issues/4115"},"comments":{"href":"https://api.github.com/repos/joomla/joomla-cms/issues/4115/comments"},"review_comments":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115/comments"},"review_comment":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/joomla/joomla-cms/pulls/4115/commits"},"statuses":{"href":"https://api.github.com/repos/joomla/joomla-cms/statuses/c2b9533093fb753874f8dece3e4590ecbbaca0d4"}}}}