POST-ID:3941 array(4) { [0]=> object(WP_Term)#16723 (11) { ["term_id"]=> int(153) ["name"]=> string(20) "Cooking for the kids" ["slug"]=> string(20) "cooking-for-the-kids" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(153) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(58) "Whip up these quick and simple recipes for the little ones" ["parent"]=> int(0) ["count"]=> int(53) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [1]=> object(WP_Term)#16690 (11) { ["term_id"]=> int(24) ["name"]=> string(14) "Speedy suppers" ["slug"]=> string(14) "speedy-suppers" ["term_group"]=> int(0) ["term_taxonomy_id"]=> int(24) ["taxonomy"]=> string(15) "bbc_collections" ["description"]=> string(34) "Easy suppers for the week" ["parent"]=> int(0) ["count"]=> int(106) ["filter"]=> string(3) "raw" ["term_order"]=> string(1) "0" } [2]=> object(WP_Term)#16618 (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)#16601 (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" } }
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 ( 153, 2436274 )) AND p.post_type = 'bbc_recipes' AND (p.post_status = 'publish' OR p.post_status = 'private') AND p.ID <> 3941 GROUP BY p.ID ORDER BY p.post_date DESC LIMIT 0, 16