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 ('A8 230 312','A3 ROA 298700','A5 289230','C9 GDB2017','C9 PA-013AF','C4 FDB1617W','A1 0986494573','A2 0986494160','A2 0986494856','A1 FSL1617','C9 2397302','B1 LUCGDB3332','A2 J3601085','A2 FE FDB1617','A3 TEX 2397302','A2 05P867','A3 BOS 0986424795','C9 GDB3332','A2 GDB3396','C9 0986424795','C9 0986494573','A1 50-08-800ASK','A3 FER FDB4069','A1 P68033','A9 0986424795','A2 RH 2987.11','A9 T 2397302','A3 JAP PA-800AF','A2 GDB2017','C4 FDB4069','B1 BOS0986424795','A1 WBP1198','C4 GDB2017','C4 KRO3332','C4 GDB3546','A1 GDB3546','B1 BREP56086','B1 BOS0986494160','A1 P59050','B1 LUCGDB3396','A8 222 065','B1 BOS0986494573','A5 57653','A9 GDB3546','B1 BREP68033','C9 23973-17,3 1 5','C4 FDB1617','A1 FDB1617','B1 BREP59050','B7 KBP-8522/KAVO','A2 0986424795','C4 0986424795','A9 FE FDB4069','C9 0252397317','A9 BD S475','C9 ADK84236','A8 232 583','A2 BP68033','B1 BOS0986494592','A9 BP59050','A1 0986494160','A1 GDB1614','B1 ABS37478','A2 BD S475','B1 ABS37395','A1 0986424795','B1 CIF822-485-0','B1 CIF822-485-1','C9 FDB1617','B1 BOS0986494856','A2 T 2397302','A3 CIF 822-485-1','A9 RH 2987.00','A2 GDB3546','C4 0986494160','B1 LUCGDB2017','A1 598641','A1 GDB3396','A2 RH 2987.00','A8 230 294','C9 0986494592','C9 VAL598847','A9 0986494160','C4 GDB3396','A1 2397302 TEX','B7 BP-8526/KAVO','A1 J3601085HB','A5 170174','D1 BP ADN142117','A5 70980','A9 J3608026','A9 GDB3396','A1 50-00-013ASK','A2 BP59050','A9 GDB2017','A5 201888','C4 J3608026','A2 FE FDB4069','A2 05P1229','B1 LUCGDB3546','C9 PA-800AF','A9 J3601085','A1 GDB3332','D2 EO GDB3332','A3 FER FDB1617','C9 0986494160','A9 05P867','A1 FDB4069','C9 0986494856','C4 05P1229','A5 201677','A1 WBP566','C4 2397302TX','A1 GDB2017','C9 GDB3396','A9 BP68033','A9 GDB3332','A8 222 064','C9 GDB3546','C9 ADN142117','C4 J3601085','E6 BP1857','A2 GDB3332','A1 P56086','C4 05P867','A8 217 742','A8 241 381','B1 BLPADN142117','B1 BLPADK84236','A5 154110','A8 236 859','A3 IDG RH 2987.11','A3 BOS 0986494160','A3 CIF 822-485-0','A5 289977','A3 ROA 298711','A2 0986494573','A3 JAP PA-013AF','A9 FE FDB1617','B7 KBP-6559/KAVO','A2 J3608026','C9 VAL598641','D1 BP ADK84236','A5 57663','A8 231 784','C4 GDB3332','B7 BP-6570/KAVO','A3 RH 2987.11','A2 ADN142117','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)) #