POST-ID:19978
array(7) {
[0]=>
object(WP_Term)#15801 (11) {
["term_id"]=>
int(49)
["name"]=>
string(11) "Easy summer"
["slug"]=>
string(11) "easy-summer"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(49)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(39) "Discover the best summer meals"
["parent"]=>
int(0)
["count"]=>
int(177)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[1]=>
object(WP_Term)#15718 (11) {
["term_id"]=>
int(44)
["name"]=>
string(4) "Fish"
["slug"]=>
string(4) "fish"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(44)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(0) ""
["parent"]=>
int(0)
["count"]=>
int(111)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[2]=>
object(WP_Term)#16591 (11) {
["term_id"]=>
int(200)
["name"]=>
string(12) "Healthy fish"
["slug"]=>
string(12) "healthy-fish"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(200)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(109) "From lighter pies to makeover fish & chips, nothing's off the menu with our healthier fish dishes..."
["parent"]=>
int(0)
["count"]=>
int(52)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[3]=>
object(WP_Term)#15816 (11) {
["term_id"]=>
int(203)
["name"]=>
string(13) "Healthy pasta"
["slug"]=>
string(13) "healthy-pasta"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(203)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(40) "Light pasta dishes that are all low cal."
["parent"]=>
int(0)
["count"]=>
int(55)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[4]=>
object(WP_Term)#15824 (11) {
["term_id"]=>
int(208)
["name"]=>
string(14) "Healthy summer"
["slug"]=>
string(14) "healthy-summer"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(208)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(35) "BBQ, picnic and al fresco feasting."
["parent"]=>
int(0)
["count"]=>
int(100)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[5]=>
object(WP_Term)#15719 (11) {
["term_id"]=>
int(326)
["name"]=>
string(5) "Pasta"
["slug"]=>
string(5) "pasta"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(326)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(47) "Delicious pasta dishes from spaghetti to soups."
["parent"]=>
int(0)
["count"]=>
int(109)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[6]=>
object(WP_Term)#15796 (11) {
["term_id"]=>
int(156)
["name"]=>
string(13) "Perfect pasta"
["slug"]=>
string(13) "perfect-pasta"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(156)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(88) "From lasagne to spaghetti, these scrumptious pasta dishes are perfect for all the family"
["parent"]=>
int(0)
["count"]=>
int(84)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
}
SELECT p.ID, p.post_title, rd.recipe_data_ref_id, rd.photo_file_name, rd.photo_src, rd.skill_level FROM bbc20may18_posts p LEFT JOIN bbc20may18_term_relationships tr ON (p.ID = tr.object_id) LEFT JOIN bbc20may18_recipes_data rd ON (p.ID = rd.recipe_post_id) WHERE (tr.term_taxonomy_id IN ( 49, 44200203208326156 )) AND p.post_type = 'bbc_recipes' AND (p.post_status = 'publish' OR p.post_status = 'private') AND p.ID <> 19978 GROUP BY p.ID ORDER BY p.post_date DESC LIMIT 0, 16