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