objects (view) pieprasījums:
---------
SELECT
  od_base.id_object AS id,
  CONCAT_WS(
    ' - ',
    if (ad1.Iname = 'IKI', "Rīgas", ad1.Iname),
    ad2.Iname,
    ad3.Iname,
    ad4.Iname
  ) AS name
FROM object_id AS od_base
LEFT JOIN object_id AS od1 
  ON od_base.id_object = od1.id_object AND od1.direction = 1
LEFT JOIN object_id AS od2 
  ON od_base.id_object = od2.id_object AND od2.direction = 2
LEFT JOIN object_id AS od3 
  ON od_base.id_object = od3.id_object AND od3.direction = 3
LEFT JOIN object_id AS od4 
  ON od_base.id_object = od4.id_object AND od4.direction = 4
LEFT JOIN `address (table)` AS ad1 ON od1.id_address = ad1.id
LEFT JOIN `address (table)` AS ad2 ON od2.id_address = ad2.id
LEFT JOIN `address (table)` AS ad3 ON od3.id_address = ad3.id
LEFT JOIN `address (table)` AS ad4 ON od4.id_address = ad4.id
GROUP BY od_base.id_object
ORDER BY od_base.id_object;

----------------------------
metter_consum (view) pieprasījums:
------------
SELECT 
o.id,
 o.name, 
 concat(
 	trim(mm.ch),
	LPAD( 
		mm.number,
		mm.len-LENGTH(trim(mm.ch)),
		0
	)
 ) AS number
FROM objects AS o
LEFT JOIN metter_acounting AS ma
	ON ma.id_object = o.id
RIGHT JOIN metter_metter AS mm
	ON ma.number = mm.number

ORDER BY o.id

---------------------------------