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