Changes between Initial Version and Version 2 of Ticket #32059
- Timestamp:
- Oct 1, 2020, 4:01:31 AM (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #32059
- Property Summary Issue when counting auth_user extended model by month → Issue when counting a model extending auth_user by month
-
Ticket #32059 – Description
initial v2 24 24 25 25 Any clues of what's happening here? If I do the same query but with the User I get what I want. 26 27 {{{ 28 SELECT CAST(DATE_FORMAT(CONVERT_TZ(`auth_user`.`date_joined`, 'UTC', 'Europe/Madrid'), '%Y-%m-01 00:00:00') AS DATETIME) AS `month`, COUNT(`auth_user`.`id`) AS `count` FROM `auth_user` GROUP BY CAST(DATE_FORMAT(CONVERT_TZ(`auth_user`.`date_joined`, 'UTC', 'Europe/Madrid'), '%Y-%m-01 00:00:00') AS DATETIME) ORDER BY NULL 29 }}}