Tagged Questions
0
votes
2answers
410 views
How to Query Database for posts with certain Taxonomy Term
I want to write a select query to return data on only posts which have are associated with the taxonomy term food-and-beverage
SELECT wp_postmeta . * , wp_posts.post_name
FROM wp_posts, wp_postmeta, ...
-1
votes
1answer
80 views
Custom wordpress SQL statement for a website
I'm trying to link specific columns from a few standard tables in a wordpress database. I specifically want to see a view/table that includes:
post title
post content
guid
meta value = image url
...
1
vote
1answer
110 views
MySQL Rank & $wpdb
I need a rank column in my MySQL statement, for example:
SET @rank=0;
SELECT @rank:=@rank +1 as rank, player, points
FROM my_table
Is there a way to use the above with $wpdb? WordPress doesn't ...
