Timeline for Changes between Mysql version 5.1 TO 5.7
Current License: CC BY-SA 4.0
26 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15 at 3:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 17 at 21:33 | review | Close votes | |||
| Jul 24 at 3:04 | |||||
| Jul 17 at 21:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 19 at 19:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 8, 2023 at 6:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 5, 2023 at 0:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 4, 2023 at 21:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 26, 2022 at 11:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 24, 2022 at 11:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 9, 2022 at 20:32 | review | Close votes | |||
| Feb 14, 2022 at 3:03 | |||||
| Feb 9, 2022 at 20:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 11, 2021 at 22:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 12, 2021 at 17:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 11, 2021 at 18:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 12, 2020 at 10:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 11, 2020 at 7:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 5, 2020 at 11:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 16, 2018 at 3:17 | answer | added | Rick James | timeline score: 0 | |
| S Oct 8, 2018 at 7:34 | history | suggested | user3863292 | CC BY-SA 4.0 |
Updated result of query with Explain clause.
|
| Oct 8, 2018 at 7:15 | comment | added | John K. N. | If you accidentally created two accounts then please have a look at the article (I accidentally created two accounts; how do I merge them?). This will allow you to directly edit your question without it being pushed into the community's review queue. Thank you. | |
| Oct 8, 2018 at 5:44 | review | Suggested edits | |||
| S Oct 8, 2018 at 7:34 | |||||
| Oct 5, 2018 at 6:01 | comment | added | danblack |
Looks like this is just a count of products with or without (left join) an 'APPROVED_ATTIRIBUTES'. So why is it so complicated? Try rewriting it from scratch. The GROUP_CONCAT obviously isn't needed. Also FULL_GROUP_BY is a feature to stop you getting wrong results, recommend using it.
|
|
| Oct 5, 2018 at 5:02 | history | edited | Akina | CC BY-SA 4.0 |
Code formatting
|
| Oct 5, 2018 at 5:02 | comment | added | Akina | ORDER BY clause have no sense when used in subquery without a LIMIT clause. Remove them. Additionally it allows remove the most inner subquery. | |
| Oct 5, 2018 at 4:20 | review | First posts | |||
| Oct 5, 2018 at 6:26 | |||||
| Oct 5, 2018 at 4:18 | history | asked | krishna | CC BY-SA 4.0 |