Write a mysql query for me

CLOSED
Bids
25
Avg Bid (USD)
$39
Project Budget (USD)
$30 - $250

Project Description:
Hello,

I'm looking for someone who can write a mysql query for me.

I'm developing a recipe site and am looking for a way to select recipes from a database and order them based on how many of the recipe's ingredients match the ingredients of the user's pantry table.

I have four tables in my database

recipes
id, name, prep_time

ingredient_types (static list of all ingredients in the world)
id, type

ingredients (for each recipe posted a record is created for the ingredient needed)
id, ingredient_type_id, recipe_id

pantry (a table containing records of each ingredient a user has at home)
id, ingredient_type_id


I was hoping to pull recipe data using fulltext search and in the same query check how many matches each ingredient of the recipe has to the user's pantry table and then order the output of the recipe data based on the number of ingredient matches.

Query must be

Thanks,

Skills required:
Data Processing, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.