How come the results are different between demo site and my script

[richardlingmei]

Following SQL was parsed pretty well on the demo site. it shows 2 tables (cad.verint_trspt_meta_v, nacccmis.all_vq_to_lob).
However, when I ran the python code with v2.16 sql-metadata, it shows 4 tables. In addition to the two above, it adds len and a.cd33 as 2 tables.

Is the demo site using a better version? thanks,

select b.lob,audio_strt_gmt_tm,cstm_data_18,txn_id,audio_strt_tm,cont_id,trsb_rule_nm,call_seg_ord_nbr
from cad.verint_trspt_meta_v as a
left outer join nacccmis.all_vq_to_lob as b on lower(a.cd33) = lower(left(b.presentation_name,len(a.cd33)))
where trsb_rule_nm = 'usa_call_types_sai_5'
and lob = 'icc' and(txn_id like '202401%')
and cast(substring(txn_id,7,2) as integer) >= 1
and cast(substring(txn_id,7,2) as integer) < 2