WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #11302, comment 25


Ignore:
Timestamp:
08/26/2015 06:46:48 PM (5 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #11302, comment 25

    initial v1  
    33I think I've figured out the SQL to do this. Can anybody tell me if I'm missing something?
    44In this case 493 is the term_id of the product category.
    5 
     5{{{
    66DELETE  term_relationships
    77INNER JOIN term_taxonomy
     
    1212count = 0
    1313WHERE term_taxonomy.term_id = 493
    14 
     14}}}
    1515
    1616ANOTHER SOLUTION which may be easier for you guys to implement as it eliminates a lot of complexity and potential for serious bugs and user misunderstanding is to have a second icon/link column in the Product Category page, next to the "Count" column. When clicked it takes you to a completely new page that lists all the products in the category (not the page that you go to when you click "count").