WordPress.org

Making WordPress.org

Changes between Initial Version and Version 1 of Ticket #1085, comment 11


Ignore:
Timestamp:
12/29/2015 04:01:08 PM (4 years ago)
Author:
ocean90
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #1085, comment 11

    initial v1  
    22
    33{{{
    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, name ASC;
     4SELECT 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;
    55}}}
    66