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 ('A5 16902','C9 GDB1376','A3 TEX 2162402','C9 0252191119/PD','B7 0390.20/REM','C4 05P639','A3 TRU 07.35.104','A2 RH 2390.01','C9 21911 00 701 10','A1 GDB1376','B1 ABS36898','B7 SP 259','C4 607077','B1 TRU07.35.104','B1 VAI10-8130-1','C9 QP8417C','B1 BOS0986424481','C9 VAL598303','A8 215 162','C4 GDB1200','C9 PA-0004AF','B7 0390.01/REM','A9 0986424481','C9 GDB1275','C9 13.0470-7081.2','C4 05P669','A1 WBP695','A1 13.0460-7081.2','A5 206820','B7 B110872/DKM','B1 VKA66980008801','A9 FE FDB1167','A1 598303','A8 201 969','B1 ATE13.0470-7081','A2 GDB1275','C9 0252162419','B7 1163605110/JP','C9 2162402','C4 2162402TX','B1 TOM1212','B1 LUCGDB1376','A1 571921J JRD','C4 2339201TX','A2 0986424481','A1 LP1525KB','C4 LP1525','A1 LP978','A3 ROA 239040','B1 VAI10-8131-1','C9 0986424460','A2 13.04707081.2','E7 188.1','B1 VAI10-8131','C4 0986424481','A2 GDB1376','C9 0252162419/PD','A2 LP978','A1 GDB1200','C9 21624-20,4','B1 KAMJQ101193','A9 GDB1376','B1 VAL302493','C4 GDB1275','C4 LP978','A3 BOS 0986424460','B7 21911.200.1','A2 LP1407','A1 P85036','A3 VAC V10-8130','A3 DLP LP978','A9 RH 2390.40','B1 ZIM21624.200.1','A2 RH 2390.40','B7 1163604810/JP','C9 19-0661','A8 205 371','A1 13.0460-7077.2','A9 21624.200.1','A9 RH 2390.20','C9 19-0660','A3 VAC V10-8131-1','A1 13.0470-7081.2','A9 13.04607077.2','C9 VAL301355','C9 QP8417','C4 LD7081','B1 LUCGDB1200','A2 0986424460','A2 LP1525','B7 0390.40/REM','A3 TEX 2339201','B1 BREP85036','A2 13.04607081.2','A3 TEX 2191102','A2 GDB1200','A3 FER FDB1167','B1 TOM1654','A1 FSL969','C4 FDB1167','A1 FDB1167','C9 21911-20,6','C4 LP1407','A1 0986424460','C4 607081','A9 13.04707081.2','C9 21624 00 701 00','A9 23392 206 05','A9 BP85045','A8 217 267','E1 30 91 6338','A2 13.04607077.2','A3 VAC V10-8131','A2 21911 206 05','C9 19-0650','A2 05P639','A8 203 482','A9 0986424460','B1 ATE13.0460-7081','C9 PA-0941AF','A8 215 802','B1 BOS0986424460','B1 VAL301355','A2 21624.200.1','C9 0986424481','A3 BOS 0986424481','C9 PF0137','A3 ROA 239020','A1 WBP105','C9 13.0460-7081.2','B1 CIF822-181-1','A1 GDB1275','B1 BREP85045','A9 BP85036','A2 FE FDB969','A2 RH 2390.20','A2 FE FDB1167','E7 188.2','B1 VAI10-8132','C9 13.0460-7077.2','A3 DLP LP1525','C9 FDB1167','C9 QP5013C','A1 FDB969','C4 FDB969','A2 21911.200.1','A9 GDB1275','A9 21624 204 05','A3 CIF 822-181-1','C9 0252191119','B7 B110043/DKM','A3 VAC V10-8130-1','A1 LP1525','A8 230 135','C9 2191102','A3 VAC V10-8132','A9 21911.200.1','A1 FSL1167','A2 05P669','B1 LUCGDB1275','A2 23392 206 05','A1 2339201 TEX','A9 GDB1200','A3 FER FDB969','B1 ATE13.0460-7077','A3 ROA 239001','C9 QP1752C','A2 BP85036','B7 21624.200.1','A2 BP85045','C9 GDB1200','A1 LP1407','B1 CIF822-181-2','C4 FSL969','A5 151925','A1 P85045','A1 WBP552','A9 13.04607081.2','C6 007243','C4 GDB1376','C9 23392-20,6','C4 KRO1376','A8 230 091','A2 21624 204 05','B1 TOM10942','B1 VAI10-8130','E2 103 587 376','A3 TRW GDB1376','A3 DLP LP1407','C9 2339201','C9 PF0146','D2 EO LP1525','A9 21911 206 05','A5 146878','A1 0986424481','B1 ZIM21911.200.1','C9 QP5013','C9 QP1752','A1 571906D JRD','A1 571906JC JRD','A1 FDB1788','A2 FE FDB1788','A3 FER FDB1788','A9 FE FDB1788','C4 FDB1788')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #