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 ('A2 LP1733','A1 13.0460-2873.2','A1 598482','A9 13.04602872.2','B1 LUCGDB1369','A9 RH 2767.00','C4 602874','A8 236 866','A9 BP85059','C4 2322416TX','B1 BOS0986494529','C9 2344605','A2 23446 165 15','A2 LP1511','A2 13.04602874.2','C9 13.0460-2874.2','B1 ATE13.0460-2872','B1 ZIM23224.165.2','B1 LUCGDB1326','A2 RH 2767.00','B7 23446.165.2','A1 0986494529','A1 P85059','A3 BOS 0986494529','A9 13.04602874.2','B1 VAL301650','A2 FE FDB1482','C9 GDB1369','C4 KRO1369','A2 RH 2591.12','A2 0986494051','A5 443697','A2 BP85059','A8 249 643','A1 FDB1482','A8 230 113','C4 23224.165.2','A3 ROA 276701','C4 0986494051','B7 0767.10/REM','B7 23224.165.3','A9 0986494051','C9 0986494619','A2 GDB1325','A1 LP1511','A5 73634','A3 TEX 2322416','C4 23446.165.1','B1 VAL301681','A2 GDB1369','A1 GDB1369','C4 2344605TX','C9 23224-17,3 1 5','A9 23224 173 15','A1 16382 FE','A3 ROA 259112','B1 BREP85046','A9 GDB1325','C4 GDB1325','B7 0767.01/REM','C9 VAL301681','A2 LP2019','C9 0986494529','A1 WBP393','B1 ABS37110','C9 GDB1325','C4 602872','C9 0986494051','A1 2322416 TEX','A8 206 599','A8 216 284','C9 13.0460-2872.2','A1 GDB1325','C4 LP1511','C4 GDB1369','A2 GDB1326','A3 DLP LP1511','A8 230 131','A3 DLP LP1733','A3 ROA 276782','A1 LP2019','A1 LP1541','C9 VAL301482','C4 FDB1482','B1 FEB16412','C9 VAL301650','C9 VAL598650','C9 VAL598482','D2 EO GDB1326','B1 FEB16382','A3 ROA 276700','A3 ROA 276712','B1 BREP85059','A1 LP1733','C9 VAL598681','A2 13.04602872.2','C4 GDB1326','A3 DLP LP2019','A1 13.0460-2874.2','A3 TRW GDB1369','A5 78026','B7 23224.165.2','B1 BOS0986494619','A9 23446 165 15','A3 BOS 0986494051','B1 ABS37118','A8 215 821','A1 2344605 TEX','A9 FE FDB1482','A1 GDB1326','B1 LUCGDB1325','C4 LP1733','C4 LP2019','C4 16412F','A2 RH 2767.12','B1 BOS0986494051','C9 GDB1326','C4 0986494529','B1 BOS0986494025','A9 GDB1326','C9 2322416','B7 0767.12/REM','B1 ATE13.0460-2874','B1 VAL301482','C9 FE16412','A1 0986494051','E7 355.1','A2 0986494025','C9 0986494025','C4 LP1541','A1 13.0460-2872.2','B7 23446.165.1','C4 23446.165.2','C9 23446-16,5','A3 TEX 2344605','A1 598681','A3 BOS 0986494025','A1 P85046','A1 0986494025','C4 1170184','A2 RH 2767.01','A3 FER FDB1482','A2 LP1541','A1 16412 FE','A1 16408 FE','B1 ABS37142','B1 ZIM23446.165.1','A2 23224 173 15','B1 BLPADV184254','A3 TEX 2322411','B1 ZIM23224.165.3','E7 355.2','B1 FEB16408','A3 DLP LP1541','A1 598650','A2 BP85046','A2 ABS37142','B1 ZIM23446.165.2','A9 BP85046','A9 ABS37142','A9 GDB1369','A8 207 626','A1 GDB1415','A1 WBP295','A2 GDB1415','A2 RH 2263.51','A2 RH 2591.00','A3 QUI 109-1233','A3 ROA 226351','A3 ROA 259100','A8 230 153','A9 GDB1415','A9 Q109-1233','A9 RH 2263.51','A9 RH 2591.00','B1 BLPADV184238','B1 CIF822-346-2','B1 KAMJQ1012964','B1 LUCGDB1415','B1 QB109-1233','B1 VAL302424','B7 0263.51/REM','B7 0591.00/REM','B7 B110852/DKM','B7 B110901/DKM','C4 GDB1415','C4 KRO1415','C9 0252322416/W','C9 0252322416-1/PD','C9 0252344616/PD','C9 0252344616/W','C9 19-1824','C9 23224 00 702 10','C9 GDB1415','C9 QB109-1233','C9 QP6081','C9 QP6081C','E1 30 91 6412')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #