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
This kind of works but I have 3 rows per item returned. I just want one, then to be able to select the newest item from all categories except 2, 4 and 7 for example.
SELECT wp_posts.post_title, wp_posts.`guid`, wp_postmeta.meta_value FROM wp_posts, wp_postmeta WHERE wp_posts.post_type = 'post' AND wp_postmeta.meta_key = 'image_url' AND wp_posts.post_status = 'publish'
I've been on this task for 3 days and searched hi and lo, watched videos, followed tuts and am about to pull my hair out.