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 05P1231','B1 LUCGDB1530','B1 ZIM21487.170.2','C4 GDB1530','A9 RH 2381.20','C4 LP1803','A1 GDB1527','A8 203 502','A5 399874','A9 T 2148781','C9 0986494006','B7 0381.20/REM','B1 BLPADJ134218','E7 576.0.T','A3 FER FDB1483','A2 21487.170.2','A1 FDB1483','A9 FE FDB1483','A9 21487.170.9','A9 21487.170.2','A3 TEX 2148701','C9 2148701','D2 34216761240','C4 KRO1530','A9 BD S363','A2 RH 2381.30','C4 2148701TX','B7 21487.170.2','B1 VAL301580','C9 21487-17,2','C9 21487-17,2T4147','C9 2148703','A3 DLP LP1143','C9 VAL598580','B1 ZIM21487.970.1','B1 ZIM21487.170.1','A2 GDB1527','A1 LP1803','A8 230 203','A2 21487.170.9','A3 TEX 2148703','A3 DLP LP1803','A1 598580','A2 0986494006','B7 21487.170.9','A2 05P1231','C9 PP-L00AF','C9 2148781','B1 ZIM21487.170.9','A9 0986494006','D1 BP ADJ134218','B1 ZIM21282.170.1','A3 BOS 0986494006','C4 607079','A2 21487 172 05','A2 T 2148781','A9 13.04607079.2','A2 13.04607079.2','A3 ROA 238130','B1 LUCGDB1527','B1 CIF822-560-0','A5 130783','A2 RH 2381.20','A5 72982','B1 VAL302465','A1 0986494006','E7 576.0','A2 FE FDB1483','A1 FSL1483','A9 GDB1527','B1 FEB16549','A3 ROA 238120','A3 ROA 238150','C4 2148703TX','A3 TEX 2148781','A1 16549 FE','C9 21487-17,2 EPAD','A8 228 213','C9 0252148717','A9 RH 2381.30','B7 21487.170.1','B1 FEB16175','A1 0986424365','A1 LP1143','A2 BD S363','B7 21282.170.1','A8 219 707','C9 21282 00 702 00','A1 16175 FE','A1 WBP432','C9 FDB1483','C9 GDB1530','A1 2148701 TEX','A1 LP846','E1 20 91 6175','A9 21487 172 05','A1 GDB1530','B1 ABS36715','B7 0381.30/REM','A2 LP1143','B1 ATE13.0460-7079','C9 VAL301580','C4 FDB1483','A1 GDB1304','C9 13.0460-7079.2','E1 20 91 6549','A1 13.0460-7079.2','C4 GDB1527','C4 0986494006','C9 GDB1527','C4 21487.170.1','A2 LP1803','A3 CIF 822-560-0','B1 BOS0986494006','A1 13.0470-7079.2','A2 13.04707079.2','A2 GDB1530DTE','A2 QWS0192A','A2 QWS0200A','A2 QWS0202A','A2 QWS0222A','A2 QWS0246A','A2 QWS0273A','A3 PEX WK429','A3 QUI 109-1201','A3 QUI WS0154A','A3 QUI WS0200A','A3 QUI WS0222A','A3 QUI WS0246A','A3 QUI WS0254A','A3 QUI WS0263A','A5 139949','A8 234 078','A8 524 141','A8 524 153','A8 524 174','A9 13.04707079.2','A9 GDB1530DTE','A9 Q109-1201','A9 QWS0154A','A9 QWS0192A','A9 QWS0200A','A9 QWS0200B','A9 QWS0202A','A9 QWS0202B','A9 QWS0203A','A9 QWS0204A','A9 QWS0222A','A9 QWS0246A','A9 QWS0273A','B1 ATE13.0470-7079','B1 KAMJQ1012966','B1 LUCGDB1530DTE','B1 QB109-1201','B1 QBWS0154A','B1 QBWS0192A','B1 QBWS0200A','B1 QBWS0202A','B1 QBWS0222A','B1 QBWS0246A','B7 B111217/DKM','C4 GDB1530DTE','C4 LD7079','C9 0252148717/PD','C9 13.0470-7079.2','C9 19-0531','C9 19-3659','C9 23-0063','C9 23-0106','C9 23-0107','C9 GDB1530DTE','C9 QB109-1201','C9 QBWS 0200 A','C9 QBWS 0204 A','C9 QBWS 0222 A','C9 QBWS 0246 A','C9 QBWS 0254 A','C9 QP7084','C9 QP7084C','C9 QP8141','C9 QP8141C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #