#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 ('C4 A2C59512895','B1 PIE7.22184.40.0','A3 INT 19654','C9 AMMQ19719','A1 7.22184.40','A3 MAR 213719666010','A9 SI A2C59512895','A9 DEN DMA-0202','A3 PIE 7.22184.40','B1 DELAF10173-12B1','C9 AMM19666','C9 AMMQ19689','C9 7.22184.40.0','B1 DENDMA-0202','A2 DEN DMA-0202','A1 MA-B110 MB','A3 DEN DMA-0202','B1 MMAAMMQ19719','A3 MAR 213719719019','C9 HIT2505029','A8 356 951','A2 7.22184.40.0','B1 HUC135029','A1 MF014 ER','A1 135029','C9 AF10173-12B1','A3 DLP AF1017312B1','B1 HEL8ET 009 142-251','A3 BRE 30099','C9 8ET009142-251','B1 HIT2505029','B1 MMAAMMQ19689','A3 PIE 7.22184.40.0','A1 213719719019','A2 AF10173-12B1','A3 HEL 8ET 009 142-251','A9 7.22184.40.0','C4 AF10173-12B1','A2 SI A2C59512895','A2 8ET009142-251','A1 8ET 009 142-251','A1 AF10173-12B1','B1 VAL366319','A1 DMA-0202','A1 A2C59512895','A3 ERA 558014','A3 MAR 213719689019','B1 VDOA2C59512895','C4 DMA-0202','A2 ERA 558014A','A8 379 984','C9 BRE30099','A8 557 406','B1 HP111 048','C4 86043MD','C9 FS-230')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#