#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr
FROM cikk_tecdoc
LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam)
WHERE
((cikk_tecdoc.cikkszam IN ('B1 KAM7200019','B1 ELCZR AD711 L','A1 490033 ER','C4 01.7441','A3 ERA 490033','A9 850850','B1 KAM7200197','A8 176 935','A2 850850','A3 TRU 07.54.023','B1 VAI10-6289','C9 AC969','B1 MMAACQ0081','A3 VAC V10-6289','C9 50-0429','A3 MAR 350103969000','C4 2160186','C9 01.7441','B1 SKV01SKV393','B1 VNW0325263','A2 VWL0325263','A8 180 076','C4 850850V','C6 017016','A1 350103170081','A3 VAL 850850','B1 TRU07.54.023','A9 VWL0325263','B1 VAL850850')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#