Link Multi-Where

ex.sql

select *
from (
  select *
  from carModels as t1,
       carMakes  as t2
  where t1.somePKId = t2.someFKId
    and (
         t1.Name like '%c%'
      or t2.Name like '%c%'
    )
  limit 0, 25 
)
where t1.Name like '%honda%'
   or t2.Name like '%honda%'
limit 0, 25;