{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":704557068,"defaultBranch":"master","name":"Sprint2_T2_MySQL_Query","ownerLogin":"plopezgit","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-10-13T14:09:47.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/131781567?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1697231173.0","currentOid":""},"activityList":{"items":[{"before":"6ddd0760de57d768a697f36e5f20ecd2f61f55d3","after":"5aea2ffb191742200ffadc95a246670700b97204","ref":"refs/heads/master","pushedAt":"2023-10-17T22:09:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"sql list query increment;\n\ntest passed\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"sql list query increment;"}},{"before":"a7558f39a0feea14a99fb6edba24376115bb860b","after":"6ddd0760de57d768a697f36e5f20ecd2f61f55d3","ref":"refs/heads/master","pushedAt":"2023-10-17T21:48:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"sql query list increment","shortMessageHtmlLink":"sql query list increment"}},{"before":"652d4a4002fd47f5ba9f66dc87e68fbb5f6c91f6","after":"a7558f39a0feea14a99fb6edba24376115bb860b","ref":"refs/heads/master","pushedAt":"2023-10-17T21:31:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses min max sql functions;\n\ntest passed\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses min max sql functions;"}},{"before":"c1d05dd4259d1ec84bd4f98b03865ac1e3998580","after":"652d4a4002fd47f5ba9f66dc87e68fbb5f6c91f6","ref":"refs/heads/master","pushedAt":"2023-10-17T19:19:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"sql query increment","shortMessageHtmlLink":"sql query increment"}},{"before":"f5270e9775a198e17a420ea04a1629f80726f319","after":"c1d05dd4259d1ec84bd4f98b03865ac1e3998580","ref":"refs/heads/master","pushedAt":"2023-10-17T18:18:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"tries subconsult sql syntax;\n\ntest passed\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"tries subconsult sql syntax;"}},{"before":"2a7a76f8ec02825aefebf5d9db73db94a6d22d6f","after":"f5270e9775a198e17a420ea04a1629f80726f319","ref":"refs/heads/master","pushedAt":"2023-10-17T17:30:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"queries increment","shortMessageHtmlLink":"queries increment"}},{"before":"a38d52e618836ef2daa892386387ab5398e41e3b","after":"2a7a76f8ec02825aefebf5d9db73db94a6d22d6f","ref":"refs/heads/master","pushedAt":"2023-10-17T17:14:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"list query increment;\n\ntest passed","shortMessageHtmlLink":"list query increment;"}},{"before":"6aba088972e8efa8281784df4260bb2a27287500","after":"a38d52e618836ef2daa892386387ab5398e41e3b","ref":"refs/heads/master","pushedAt":"2023-10-17T16:38:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"tries group by having clause;\n\ntest passed\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"tries group by having clause;"}},{"before":"a7271fdabf8e036d95c8107125c0ae90a9f3a23a","after":"6aba088972e8efa8281784df4260bb2a27287500","ref":"refs/heads/master","pushedAt":"2023-10-17T16:27:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"groups by two elements on #55\n\nquery line; test passed\n\nigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"groups by two elements on #55"}},{"before":"280bbd56f812700d133bd41d37d55fd4767e6fbd","after":"a7271fdabf8e036d95c8107125c0ae90a9f3a23a","ref":"refs/heads/master","pushedAt":"2023-10-17T16:09:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"updates README.md","shortMessageHtmlLink":"updates README.md"}},{"before":"ef8175ca2080625806efd00c46f57511659c4afd","after":"280bbd56f812700d133bd41d37d55fd4767e6fbd","ref":"refs/heads/master","pushedAt":"2023-10-17T16:06:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"tries group by statement;\n\ntest passed; adds README.md\nnote: current university data structure does not seem to support credits\nby type assignature distinction\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"tries group by statement;"}},{"before":"ce37b85ad64b9536b6202f635ad1f2c956f98b2d","after":"ef8175ca2080625806efd00c46f57511659c4afd","ref":"refs/heads/master","pushedAt":"2023-10-17T15:03:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"summary query list increment;\n\ntest passed\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"summary query list increment;"}},{"before":"85ab475f4e7ff5d1c8f97398eec11b5e3777451a","after":"ce37b85ad64b9536b6202f635ad1f2c956f98b2d","ref":"refs/heads/master","pushedAt":"2023-10-17T12:36:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"tries diverse filters","shortMessageHtmlLink":"tries diverse filters"}},{"before":"b37ffd69f85a991a4970d72ff5c90c9d8a50b66a","after":"85ab475f4e7ff5d1c8f97398eec11b5e3777451a","ref":"refs/heads/master","pushedAt":"2023-10-17T08:17:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"adds order by on #44 line query\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"adds order by on #44 line query"}},{"before":"5842abcfd0f1c0778d3164b42166f447ce823da7","after":"b37ffd69f85a991a4970d72ff5c90c9d8a50b66a","ref":"refs/heads/master","pushedAt":"2023-10-16T18:52:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"try left join\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"try left join"}},{"before":"8cb4ddfcddf434598bdbd906564e3ce4b670b925","after":"5842abcfd0f1c0778d3164b42166f447ce823da7","ref":"refs/heads/master","pushedAt":"2023-10-16T12:40:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"enhance line #28 query by distinct p.*\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"enhance line #28 query by distinct p.*"}},{"before":"713e07afd5c33bc6a43e553f368ed9742b71c3f2","after":"8cb4ddfcddf434598bdbd906564e3ce4b670b925","ref":"refs/heads/master","pushedAt":"2023-10-16T12:34:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"opens to p.*","shortMessageHtmlLink":"opens to p.*"}},{"before":"8f98c1e956335d98bea1dc8e2304ee584dc569b6","after":"713e07afd5c33bc6a43e553f368ed9742b71c3f2","ref":"refs/heads/master","pushedAt":"2023-10-16T10:15:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"try between\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"try between"}},{"before":"3d8d84ca278246c2ccbf4f2ea4874e5db3b55406","after":"8f98c1e956335d98bea1dc8e2304ee584dc569b6","ref":"refs/heads/master","pushedAt":"2023-10-16T09:27:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"try four tables join query\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"try four tables join query"}},{"before":"34e4d848a802586a92b86f06fccfc7de16b0996d","after":"3d8d84ca278246c2ccbf4f2ea4874e5db3b55406","ref":"refs/heads/master","pushedAt":"2023-10-16T08:22:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses diverse filters\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses diverse filters"}},{"before":"63f19bbdb3b1ebb11052b5d8df37b700a6065402","after":"34e4d848a802586a92b86f06fccfc7de16b0996d","ref":"refs/heads/master","pushedAt":"2023-10-15T09:59:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses union\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses union"}},{"before":"48d568414538857d8fdc19690490687e183e0988","after":"63f19bbdb3b1ebb11052b5d8df37b700a6065402","ref":"refs/heads/master","pushedAt":"2023-10-14T18:47:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses %","shortMessageHtmlLink":"uses %"}},{"before":"f4dd35e9235f273ee8e50f1a2e31431c860627cc","after":"48d568414538857d8fdc19690490687e183e0988","ref":"refs/heads/master","pushedAt":"2023-10-14T18:23:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses in operator","shortMessageHtmlLink":"uses in operator"}},{"before":"3ae798241754333b842d7b254408db9b8274eac5","after":"f4dd35e9235f273ee8e50f1a2e31431c860627cc","ref":"refs/heads/master","pushedAt":"2023-10-14T17:12:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses diverse filters combination\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses diverse filters combination"}},{"before":"5422550fe4012bf5dbb8963465215d2bbcf52ff7","after":"3ae798241754333b842d7b254408db9b8274eac5","ref":"refs/heads/master","pushedAt":"2023-10-14T12:09:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses order by and limit combination\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses order by and limit combination"}},{"before":"037b0f18cf854e7e1f18e2013d1f745ccaca0602","after":"5422550fe4012bf5dbb8963465215d2bbcf52ff7","ref":"refs/heads/master","pushedAt":"2023-10-14T11:45:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses order by asc desc, limit keyword\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses order by asc desc, limit keyword"}},{"before":"9f7555f5d4b76a00d5cffd85d7c78835b9f7ffd5","after":"037b0f18cf854e7e1f18e2013d1f745ccaca0602","ref":"refs/heads/master","pushedAt":"2023-10-14T09:08:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses distinct keyword","shortMessageHtmlLink":"uses distinct keyword"}},{"before":"c1ff436d07da04a15c337b7bcd8f3eaba146c79b","after":"9f7555f5d4b76a00d5cffd85d7c78835b9f7ffd5","ref":"refs/heads/master","pushedAt":"2023-10-14T08:39:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses format() sql function\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses format() sql function"}},{"before":"5ac42f8ee6550de488e5cf68322843fb7f0189c0","after":"c1ff436d07da04a15c337b7bcd8f3eaba146c79b","ref":"refs/heads/master","pushedAt":"2023-10-13T21:51:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"uses substring(upper(nombre), 0, 1)\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"uses substring(upper(nombre), 0, 1)"}},{"before":null,"after":"5ac42f8ee6550de488e5cf68322843fb7f0189c0","ref":"refs/heads/master","pushedAt":"2023-10-13T21:06:13.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"plopezgit","name":"Pedro Lopez","path":"/plopezgit","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/131781567?s=80&v=4"},"commit":{"message":"writes MySQL queries\nhttps://github.com/plopezgit/Sprint2_T2_MySQL_Query/issues/2\n\nSigned-off-by: plopezgit <p.lopez.ch.hr@hotmail.com>","shortMessageHtmlLink":"writes MySQL queries"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADmWt7AQA","startCursor":null,"endCursor":null}},"title":"Activity · plopezgit/Sprint2_T2_MySQL_Query"}