SELECT * FROM `0p4_gl_transaction` WHERE document_type!="CHARTACCOUNT" and created_by =1 and `date`<'2020-01-01-00:00'
order by date desc
limit 100
