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 ('B1 ATE13.0460-2880','C9 2448381','A2 T 2391482','C9 VAL598463','A2 LP1824','A1 P85108','C4 16476F','A3 TEX 2391481','C9 2391401','B1 VAI10-8173','A2 T 2448302','A1 P85095','A1 573158JC JRD','A3 VAC V10-8173-1','B1 BOS0986461769','A9 FE FDB4192','A3 BOS 0986494053','A8 221 484','A9 13.04702887.2','A2 05P634','C4 2448302TX','A9 0986461769','A9 0986494053','A2 FE FDB1636','A8 201 645','C4 05P1390','A3 TEX 2391402','B1 VAL301463','A1 571906JC JRD','B1 FEB16344','E1 30 91 6476','B1 BOS0986494062','C4 0986461769','A8 228 210','A9 05P634','C9 VAL872914','B7 SP 321','C9 13.0470-2887.2','A2 0986494053','A9 0986494062','B7 0263.05/REM','A1 0986494053','A1 13.0470-2880.2','A1 GDB1622DTE','A9 BP85108','A2 23554 152 14','A1 16476 FE','B1 BREP85073','B1 BOS0986494649','A1 573005JC JRD','A1 FDB4192','C9 FDB1636','C9 13.0460-2880.2','A1 0986424824','A9 05P1219','B7 05P634/SUZ','A8 233 635','A3 BOS 0986461769','A1 16342 FE','C4 2448382TX','A3 TEX 2355482','C9 VAL598752','C9 VAL301463','C4 16344F','A3 TEX 2355401','B1 BREP85095','A9 FE FDB1636','C9 0986494626','A2 13.04702887.2','A2 FE FDB4192','B1 BREP85108','C4 0986494062','A1 0986495054','C9 2448302','C4 LD2887','C4 FDB4192','A1 13.0460-2880.2','A3 VAC V10-8173','C9 VAL301752','A2 0986495054','C9 13.0460-2887.2','A2 05P1219','B1 ATE13.0470-2887','A3 TEX 2391401','C9 0252096117','A1 0986494062','A5 66316','B1 FEB16346','B1 FEB16476','A2 0986494062','B1 BOS0986494595','C4 0986494053','C9 24483-17,2 2 4','A9 BP85095','C9 13.0470-2880.2','C9 224775','C9 23914-17,2 EPAD','A8 224 847','A8 234 095','A1 FSL1636','A1 FDB1636','A2 BP85095','C4 602880','B1 ATE13.0460-2887','A1 0986424796','A8 236 935','D1 BP ADV184205','A2 BP85073','A3 TEX 2448382','A5 113386','A1 571906D JRD','A9 GDB1622DTE','A1 2355401 TEX','A1 P85073X','C4 FSL1636','A9 13.04602880.2','C9 23914-17,2 2 4 EPAD','A2 05P1390','A8 215 485','C9 2391482','A1 FSL1636-PROMO','B7 1031.00/REM','A9 13.04702880.2','A3 FER FDB1636','A5 73645','A5 116726','C9 2355401','A8 236 867','C9 GDB1622DTE','C4 LP1824','A1 0986494626','A1 0986461769','C4 FDB1636','A2 23914 172 24','A9 T 2448381','A5 289492','A1 598463','C9 0252096117/PD','A3 TEX 2448381','C9 2355482','A9 23914 172 14','A2 T 2448381','A2 13.04602887.2','C4 LD2880','A3 BOS 0986494062','A9 23554 152 14','A5 144410','A3 TEX 2448302','A9 T 2391482','A3 BOS 0986495054','C9 0986494649','A8 220 644','C9 24483-17,2 EPAD','C4 GDB1622DTE','C9 0986461769','B1 VAI10-8173-1','C9 2391402','B1 ATE13.0470-2880','C9 23554-15,2','A1 16344 FE','A1 LP1824','C4 2391401TX','C9 23914-17,2 2 4','C9 0986494062','C9 24483-17,2 2 4 EPAD','A1 13.0460-2887.2','A9 13.04602887.2','A2 23914 172 14','B1 BREP85073X','B1 VAL301752','C9 0986494595','A2 0986494626','A8 200 292','B1 LUCGDB1622DTE','A3 FER FDB4192','E1 30 91 6540','A5 74124','C4 2355401TX','A8 233 944','C9 23914-17,2','A1 16540 FE','C4 05P634','A3 DLP LP1824','C4 602887','A1 16478 FE','A1 P85073','C9 0252391417/PD','A3 TEX 2391482','B1 BOS0986494626','C9 0986494053','A1 16346 FE','C9 0252391417','A2 BP85108','B1 FEB16540','A8 236 868','A9 23914 172 24','A2 GDB1622DTE','B7 0263.03/REM','B1 BOS0986494053','A2 13.04702880.2','C4 05P1219','A9 BP85073','A5 194869','A2 0986461769','A2 13.04602880.2','A1 13.0470-2887.2','A1 2391401 TEX','C9 23554-15,2 EPAD','C9 ADV184205','A2 T 2391481','B1 BLPADV184205','A1 0986494344','A1 0986494731','A1 13.0460-2621.2','A1 13.0460-2749.2','A1 13.0470-2749.2','A1 P85095X','A2 0986494344','A2 13.04602749.2','A2 23914.970.1','A2 BD S011S','A2 Q109-1606','A2 Q109-1679','A2 RH 21031.00','A3 BOS 0986494344','A3 CIF 822-553-0','A3 JAP PP-0007AF','A3 QUI 109-1679','A3 ROA 2103100','A5 110730','A5 274073','A5 275128','A5 309511','A8 257 865','A9 0986494344','A9 13.04602621.2','A9 13.04602749.2','A9 13.04702621.2','A9 13.04702749.2','A9 BD S011S','A9 Q109-1606','A9 Q109-1679','A9 RH 21031.00','B1 ABS37411','B1 ATE13.0460-2621','B1 ATE13.0460-2749','B1 ATE13.0470-2621','B1 ATE13.0470-2749','B1 BLPADV184231','B1 BOS0986494731','B1 BREP85095X','B1 CIF822-553-0','B1 FEB16991','B1 KAMJQ1013272','B1 QB109-1606','B1 QB109-1679','B1 ZIM23914.170.1','B1 ZIM23914.170.2','B1 ZIM23914.970.1','B7 23914.170.1','B7 23914.170.2','B7 B110859/DKM','B7 B111275/DKM','C4 0986494344','C4 0986494731','C4 1170005','C4 23914.170.1','C4 23914.170.2','C4 602749','C9 0986494731','C9 13.0460-2621.2','C9 13.0460-2749.2','C9 13.0470-2621.2','C9 13.0470-2749.2','C9 19-0475','C9 23914 00 704 00','C9 PP-0007AF','C9 QB109-1606','C9 QB109-1679','C9 QP5999','C9 QP5999C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #