Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter valta

    (@valta)

    I found i workaround using the post instead of Project type.

    As the posts are using different category depending of the language

    Best regards

    Etienne

    Thread Starter valta

    (@valta)

    Again to give more information :

    the SQL Query from an other module when the plugin Polylang is active :
    SELECT SQL_CALC_FOUND_ROWS my_posts.ID FROM my_posts LEFT JOIN my_term_relationships ON (my_posts.ID = my_term_relationships.object_id) LEFT JOIN my_term_relationships AS tt1 ON (my_posts.ID = tt1.object_id) WHERE 1=1 AND ( my_term_relationships.term_taxonomy_id IN (12) AND tt1.term_taxonomy_id IN (6) ) AND my_posts.post_type = ‘project’ AND (my_posts.post_status = ‘publish’ OR my_posts.post_status = ‘acf-disabled’ OR my_posts.post_status = ‘private’) GROUP BY my_posts.ID ORDER BY my_posts.post_date ASC LIMIT 0, 16

    And the SQL Query from visual portfolio
    SELECT my_posts.* FROM my_posts LEFT JOIN my_term_relationships ON (my_posts.ID = my_term_relationships.object_id) WHERE 1=1 AND ( my_term_relationships.term_taxonomy_id IN (6) ) AND my_posts.post_type = ‘project’ AND (my_posts.post_status = ‘publish’ OR my_posts.post_status = ‘acf-disabled’ OR my_posts.post_status = ‘private’) GROUP BY my_posts.ID ORDER BY my_posts.post_date DESC

    Thread Starter valta

    (@valta)

    Hello

    More information about the values :

    If the plugin Polylang is not active :
    WP_Query[‘tax_query’] =>
    Array ( [relation] => and [0] => Array ( [taxonomy] => project_category [field] => id [terms] => 12 ) )

    If the plugin Polylang is active :
    Array ( [relation] => and )

    Polylang is adding some data at this end of the query to filter on the language

    Thank you for your support

    Valta

Viewing 3 replies - 1 through 3 (of 3 total)