mad wss issue

select  wss.subject_id , wsss.subjectCode as wssSubjectCode, os.id as correctId,  os.subjectCode as subjectCode ,
if(wsss.subjectCode = os.subjectCode , 'YES', 'NO' ) as result,
if(wsss.id = os.id , 'YES', 'NO' ) as idresult,
os.level as correctSubjectLevel,
wsss.level as wsssSubjectLevel

from commons_worknode_db.worknode_slot_shift wss
join ltlddb.sclevelbatch sclb on wss.for_entity_id = sclb.id
join ltlddb.sclevel scl on sclb.SCLevelId = scl.id
left join ltlddb.subjects s on s.level= scl.level and s.id = wss.subject_id
left join ltlddb.subjects wsss on wss.subject_id = wsss.id
left join ltlddb.subjects os on wsss.subjectCode=  os.subjectCode and os.level= scl.level;