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 ('B7 OP525/3/AG','C9 W830/1','A2 W940','D1 BP ADV182130','B1 FTROP525/3','B1 MANW940/20','A5 324887','C4 0986452400','A5 44143','C4 0451103290','A5 15269','B1 MANW940','B7 OP 525/3/IP','B1 BOS0451103290','A8 313 986','A9 H20W06','C9 0451103313','A1 WOF232','B7 OP525/4/AG','A9 UFI 23.417.00','C4 W 940','A3 FLT OP525/4','C4 OC 214','A5 38178','A3 MNN W1130/3','A2 FI OP525/3','A8 365 969','C9 LS214','A2 H20W06','A2 FI OP526/5','A2 UFI 23.465.00','A3 MNN W930/21','C4 O0662DREIS','B1 BLPADF122114','A1 W940/20','C4 W 940/20','A9 OC214','A9 0986452400','A3 FLT OP525/5','C4 H20W06','A1 0451103256','B7 H20W06','A9 W830/1','A2 FI OP525/5','C4 W 940/20 SD','C9 ADV182129','A1 WOF223','A8 360 200','A3 MHL OC485','A2 OC214','A2 OC485','A9 FI OP525/3','C9 LS299','A3 MNN W940','B1 FTROP526/5','A1 0451103257','B1 FTROP525/5','C4 S 3417 R','B1 BOS0986452400','A2 W830/1','C9 DO896','A3 MNN W830/1','A1 0986452400','A9 W940/20','A8 302 337','C4 W 830/1','C9 W940','C9 0451103306','D1 BP ADV182129','A3 BOS 0451103290','A2 OC262','A3 BOS 0451103257','C9 0451103249','A9 FI OP526/5','A2 0451103313','B1 MANW930/21','A8 318 819','A8 370 519','A1 0451103313','A1 LS214PU','C9 DO937','A1 OC485','B7 H24W04','A1 W1130/3','A2 W930/21','A8 313 517','A8 320 496','A8 303 201','C9 0451103290','A3 FLT OP525/3','A2 F026407136','A8 303 491','B7 OP 526/5/IP','A9 0451103249','A1 WOF434','C4 0451103249','C9 0451103256','A2 0451103257','B1 PURLS214','C4 S 6620 R','A2 FI OP525/4','B7 OP 525/5/IP','A1 0451103306','A1 LS299PU','B1 BOS0451103249','A3 BOS 0986452400','A5 44800','C4 W 930/21','A2 W940/20','B1 MANW830/1','C4 S 3459 R','A8 365 942','A3 FLT OP526/5','B1 VAL586036','A1 OC311','B1 HENH24W04','C9 F026407136','B1 HENH20W06','C4 OC 262','A9 OC262','B1 BOS0451103313','B7 OP526/5/AG','A9 0451103257','C9 W930/21','A9 OC485','D1 BP ADF122114','A8 318 354','A9 0451103313','B7 OP525/5/AG','A2 UFI 23.417.00','A8 306 453','A8 370 493','A3 BOS 0451103249','A3 MHL OC262','A3 MNN W940/20','A8 313 788','A1 WOF438','A2 0451103290','C9 W1130/3','A1 OC214','A5 65942','A1 0451103290','B1 BOSF026407136','A1 OC262','A2 0451103249','C4 W 1130/3','C9 H20W06','C9 ADV182130','A1 WOF248','C4 LS214PU','C9 W940/20','A9 0451103290','A8 328 817','B1 BOS0451103306','B1 BLPADV182129','A1 WOF292','A1 0451103249','C9 0451103257','C4 0451103313','A2 0986452400','B1 BOS0451103257','A3 BOS 0451103306','C9 ADF122114','A1 F026407136','A8 318 745','A9 W930/21','A1 W830/1','A1 W930/21','C9 0986452400','B7 OP 525/4/IP','A1 WOF533','A9 FI OP525/4','A3 BOS 0451103313','C9 DO944','A3 HEN H24W04','B1 FTROP525/4','A9 W940','A3 MHL OC214','B1 MANW1130/3','B1 BLPADV182130','A2 W1130/3','A5 44462','A1 W940','C4 H24W04','A9 W1130/3','C9 H24W04','A1 OC241','A9 UFI 23.465.00','A1 0451203223','A1 C150','A5 44751','A9 0451203223','B1 BOS0451203223','B1 CHACOF100150S','B1 FEB22530','B1 KAMF103201','B1 KAMF117801','B1 KNEOC262','B1 KNEOC485','B1 VAI10-0316','B1 VAL586075','B7 A210029/DKM','B7 SM111','C4 0451203223','C4 22530F','C9 0451203223','C9 1001150005','C9 1003220002','C9 OF-1112','C9 SP-1078')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #