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 ('A9 BP06044','A3 TEX 2148701','B1 FEB16175','B1 KAMJQ1012966','A1 FDB857','B7 B111217/DKM','E1 20 91 6175','B7 0381.00/REM','C9 2148781','A1 LP1803','A1 13.0460-7079.2','A9 21487 172 05','A3 FER FDB1483','E7 576.0','A9 RH 2381.20','A1 GDB1119','C4 FDB1483','B1 BOS0986494006','A9 GDB1530DTE','A5 139949','A8 203 502','C9 21487-17,2 EPAD','A3 TEX 2148703','A2 BP06044','A1 LP846','C4 21487.170.1','A8 234 078','C9 GDB1119','A9 BP06020','A2 GDB1530DTE','A3 BOS 0986494006','A3 ROA 238100','A1 GDB1304','C9 2148701','A9 RH 2381.30','C4 2148703TX','A2 RH 2381.20','A1 FDB1483','A5 399874','A1 16175 FE','A2 RH 2381.30','C9 FDB1483','A2 RH 2381.00','B1 ZIM21487.170.9','E7 576.0.T','A9 0986494006','A9 13.04707079.2','A2 BP06020','B1 BREP06016','B1 ZIM21487.970.1','C9 PF0485','B1 ZIM21487.170.2','B7 21487.170.1','A9 FE FDB1483','A3 FER FDB857','B1 LUCGDB1119','A1 WBP432','A2 13.04607079.2','A1 16549 FE','A1 GDB1530DTE','E1 20 91 6549','C9 VAL598580','A1 P06044','A2 BP06016','B7 0381.20/REM','C4 KRO1530','C4 GDB1119','C9 21282-17,3','C9 13.0460-7079.2','C4 05P1231','A3 TEX 2148702','C4 607079','D1 BP ADJ134218','A9 T 2148781','B1 ZIM21487.170.1','A5 72982','A3 DLP LP1803','A1 116028 FE','C9 GDB1527','B7 21487.170.9','A2 0986494006','E1 20 11 6028','A9 RH 2381.00','A3 ROA 238120','A3 DLP LP1143','C4 GDB1530DTE','A2 FE FDB1483','A9 GDB1119','C9 GDB1530DTE','A2 05P1231','B1 ZIM21282.170.1','A1 598580','B1 CIF822-560-0','A2 21487.170.2','A1 FSL1483','C9 GDB1530','B1 BREP06020','B1 VAL301580','A1 13.0470-7079.2','A1 P06020','C4 2148701TX','B1 FEB116028','A3 ROA 238130','C9 2148703','C9 21487-17,2T4147','A2 21282 173 05','A3 CIF 822-560-0','A1 0986424365','C9 13.0470-7079.2','C9 21282 00 702 00','B7 21487.170.2','B1 VAL302465','A2 FE FDB857','C9 0986424185','A2 GDB1527','A1 GDB1530','C4 GDB1527','C9 VAL301580','C4 0986494006','C9 19-0531','A2 21487 172 05','A2 BD S363','A1 P06016','A1 LP1143','B1 ATE13.0470-7079','A3 TEX 2148781','A2 T 2148781','A8 228 213','A2 13.04707079.2','A1 0986424185','B7 51L00/JAPKO','B7 21282.170.1','C9 0986494006','B1 LUCGDB1530DTE','A9 BD S363','C9 19-3659','A9 GDB1527','A8 219 707','A9 13.04607079.2','B1 ATE13.0460-7079','A9 21487.170.9','A1 GDB1527','C9 PF0152','B7 0381.30/REM','B7 1463700910/JP','C4 LD7079','B1 FEB16549','A3 TEX 2128201','C9 0252148717','C4 LP1803','C9 PP-L00AF','A2 07.B315.01','C4 GDB1530','A9 21487.170.2','A1 0986494006','D2 34216761240','C9 0252148717/PD','C9 21487-17,2','A9 BP06016','B1 LUCGDB1530','A5 130783','A8 230 203','A2 LP1803','A2 21487.170.9','A2 LP1143','B1 LUCGDB1527','A1 2148701 TEX','A2 GDB1119','B1 BREP06044','B1 BLPADJ134218','A3 QUI 109-1201','A9 Q109-1201','B1 FEB16176','B1 QB109-1201','B1 VAL301103','B1 VAL301753','C4 16176F','C9 QB109-1201','C9 QP7084','C9 QP7084C','C9 QP8141','C9 QP8141C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #