SELECT recipes.id AS recipes_id, recipes.created AS recipes_created, recipes.modified AS recipes_modified, recipes.NAME AS recipes_name, recipes.name_search_vector AS recipes_name_search_vector, recipes.summary AS recipes_summary, recipes.description AS recipes_description, recipes.book AS recipes_book, recipes.isbn AS recipes_isbn, recipes.content_key AS recipes_content_key, recipes.prep_time_seconds AS recipes_prep_time_seconds, recipes.cooking_time_seconds AS recipes_cooking_time_seconds, recipes.max_stand_time AS recipes_max_stand_time, recipes.number_of_servings AS recipes_number_of_servings, recipes.difficulty AS recipes_difficulty, recipes.quantity AS recipes_quantity, recipes.serving_size AS recipes_serving_size , recipes.calories AS recipes_calories, recipes.total_fat AS recipes_total_fat, recipes.saturated_fat AS recipes_saturated_fat, recipes.unsaturated_fat AS recipes_unsaturated_fat, recipes.carbohydrates AS recipes_carbohydrates, recipes.sugar AS recipes_sugar, recipes.fiber AS recipes_fiber, recipes.protein AS recipes_protein, recipes.cholesterol AS recipes_cholesterol, recipes.sodium AS recipes_sodium, recipes.potassium AS recipes_potassium, recipes.has_good_carbohydrate AS recipes_has_good_carbohydrate, recipes.has_bad_carbohydrate AS recipes_has_bad_carbohydrate, recipes.has_gluten AS recipes_has_gluten, recipes.has_oats AS recipes_has_oats, recipes.has_tree_nuts AS recipes_has_tree_nuts, recipes.has_peanuts AS recipes_has_peanuts, recipes.has_soy AS recipes_has_soy, recipes.has_sulphite AS recipes_has_sulphite , recipes.has_alpha_gal AS recipes_has_alpha_gal, recipes.has_milk AS recipes_has_milk, recipes.has_lactose AS recipes_has_lactose, recipes.has_eggs AS recipes_has_eggs, recipes.has_wheat AS recipes_has_wheat, recipes.is_mollusk AS recipes_is_mollusk, recipes.is_shellfish AS recipes_is_shellfish , recipes.is_beef AS recipes_is_beef, recipes.is_animal_product AS recipes_is_animal_product, recipes.is_pork AS recipes_is_pork, recipes.is_fish AS recipes_is_fish, recipes.is_vegetable AS recipes_is_vegetable , recipes.is_fruit AS recipes_is_fruit, recipes.is_poultry AS recipes_is_poultry, recipes.publish_state AS recipes_publish_state, recipes.published_by_id AS recipes_published_by_id, recipe_authors_1.recipe_id AS recipe_authors_1_recipe_id, recipe_authors_1.person_id AS recipe_authors_1_person_id, recipe_authors_1.full_name AS recipe_authors_1_full_name, recipe_authors_1."order" AS recipe_authors_1_order, scanned_photos_1.id AS scanned_photos_1_id, scanned_photos_1.created AS scanned_photos_1_created, scanned_photos_1.modified AS scanned_photos_1_modified, scanned_photos_1.shopping_receipt_id AS scanned_photos_1_shopping_receipt_id, scanned_photos_1.recipe_id AS scanned_photos_1_recipe_id, scanned_photos_1.household_id AS scanned_photos_1_household_id, scanned_photos_1.person_id AS scanned_photos_1_person_id, scanned_photos_1.device AS scanned_photos_1_device, scanned_photos_1.position AS scanned_photos_1_position, scanned_photos_1.original_photo_storage_key AS scanned_photos_1_original_photo_storage_key, scanned_photos_1.scanned_photo_storage_key AS scanned_photos_1_scanned_photo_storage_key, scanned_photos_1.archival_photo_storage_key AS scanned_photos_1_archival_photo_storage_key, cooking_utensils_1.id AS cooking_utensils_1_id, cooking_utensils_1.NAME AS cooking_utensils_1_name, cooking_utensils_1.created AS cooking_utensils_1_created, cooking_utensils_1.modified AS cooking_utensils_1_modified, cooking_appliances_1.id AS cooking_appliances_1_id, cooking_appliances_1.NAME AS cooking_appliances_1_name, cooking_appliances_1.created AS cooking_appliances_1_created, cooking_appliances_1.modified AS cooking_appliances_1_modified, recipe_pictures_1.id AS recipe_pictures_1_id , recipe_pictures_1.created AS recipe_pictures_1_created, recipe_pictures_1.modified AS recipe_pictures_1_modified, recipe_pictures_1.recipe_id AS recipe_pictures_1_recipe_id, recipe_pictures_1.image AS recipe_pictures_1_image, recipe_pictures_1.content_type AS recipe_pictures_1_content_type, recipe_pictures_1."order" AS recipe_pictures_1_order, ingredient_nodes_1.NAME AS ingredient_nodes_1_name, ingredients_1.id AS ingredients_1_id, ingredient_nodes_1.id AS ingredient_nodes_1_id, ingredient_nodes_1.hashed_id AS ingredient_nodes_1_hashed_id, ingredient_nodes_1.label AS ingredient_nodes_1_label, ingredient_nodes_1.type AS ingredient_nodes_1_type, ingredient_nodes_1.name_length AS ingredient_nodes_1_name_length, ingredient_nodes_1.source_id AS ingredient_nodes_1_source_id, ingredient_nodes_1.edge_type_id AS ingredient_nodes_1_edge_type_id, ingredient_nodes_1.name_search_vector AS ingredient_nodes_1_name_search_vector, ingredient_nodes_1.has_image AS ingredient_nodes_1_has_image, ingredients_1.created AS ingredients_1_created, ingredients_1.modified AS ingredients_1_modified, ingredients_1.quantity AS ingredients_1_quantity, ingredients_1.serving_size AS ingredients_1_serving_size, ingredients_1.calories AS ingredients_1_calories, ingredients_1.total_fat AS ingredients_1_total_fat, ingredients_1.saturated_fat AS ingredients_1_saturated_fat, ingredients_1.unsaturated_fat AS ingredients_1_unsaturated_fat, ingredients_1.carbohydrates AS ingredients_1_carbohydrates, ingredients_1.sugar AS ingredients_1_sugar, ingredients_1.fiber AS ingredients_1_fiber, ingredients_1.protein AS ingredients_1_protein, ingredients_1.cholesterol AS ingredients_1_cholesterol, ingredients_1.sodium AS ingredients_1_sodium , ingredients_1.potassium AS ingredients_1_potassium, ingredients_1.has_good_carbohydrate AS ingredients_1_has_good_carbohydrate, ingredients_1.has_bad_carbohydrate AS ingredients_1_has_bad_carbohydrate, ingredients_1.has_gluten AS ingredients_1_has_gluten, ingredients_1.has_oats AS ingredients_1_has_oats, ingredients_1.has_tree_nuts AS ingredients_1_has_tree_nuts, ingredients_1.has_peanuts AS ingredients_1_has_peanuts, ingredients_1.has_soy AS ingredients_1_has_soy, ingredients_1.has_sulphite AS ingredients_1_has_sulphite, ingredients_1.has_alpha_gal AS ingredients_1_has_alpha_gal, ingredients_1.has_milk AS ingredients_1_has_milk, ingredients_1.has_lactose AS ingredients_1_has_lactose, ingredients_1.has_eggs AS ingredients_1_has_eggs, ingredients_1.has_wheat AS ingredients_1_has_wheat, ingredients_1.is_mollusk AS ingredients_1_is_mollusk, ingredients_1.is_shellfish AS ingredients_1_is_shellfish, ingredients_1.is_beef AS ingredients_1_is_beef, ingredients_1.is_animal_product AS ingredients_1_is_animal_product, ingredients_1.is_pork AS ingredients_1_is_pork, ingredients_1.is_fish AS ingredients_1_is_fish, ingredients_1.is_vegetable AS ingredients_1_is_vegetable, ingredients_1.is_fruit AS ingredients_1_is_fruit, ingredients_1.is_poultry AS ingredients_1_is_poultry, ingredients_1.location_in_house AS ingredients_1_location_in_house, ingredients_1.location_in_store AS ingredients_1_location_in_store, ingredients_1.store_location_id AS ingredients_1_store_location_id, ingredient_nodes_1.upc14 AS ingredient_nodes_1_upc14, ingredient_nodes_1.ndb_no AS ingredient_nodes_1_ndb_no, ingredient_nodes_1.food_group_no AS ingredient_nodes_1_food_group_no, measurement_unit_types_1.id AS measurement_unit_types_1_id, measurement_unit_types_1.NAME AS measurement_unit_types_1_name, measurement_unit_types_1.created AS measurement_unit_types_1_created, measurement_unit_types_1.modified AS measurement_unit_types_1_modified, recipe_ingredients_1.created AS recipe_ingredients_1_created, recipe_ingredients_1.modified AS recipe_ingredients_1_modified, recipe_ingredients_1.recipe_id AS recipe_ingredients_1_recipe_id, recipe_ingredients_1.ingredient_id AS recipe_ingredients_1_ingredient_id, recipe_ingredients_1.measurement_id AS recipe_ingredients_1_measurement_id, recipe_ingredients_1.amount AS recipe_ingredients_1_amount, recipe_ingredients_1.description AS recipe_ingredients_1_description, recipe_ingredients_1.text_order AS recipe_ingredients_1_text_order, recipe_instructions_1.id AS recipe_instructions_1_id, recipe_instructions_1.created AS recipe_instructions_1_created, recipe_instructions_1.modified AS recipe_instructions_1_modified, recipe_instructions_1.recipe_id AS recipe_instructions_1_recipe_id, recipe_instructions_1.step_text AS recipe_instructions_1_step_text, recipe_instructions_1.stage_time_seconds AS recipe_instructions_1_stage_time_seconds, recipe_instructions_1.trice_time_interval_seconds AS recipe_instructions_1_trice_time_interval_seconds, recipe_instructions_1.stand_time_seconds AS recipe_instructions_1_stand_time_seconds, recipe_instructions_1.fbt_status AS recipe_instructions_1_fbt_status, recipe_instructions_1."order" AS recipe_instructions_1_order, recipecoursetypes_1.recipe_id AS recipecoursetypes_1_recipe_id, recipecoursetypes_1.course_type_id AS recipecoursetypes_1_course_type_id, recipecoursetypes_1.number_of_servings AS recipecoursetypes_1_number_of_servings, recipecoursetypes_1.minimum_number_of_servings AS recipecoursetypes_1_minimum_number_of_servings, recipecoursetypes_1.maximum_number_of_servings AS recipecoursetypes_1_maximum_number_of_servings, moods_1.id AS moods_1_id, moods_1.NAME AS moods_1_name, moods_1.created AS moods_1_created, moods_1.modified AS moods_1_modified, tags_1.id AS tags_1_id, tags_1.NAME AS tags_1_name, tags_1.created AS tags_1_created, tags_1.modified AS tags_1_modified, tags_1.tag_group AS tags_1_tag_group, household_recipes_1.created AS household_recipes_1_created, household_recipes_1.modified AS household_recipes_1_modified, household_recipes_1.household_id AS household_recipes_1_household_id, household_recipes_1.recipe_id AS household_recipes_1_recipe_id, household_recipes_1.status AS household_recipes_1_status FROM recipes LEFT OUTER JOIN recipe_authors AS recipe_authors_1 ON recipes.id = recipe_authors_1.recipe_id LEFT OUTER JOIN scanned_photos AS scanned_photos_1 ON recipes.id = scanned_photos_1.recipe_id LEFT OUTER JOIN (recipecookingutensils AS recipecookingutensils_1 JOIN cooking_utensils AS cooking_utensils_1 ON cooking_utensils_1.id = recipecookingutensils_1.utensil_id) ON recipes.id = recipecookingutensils_1.recipe_id LEFT OUTER JOIN (recipecookingappliances AS recipecookingappliances_1 JOIN cooking_appliances AS cooking_appliances_1 ON cooking_appliances_1.id = recipecookingappliances_1.appliance_id) ON recipes.id = recipecookingappliances_1.recipe_id LEFT OUTER JOIN recipe_pictures AS recipe_pictures_1 ON recipes.id = recipe_pictures_1.recipe_id LEFT OUTER JOIN recipe_ingredients AS recipe_ingredients_1 ON recipes.id = recipe_ingredients_1.recipe_id LEFT OUTER JOIN (ingredient_nodes AS ingredient_nodes_1 JOIN ingredients AS ingredients_1 ON ingredient_nodes_1.id = ingredients_1.id) ON ingredients_1.id = recipe_ingredients_1.ingredient_id LEFT OUTER JOIN measurement_unit_types AS measurement_unit_types_1 ON measurement_unit_types_1.id = recipe_ingredients_1.measurement_id LEFT OUTER JOIN recipe_instructions AS recipe_instructions_1 ON recipes.id = recipe_instructions_1.recipe_id LEFT OUTER JOIN recipecoursetypes AS recipecoursetypes_1 ON recipes.id = recipecoursetypes_1.recipe_id LEFT OUTER JOIN (recipemoods AS recipemoods_1 JOIN moods AS moods_1 ON moods_1.id = recipemoods_1.mood_id) ON recipes.id = recipemoods_1.recipe_id LEFT OUTER JOIN (recipetags AS recipetags_1 JOIN tags AS tags_1 ON tags_1.id = recipetags_1.tag_id) ON recipes.id = recipetags_1.recipe_id LEFT OUTER JOIN household_recipes AS household_recipes_1 ON household_recipes_1.recipe_id = recipes.id AND household_recipes_1.status = 0 WHERE recipes.id IN ( 3896191052851256076, 3959961359996963655, 3924443986397073201, 3930170024664549395 ) ORDER BY recipe_authors_1."order", scanned_photos_1.position, recipe_ingredients_1.text_order, recipe_instructions_1."order"