Please help in WordPress query

I need User filter as well in this query, mean result will come as per logged in user or post user

This is function created

 public static function listing_views_get_popular_listings( $count = 10 ) {
        global $wpdb;

        $sql = 'SELECT <code>key</code>, post_title, COUNT(*) as count FROM ' . $wpdb->prefix . 'listing_stats
                LEFT JOIN ' . $wpdb->prefix . 'posts ON ' . $wpdb->prefix . 'posts.ID=' . $wpdb->prefix . 'listing_stats.key
				GROUP BY <code>key</code>
                ORDER BY count DESC
                LIMIT ' . $count . ';';

        return $wpdb->get_results( $sql );
    }

I need where condition, mean data will come as per post user

• This topic was modified 7 years, 3 months ago by Steven Stern (sterndata).