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 ('A9 OC501','A2 586023','A9 W712/21','A1 0986AF1041','C4 W 712/21','C9 FO-800S','B1 KNEOC988','C4 TO-129','A5 30191','B1 BOS0451103271','A8 365 946','C9 H90W20','A5 169850','C9 30-143220004','A2 FI OP534','B1 PURLS285','A2 W712/21','A8 365 184','A5 432463','A8 365 896','A1 W712/73','C4 W 7035','C4 27147F','A9 UFI 23.435.00','C9 E27HD125','A5 500318','B1 KAMF106401','B7 OP 618/IP','A5 43729','A9 SF OF0078','B7 OP 534/IP','A3 BOS 0451104066','B7 1118501200/JP','A2 0451103271','C9 0986452044','A3 VAC V25-0102','A1 OC235','A1 LS285PU','B7 H14W32','B1 KAMF113101','A9 SF OF0183','A1 W7015','A3 BOS 0451103271','A8 370 404','C9 SP-994','A3 VAC V25-0144','B1 PURLS801','B1 KAMF104801','B7 H90W20','A3 VAC V70-0016','A5 102423','C4 H14W32','B7 SM180','B1 FTROP618','A1 WOF1868','A5 62149','A9 OC988','C4 W 712/83','C9 50013820','C9 W712/21','A2 0451104066','A8 378 012','A2 W712/73','A2 OC988','B1 VAI24-0023','A5 189440','B1 HENH14W32','C4 0451104066','B7 W7015/AG','C4 LS801PU','B1 HENH90W20','B1 VAL586047','D9 16510-60B11 50db','A8 389 804','A8 920 093','D9 16510-60B11 10db','C4 S 1600 R','B1 VAI25-0144','B7 SM196','A3 BOS 0986452044','A3 FLT OP534','A9 W712/98','B1 VAL586073','B1 MANW7035','A1 W712/98','C9 LS359','A2 0986452044','C4 W 712/73','C4 S 3253 R','C9 71760788','B7 A210095/DKM','A1 W7035','B1 MANW7015','C9 OF-821','C4 O0583DREIS','B7 OP618/AG','A8 369 966','C9 DO911','B7 A210031/DKM','A2 SF OF0183','C4 W 7015','A9 W712/73','A1 0986452044','B1 FTROP534','C4 LS188BPU','B1 VAI10-0322','C9 0451104066','A9 W712/83','C4 E27H D125','C9 W712/73','B1 PURLS359','A3 VAC V24-0023','C4 LS285PU','C9 OF-573','C9 FO-279S','C9 FE27147','C4 H90W20','A3 VAC V25-0145','A5 169853','B1 VAL586023','A8 312 820','A8 325 297','A9 W7035','A3 HEN H90W20','B7 TO-138/KAVO','A3 MNN W712/73','A1 10-02-279ASK','A9 FI OP534','B1 BOSF026407229','B7 A210109/DKM','A2 OC501','B1 MANW712/73','A1 0451104066','A9 0986452044','A2 SF OF0078','C9 OF-994','A1 LS359PU','A1 10-08-800ASK','B7 W712/83/AG','B1 KNEOC501','C4 S 3435 R','A3 VAC V10-0322','C9 LS188B','B1 VAI24-0020','A8 328 206','C9 W712/83','B1 VAL586077','A5 202450','A8 303 046','A2 W712/83','C9 0451103271','A2 FI OP618','A2 W7015','A5 337785','A3 JAP FO-279S','B7 E27H D125','B7 10800/JAPKO','B7 H90W30','A1 W712/21','C9 LS801','C9 H14W32','A5 200755','C4 OC 988','B1 VAI25-0145','B7 ST784','B1 FEB27147','A1 0451103271','A1 0986AF1060','C9 W7035','B1 MANW712/98','A2 J1312021','B1 VAI25-0102','C4 0451103271','A8 318 321','B1 HENE27H D125','A9 W7015','B7 SM143','A3 MNN W712/83','C9 LS285','C9 DO339','C4 0986452044','A3 FLT OP618','A3 MNN W712/21','A1 27147 FE','A9 0451103271','D9 16510-60B11','B7 A210052/DKM','B1 BOS0451104066','C9 50013104','A3 MHL OC501','A1 0986AF1042','A1 LS188BPU','B1 MANW712/21','A9 FI OP618','A1 J1312011HB','A2 UFI 23.435.00','C9 71758744','C9 7143220001','A3 VAC V24-0020','A1 OC988','C9 OF-845','A9 J1312021','A3 VAC V25-0101','A9 0451104066','C9 W7015','A3 JAP FO-800S','B7 OP534/AG','C9 DO225/C','A2 W712/98','A2 UFI 23.253.00','B7 10279/JAPKO','A1 WOF537','A1 LS801PU','A1 W712/83','C4 OC 501','B7 SM110','A8 307 715','A1 OC501','B7 SM133','B1 PURLS188B','C9 50013050','B1 VAI70-0016','A2 W7035','B1 VAL586087','A9 UFI 23.253.00','A3 KAP TO-138','C4 J1312021','B1 MANW712/83','B1 BOS0986452044','C4 O0550DREIS','A3 MHL OC988','C9 SP-845','B1 VAI25-0101','A8 312 830','A8 320 522','A5 206442','C9 W712/98','C9 OF-478')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #