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 ('B7 51K09/JAPKO','A2 24320.155.2','B1 FRE940142','B1 ZIM24320.155.1','C9 VAL301817','B1 TOM1628','B1 ABS36692','A5 436267','B1 BREP30046','B7 B110965/DKM','A9 BP30025','A2 RH 21209.02','B1 LUCGDB3641','B1 CIF822-725-0','A2 LP1952','A2 N3610313','A5 284598','A2 T 2432001','C4 LP1952','A1 WBP818','A9 13.04605781.2','C9 13.0460-5780.2','C9 QP0706','B1 BOS0986494140','C9 FDB1956','C9 VAL598867','C9 QP6986','A8 249 707','A1 0986495354','A1 0986494140','A8 227 333','C4 KRO3421','B1 KAMJQ101146','A2 FE FDB4408','A2 FE FDB1902','C4 FDB4235','B1 VAI52-0070','A3 FER FDB4408','C9 PP-K09AF','A8 233 621','C4 0986494140','A8 230 499','A2 J3610512','A9 FE FDB1902','C4 J3610512','B7 BP-4018/KAVO','A1 FDB4235','A8 230 268','A2 BP30025','A1 LP1976','C9 2432001','A3 TEX 2494901','A9 FE FDB4408','A8 227 144','C4 24320.155.2','A3 FER FDB4235','A9 GDB3641','B7 1209.02/REM','B1 VAL302408','A9 BP30046','C4 FDB1956','A2 BP30046','B1 LUCGDB3421','B1 VAL301817','A1 GDB3421','A1 P30025','A2 GDB3641','C9 2494901','A1 P30051','C9 25292-15,9','C9 24949-16,5','B1 BREP30025','A2 GDB3421','A1 0986494887','A9 N3610313','A9 RH 21209.02','A3 JAP PP-K09AF','A9 RH 21209.42','A5 118316','A3 FER FDB1902','A1 LP1952','C4 25292.155.1','A2 0986494140','B1 BOS0986495354','C9 GDB3421','C9 0986494887','A3 CIF 822-725-0','B1 LUCGDB3474','C9 0252567716','C4 24320.155.1','C9 0986494627','A1 WBP775','A8 236 965','C9 2567701','B1 ATE13.0460-5781','C4 2432001TX','A8 256 332','B1 BREP30051X','A1 FDB1902','B1 BOS0986494627','A2 LP1976','C9 13.0460-5781.2','A3 FER FDB1956','A8 224 380','C9 0252432015/PD','A3 BOS 0986494140','C9 0986494140','C4 LP2303','B1 FEB116260','A2 GDB3474','A5 271062','A9 T 2432001','A2 T 2494901','C9 PP-K04AF','C9 2529201','B1 BREP30051','A5 286887','B1 VAL301706','B1 ABS37533','A9 0986494140','C9 VAL301867','A5 413059','A5 283725','B7 24320.155.1','B1 CIF822-725-1','C9 25677-15,9','A3 VAC V52-0070','C4 116260F','C4 GDB3474','B1 ABS37515','B7 KBP-4007/KAVO','A3 DLP LP2303','A5 58643','C9 GDB3474','C4 05P1344','B7 24320.155.2','C4 FDB1902','A2 FE FDB1956','A1 13.0460-5780.2','C4 FDB4408','C9 13.0470-5781.2','B1 ZIM25292.155.1','A1 51-0K-K09ASK','A3 TEX 2529201','A1 GDB3474','C9 GDB3641','A9 J3610512','C4 N3610313','B7 SP 380','A9 24320.155.2','A8 233 608','B7 B111033/DKM','C9 24320-15,9','A1 51-0K-004ASK','B1 TOM1566','B7 1209.42/REM','B1 KAMJQ1011276','C4 1170070','C4 2529201TX','C9 QP6986C','C4 605780','A3 ROA 2120902','A3 DLP LP1976','C9 19-1131','A3 TEX 2432001','A5 68791','A9 13.04605780.2','B1 BOS0986494887','C9 13.0470-5780.2','B1 ZIM24320.155.2','A9 T 2494901','A2 RH 21209.42','C4 KRO3474','C9 24320 00 704 10','C9 19-3647','A1 2432001 TEX','A2 T 2529201','A3 TEX 2567701','C4 LP1976','A9 GDB3421','C9 24949 00 704 00','A1 13.0460-5781.2','B1 ATE13.0470-5780','B1 ATE13.0460-5780','A3 DLP LP1952','A2 13.04605780.2','A9 GDB3474','B7 25292.155.1','A1 LP2303','B1 ATE13.0470-5781','A1 J3610312HB','A1 P30046','C9 0252432015/W','B7 BP-3046/KAVO','A9 T 2529201','A1 FDB1956','A3 ROA 2120942','C4 GDB3421','A9 FE FDB1956','B1 VAL301867','B7 51K04/JAPKO')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #