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 FDB749','A3 BOS 0986460968','A9 GDB1099','C9 2136502','A1 2143602 TEX','B7 0414.00/REM','A8 206 778','C4 LP851','C9 2143602','C9 13.0460-3807.2','A1 FDB1630','B7 21436.170.1','A3 TRW GDB1099','A9 05P462','B7 21436.170.2','C4 FSL749','A3 ROA 241420','B7 21365.170.1','B1 ABS37896','B7 05P483/SUZ','A1 13.0460-3949.2','A3 TEX 2136502','A2 RH 2414.20','C4 05P464','A2 GDB1099','A1 598012','C9 0986461119','A3 DLP LP771','C9 PA-0058AF','A2 05P464','B7 0414.01/REM','A1 13.0460-3807.2','A5 5330','A1 0986495033','A8 211 035','C4 05P483','A3 DLP LP851','C4 FDB1630','A3 BOS 0986495033','A9 RH 2414.00','A5 194959','A1 FDB749','A3 TEX 2143602','A1 GDB1299','C9 FDB749','A2 0986495033','A1 0986495255','A1 LP771','A3 ROA 241410','A1 WBP163','A2 0986460968','C4 GDB1115','A2 LP771','B1 FEB16754','A1 GDB1099','A2 05P462','A9 0986461119','A8 215 140','E7 139.0.T','C9 GDB1115','A3 BOS 0986461119','A9 13.04603950.2','C4 0986495255','B1 VAL301012','B1 LUCGDB1115','A1 WBP164','C4 603807','B1 ATE13.0460-3950','A5 15255','B1 ATE13.0460-3807','A1 16754 FE','C4 2143602TX','A5 40482','B1 ZIM21436.170.2','B1 ZIM21436.170.4','A8 201 688','C4 0986461119','A5 206775','A3 FER FDB1630','C4 KRO1115','C9 13.0460-3949.2','B7 21436.170.4','A1 FSL749','C9 21365-17,0','B1 ZIM21436.170.1','B7 0414.10/REM','B1 CIF822-159-0','C9 VAL598012','A1 LP851','A2 13.04603949.2','A2 RH 2414.10','A2 0986495255','A1 0986461119','C9 21436 00 702 00','B1 CIF822-159-1','C1 RH 2414.20','B1 BOS0986460968','B1 BLPADL144221','C4 05P462','A3 BOS 0986495255','A9 0986460968','D1 BP ADL144221','B1 ZIM21365.170.1','A2 GDB1115','A3 JAP PA-0227AF','E7 139.0','C4 16754F','A3 ROA 241400','B1 LUCGDB1099','A9 21365 170 04','A8 230 057','A9 FE FDB1630','C9 19-0493','A3 CIF 822-159-1','A2 13.04603950.2','C9 VAL301012','C4 603950','C9 PA-0016AF','B7 0414.20/REM','A2 05P1262','A9 GDB1115','B1 BOS0986461119','A2 RH 2414.00','B1 FEB16082','B7 GDB1115_TRW/AG','B1 CIF822-137-0','B1 ATE13.0460-3949','A9 RH 2414.20','C9 0986460968','C4 21436.170.1','C9 21436-17,0','A9 LP851','A9 21436 170 04','B1 ABS36854','B1 VAL302110','A1 16082 FE','A2 05P1191','A3 FER FDB749','A2 FE FDB1630','A2 ABS36854','A3 CIF 822-159-0','A1 0986460968','A9 ABS36854','C4 LP771','A2 21436 170 04','C9 PA-0087AF','A2 RH 8414.00','A2 LP851','A2 0986461119','C9 13.0460-3950.2','A1 GDB1115','C9 GDB1099','A2 05P483','E1 70 91 6084','A8 209 766','A2 21365 170 04','A1 13.0460-3950.2','A1 WBP156','A9 13.04603949.2','A2 FE FDB749','A1 13.0460-3951.2','A1 FDB925','A1 LP2013','A2 Q109-1273','A2 RH 2414.01','A3 DLP LP2013','A3 QUI 109-1273','A5 12592','A8 203 712','A9 13.04603951.2','A9 FE FDB925','A9 Q109-1273','B1 ATE13.0460-3951','B1 BLPADL144206','B1 FEB16084','B1 QB109-1273','B7 B110183/DKM','B7 B111051/DKM','C4 16084F','C4 603951','C4 LP2013','C9 0252143617/PD','C9 0252143617/W','C9 13.0460-3951.2','C9 QB109-1273','C9 QP7932','C9 QP7932C','D1 BP ADL144206')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #