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