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 KBP-6559/KAVO','A1 0986424795','C9 0252397317','A3 RH 2987.11','A3 IDG RH 2987.11','C4 2397302TX','B7 BP-8526/KAVO','A1 J3601085HB','B1 BOS0986424795','C4 0986424795','B1 BREP56086','A2 BP59050','C4 FDB1617W','A2 0986494160','A1 GDB3332','A1 FDB4069','A2 ADN142117','A5 170174','A8 230 312','A2 RH 2987.00','C4 0986494160','A8 232 583','A3 ROA 298700','C4 GDB2017','A2 FE FDB1617','A1 0986494573','A5 154110','B1 BOS0986494856','A1 50-08-800ASK','A9 0986424795','A8 230 294','B1 BOS0986494160','C9 23973-17,3 1 5','B1 BREP68033','A1 WBP1198','B1 BREP59050','A1 GDB3396','B1 LUCGDB2017','A9 GDB3332','C4 GDB3396','C9 0986494573','A9 BD S475','A9 RH 2987.00','A5 70980','A9 BP68033','A3 JAP PA-013AF','C9 0986494856','C9 ADN142117','A1 GDB3546','C9 GDB3332','B1 LUCGDB3332','C4 FDB4069','A1 P59050','A5 201677','B1 BOS0986494573','A1 50-00-013ASK','A9 FE FDB1617','A3 JAP PA-800AF','A5 57663','C9 ADK84236','B7 KBP-8522/KAVO','B1 BOS0986494592','A8 241 381','A5 57653','A2 J3601085','B1 BLPADN142117','A9 GDB3396','C4 05P867','A2 GDB2017','C9 FDB1617','A3 FER FDB1617','B7 BP-6570/KAVO','A8 231 784','A9 J3601085','A5 201888','A9 0986494160','A9 FE FDB4069','B1 CIF822-485-0','A9 GDB2017','A1 GDB2017','A8 236 859','C4 05P1229','A1 FSL1617','A1 598641','C4 FDB1617','A2 BP68033','A2 BD S475','C9 VAL598641','A2 0986494573','A9 T 2397302','A1 WBP566','C9 0986494160','A3 CIF 822-485-1','C4 KRO3332','A2 05P1229','D2 EO GDB3332','A2 GDB3546','C9 PA-013AF','C9 0986424795','D1 BP ADK84236','A1 2397302 TEX','A1 FDB1617','C9 PA-800AF','B1 LUCGDB3546','A8 222 065','A5 289230','A1 P56086','A8 217 742','A5 289977','C9 GDB3546','A8 222 064','C9 2397302','B1 LUCGDB3396','D1 BP ADN142117','A3 BOS 0986494160','A9 J3608026','C4 GDB3332','B1 ABS37478','C9 0986494592','B1 CIF822-485-1','C9 GDB2017','A1 P68033','A2 05P867','A2 GDB3396','A2 0986494856','A3 BOS 0986424795','C4 J3601085','A3 TEX 2397302','A1 GDB1614','A3 CIF 822-485-0','A2 FE FDB4069','A2 0986424795','A9 GDB3546','C4 GDB3546','A2 T 2397302','A3 ROA 298711','C9 VAL598847','A9 05P867','A2 RH 2987.11','B1 BLPADK84236','E6 BP1857','A9 BP59050','A3 FER FDB4069','C9 GDB3396','A2 J3608026','A1 0986494160','C4 J3608026','B1 ABS37395','A2 GDB3332','A1 13.0460-2709.2','A1 13.0460-2774.2','A1 13.0460-5700.2','A1 13.0460-5801.2','A1 GDB3332DTE','A2 13.04602709.2','A2 Q109-1709','A3 QUI 109-1709','A3 ROA 298702','A5 136064','A5 73868','A5 77606','A8 234 126','A9 13.04602709.2','A9 13.04602774.2','A9 13.04605700.2','A9 13.04605801.2','A9 13.04702709.2','A9 GDB3332DTE','A9 Q109-1709','B1 ATE13.0460-2709','B1 ATE13.0460-2774','B1 ATE13.0460-5700','B1 ATE13.0460-5801','B1 ATE13.0470-2709','B1 ATE13.0470-5801','B1 FEB16523','B1 KAMJQ101188','B1 KAMJQ101344','B1 LUCGDB3332DTE','B1 QB109-1709','B1 VAL301641','B1 VAL301847','B1 ZIM23973.175.1','B1 ZIM23973.975.1','B1 ZIM24403.175.1','B7 0987.00/REM','B7 0987.11/REM','B7 23973.175.1','B7 B110927/DKM','B7 B111060/DKM','C4 16523F','C4 23973.175.1','C4 602709','C4 602774','C4 605700','C4 605801','C4 GDB3332DTE','C4 LD2709','C9 0252397317/PD','C9 0252440317/PD','C9 0252440317/W','C9 13.0460-2709.2','C9 13.0460-2774.2','C9 13.0460-5700.2','C9 13.0460-5801.2','C9 13.0470-2709.2','C9 13.0470-5801.2','C9 19-0892','C9 19-1995','C9 23973 00 702 00','C9 GDB3332DTE','C9 QB109-1709','C9 QP2261','C9 QP2261C','C9 QP7494','C9 QP7494C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #