Advand | Autóalkatrész webáruház és autóápolás

#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 ('C9 0252379420/PD','A2 13.04607176.2','B7 1052.00/REM','A9 BP06057','C9 13.0460-7176.2','E1 20 91 6503','C4 16503F','C9 23794-20,3','C9 0986424822','A5 57792','A1 13.0470-7176.2','A1 P06057','A8 221 250','A2 13.04607216.2','B1 ZIM23793.200.9','A5 139951','A1 FDB1773','C4 05P1512','D2 EO FDB1628','A9 FE FDB1628','A2 0986494118','C4 LD7176','A1 13.0470-7216.2','A5 130790','B7 23793.200.9','A5 73229','A2 FE FDB1773','A9 13.04607176.2','C9 GDB1559DTE','A8 228 208','C9 23793-20,3 EPAD','A2 05P1271','C9 13.0460-7216.2','B1 VAI20-8126','A1 573364JC JRD','B1 ZIM23793.200.2','B1 ZIM23794.200.9','C4 0986494118','C9 221527','A9 13.04607216.2','A1 573187JC JRD','C4 08.34.110','C9 FDB1628','A3 FER FDB1628','A2 BP06036','C4 23794.200.1','A3 BOS 0986494118','C4 23793.200.1','C4 607216','B7 23793.200.1','A1 573151JC JRD','C4 GDB1559DTE','C9 23793-20,3','B7 23794.200.2','A5 206940','A2 BP06057','C4 2379301TX','A2 05P1512','B1 BREP06036','A3 VAC V20-8126','C9 ADB114205','A5 48895','B1 ZIM23794.200.2','C9 13.0470-7216.2','A2 23794.200.9','B1 ABS37409','C4 2379401TX','B1 TRU08.34.110','B7 23794.200.1','C4 LD7216','A9 T 2379481','A2 ADB114205','A1 0986494118','B1 ATE13.0470-7176','A1 WBP558','A3 TEX 2379481','C9 2379301','A9 GDB1559DTE','A9 13.04707216.2','A3 TEX 2379301','A3 VAC V20-8118','A8 227 340','A1 0986424822','A3 DLP LP1956','B7 23794.200.9','A5 73076','C4 23794.200.9','B1 ATE13.0470-7216','C9 0252379420','A9 23794.200.9','B1 LUCGDB1559DTE','A9 23794 203 05','A3 TRU 08.34.110','B1 VAI20-8118','A2 T 2379481','C4 05P1271','B1 ZIM23793.200.1','A9 BP06036','C9 VAL598640','A9 T 2379301','C9 FDB1773','A1 P06036','A2 T 2379301','A1 16503 FE','B7 23793.200.2','A2 23794 203 05','C4 LP1956','A3 TEX 2379401','A2 T 2379381','B1 ATE13.0460-7216','C4 FDB1628','A2 13.04707176.2','E7 AC0581512D','A2 LP1956','A1 2379401 TEX','C9 23794-20,3 EPAD','A1 GDB1559DTE','C4 607176','C9 0986494118','A9 13.04707176.2','C9 VAL301640','B1 BLPADB114205','A2 FE FDB1628','A3 TEX 2379381','B1 ATE13.0460-7176','A2 13.04707216.2','D1 BP ADB114205','A9 0986494118','B1 FEB16503','A8 224 631','B1 BOS0986494118','A3 FER FDB1773','C9 13.0470-7176.2','B1 VAL301640','A1 LP1956','B1 BREP06057','A1 FDB1628','B1 ZIM23794.200.1','A8 234 087','C4 FDB1773','C9 2379381','A1 598640','A2 GDB1559DTE','A1 13.0460-7176.2','A1 13.0460-7216.2','C9 2379401','C9 0252409620','A9 ADB114205','A2 RH 21052.00','A3 ROA 2105200','A1 13.0460-7268.2','A1 P06036X','A1 P06057X','A2 13.04607268.2','A2 Q109-1751','A2 QWS0218A','A2 QWS0224A','A2 QWS0259A','A2 QWS0289A','A2 QWS0317A','A3 CIF 822-557-0','A3 QUI 109-1751','A3 QUI WS0218A','A3 QUI WS0224A','A3 QUI WS0259A','A3 QUI WS0289A','A3 QUI WS0294A','A3 QUI WS0317A','A5 119322','A5 194856','A5 348443','A8 524 100','A8 524 102','A8 524 105','A8 524 166','A8 562 880','A9 13.04607268.2','A9 Q109-1751','A9 QWS0218A','A9 QWS0224A','A9 QWS0259A','A9 QWS0289A','A9 QWS0292A','A9 QWS0317A','A9 RH 21052.00','B1 ATE13.0460-7268','B1 ATE13.0470-7268','B1 BLPADBP420025','B1 BREP06036X','B1 BREP06057X','B1 CIF822-557-0','B1 FEB16670','B1 KAMJQ1013546','B1 QB109-1751','B1 QBWS0218A','B1 QBWS0224A','B1 QBWS0259A','B1 QBWS0289A','B1 QBWS0317A','B1 ZIM23793.900.1','B7 B110982/DKM','B7 B111228/DKM','C4 1170078','C4 16670F','C4 607268','C4 LD7268','C9 13.0460-7268.2','C9 13.0470-7268.2','C9 19-0637','C9 23794 00 701 00','C9 QB109-1751','C9 QBWS 0218 A','C9 QBWS 0259 A','C9 QBWS 0286 A','C9 QBWS 0289 A','C9 QBWS 0292 A','C9 QBWS 0294 A','C9 QP0556','C9 QP0556C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #