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 ('A1 WBP762','A2 05P1206','A8 230 198','A1 GDB1557','A3 BOS 0986494108','B1 CIF822-554-0','C4 KRO1516','C9 19-3324','A9 BP85076','A1 WBP663','A3 VAC V10-8176','C9 23326 00 702 00','B1 ZIM23326.175.2','C9 VAL872326','A2 T 2332601','C4 LP1920','B1 VAI10-8351','C4 LP1911','C4 16860F','A2 LP1911','A2 13.04602882.2','A1 0986494303','B1 VAI10-8188','A3 ROA 289711','B7 B111133/DKM','C4 LP1860','C9 QP2724C','C9 0252332617/W','C4 GDB1557','B1 VAL301004','A1 P85083','C6 019113','A2 FE FVR1644','A2 23326 177 24','A3 TEX 2332601','E1 30 91 6588','B1 VKA66981103201','B7 1163706210/JP','B7 23326.175.2','B1 VAI10-8176','A9 0986494303','B1 ZIM23326.175.1','A3 DLP LP1920','A8 229 584','E1 30 91 6860','A2 0986494108','C9 2332602','B1 ATE13.0460-7218','C9 0252332617/PD','A3 VAC V10-8351','A1 LP1860','A3 ROA 289702','D1 BP ADV184228','C9 0986494108','C9 23326-17,7','C9 0986494583','B1 BOS0986494303','A3 VAC V10-8188','C9 13.0460-2882.2','E3 23326.175.1','C4 602882','A9 13.04607218.2','A1 LP1920','C4 23326.175.2','C9 QP2724','C9 23326-17,7 1 4 EPAD','C9 GDB1557','A2 BP85076','A9 13.04602882.2','C9 GDB1516','A1 16860 FE','C9 PF0412','B1 TOM13961','C9 0986494303','A2 GDB1557','B1 FEB16826','A8 236 287','A2 LP1860','A2 RH 2897.02','A1 573220JC JRD','C4 2332602TX','A2 0986494303','E3 23882.175.1','C4 16826F','A1 P85076','B1 TOM1396','A2 BP85083','B7 23326.175.1','B1 LUCGDB1516','A2 LP1920','A9 GDB1557','C4 05P1206','C9 PF0602','A1 13.0460-7218.2','B7 23882.175.1','A8 228 244','C9 VAL598671','C4 23326.175.1','A1 13.0460-2882.2','B1 ATE13.0460-2882','B1 BREP85083','C9 2332601','A5 195005','C9 0252332617-1/PD','A5 73584','D2 EO 2332601','C4 0986494108','A3 BOS 0986494303','A9 T 2332601','A3 TRU 07.35.239','A8 230 220','C4 2332601TX','B1 ZIM23882.175.1','C9 23326-17,7 1 4','B1 LUCGDB1557','A1 2332601 TEX','A3 TEX 2332602','A2 BD S355','A2 RH 2897.11','B1 TRU07.35.239','A9 FE FVR1644','C9 13.0460-7218.2','C4 GDB1516','A2 T 2332681','A3 DLP LP1911','B1 BLPADV184239','A2 GDB1516','A9 23326 177 24','A1 573220J JRD','B1 FEB16588','C4 FVR1644','C4 KRO1557','A3 CIF 822-554-0','C9 QP5769C','A1 0986494108','C9 23326 00 702 10','B7 B110854/DKM','D1 BP ADV184239','A1 GDB1516','A9 0986494108','B7 1163706510/JP','A3 DLP LP1860','A8 236 875','A1 16826 FE','B7 B110853/DKM','B1 FEB16860','A1 FVR1644','A3 FER FVR1644','A1 2332602 TEX','B1 BOS0986494583','C4 2332681TX','A1 LP1911','C9 FVR1644','B1 CIF822-554-2','C9 VAL301004','A9 GDB1516','C9 QP8823C','A1 16588 FE','A1 WBP433','A8 215 486','A9 BP85083','A5 282095','B1 BLPADV184228','B1 BREP85076','B1 ABS37413','B1 BOS0986494108','A2 13.04607218.2','A3 TEX 2332681','A8 220 659','C4 0986494303','A5 124797','C4 607218','C9 19-0497','C4 23882.175.1')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #