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 ('A2 LO 03556','B1 ABS200004','A1 5538 FE','A2 LO 03525','B7 T474001/STC','C4 VKBA 3556','A8 903 983','C9 VKBA3658','A3 SKF VKBD0138','A1 200004ABS','A5 140041','B7 713 8015 10','B1 GSPGK3658','B1 GSPGK0961','C4 WB99039','B7 T474118/STC','A3 SKF VKBD0124','C9 763938','B7 W413261/DKM','C9 763914','A3 SKF VKBD0140','A9 LO 00961','A2 R155.19','C9 763908','A1 R155.89','A1 FR791241','B7 GK3525/GSP','A3 NKS 763938','A3 MOG RE-WB-11479','B1 SKFVKBD 0140','A2 VKBA 3556','A2 VKBD 0124','B1 SKFVKBD 0116','B1 SNRR155.63','A5 191666','C4 RE-WB-11486D1','A1 602 858','C9 VKBD0133','C4 KWD1010DY','B1 SKFVKBA 3525','C9 VKBD0132','A8 901 496','C9 FE05538','A8 903 543','A2 R155.63','A1 VKBA 3658','C4 PE-WB-11403','B7 WM 1088/MTZ','A1 VKBD 0132','C9 16-146500001','A1 RU5519','B7 713 6303 00','C4 WB96444','B1 FAG713630250','A3 MAR 361111183871','A2 OPT 702312L','A3 MOG RE-WB-11514','A1 602 669','A3 VAC V46-0049','A1 WWB219','A1 WWB220','C4 RE-WB-11514','C9 2519/MG','A1 R155.63','B1 ABS200045','A3 MOG RE-WB-11486D1','C4 VKBD 0124','A1 713 8015 10','A2 VKBA 969','C9 713630300','C4 853025239T','A3 SKF VKBD0132','C9 702352A','A9 OPT 602858','C9 VKBD0125','D2 7701205812','C9 16-147500005','A1 44-21071ASK','B1 GSPGK3525','A2 VKBA 3525','A3 JAP KK-21071','B1 KAM5600070','C4 WB96475','B1 FAG713801510','C9 VKBD1025','A2 MAP 26103','A1 702 312L','A1 VKBA 969','B1 IJS10-1141','E2 700 179 755','A3 RUV 5563','B1 VAI46-0091','C9 16-147500011','B1 SNRR155.89','A3 MOG PE-WB-11403','A1 R155.19','B1 SKFVKBD 0138','B1 SKFVKBD 0125','B7 W413243/DKM','A3 MOG RE-WB-11486D2','A2 60 90 5538-1','A3 NKS 763924','A9 VKBA 969','C4 KWD1094DY','C4 700179HP','C9 VKBD0138','A3 NKS 763914','B1 SNRR155.19','A8 900 073','B1 FAG713630300','A8 901 629','A3 SKF VKBD0116','B7 T474128/STC','A1 546467','A3 SKF VKBA961','B7 421071/JAPKO','A2 713 8015 10','A1 702 426','A1 VKBD 0125','C4 853025203T','A1 FR791201','A8 909 880','C4 RE-WB-11479','B1 SKFVKBD 0132','B1 SKFVKBA 3556','A9 713 6303 00','A5 146432','B1 SKFVKBD 0124','B1 SKFVKBD 0112','B7 T474012/STC','B1 KAM5600101','B1 SNRR155.126','B1 SKFVKBA 969','A1 713 6302 50','A3 SKF VKBA3525','A3 MOG RE-WB-11494','C4 N4711064','A1 200045ABS','A1 RU5563D','C9 5563D','C4 VKBA 3525','C4 05538F','A5 141528','C9 602858A','A9 VKBD 0116','A8 901 510','A3 SKF VKBD0133','C9 VKBD0116','C9 VKBA961','E2 700 185 755','A3 VAC V46-0091','C9 FSTDAC25520037-KIT','A1 702 312','C4 RE-WB-11486D2','A2 VKBD 0116','C9 763924','A2 OPT 602858','C4 VKBD 0133','A8 908 802','C4 WM 1088','C9 2513/MG','A2 LO 00961','C4 16-14 750 0011MY','A1 WWB476','A1 702 312S','A9 LO 03525','A3 SKF VKBA3556','B7 546467','A1 VKBD 0133','B1 SKFVKBD 0143','A3 MAR 361111181790','A1 VKBD 0142','B7 GK3556/GSP','A4 7701463523','C9 702312','A1 702 312 S','B1 KAM5600065','B7 WBK-6509/KAVO','A1 VKBA 961','C4 VKBA 961','B1 IJS10-1138','C4 16-14 650 0001MY','A3 SKF VKBD0125','C9 KK-21071','A4 16-14 650 0001','A9 60 90 5538','C4 30-3025','A2 MAP 26102','A1 VKBD 0143','A2 R155.89','A5 123594','A1 VKBD 0116','C9 VKBA3556','C9 VKBD0142','C4 VKBA 969','A3 SKF VKBD1025','C4 RE-WB-12752','C9 5563','A1 VKBA 3556','C9 3607/MG','C4 713801510','A1 KWD1094-DY','A9 LO 03556','C4 853025202T','C9 713801510','A9 N4711064','C9 VKBA969','B7 W413092/DKM','B1 GSPGK0869','A4 700 179 755','B7 T474026/STC','C9 2938/MG','A5 136382','A3 SKF VKBD0112','C9 VKBA3525','B1 IJS10-1129','C4 713630300','B1 IJS10-1288','A1 WWB247','C9 VKBD0143','B1 GSPGK0969','A3 MAR 361111181795','A9 VKBA 3525','A3 FEB 05538','A1 RU5563','A8 232 478','A9 VKBA 961','B1 KAM5600069','A9 VKBA 3556','A5 68292','A3 NKS 763908','B1 KAM5600027','B1 KAM5600011','B1 VAI46-0049','B1 SKFVKBD 0133','A1 WWB109','B1 GSPGK3556','A2 N4711064','A1 713 6303 00','A8 900 037','C9 VKBD0124','A1 FR791201L','A1 VKBD 0140','B1 SKFVKBA 3658','A9 VKBD 0124','A3 SKF VKBD0142','B1 SKFVKBD 0142','A1 702 352','A2 60 90 5538','A3 SKF VKBA3658','A2 713 6303 00','A1 J4711061HB','C9 602669A','C9 2919/MG','A1 VKBD 0138','A1 WWB231','A1 VKBD 0124','A3 SKF VKBA969','A1 VKBA 3525','B1 IJS10-1343','A3 SKF VKBD0143','C9 VKBD0112','A9 OPT 702312L','A2 VKBA 961','A5 84267','B1 FEB05538','C9 702426A','C4 VKBA 3658','B1 SKFVKBA 961','A1 WWB353','A9 VKBA 3658','A5 46484','A2 VKBA 3658','C4 RE-WB-11494','C9 VKBD0140','A8 900 118','A1 VKBD 0112')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #