Help With MySQL Queries within PHP Product DataFeed

IMPORTANT NOTES & PREREQUISITES Freelancers responding with a ""canned"" / ""default"" reply to our postings will not be considered for the job. If you are serious about being considered for this job and others, ensure your response is specific to our job post. If you do a good job with this first project, we have many others that we need help (PHP and MySQL) with and we really want to find a freelancer to hire as an extended part of our team. GREAT communication skills and responsiveness is mandatory. We always provide bonuses to freelancers who ensure the job is... 1) completed on time 2) completed per our specifications. 3) completed with exceptional quality. 4) performed while ensuring active and effective communication. Any delays in communication will highly jeopardize consideration of a bonus payment." PROJECT DESCRIPTION We already have a functioning PHP that builds our product datafeed export file and subsequently FTPs the file to the targeted destination. The datafeed works very well. However, we have added new data fields within our MySQL database for the products we sell. Due to my lack of skill in writing effective MySQL "join" queries, We require help modifying the existing SQL within the datafeed PHP to properly pull these values from the new fields for each product within our datafeed. Within the attachment summary below, I have include details regarding the objectives. Thse details provide an example of the new product data fields that must be included within the datafeed. I have provided the table names and field/column names. I also included a snippet of the current SQL utilized within the datafeed. This job is solely to assist us with writing and incorporating the additional / modified SQL required to pull the new product attributes into the datafeed. We are looking to build a new datafeed and we are NOT going to redesign or otherwise modify the datafeed. It is extremely important to be clear that this job is only for help with improving the current datafeed.