https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=%D0%9F%D1%80%D0%B8%D0%BC%D0%B5%D1%80Пример - История изменений2026-07-17T03:16:15ZИстория изменений этой страницы в викиMediaWiki 1.19.16https://gsbelarus.com:80/gs/wiki/index.php?title=%D0%9F%D1%80%D0%B8%D0%BC%D0%B5%D1%80&diff=1625&oldid=prevSYSDBA в 12:18, 7 января 20072007-01-07T12:18:53Z<p></p>
<p><b>Новая страница</b></p><div><br />
SELECT<br />
SUM(m.debit) as Debit, SUM(m.credit) as Credit<br />
FROM gd_contact con<br />
JOIN gd_contact con1 ON con1.LB >= con.LB AND con1.RB <= con.RB<br />
JOIN inv_movement m ON con1.ID = m.contactkey<br />
LEFT JOIN gd_document doc ON m.documentkey = doc.ID<br />
LEFT JOIN inv_card c ON m.cardkey = c.ID<br />
WHERE<br />
con.ID = 147146594<br />
AND m.movementdate >= '01.01.2006'<br />
AND m.movementdate <= '03.01.2007'<br />
AND c.goodkey = 148132903<br />
and doc.documenttypekey <> 147063932<br />
and (not doc.documenttypekey in (147596827, 147596870, 147596935, 148044102, 147017884))</div>SYSDBA