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 DRB1920','A8 540 365','A1 232766 CAR','A1 333119 CAR','B1 SKV11SKV009','A2 529 0005 10','C9 AP9016','C6 014475','A1 F00M147801','A1 141232 CAR','A1 529 0002 10','C4 232198C','A1 DRB1860','A3 DEL DRB1890','B1 HEL9XU 358 038-041','C9 AP9001','B1 VAL200009','B1 VEM10-13-41230','B1 DENDAN3011','B1 ASPA0059','C4 DRB1890','A1 0124615038','A1 142270 CAR','B1 INA529000110','A1 DRB1890','C4 DRB1920','A3 BOS 0124615038','B7 T404999/STC','A2 ERA 210247','C9 529000510','A2 588001','A1 113884 CAR','B7 55467','C9 AMA0005','B1 INA535001210','A5 433470','C4 139921C','C4 535001210','A9 529 0002 10','A9 AX 1054','A1 F00M991002','B1 LCELRA01856','B1 CNTAP9090','B1 VAL439664','A5 172652','B1 SNRGA754.05','A3 DEL DRB5360','C4 142268C','C4 RAA22621','C9 1000531004','C9 VAL200012','A1 WGE244','A8 323 354','A1 WGE186','A1 AP9016-CT','A1 GA754.07','C6 007385','C4 28-2990E','B1 SKV11SKV001','C9 A0059','A1 AP9001-CT','B1 SKFVKM 03100','B1 GATOAP7047','A9 HC 333110','C9 9XU358038-041','C4 529000210','A3 TRU 07.17.022','A9 HC 235835','A2 GAT OAP7047','C9 ELS28-3709','B1 CNTAP9016','A2 ELT 28-2985','A1 230075 CAR','A5 239031','C4 100 053 1004MY','C9 GATOAP7013','D1 BP ADV186101','C4 588001V','A3 SKF VKM03100','A8 541 127','C4 333119C','C9 MARC1446','A1 WGE251','A2 20130246','C4 333110C','C9 MRA41480','A3 VAC V10-7526','A1 WGE116','A9 GAT OAP7013','C4 140273C','C4 DRB1860','A1 RU55467','A8 540 625','A2 HC 139925','C9 VKM03101','A1 139921 CAR','C9 VAL588001','A1 8EL 012 427-541','A3 DEL DRB2700','A1 112079 CAR','C9 ALP2335','C4 AP9016CT','A1 332317 CAR','C9 A0521','A3 GAT OAP7047','A1 140263 CAR','C9 ELS28-3712','C9 MRA41860','A1 DRA0535','A8 532 641','B1 ASPA0059 (P-INA)','A9 ELT 28-2990','A9 HC 232766','B1 ASPA0233','A1 DRB2810','C9 0124615038','A2 HC 141232','A3 MAR 063535150220','A1 141233 CAR','C4 140093C','A3 NKS 4910061','C9 MRA90387','C4 28-2985E','A8 391 941','A2 HC 141233','A1 439664','A3 HUT DB0251','A3 SKF VKM03101','A1 437454','A3 ERA 210247','A1 F00M991122','B1 LCELRB00475','A1 WGE273','C4 232766C','A2 ERA 210194A','A5 49522','A1 DRB1480','C4 230075C','A9 HC 140273','A9 0AP9001','C4 OAP7013','B1 GATOAP7013','A8 510 515','B1 VEM10-23-0005','B1 VAL200012','A9 HC 140093','A1 8EL 737 644-001/GR','A8 523 591','C6 016997','C9 ELS28-4811','A2 GAT OAP7013','C9 GATOAP7047','A2 0AP9001','A1 232198 CAR','B1 ASPA0127','B7 529 0001 10','A5 265192','C9 A0233','C9 A0521PR','C9 AFP0010(V)','A3 DAY ALP2334','A1 113275 CAR','A1 230121 CAR','C9 A0127(P)','A3 ERA 210167','A2 ERA 210605A','C4 AP9090CT','B1 LCELRB00473','A1 8EL 012 428-271','A2 HC 140093','A2 8EL011710-321','A2 VKM 03100','A1 529 0006 10','A9 439664','C4 07.17.022','B1 ASPAFP0010','A3 DEL DRB1920','A3 DEL DRB1510','C4 141233C','A2 ERA 210944A','C9 A0233(BOSCH)','A1 113754 CAR','C4 F00M147801','A1 142318 CAR','A1 DRB1490','A1 DRB5360','A3 ERA 215231','C4 28-3712E','A1 RU55472','A9 RS 101210','A2 55472','C9 MRA45360','A1 ALP2334-DY','A1 437454/GRX','B7 T404997/STC','B1 VEM10-13-41860','C4 142270C','A2 ELT 28-3709','C9 55467','C9 529000110','B1 MMAAMA0005','B1 LCELRA02758','B1 MMAMARC1394','C9 55472MG','B7 529 0006 10','C9 AFP0010','B7 OAP7013/GAT','A8 540 501','B1 HUTDB0251','A8 391 188','A5 239025','A3 HEL 8EL 737 644-001','A9 ELT 28-3712','A2 HC 140263','A3 ERA 210605A','A8 376 338','B1 VEM10-23-0001','B1 CNTAP9001','A8 363 149','A1 8EL 011 710-381','B1 INA529000510','A2 HC 230849','A1 ALP2335-DY','A2 439664','C9 ELS28-4708','A3 RUV 55467','C9 ELS28-2985','B1 VEM10-13-42810','A2 0124615038','A3 MAR 943313941010','C4 230121C','A3 VAL 439664','C9 A0127','B1 VEM10-13-45340','B1 VKA99030010001','C9 A0480PR','B1 SKFVKM 03101','A3 DEL DRB1490','C9 VAL437454','A1 DRB1510','B1 VEM10-13-41500','A9 ELT 28-3709','A1 GA754.05','A1 WGE276','A2 529 0002 10','C9 VKM03100','C9 529000210','A9 ERA 215231','A2 HC 139921','B1 SNRGA754.07','C9 MRA42700','C9 VAL439664','A1 112002 CAR','B7 AP9016/AG','C4 529000110','A1 140273 CAR','B1 BLPADV186101','B1 SKV11SKV007','A2 437454','A1 ZN5378 ER','A5 130446','A2 HC 232766','A2 30 14 0008','C4 230849C','C4 ALP2334DY','A1 DRB2700','A2 ERA 210247A','A1 230849 CAR','A2 529 0006 10','B7 AP9001/AG','C4 140263C','B1 ASPAFP0010 (V)','A3 ERA 210231A','A3 BOS F00M147801','C4 230293C','A2 8EL737644-001','A2 HC 230075','A2 HC 233713','A3 DEL DRB1480','A9 30 14 0008','A1 233713 CAR','C9 MRA42810','A3 ERA 210231','B1 ASPA0521','A8 509 190','A3 ERA 210597','C9 535001210','A2 529 0001 10','A2 HC 230293','B1 VEM10-23-0008','C9 A0059PR','B7 1190101100/JP','A2 HC 232198','A2 HC 140273','A3 DEL RAA22621','C9 ELS28-2990','C4 139925C','A3 INA 535001210','A1 113340 CAR','A2 HC 142270','B1 KAMRC002','A9 8EL011710-321','C9 55472','B1 INA529000210','A1 529 0001 10','A1 529 0005 10','B7 535 0012 10','A1 333103 CAR','A9 588001','A2 535 0012 10','A9 HC 139925','A2 ERA 210231A','C9 A0127PR','C4 DRB1490','C4 529000610','A1 140093 CAR','B1 ASPA0059 (P)','A2 0AP9090','A2 RS 101210','B1 VAL200010','B1 INA529000610','B1 SKV11SKV002','C4 AP9001CT','C4 141232C','B1 LCELRA02233','A1 8EL 011 710-321','C4 VKM 03100','A2 VKM 03101','A1 230293 CAR','B7 55472','A3 DEL DRB1860','A2 HC 230121','B1 SKV11SKV003','A9 VKM 03100','A2 ELT 28-2990','B1 VAI10-7526','A5 204081','B1 ASPAFP0010 (INA)','C6 000934','A2 HC 333110','A1 588001','A3 ERA 210605','A2 ERA 210597A','A2 HC 235835','B1 VEM10-13-41920','C4 28-3709E','B7 1190101200/JP','C9 F00M147801','A2 ELT 28-4811','A1 142268 CAR','B1 LCELRB00474','A1 F00M147600','A1 333110 CAR','B1 VAL588001','A1 535 0012 10','A2 AX 1054','A3 GAT OAP7013','B1 VEM10-13-41490','C4 529000510','C9 MRA41490','A1 139925 CAR','B1 LCELRA02318','C4 ALP2335DY','C9 ELS28-2996','C9 AFP0010(INA)','A3 RUV 55472','A2 ERA 215231','A5 265741','B7 1190102500/JP','B1 KAMRC003','A3 DEL DRA0535','A1 235835 CAR','C4 333103C','C9 A0059(P)','C4 28-4811E','A9 ELT 28-2985','A3 DAY ALP2335','B7 529 0002 10','A2 ERA 210167A','C9 ADV186101','A9 437454','A3 MAR 940113010005','A3 DEL DRB2810','B1 VEM10-13-42830','A9 535 0012 10','A1 8EL 737 644-001','A3 VAL 588001','B1 ASPA0127 (P)','A2 ELT 28-2996','B7 529 0005 10','A5 103932','C9 A0233PR','C9 A0059(P-INA)','A9 HC 141233','A1 WGE222','C4 233713C','A3 MAR 063533250010','B1 TRU07.17.022','C9 529000610','A3 VAL 437454','C1 535 0012 10')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #