ABillS

SELECT
sia.id,
CONCAT AS name,
SUM AS count,
SUM AS discard_count,
SUM AS accountability_count,
SUM AS reserve_count,
SUM AS installation_count,
SUM AS inner_use_count,
(SUM) +
SUM) +
SUM) +
SUM) +
SUM)) AS total_count,
sia.article_id,
sm.name as measure_name,
sia.main_article_id as main_article_id
FROM storage_incoming_articles sia
LEFT JOIN storage_articles sa ON (sa.id = sia.article_id)
LEFT JOIN storage_article_types sat ON (sat.id = sa.article_type)
LEFT JOIN storage_discard sd ON (sd.storage_incoming_articles_id = sia.id)
LEFT JOIN storage_accountability sac ON (sac.storage_incoming_articles_id = sia.id)
LEFT JOIN storage_reserve sr ON (sr.storage_incoming_articles_id = sia.id)
LEFT JOIN storage_inner_use siu ON (siu.storage_incoming_articles_id = sia.id)
LEFT JOIN storage_installation sin ON (sin.storage_incoming_articles_id = sia.id)
LEFT JOIN storage_measure sm ON (sm.id = sa.measure)
LEFT JOIN storage_incoming si ON (si.id = sia.storage_incoming_id)
and si.date >= '2019-08-09 00:00:00' and si.date <= '2019-08-09 00:00:00' and si.domain_id=0
GROUP BY sia.article_id
ORDER BY 1 ;