Category Page Order By

  • Resolved Alok Mishra

    (@alokchetaru)


    5 years, 2 months ago

    Hello,
    We have included orderby => menu_order with the query.
    it’s visible on the print.
    But it’s not working because of request.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
    wp_posts.ID NOT IN (SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (8)) AND wp_term_relationships.term_taxonomy_id IN (66)
    ) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’) GROUP BY wp_posts.ID ORDER BY FIELD(wp_posts.ID, 7340,6298,5188,7563,6275,6227,5772,5777,5752,5546,5355,5370,4326,4337,4251,4242,4156,4159,3982,3993,3865,3857,3774,3783,3648,3673,3676,3724,3431,3441,3264,3265,3271,3277,3293,3299,3306,16852), wp_posts.post_date DESC LIMIT 0, 12

    Woocommerce: Version 3.8.1
    Wordpress: Version 5.3.2

    • This topic was modified 5 years, 2 months ago by Alok Mishra.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Category Page Order By’ is closed to new replies.