POST-ID:22120
array(7) {
[0]=>
object(WP_Term)#6546 (11) {
["term_id"]=>
int(118)
["name"]=>
string(16) "All-time classic"
["slug"]=>
string(16) "all-time-classic"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(118)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(72) "Our selection of cheesecake recipes that will surely sate your appetite."
["parent"]=>
int(0)
["count"]=>
int(47)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[1]=>
object(WP_Term)#6545 (11) {
["term_id"]=>
int(242)
["name"]=>
string(23) "Festive dessert recipes"
["slug"]=>
string(15) "festive-dessert"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(242)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(160) "Try our selection of traditional and alternative sweet treats for the festive season. We've got Christmas pudding, mince pies, trifle, cheesecake and more."
["parent"]=>
int(0)
["count"]=>
int(86)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[2]=>
object(WP_Term)#6544 (11) {
["term_id"]=>
int(214)
["name"]=>
string(21) "Low-calorie breakfast"
["slug"]=>
string(21) "low-calorie-breakfast"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(214)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(0) ""
["parent"]=>
int(0)
["count"]=>
int(23)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[3]=>
object(WP_Term)#6543 (11) {
["term_id"]=>
int(254)
["name"]=>
string(18) "Mince pies recipes"
["slug"]=>
string(10) "mince-pies"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(254)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(76) "Deep & decadent or simple & speedy - we have all mince pies covered!"
["parent"]=>
int(0)
["count"]=>
int(22)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[4]=>
object(WP_Term)#6560 (11) {
["term_id"]=>
int(416)
["name"]=>
string(6) "Pastry"
["slug"]=>
string(6) "pastry"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(416)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(0) ""
["parent"]=>
int(0)
["count"]=>
int(30)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[5]=>
object(WP_Term)#6562 (11) {
["term_id"]=>
int(109)
["name"]=>
string(14) "Perfect pastry"
["slug"]=>
string(14) "perfect-pastry"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(109)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(0) ""
["parent"]=>
int(0)
["count"]=>
int(17)
["filter"]=>
string(3) "raw"
["term_order"]=>
string(1) "0"
}
[6]=>
object(WP_Term)#6457 (11) {
["term_id"]=>
int(218)
["name"]=>
string(18) "Vegetarian dessert"
["slug"]=>
string(18) "vegetarian-dessert"
["term_group"]=>
int(0)
["term_taxonomy_id"]=>
int(218)
["taxonomy"]=>
string(15) "bbc_collections"
["description"]=>
string(57) "Decadent desserts such as Pavlova and Chocolate marquise."
["parent"]=>
int(0)
["count"]=>
int(27)
["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 ( 118, 242214254416109218 ) OR rd.ingredients LIKE '%Christmas food%' OR rd.ingredients LIKE '% Dried fruit%' OR rd.ingredients LIKE '% lighter mince pies%' OR rd.ingredients LIKE '% Mince pies%' OR rd.ingredients LIKE '% Mincemeat%' OR rd.ingredients LIKE '% Puff pastry%') AND p.post_type = 'bbc_recipes' AND (p.post_status = 'publish' OR p.post_status = 'private') AND p.ID <> 22120 GROUP BY p.ID ORDER BY p.post_date DESC LIMIT 0, 16