SELECT *
FROM wp_posts
LEFT JOIN wp_term_relationships ON(wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_taxonomy ON(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
LEFT JOIN wp_terms ON(wp_term_taxonomy.term_id = wp_terms.term_id)
WHERE wp_posts.post_type = 'work-item'
AND wp_posts.post_status = 'publish'
AND wp_term_taxonomy.taxonomy = 'we-do'
AND wp_terms.slug = 'featured'
ORDER BY wp_posts.post_date DESC
J&B required a Facebook app for the J&B Met following the theme of “made different”.
What we did
We developed an interactive Facebook app where a user could select from preset keywords to describe themselves, which were then posted to their Facebook wall and entered into a competition.