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 ('B1 ABS230429','B1 VAI10-7151','C4 TA2333','C9 FE38947','C4 TA1690','B1 RTS91.90903.1','A2 JTF203','A3 NKS 50347103','A1 26120 FE','C4 JTF204','B1 ABS230018','A1 TA1690','B7 1144601589/JP','C4 TA2332','A3 NKS 5034759','A1 RU925426','E3 V-912','A1 EL1357','A1 WSS415','B1 MOZL29124','B1 FEB26120','C9 FE19346','B1 FEB29621','C4 VO-ES-0511','A1 VO-ES-0511','C4 VKDY 311031','C4 VO-ES-0510','A2 S37132','A3 MOG VO-ES-0510','A2 30 71 0044','C9 1160200011','A1 TA2332','A1 EL1358','A1 JTE753','A1 VO-ES-0510','B1 TRWJTF204','A2 TA2333','A3 RUV 925427','B1 RTS91.90927.1','B1 FEB17008','A1 VO-ES-7106','A1 840 0834 10','A3 FEB 18494','A1 G1-1018','C9 925426','C9 50347103','B1 VAI10-7150','A1 26121 FE','A1 840 0835 10','C9 5034760','B7 D130121/DKM','A2 TA1690','A9 30 71 0045','C4 38947F','A3 MOG VO-ES-0511','A5 109652','C9 FE29621','C9 FE29620','A1 G1925','A3 DLP TA2332','A1 JTE752','E2 107 832 586','A1 G1-1430','C9 FE17006','B1 FEB26121','C4 54006202','A8 416 589','A2 JTF204','A3 FEB 19346','C4 17006F','A8 405 664','A8 416 588','A3 FEB 17006','A3 MEY 1160200028','B7 1144603589/JP','A9 JTF204','B1 FEB38947','C4 VO-ES-7106','A3 RED 6-137','B7 925426','C4 VKDY 311021','A1 TA2333','B1 ABS230434','C9 1160200024','A9 TA2332','A3 MOG VO-ES-7106','B7 840 0834 10','A9 30 71 0044','A8 457 752','A1 G1-1427','B7 D130114/DKM','A5 109651','C4 54008101','C4 54006301','C9 FE26120','A2 JTE752','C9 FE17008','A8 457 751','A3 DLP TA1691','A1 TA1691','A2 TA2332','C4 VO-ES-7139','A3 VAC V10-7151','A2 JTE753','A3 RUV 925426','A3 TRI 850029140','C4 17008F','B1 TRWJTF203','A1 37132 SID','C4 TA1691','B7 1144601580/JP','B1 FEB38948','A1 G1926','C4 850029139T','A8 400 146','A1 17006 FE','A8 413 669','A9 S37132','A9 JTF203','A1 63433 SID','C4 54008002','B1 MOZL29140','C4 JTF203','B1 ABS230433','C4 VKDY 311020','A1 JTF203','B1 MOZL29139','B1 MOZL29123','A1 29621 FE','C9 5034775','E6 DE1248','A2 TA1691','B1 FAG840083510','A3 FEB 17008','A2 S63433','C4 850029123T','A3 DLP TA1690','A3 RED 6-136','B7 840 0835 10','B1 FAG840083410','C9 FE26121','A3 NKS 5034760','C9 1160200028','C4 850029124T','C9 5034759','C4 850029140T','B1 RTS91.90927.2','B1 TRWJTE2132','C4 JTE752','A1 WSS416','A3 NKS 5034776','A1 17008 FE','A1 G0-635','A1 RU925427','A1 G1-1428','B7 925427','A9 S63433','A1 G1-1019','A2 30 71 0045','A3 MOG VO-ES-7139','B1 TRWJTE753','E6 DE1247','A3 FEB 18496','B1 RTS91.90903.2','A3 NKS 5034775','A1 VO-ES-7139','C9 5034776','A8 405 663','C4 JTE2132','A1 G1-1429','A1 JTF204','A3 VAC V10-7150','A1 29620 FE','B1 TRWJTE752','C4 JTE753','A1 G0-668','C9 925427','A3 DLP TA2333','B1 FEB29620','B1 FEB17006','C4 JTE2162','C9 FE38948','A1 30567LMI','A2 3056701','A2 42.74.723','A9 3056701','A9 42.74.723','B1 KAM9010071','B7 D130003/DKM','C4 30567 01','C4 RW69433','C9 LMI30567','C9 MGZ-301037','C9 QS8932/HQ')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #