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 ('A3 JAP FO-203S','A2 OC292','A8 318 318','C4 0986452019','A3 MHL OC292','A9 OC139','C9 FO-108S','C9 H97W01','A2 OC139','A2 W811/83','A8 365 826','B1 BLPADG02110','C9 W811/81','B1 BLPADT32112','A1 W818/84','C4 W 811/81','A8 366 131','C9 ADT32112','A1 J1311006HB','A9 0986452019','B1 HENH16W03','A5 30179','C9 FO-203S','C4 S 2290 R','A8 361 470','A8 365 877','A3 BOS 0986452019','A1 WOF217','C9 FO-601S','C4 W 610/80','B1 FTROP539','A1 J1318000HB','C9 W68/1','B1 VAL586054','A8 303 393','A1 J1312014HB','C9 DO816','A1 0986AF1041','C9 0986452035','B1 HENH97W16','A3 FLT OP539','A2 UFI 23.213.00','A3 JAP FO-205S','A2 0986452019','A9 UFI 23.131.01','A3 JAP FO-108S','C9 LS901','A9 UFI 23.263.00','A8 370 633','A2 UFI 23.210.00','C4 W 811/83','E6 FL1202','C9 DO337','A2 0986452027','B1 BOS0986452019','A1 0986452035','A9 W811/83','A2 UFI 23.496.00','C4 S 3496 R','A8 919 261','A3 MNN W811/83','A1 10-06-604ASK','B7 H97W01','A2 UFI 23.263.00','C4 W 811/81 SD','A9 FI OP539','A2 UFI 23.131.01','A5 30154','A1 0986452917','A1 WOF431','A9 W811/81','B1 PURLS908','A3 MHL OC139','E6 FL1036','A1 W811/81','B1 BOS0986452035','A1 WOF110','A2 FI OP539','C4 H97W01','C9 W811/83','D3 B12014UN','A1 J1312010HB','B7 H97W16','C9 ADT32102','C9 DO862','C4 W 68/1','A8 365 904','A3 JAP FO-800S','A3 JAP FO-601S','A1 0986452027','A8 307 265','A8 313 519','A8 313 520','A1 LS901PU','B1 BLPADT32102','C9 0986452019','A1 10-02-203ASK','A9 UFI 24.H2O.08','A8 359 156','B1 MANW811/81','A1 W811/83','B1 MANW811/83','A1 J1316001HB','C9 FO-800S','A1 OC182','C9 ADG02110','A1 0986452017','C4 0986452035','C4 LS908PU','C9 LS908','A3 BOS 0986452027','A5 337788','A1 C131','A9 UFI 23.210.00','A2 0986452035','A5 30191','C4 H97W16','C4 OC 292','D1 BP ADT32112','A1 0986452038','A1 0986452019','A3 MNN W811/81','A1 W68/1','A2 UFI 24.H2O.08','B7 OP 539/IP','D1 BP ADG02110','A1 LS908PU','B7 H16W03','D1 BP ADT32102','B1 HENH97W01','A1 OC139','A3 BOS 0986452035','C9 H16W03','A1 OC292','A2 W811/81','A5 246901','A9 0986452035','C4 S 3251 R','A1 10-01-108ASK','A1 38813 FE','A1 C170','A1 J1312011HB','A1 J1313021HB','A1 J1316004HB','A1 OC1253','A1 OC215','A1 W68/3','A1 WOF156','A2 J1316001','A2 OC1253','A2 OC215','A2 W68/3','A3 JAP FO-210S','A3 JAP FO-214S','A3 JAP FO-898S','A3 JAP FO-W01S','A3 MHL OC215','A5 134580','A5 202449','A5 250169','A5 30192','A5 44685','A5 47432','A5 48009','A8 300 023','A8 920 093','A9 J1316001','A9 OC1253','A9 OC215','A9 W68/3','B1 BLPADM52122','B1 BLPADT32109','B1 CHACOF100170S','B1 FEB27149','B1 FEB38813','B1 KAMF101701','B1 KNEOC215','B1 MANW68/3','B1 VAL586040','B1 VAL586060','B1 VAL586073','B1 VAL586082','B7 A210026/DKM','B7 DO-722/KAVO','B7 SM165','C4 J1316001','C4 O0547DREIS','C4 OC 1253','C4 OC 215','C4 W 68/3','C9 ADM52122','C9 ADT32109','C9 FE27149','C9 FE38813','C9 FO-210S','C9 FO-214S','C9 FO-898S','C9 FO-W01S','C9 OF-8119','C9 OF-951','C9 W68/3','D1 BP ADM52122','D1 BP ADT32109')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #