CREATE VIEW dbo.ETIKETSIZ_MALZEME_LISTESI
AS
SELECT ITM.LOGICALREF, ITM.CODE, CONCAT(ITM.[NAME],ITM.NAME3) AS [NAME],
--CONCAT(XT.ETIKET_ACIKLAMA, CONCAT(' ', XT.MODEL_BILGI)) AS [ESDEGER],
XT.ETIKET_ACIKLAMA, XT.MODEL_BILGI 
FROM LG_011_ITEMS AS ITM 
LEFT OUTER JOIN LG_XT1001_011  AS XT ON XT.PARLOGREF = ITM.LOGICALREF 
WHERE ITM.ACTIVE=0 AND ITM.[NAME]<>'' AND LOGICALREF NOT IN(4,22952,13212,
13213,
13214,22962,22937,
22939,
22940,
22942,
22944,
22945,23168,
23237,
23343,
23344,
23347,
23348,
23349,
23386,23451,
23452,
23585,
23586,
23587,
27802,
27803,
27804,
27805,
27806,
27807,
27808,
27809,
27810,
27811,
27812,
27813,
27814,
27973,
27974,
27975,
27976,27991,22993,
22995,
28847,22950,
22966,
22973,
28271,
28846,
29123,22963,
22967,29599,
29601,
29608,
29610,
29615,
29617,29599,
29601,
29608,
29610,
29615,
29617,22970,22936,29603,
29604,
29605,
29606,
29619,
29620,29593,
29594,
29595,
29596,
29597,
29598,
29600,
29602,
29607,
29609,
29611,
29612,
29613,
29614,
29616,
29618,
29621,29377,
27977) AND (XT.ETIKET_ACIKLAMA='' OR XT.ETIKET_ACIKLAMA IS NULL)