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 LUCGDB1559','C4 0986494118','A2 RH 21052.00','A3 DLP LP1956','C4 607176','E7 AC0581512D','C4 LD7176','B7 23794.200.9','C4 LD7216','B1 VAL301640','A3 TEX 2379381','C9 FDB1773','A2 BP06057','A3 DLP LP1794','C9 2379381','A2 T 2379381','B1 KAMJQ101175','A1 13.0460-7216.2','A1 0986494705','A2 13.04607176.2','B1 FEB16503','A2 05P1512','C9 GDB1559','A8 224 631','B7 23794.200.2','A3 CIF 822-557-0','B1 ATE13.0470-7216','B7 1463601110/JP','B1 BOS0986424621','C4 23794.200.9','A3 TRU 08.34.110','A2 23794.200.9','C9 23794-20,3','C9 13.0470-7176.2','B1 VAI20-8118','C4 0986494705','A1 573187JC JRD','A8 251 886','A3 VAC V20-8126','B7 B110982/DKM','A5 130790','C4 08.34.110','B1 BOS0986494705','B7 23793.200.1','A1 573151JC JRD','C4 2379401TX','A3 BOS 0986494705','A2 BP06036','A9 0986494118','A1 FDB1773','A8 234 087','A5 206940','B1 ABS37409','C9 0252379420/PD','A1 0986494118','A1 13.0470-7176.2','A9 23794.200.9','C9 23793-20,3','A9 LP1794','A5 73229','C4 LP1794','B7 23793.200.9','A3 VAC V20-1463','C9 VAL301640','C9 GDB1559DTE','C9 PA-0048AF','B1 BREP06057X','B1 ZIM23793.200.2','C9 QP0556C','B1 ATE13.0460-7216','A1 LP1794','C9 0252409620','B1 ZIM23793.200.9','B1 VAI20-8126','A1 P06057X','B1 BOS0986494958','C4 LP1956','A9 13.04607176.2','B1 ZIM23793.900.1','A9 BP06057','B1 VAI20-1463','B1 KAMJQ1013546','C9 2379301','A1 P06036X','C9 0252379420','A2 13.04707176.2','A9 BP06036','A9 23794 203 05','E1 20 91 6503','A2 T 2379481','C9 0986494958','C4 05P1271','C9 2379401','A1 WBP440','A5 139951','A2 GDB1559','A2 13.04607216.2','C9 23794 00 701 00','C4 23794.200.1','A3 TEX 2379401','A1 GDB1559','A9 GDB1559DTE','A2 GDB1559DTE','A2 23794 203 05','C4 KRO1559','C9 PF0160','A9 GDB1559','A9 T 2379481','B7 23793.200.2','A9 13.04707176.2','B1 CIF822-557-3','C4 GDB1559DTE','A8 230 221','B7 1052.00/REM','B1 ZIM23794.200.1','B1 TRU08.34.110','A9 13.04607216.2','C9 13.0460-7176.2','A2 FE FDB1773','B1 CIF822-557-0','B1 BOS0986494118','C9 PF0156','A5 73076','B1 LUCGDB1559DTE','A9 RH 21052.00','A1 LP1956','A3 ROA 2105200','C4 GDB1559','C4 05P1512','A1 GDB1559DTE','A2 13.04707216.2','A2 LP1794','C4 FDB1773','C4 23793.200.1','C9 VAL598640','B1 ATE13.0470-7176','C4 2379301TX','A2 05P1271','B1 BREP06057','A9 T 2379301','B1 BREP06036X','A2 LP1956','C4 607216','A3 VAC V20-8118','A1 2379401 TEX','C9 0986494705','B1 BREP06036','C4 16503F','A3 FER FDB1773','A3 TEX 2379481','B1 ZIM23794.200.9','A9 13.04707216.2','B1 ATE13.0460-7176','C9 23793-20,3 EPAD','A1 16503 FE','A2 T 2379301','A5 57792','C9 13.0470-7216.2','C4 1170078','C9 QP0556','A3 TEX 2379301','A5 165426','A8 227 340','A2 0986494118','A1 P06036','A1 598640','C9 23794-20,3 EPAD','A1 13.0470-7216.2','B7 23794.200.1','A8 221 250','A5 348443','B1 ZIM23794.200.2','C9 0986494118','A8 228 208','A1 P06057','C9 19-0637','A1 WBP1052','B1 TOM1509','B1 ZIM23793.200.1','A3 BOS 0986494118','C9 13.0460-7216.2','A1 13.0460-7176.2','A1 GDB1882','A1 LP2245','A2 GDB1882','A3 DLP LP2245','A5 267252','A8 237 661','A9 GDB1882','B1 LUCGDB1882','B7 B111228/DKM','C4 GDB1882','C4 KRO1882','C4 LP2245','C9 19-2904','C9 GDB1882')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #