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 ('A8 556 963','C9 VAL245185','A3 ERA 880061','B1 BERZSE 002','A3 INT 12621','A8 535 082','A5 17585','C9 1-970-159','C4 104033HP','C9 MG-00022','B1 JANJM5209','A3 ERA 880001','C4 48000NGK','C9 BERZSE001','A1 060717008012','C4 12916 INTERMOTOR','C9 VAL245092','C4 07.17.009','B1 HUC138701','A1 138415','A2 5DA006623-621','B1 VEM10-70-0014','B1 HUC138415','B1 JANJM5258','A5 144887','C4 ZSE001BERU','C4 10308MD','B1 BOS0986221002','A9 CE10023-12B1','A2 99050039701','A9 5DA006623-951','A2 TES CL001','B1 MMABAEQ005','A5 142656','A2 TES CL019','C9 HUC138415','A2 CE10023-12B1','B7 48000/AG','A1 IG-H016K MB','B1 SKV03SKV006','A3 BGD BSP22177','C9 0986221000','A3 BRE 11892','A1 17194 FE','A8 524 918','A3 VAL 245185','B1 VKA99050039701','A1 9.6059','A2 U1001','A1 5DA 006 623-621','C4 IG-H016K','B1 FAE80219','A3 NGK 48039','C9 HUC138419','C4 5DA 006 623-621','C9 1009050007','A8 530 675','A1 150227 CAR','A2 U1003','B1 VEM10-70-0009','C9 BRE11892','A8 523 116','B1 DELCE10023-12B1','A8 504 978','A9 30 91 7194','B1 MMABAEQ004','A1 245093','A3 MAR 060717005012','A1 GN10378-12B1','A3 MAR 060717006012','B1 NGKU1003','B1 HEL5DA 006 623-951','A2 5DA006623-951','B1 HP104 033','B1 VAL245092','A1 0986221002','A3 MAR 060717007012','B7 1191601509/JP','B1 MMABAEQ006','C4 17194F','A1 BAE851AE/245','C4 880001AERA','A3 NGK 48000','A2 0986221002','C9 MG-00021','C4 CE-01','C6 007118','B1 BOS0986221000','A3 BRE 11893','A1 060717007012','A8 532 583','A3 MAR 060717004012','C9 HIT2508416','B7 48039/AG','A2 245092','A8 551 217','A3 ERA 880001A','A2 ERA 880001A','B1 MMABAEQ077','A3 MAR 060717008012','C4 IG-H013K','B7 1191601500/JP','B1 DENDIC-0200','A3 INT 12916','C4 CE-09','C9 CE10023-12B1','B1 EPS1.990.414','B1 MMABAEQ008','C9 5DA006623-951','A3 BOS 0986221002','A3 BOS 0986221000','C4 100 905 0007MY','A3 HEL 5DA 006 623-621','B1 EPS1.970.159','A1 U1001','A1 80200 FA','A3 BER ZSE001','C9 U1003','A3 FEB 17194','B1 MMABAEQ007','A2 GN10378-12B1','A3 DLP CE1002312B1','A1 138419','C9 GN10378-12B1','B1 SKV03SKV008','A1 245092','A1 9.8114','C9 5DA006623-621','A5 44311','C4 9.6059','A3 INT 12918','A8 555 571','A3 MAR 060717077012','B1 TRU07.17.009','A1 IG-H013K MB','C4 CE10023-12B1','A8 560 137','A1 060717005012','B1 NGKU1001','C9 MG-2720M3','B1 FAE80200','A1 138701','A9 U1001','B7 1191601502/JP','B1 VEM10-70-0010','A2 30 91 7194','A1 CE10023-12B1','A1 0040402001','B1 HEL5DA 358 000-711','C4 0986221000','A2 9.8114','B1 DELGN10378-12B1','A1 5DA 006 623-951','A3 VAL 245093','C9 104033756','C9 BRE11893','C9 1-990-414','A3 TRU 07.17.009','A5 204859','B1 FEB17194','A2 0986221000','C4 11892BREM','A9 TES CL001','A3 DLP GN1037812B1','A1 CE-01 MB','A9 99050039701','C4 11893BREM','A5 142664','A1 0986221000','A4 100 905 0007','C9 FE17194','C9 U1001','A8 527 125','B1 JANJM5046','A1 0221600050','B1 HUC138419','A2 9.6059','A1 CE-09 MB','A2 245093','A8 502 692','B7 IC03109/BBT','A3 VAL 245092','C9 0986221002','A9 ERA 880001A','C9 BERZSE002','A3 ERA 880002','B1 BERZSE 001')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #