select Firm_Address.id, Firm_Address.firmId, Firm_Address.addressId, Firm_Address.phones, Firm_Address.info,
  Firm_Address.workingHours, Firm_Address.position, Firm_Address.updateDate, Firm_Address.updateUserId, Address_Address.house as house,
  Address_Address.description as houseInfo, Address_Street.title as streetTitle, Address_Street.oldTitle as streetOldTitle,
  Address_Street.type as streetType, Address_District.title as districtTitle, Address_City.title as cityTitle, Firm.title as firmTitle,
  Firm.keywords as firmKeywords, Firm.pay as firmPay
from
 Firm_Address
inner join
 Address_Address on Firm_Address.addressId = Address_Address.id 
inner join
 Address_Street on Address_Address.streetId = Address_Street.id 
left join
 Address_District on Address_Street.districtId = Address_District.id 
inner join
 Address_City on Address_Street.cityId = Address_City.id 
inner join
 Firm on Firm.id = Firm_Address.firmId 
inner join
 Firm_Profile on Firm_Profile.firmId = Firm.id 
where
  (Address_City.title like ?
  or Address_Street.title like ?
  or Address_Street.oldTitle like ?
  or Address_District.title like ?
  or Address_Address.house like ?
  or Address_Address.description like ?
  or Firm_Address.phones like ?
  or Firm_Address.info like ?
  or Firm_Address.workingHours like ?)
  and Firm_Profile.descriptionHelp like ?
  and Firm_Profile.onHelp = ?
  and Firm.onHelp = ?
order by Firm.pay desc, Firm.title asc