Ali Honarmand ahonarmand-zz

## fix_ignored_and_unignored_accounts.sql
-- ----------------------- Ledger Balance for both ignored and unignored---------------
delete from ledger_balance_event where id in
(
	select distinct lbe.id
	from ledger_balance_event lbe
	inner join ledger_balance lb on lbe.id = lb.id and lb.status <> 'REFERENCE'
	where lb.ledger_id in (<ignored_accounts,unignored_accounts>)
);


## README.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                ahonarmand-zz
                / README.md
            
            
              Created
              March 30, 2018 19:19
                — forked from hofmannsven/README.md
            
              
                My simply Git Cheatsheet
              
          
    Using Git

Global Settings

Related Setup: https://gist.github.com/hofmannsven/6814278
Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/
	-- ----------------------- Ledger Balance for both ignored and unignored---------------
	delete from ledger_balance_event where id in
	(
	select distinct lbe.id
	from ledger_balance_event lbe
	inner join ledger_balance lb on lbe.id = lb.id and lb.status <> 'REFERENCE'
	where lb.ledger_id in (<ignored_accounts,unignored_accounts>)
	);