select legal.sub_number, legal.sub_name, legal.sub_address, legal.sub_code,
       contract.region, contract.contract_num, contract.contract_name,
       contract.date_of_contract, contract.contact_information, contract.unn,
       contract.street, contract.dwelling, contract.building, contract.apartment,
       contract.telephone, contract.date_edited,
       electric.contract_value, power.contract_value as contract_val
from core_consumers_legal legal
       join core_consumerslegalcontract contract
                 on (legal.region = contract.region and
                     legal.contract_num = contract.contract_num)
       join core_contractualwithelectricityvaladjustments electric
                 on (legal.region = electric.region and
                     legal.contract_num = electric.contract_num)
       join core_contractualwithpowervaladjustments power
                 on (legal.region = power.region and
                     legal.contract_num = power.contract_num)
 ORDER BY region ASC
LIMIT 10 OFFSET 0