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 ('C4 2318302TX','C9 VAL301409','C4 GDB1404','A9 GDB1531','A2 301409','A1 FDB1073','A3 TEX 2167781','A3 ROA 227015','A1 LP602','A9 21677 203 05','C9 2199003','B1 LUCGDB1404','C4 0986424485','C4 KRO1404','B1 FEB16442','B1 VAL301310','A2 RH 2270.25','A8 205 375','C4 607155','A8 227 287','A2 23183 203 05','C9 23474-20,3','A3 ROA 296300','A1 P06022','A2 23474 203 05','A1 GDB1404','A2 BP06065','C4 05P649','A3 TEX 2199003','A8 218 853','A9 13.04607089.2','B1 ABS37036','A1 GDB1264','A9 LP602','C4 KRO1531','A2 LP602','A1 13.0460-7155.2','A1 16349 FE','C9 GDB1404','A1 2318302 TEX','C4 LP1843','A2 21990 203 05','A1 WBP119','A9 BD S359','A5 165418','C4 LP602','A3 DLP LP1608','A9 0986424485','C4 16442F','B1 LUCGDB1264','A2 0986424485','A5 282151','A1 GDB1577','A1 16217 FE','A9 GDB1264','B1 ATE13.0460-7155','C9 21677-20,3','A2 LP1608','C4 16217F','C9 VAL598811','C9 FDB1073','C9 2347402','A8 201 879','A2 GDB1404','C4 2199003TX','A1 13.0460-7089.2','A2 13.04607089.2','A1 13.0463-7089.2','A9 21990 203 05','B1 FEB16349','A9 13.04607155.2','A3 DLP LP1843','A1 WBP122','E7 216.0','A1 573002J JRD','C9 0986424485','A2 RH 2270.15','C9 VAL301310','A2 05P649','A1 LP1843','A9 RH 2963.00','A5 151842','A2 13.04607155.2','C9 2167703','A9 RH 2270.25','A2 21677 203 05','A2 BD S359','B1 ATE13.0460-7089','A3 ROA 227025','A2 LP1843','A2 GDB1264','A3 TEX 2347402','C9 GDB1577','B7 0270.25/REM','A1 P06065','C9 21677-20,3 EPAD','C9 GDB1531','A1 598409','C9 13.0460-7089.2','B1 FEB16217','C4 LP1608','B1 ABS36998','A9 GDB1404','A1 WBP507','D2 EO FDB1073','A1 0986424485','A3 FER FDB1073','A2 RH 2963.00','C9 VAL598310','C9 GDB1264','A1 GDB1531','B1 BREP06065','B1 BREP06022','B1 VAL301409','A8 230 204','A9 BP06022','A9 23183 203 05','B1 LUCGDB1577','C9 VAL598409','C4 607089','A9 BP06065','C9 21990-20,3','A8 203 506','B7 0270.15/REM','A2 BP06022','A8 241 550','A2 FE FDB1073','B1 ZIM21677.995.1','A8 230 148','A3 TEX 2318302','C9 2318302','A1 LP1608','A5 42594','A3 BOS 0986424485','B1 BOS0986424485','A1 598310','C9 13.0460-7155.2','C4 GDB1531','A5 15240','A3 TEX 2167703','A1 2199003 TEX','A1 16442 FE','A3 DLP LP602','C4 GDB1264','A9 FE FDB1073','B1 LUCGDB1531','C4 FDB1073','C9 23183-20,3','A5 18293','C4 2167703TX','A2 GDB1531','A1 571880JC JRD','A1 13.0470-7089.2','A1 P06043','A1 P06043X','A2 23183.195.1','A2 23183.995.1','A2 BP06043','A2 Q109-1096','A2 QWS0163A','A2 QWS0199A','A2 QWS0244A','A3 CIF 822-207-0','A3 QUI 109-1096','A3 QUI 109-1224','A3 QUI 109-1702','A3 QUI WS0163A','A3 QUI WS0199A','A3 QUI WS0244A','A5 282323','A8 236 681','A8 524 154','A9 13.04707089.2','A9 BP06043','A9 D4-2961A','A9 GDB1404DTE','A9 GDB1531DTE','A9 Q109-1096','A9 Q109-1702','A9 QWS0163A','A9 QWS0199A','A9 QWS0244A','B1 ABS37374','B1 ATE13.0470-7089','B1 BREP06043','B1 BREP06043X','B1 KAMJQ1012146','B1 LUCGDB1404DTE','B1 LUCGDB1531DTE','B1 QB109-1096','B1 QBWS0163A','B1 QBWS0199A','B1 QBWS0244A','B1 ZIM21677.195.1','B1 ZIM21677.195.2','B1 ZIM23183.195.1','B1 ZIM23183.195.9','B1 ZIM23183.995.1','B7 0963.00/REM','B7 21677.195.1','B7 21677.195.2','B7 23183.195.1','B7 B110072/DKM','B7 B111110/DKM','C4 05P1251','C4 21677.195.1','C4 23183.195.1','C4 GDB1531DTE','C4 LD7089','C9 0252167720','C9 0252167720/PD','C9 0252199020','C9 0252199020/PD','C9 0252318320','C9 0252318320/PD','C9 13.0470-7089.2','C9 19-0635','C9 21677 00 701 00','C9 23183 00 701 00','C9 D42961A','C9 GDB1404DTE','C9 GDB1531DTE','C9 QB109-1096','C9 QB109-1702','C9 QBWS 0199 A','C9 QP5211','C9 QP5211C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #