SELECT i.id,i.number,i._date,i.brutto,i.tara,a.auth,
	(IF(ic1.ai!=ic2.ai,2,1)) AS libra,
	ic1.brutto AS brutto1,ic1.tara AS tara1,
    ic2.brutto AS brutto2,ic2.tara AS tara2,  
    ic._date AS rmdate,ar.auth AS rmauth,
    CONCAT(ii.org,' (',ii.culture,')[',ii.car_number,'] ',ii.info) AS info
FROM _inv AS i
LEFT JOIN _adm AS a ON i.adm=a.id
LEFT JOIN _inv_change AS ic1 ON ic1.ai=(
    SELECT MIN(ic.ai) FROM _inv_change AS ic WHERE ic.id=i.id
    AND ic.type='libra'
	)
LEFT JOIN _inv_change AS ic2 ON ic2.ai=(
    SELECT MAX(ic.ai) FROM _inv_change AS ic WHERE ic.id=i.id
    AND ic.type='libra'
	)
LEFT JOIN _inv_change AS ic ON ic.id=i.id AND ic.type='remove'
LEFT JOIN _adm AS ar ON ic.adm=ar.id
LEFT JOIN _inv_info AS ii ON ii.id=i.id
WHERE i.visible=-1 
ORDER BY i._date DESC

LEFT JOIN _inv_change AS ic1 ON ic1.ai=(
    SELECT MIN(ic.ai) FROM _inv_change AS ic WHERE ic.id=i.id
    AND ic.type='libra'
	)

LEFT JOIN _inv_change AS ic2 ON ic2.ai=(
    SELECT MAX(ic.ai) FROM _inv_change AS ic WHERE ic.id=i.id
    AND ic.type='libra'
	)

LEFT JOIN _inv_change AS ic1 ON ic1.id=i.id AND ic.type='libra'