Changes between Initial Version and Version 1 of Ticket #1085, comment 11
- Timestamp:
- 12/29/2015 04:01:08 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #1085, comment 11
initial v1 2 2 3 3 {{{ 4 SELECT SUBSTRING_INDEX( `post_name`, '-', 1 ) as name, COUNT(*) + 1 AS count FROM `wporg_33_posts` WHERE `post_status` = 'publish' AND `post_type` = 'wp-parser-hook' AND `post_name` REGEXP '-[0-9]$' GROUP BY name ORDER BY count DESC, nameASC;4 SELECT SUBSTRING_INDEX( `post_name`, '-', 1 ) as hook, COUNT(*) AS count, GROUP_CONCAT(id) AS post_ids FROM `wporg_33_posts` WHERE `post_status` = 'publish' AND `post_type` = 'wp-parser-hook' AND `post_name` REGEXP '-[0-9]$' GROUP BY hook ORDER BY count DESC, hook ASC; 5 5 }}} 6 6