Query to Check Transactions Earlier than the Opening Date

Below are the Queries on How to Check Transactions Earlier than the Opening Date on MySQL yog, if Delete Transactions[Posted from Other Modules] is showing Empty

1)

SELECT * FROM JOURNAL1 WHERE D_ATE <= '2016/12/31' AND FINCATCODE NOT IN ('B55','B70');

2)

SELECT * FROM journal1 WHERE D_ATE <= '2016/12/31' AND acountcode = 'xxx';