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 ('C9 GDB3265','A1 WBP1166','C9 2406201','A9 13.04605863.2','C4 605994','A9 RH 2645.22','A9 0986424474','A2 0986495059','B7 0645.32/REM','A2 0986424474','A2 GDB3347','C9 24062-17,6','A2 LP1779','A1 16510 FE','C4 FDB1369','B7 23234.170.1','A1 598361','B7 B110139/DKM','A2 RH 2645.32','A2 05P682','B1 LUCGDB3216','A9 GDB3171','A1 WBP384','C4 0986424474','C4 05P729','A9 13.04605859.2','B1 ZIM23234.170.1','B1 CIF822-294-0','A2 RH 2645.02','B1 TOM1298','A1 50-W0-005ASK','A9 BP15002','A1 LP1816','B1 TOM1180','A1 0986424474','A5 205167','B7 BP-1011/KAVO','A9 0986494343','A2 RH 2645.12','A2 J3600910','A2 J3600902','A1 WBP533','A2 FE FDB1116','B1 LUCGDB3265','A2 LP1304','C9 PF0206','A2 BP15002','A3 FER FDB1969','B1 BOS0986494343','A1 P15002','C9 VAL301184','C9 QP3226','B7 24062.170.1','A2 RH 2645.22','B1 BOS0986494173','A1 0986494343','A3 ROA 264532','A2 LP1816','A2 13.04605863.2','A8 215 805','C9 21190 00 701 00','C4 05P710','A1 0986494173','B1 TOM1074','C9 PF0510','C9 GDB3347','A2 24062 176 05','A2 301184','B1 TOM1676','A3 FER FDB1369','C9 GDB3216','A1 LP1304','C9 13.0460-5994.2','A9 FE FDB1905','B1 KAMJQ1012232','B1 BREP15002','A2 GDB3345','A3 TRW GDB3265','A3 BOS 0986495116','C4 GDB3347','B1 ATE13.0460-5859','A2 13.04605994.2','C9 VAL598184','B1 KAMJQ1012134','C9 0986494173','A9 GDB3345','C4 GDB3345','C9 0252186217','B7 B111234/DKM','B7 BP-1003/KAVO','A1 J3600902HB','A3 ROA 264502','B7 1263600910/JP','A1 572407J JRD','A5 40180','C9 19-0609','A2 05P729','C9 13.0460-5863.2','A1 FDB1369','C4 GDB3171','A3 NKS 225008','C9 PF0207','A1 FDB1905','A1 GDB3171','B1 KAMJQ101284','C4 LP1304','A1 0986495116','B1 CIF822-509-0','A3 ROA 264512','A8 205 595','A9 J3600902','C9 19-3398','B1 ABS37053','B1 VAL301184','A3 ROA 264522','C9 23234-16,9','C9 0986424474','A1 LP1779','B7 05P682/SUZ','B7 KBP-1001/KAVO','C4 605863','B1 TOM1068','A2 GDB3171','A1 P10006','A8 230 496','A9 13.04605994.2','C9 2323401','C9 GDB3171','C4 GDB3265','C9 0986494343','C1 RH 2645.32','A1 GDB3216','C9 0252323417/W','A5 206892','B7 KBP-1008/KAVO','C4 2323401TX','A2 BP10006','A2 FE FDB1969','A2 0986494173','A3 TEX 2323401','A3 DLP LP1779','A3 FER FDB1116','C9 82-0246','C9 GDB3345','B7 B110140/DKM','B1 ZIM24062.170.1','B7 0645.22/REM','A1 FSL1116','A1 GDB3345','B7 50W05/JAPKO','A1 598184','B1 KAMJQ101257','C9 PA-W05AF','C4 J3600902','C9 23234 00 701 10','B1 BREP10006','B1 ABS37526','B1 ATE13.0460-5863','B1 BOS0986424474','B1 LUCGDB3345','B1 ABS37055','A9 BP10006','B7 0645.12/REM','B1 FEB16510','A1 13.0460-5994.2','A8 221 842','A1 13.0460-5863.2','C1 RH 2645.22','A3 BOS 0986494343','A2 0986494343','A2 05P710','A1 FSL1369','A2 FE FDB1905','B1 LUCGDB3171','A1 0986495059','A2 23234 169 05','C9 VAL598361','C4 FDB1116','A1 GDB3265','A3 CIF 822-509-0','E1 89 91 6510','A8 230 492','A1 13.0460-5859.2','C9 13.0460-5859.2','A9 FE FDB1116','A1 FDB1116','A1 GDB3347','A3 BOS 0986424474','A3 DLP LP1304','E7 AC443381D','C4 05P682','C4 FDB1905','B1 LUCGDB3347','B1 FRE940078','A3 BOS 0986495059','C4 LP1779','B1 ATE13.0460-5994','A9 GDB3347','B7 B111067/DKM','A2 13.04605859.2','B1 VAL301361','A1 WBP145','A3 FER FDB1905','A2 FE FDB1369','A3 TEX 2406201','A3 BOS 0986494173','C9 VAL301361','A9 23234 169 05','C4 FDB1969','A1 WBP502','A3 DLP LP1816','C9 19-0654','B7 0645.02/REM','C4 GDB3216')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #