POST-ID:2677 array(5) { [0]=> object(WP_Term)#15589 (11) { ["term_id"]=> int(368) ["name"]=> string(12) "Father's Day" ["slug"]=> string(11) "fathers-day" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(368) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(60) "Brilliant ideas for treating Dad to something extra special." ["parent"]=> int(0) ["count"]=> int(64) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [1]=> object(WP_Term)#15593 (11) { ["term_id"]=> int(359) ["name"]=> string(27) "Food to get you in the mood" ["slug"]=> string(27) "food-to-get-you-in-the-mood" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(359) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(36) "Recipes to make you feel romantic..." ["parent"]=> int(0) ["count"]=> int(35) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [2]=> object(WP_Term)#15555 (11) { ["term_id"]=> int(362) ["name"]=> string(5) "Steak" ["slug"]=> string(5) "steak" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(362) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(102) "Master the classic steak and homemade chips or experiment with sauces, from peppercorn to chimichurri." ["parent"]=> int(0) ["count"]=> int(107) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [3]=> object(WP_Term)#15491 (11) { ["term_id"]=> int(74) ["name"]=> string(13) "Steak suppers" ["slug"]=> string(13) "steak-suppers" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(74) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(176) "Try something new for your steak night and invest in some rich game meat, such as venison. Or, choose an unusual cut like bavette or onglet. Some of the recipes have sides too!" ["parent"]=> int(0) ["count"]=> int(15) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [4]=> object(WP_Term)#15574 (11) { ["term_id"]=> int(27) ["name"]=> string(15) "Valentine's Day" ["slug"]=> string(14) "valentines-day" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(27) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(51) "Food of love - romantic recipes for the special day" ["parent"]=> int(0) ["count"]=> int(104) ["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 ( 368, 3593627427 )) AND p.post_type = 'bbc_recipes' AND (p.post_status = 'publish' OR p.post_status = 'private') AND p.ID <> 2677 GROUP BY p.ID ORDER BY p.post_date DESC LIMIT 0, 16