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 ('B1 ZIM23599.990.1','A3 DLP LP1679','A2 GDB1463','A3 BOS 0986494027','A1 0986495051','B1 BREP61066X','B1 TOM1327','A2 GDB1563','A1 0986494270','A1 WBP317','C9 VAL301464','B1 CIF822-327-0','A2 FE FSL1399','A3 CIF 822-327-0','A2 RH 2840.20','A5 70978','A2 0986495051','C4 05P1327','C4 2410101TX','B1 ZIM23954.190.1','A1 WBP514','A1 FDB4066','C9 2410101','C4 FDB4066','A5 282168','C9 19-0574','C9 13.0460-3994.2','B7 0840.30/REM','B1 ATE13.0470-3994','A2 FE FDB4066','A3 BOS 0986494270','B1 BLPADP154202','A3 BOS 0986495051','B7 B110851/DKM','A9 0986494027','C4 LP1727','A5 319304','C4 23954.190.1','A2 FE FDB1399','A2 BD S842P','A1 GDB1623','C9 GDB1463','A8 230 405','B1 LUCGDB1677','D1 BP ADP154202','A9 GDB1623','A9 24101 190 14','A2 RH 2840.30','A5 274075','A9 05P802','C9 0986494623','B1 FRE901218','A3 VAC V22-0083','A1 FDB1399','C9 FDB4066','A3 DLP LP1727','A2 24101 190 14','A1 0986494027','A2 05P1327','C9 0252359919','A1 GDB1563','A1 0986424571','A8 227 513','A5 118394','C9 GDB1563','A3 TEX 2359901','C4 GDB1463','A2 0986494027','A8 230 482','C9 QP2989C','A1 GDB1462','A5 170161','A1 P61066','B1 KAMJQ1012798','B7 23599.190.2','A3 ROA 284030','A1 GDB1582','A2 13.04603994.2','B7 0840.10/REM','A5 77334','C9 VAL598464','A1 573030J JRD','A1 FSL1399','A5 50071','C4 GDB1463DTE','A3 ROA 284010','C4 23599.190.1','A3 FER FDB1399','A9 GDB1463','A3 TEX 2395401','A1 13.0460-3994.2','A1 P61066X','B1 LUCGDB1463BTE','A9 FE FDB4066','C9 GDB1463DTE','A1 WBP400','C9 PA-0051AF','A9 RH 2840.30','B7 0840.20/REM','A1 GDB1677','A9 23954 190 14','A9 BD S842P','A8 217 762','A9 GDB1677','B1 ZIM23599.190.2','A3 JAP PA-0051AF','A5 357200','C4 GDB1677','A2 GDB1463DTE','B1 LUCGDB1563','C9 23599 00 701 00','A2 LP1727','C9 23954-19,0','B1 TOM1464','A2 0986494623','A2 05P1188','A1 LP1679','A2 BP61066','C4 2395401TX','C4 603994','B1 VAI22-0083','A3 FER FDB4066','B7 23599.190.1','A1 GDB1463DTE','B7 23954.190.1','A8 236 864','C4 23599.190.2','B1 BOS0986494027','C9 QP2989','A2 05P802','B7 B110131/DKM','C9 GDB1623','A9 BP61066','C9 GDB1677','C9 24101-19,0','B1 ATE13.0460-3994','C4 GDB1563','B1 ZIM23599.190.1','A8 217 303','C9 PF0170','A9 13.04603994.2','B1 ABS37272','B1 LUCGDB1463DTE','C4 KRO1463','C4 05P1188','A8 234 067','B1 BREP61066','B1 VAL301464','A9 GDB1563','A3 ROA 284020','C9 VAL872599','A1 598464','A3 TEX 2410101','A2 GDB1623','A2 23954 190 14','A1 LP1727','C4 0986494027','C9 ADP154202','B1 LUCGDB1463','A5 116571','B7 GDB1463_TRW/AG','A8 230 172','A8 227 324','A1 GDB1463','C9 2395401','C9 0252359919/PD','E1 62 91 6432','B1 LUCGDB1623','A9 GDB1463DTE','C9 0986494027','A8 207 194','B1 BOS0986494623','A2 GDB1677','A1 FDB1399-PROMO','A2 RH 2840.10','C4 05P802','C4 FSL4066','E3 23599.190.1','C9 13.0470-3994.2','A9 RH 2840.20','A1 13.0470-3994.2','A1 GDB1521','A8 230 201','A9 GDB1521','B1 LUCGDB1521','B1 VAL301570','C4 GDB1521','C4 KRO1521','C9 GDB1521')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #