trying to show all posts being watched by more than 1 visitor on a page for my own admin purposes.
I've got this so far, but can't see
SELECT * FROM $wpdb->postmeta
WHERE 'meta_key' LIKE 'wpfp_favorites'
AND 'meta_value' > 1
then typically in a page template I do this, to use a template that shows specific information about the posts gathered.
This template includes the typical
while (have_posts()) : the_post();
so what am I doing wrong in the sql query above?
The final result will be a page which gives me a visual on the posts being favorited AND a list of page ID numbers (in my case, e-commerce site, so SKU's) which I can place on Special each week to generate more sales.
any help appreciated