select Table4000.* from Table250 
       
       inner join Table4000  
          on Table250.Field1 = Table4000.Field1 
                 WHERE 
                            (lower(Table4000.Field1) LIKE '%а%') 
                              OR 
							 (
                                      (lower(Table4000.Field2) LIKE '%а%') OR
                                      (lower(Table4000.Field3) LIKE '%а%') OR 
                                      (lower(Table4000.Field4) LIKE '%а%') OR 
                                      (lower(Table4000.Field5) LIKE '%а%') OR 
                                      (lower(Table4000.Field6) LIKE '%а%') OR                                       
                                      (lower(Table4000.Field7) LIKE '%а%') OR 
                                      (lower(Table250.Filed2) LIKE '%а%') OR 
                                      (lower(Table250.Field3) LIKE '%а%') 
                           ) 
                             
                 
                             AND 
                             lower(Table4000.Field1) != 'а' 
                             order by Table4000.Field8 LIMIT 10