The problem with filtering categories

Bring Your Business to LifeSupportPopular WidgetThe problem with filtering categories

Tagged: ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #44591
    sajuuk
    Participant

    Super plugin, but I have a little problem with it.
    The query to the database does not include the category. The variable $where and $join is not included in the function get_most_viewed().
    Print a query used in get_most_viewed() function returns:
    SELECT ID, post_title, post_date, post_content, post_excerpt, meta_value FROM pd_posts as views p
    JOIN pd_postmeta pm on p.ID = pm.post_id
    WHERE meta_key = ‘_popular_views’
    AND meta_value! =”
    AND post_date> = ‘2012-01-08 11:48:51 ‘
    AND post_status =’publish’
    AND post_type IN (‘ post ‘,’ question ‘)
    ORDER BY (meta_value+0)
    DESC LIMIT 5

    #44614
    Xpark Media
    Keymaster

    I will look into it, if you made modifications to the query please send me the changes so I can include it on future releases

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.