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 ABS36712','A2 GDB3516','A9 FE FDB956','B1 BOS0986461006','C9 GDB3191','C9 2365201','B1 VAL301672','A1 598682','B1 ZIM23871.138.1','C9 0252373615/PD','C9 0252171914/W','C9 13.0460-5711.2','A9 GDB3447','B7 B110294/DKM','B1 LUCGDB3154','C9 QP7537','A1 WBP871','A1 16873 FE','B1 KAMJQ1018538','A2 0986494358','A8 256 353','B7 21719.150.1','A1 13.0460-5929.2','B7 0325.22/REM','B1 ATE13.0460-5557','A8 228 742','B1 ZIM21719.150.1','B7 51405/JAPKO','A2 RH 2325.52','A2 RH 2325.02','A3 ROA 232502','B1 LUCGDB3175','A3 TEX 2172001','A3 DLP LP948','C9 PF0462','C4 2365201TX','A1 LP948','A2 GDB3269','C9 0986494358','A9 21719 146 05','A2 GDB1923','A9 GDB3175','A9 0986461006','A2 FE FDB956','A9 13.04605711.2','B1 LUCGDB774','A8 241 447','C9 VAL301682','A2 GDB3154','A8 207 860','A8 256 784','A3 JAP PP-405AF','C9 VAL598682','A2 BP79027','C4 605711','C9 19-0432','A1 LP1507','B1 VAL301682','C9 0252373615','A3 BOS 0986461006','C4 0986494358','A1 GDB3175','A3 TEX 2365201','A3 VAC V26-0021','B7 BP-2032/KAVO','B1 KAMJQ101332','C9 GDB1923','A2 J3614008','C9 PF0464','C9 PP-405AF','C9 2172001','A2 RH 2325.22','B7 B110907/DKM','A3 ROA 232522','A1 FDB1679','B1 BREP79027','A9 GDB3269','A1 WBP795','B7 0325.12/REM','B7 0325.32/REM','A1 598627','A8 241 409','C9 GDB774','C4 GDB3175','A2 GDB3447','A8 201 893','A9 GDB3154','C9 GDB3269','A3 ROA 225001','A2 05P1014','A3 ROA 232512','B1 TOM1100','A1 WBP202','B7 BP-2043/KAVO','A2 GDB3175','C9 GDB3154','B1 BOS0986494358','A8 241 405','A1 GDB3269','A1 FDB956','A9 23652 148 05','A3 DLP LP1507','A2 RH 2250.01','E7 176.0','A3 BOS 0986494358','A9 BP79027','C4 LP1507','B1 ABS36758','A2 LP1507','C4 GDB3154','A9 0986494358','A3 ROA 232552','A1 GDB3154','A9 13.04605929.2','A1 J3614008HB','A1 WBP817','C4 0986461006','D3 RE 25001-AF','B1 CIF822-173-0','C9 23652 00 704 00','B7 23871.138.1','A9 RH 2325.52','C4 FDB956','A8 230 350','C4 GDB3269','B1 LUCGDB3447','C9 PF0461','A3 CIF 822-173-0','B1 FEB16873','A2 0986461006','A3 FER FDB956','A1 51-04-405ASK','B1 ATE13.0460-5929','A1 GDB1063','B1 ABS36757','A1 J3614009HB','B1 FRE940126','C4 J3614008','A1 P28039','A9 GDB3516','B7 0325.52/REM','A2 21719 146 05','A2 RH 2325.12','C9 21719-14,6','A1 WBP431','C9 19-3669','C9 13.0460-5929.2','C9 QP7537C','A8 215 845','A2 BP28039','A9 RH 2325.22','A1 572138J JRD','C9 23652-14,8','C9 21720-14,6','C4 GDB774','A5 177166','A2 GDB774','A9 J3614008','B1 ABS37612','C9 19-3387','A8 230 493','B7 KBP-2008/KAVO','A1 13.0460-5711.2','C9 2171901','A3 ROA 232532','A3 TRW GDB3191','B1 LUCGDB1923','C9 GDB3175','B1 ATE13.0460-5711','C9 0252171914/PD','A9 GDB1923','A1 0986461006','A1 GDB1923','A2 FE FDB1679','A9 GDB3191','A1 FSL956','A5 206710','A3 TEX 2171901','A1 GDB3191','A2 LP948','C4 LP948','B7 0325.02/REM','A2 23652 148 05','A5 289871','A9 GDB774','C4 2171901TX','B7 KBP-2009/KAVO','C9 0986461006','A2 05P508','B1 LUCGDB3516','A2 ABS36758','B1 VAI26-0021','A2 13.04605929.2','A1 GDB3516','C9 FDB956','C4 05P508','C9 GDB3516','A3 FER FDB1679','C9 GDB3447','C9 VAL301672','B1 LUCGDB3269','A1 P79027','E1 70 91 6873','A1 GDB3447','C9 VAL598627','A1 0986494358','A2 13.04605711.2','C4 23871.138.1','A9 BP28039','A2 GDB3191','A3 ROA 232542','B7 B110274/DKM','C9 VAL598911','A1 GDB774','B1 LUCGDB3191','A1 2365201 TEX','B1 BREP28039','A5 32813','A5 36442','A2 RH 2325.32','A9 ABS36758','A9 RH 2325.32')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #