select a.* , b.B1, b.B2, b.B3 , b.B4 as B44 , b.B5 as B55 from 테이블1번 a
left join 테이블2번 b
on (a.A = b.B1 and b.3 like '2022-11-27%' and b.2 = 'KKKKK' and b.4 = '444')
and adatetime > now()
and now() > DATE_ADD(cdatetime, interval 600 SECOND)
and (
(eng = 'thecitizne' and scnt <= '1500')
OR
(eng = 'thecitizeneng' and scnt <='3000')
)
and b.B3 is NULL
order by cdatetime asc limit 0, 1