Multiple Taxonomy Queries Working?

  • jawhalen

    (@jawhalen)


    4 months ago

    It seems this function is not working. My shortcode is: [display-posts post_type=”product” taxonomy=”product_tags” tax_term=”featured” taxonomy_2=”product_categories” tax_2_term=”awards” posts_per_page=”20″ post_status=”publish” orderby=”post_title” image_size=”medium” wrapper=”div” wrapper_id=”product-product_tags-home-page”]

    The query generated is: SELECT?DISTINCT?t.term_id, tr.object_id
    FROM?staging_drJ_terms?AS?t
    INNER?JOIN?staging_drJ_term_taxonomy?AS?tt
    ON?t.term_id = tt.term_id
    INNER?JOIN?staging_drJ_term_relationships?AS?tr
    ON?tr.term_taxonomy_id = tt.term_taxonomy_id
    WHERE?tt.taxonomy?IN?(‘product_categories’, ‘product_tags’)
    AND?tr.object_id?IN?(85459, 85471, 85540, 85580, 85549, 85456, 85497, 85468, 85578, 85295)
    ORDER?BY?t.name?ASC

    I was following instructions on this page: https://displayposts.com/2019/01/07/taxonomy-queries/

    Appreciate your help!

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.