Correct sql query written for mysql to do the same faster (optimization)

Dear Sir we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by replying.. hope to hear you soon.. -- Thanks & Regards Moumita

dear sir. How are you. I have read your job description. and took an interest in your work. I have a experience of website designing and developing for 4 years. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful I ll complete all of your requirements - I ll do more tweaks for you as well Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details Looking forward to hear from you. Best Regards

I saw queries and I think need create index in field it.f_category and in field that participate in joins.

A proposal has not yet been provided

Hi! I'm an experienced DBA and I can clearly see the problem in your queries. (You can see I just got 93% on my first SQL course on here!) Of course I also know a solution. I can likely finish this in 2-3 hours but because we'll need to communicate back and forth I set the completion time as longer just in case. Cheers, Dorlan

I saw the code in your sql queries and i think it could be a lot better . You have unnecessary joins and very bad 'where' part. You just need to give me some additional information. Contact me Goce

Hi, I am a Microsoft Certified Engineer with 8 years of work experience and expertise in optimization. This is a search type query. I have done this before and have a technique of short circuit OR to optimize this :) Thanks Ankit