Complicated WordPress Database / Template Fix

NO MILESTONE WILL BE PAID. FULL PAYMENT IMMEDIATELY ON COMPLETION. YOU MUST ACCEPT HIRE BEFORE WE PROVIDE SERVER ACCESS. FREELANCERS ONLY, NO TEAMS. !!! You will not be hired if you are not HIGHLY skilled in mySQL, PHP and WordPress. If you have not built numerous WordPress plugins and themes, you will not be able to do this project. We will check all your WordPress related feedbacks and the job postings. !!! You will not be hired if you do not have a 5 star rating and have completed over 25 jobs on Freelancer, with a good number of WordPress complexities. !!! You will not be hired if you are not ready to work immediately. *************************************************************** This website is a complicated mess. It is a client website that has numerous issues. You will be hired to fix a specific issue: a. There is a custom post type that has its own table to store its data. b. There is a template that displays this data, by pulling it from the database based on specific criteria. c. Then, something happened, and the custom post type started putting all its new posts in wp_posts and wp_postmeta tables, instead of the custom post type's table. So now when you create and publish a new one of these custom post types, it gets added to the wrong tables, and does not display in the template, while the older posts are still in the correct custom table. Your job: 1. export the incorrect wp_post/wp_postmeta posts that are showing in the custom post type index 2. convert them to to the custom post type 3. import them to the custom post type table 4. fix the save/edit function of this custom post type so that it saves to the correct table I will know immediately if you do not know what you are doing, and will terminate the contract immediately. We have had 4 developers say they can fix, taken deposits, and then not been able to fix. Again, DO NOT APPLY IF YOU ARE NOT AN EXPERT.