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