Executing multiple line queries to generate pie chart

  • fireresearch

    (@fireresearch)


    7 years, 5 months ago

    Hii,

    We are unable to execute query to generate pie chart through Edit Query Page. Query is as below.

    SELECT name,count(name) from wp_terms
    where term_id in (select term_taxonomy_id from wp_term_relationships
    where object_id in (select id from wp_posts where post_date>=’2017-15-06%’ and post_date<=’2018-12-28%’))
    group by name

    Following is the error
    http://localhost:8000/wp-admin/admin-post.php?action=edit_query
    HTTP ERROR 500

    Please advice.

    Thanks in advance.

The topic ‘Executing multiple line queries to generate pie chart’ is closed to new replies.