SQL stored procedure bug fixing

***************
You must be an EXPERIENCED specialist in SQL stored procedures.
***************

Database is MySQL

Areas:
1. create a conversion script that can search one column for a value and then read what that value us comparable to

2. search function P can not find values if we use single product search. If we use a similar search we can find the error. So single search product is doing something wrong.

3. search function L that is based on the above can not deliver all products. ITG is likely a knock on error of point 2 above.

4. create a virtual script L-ALLthat use search script L and A AND/OR possibly also P. It should simply call script L first, based on this script it should then do For X=1 to N do .... Next

5. create a virtual script C-ALL that use search script L and A AND/OR possibly also P. It should simply call script L first, based on this script it should then do For X=1 to N do .... Next

This job can all be done within one day if you are experienced.

Your experience
- SQL script 10+ years
- MySQL, Oracle MSSQL, 10 years