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 ('A1 598682','B7 BP-2043/KAVO','C4 05P508','A2 RH 2325.02','A8 215 845','A1 FDB1679','B1 LUCGDB3376BTE','A5 36442','A9 FE FDB956','E1 85 91 6775','B1 FEB170289','B1 ABS36712','A2 GDB3175','B1 BLPADH24264','A9 GDB774','A3 TEX 2171901','A3 TEX 2172001','A9 GDB3175','B1 LUCGDB3447','A8 228 742','C9 GDB3175','B1 BREP79027','A3 DLP LP948','C4 LP948','A2 J3614008','A2 BP79027','A2 21719 146 05','B1 BLPADH24250','A1 WBP431','C9 VAL301682','C4 605929','B7 0325.02/REM','C9 19-3387','A8 201 893','B1 LUCGDB3516','C4 GDB3175','B1 FEB16873','A2 LP948','A9 GDB3191','A8 241 409','B7 KBP-2008/KAVO','A5 32813','C9 VAL598911','B7 BP-2030/KAVO','A9 13.04605929.2','B7 0325.32/REM','C9 PP-405AF','A1 GDB3447','C9 0986461006','C4 GDB774','A1 GDB774','A1 16775 FE','D1 BP ADH24264','C9 GDB1923','B7 0325.12/REM','A1 FSL956','A1 GDB3191','B1 LUCGDB3191','A8 241 405','A2 13.04605929.2','C4 0986461006','B1 CIF822-173-0','A2 GDB1923','A2 05P508','A1 16297 FE','B7 B110274/DKM','B7 51405/JAPKO','A1 51-04-405ASK','A1 GDB3175','C9 FDB956','A3 CIF 822-612-0','B7 SP 168','A9 GDB1923','A1 P28022','A9 BP79027','B1 LUCGDB3407BTE','C9 GDB3407BTE','C9 GDB774','A1 572138J JRD','B1 LUCGDB3175','A2 RH 2325.32','B7 21719.150.1','B1 LUCGDB1923','A1 WBP795','A2 GDB3407BTE','A2 GDB3191','A3 ROA 232542','B1 ABS37612','B1 BOS0986461006','A5 177166','A8 230 350','A2 GDB774','C9 GDB3191','B1 ATE13.0460-5929','A9 21719 146 05','C9 ADH24250','C9 19-0432','C9 ADH24264','A3 VAC V26-0021','A1 16873 FE','B7 BP-2032/KAVO','C9 QP7537','B1 FEB16775','A1 LP948','B1 LUCGDB774','A1 F026000114','C9 GDB3447','C9 PF0464','C9 13.0460-5929.2','A9 0986461006','E1 70 91 6873','A1 13.0460-5929.2','A1 GDB3516','A1 GDB1923','C4 J3614008','C4 FDB956','E1 85 91 6297','A2 0986461006','C9 VAL598682','E6 BP1026','A2 FE FDB956','A1 FDB956','A9 J3614008','A1 0986461006','A2 GDB3516','B1 VAI26-0021','C9 23652 00 704 00','A2 BP28022','A9 RH 2325.32','B1 BREP28022','B7 3463700119/JP','B1 ZIM21719.150.1','A1 P79027','A3 FER FDB1679','C9 2172001','E7 176.0','B1 CIF822-612-0','A3 JAP PP-405AF','A9 BP28022','B1 VAL301682','C9 GDB3516','B1 LUCGDB3478BTE','A3 ROA 232532','A9 GDB3516','C9 21720-14,6','D1 BP ADH24250','A1 WBP202','B1 FEB16297','A3 TRW GDB3191','C9 2171901','A3 ROA 232502','A3 FER FDB956','A3 BOS 0986461006','A3 CIF 822-173-0','B1 TOM1100','A9 GDB3407BTE','A8 241 447','A9 GDB3447','A2 FE FDB1679','A2 GDB3447','C4 2171901TX','D1 BP ADL144212','A5 289871','A1 WBP817','C9 21719-14,6','A1 WBP871','A1 13.0460-5711.2','A1 2365201 TEX','A1 GDB3154','A1 P28039','A2 13.04605711.2','A2 23652 148 05','A2 ABS36758','A2 BP28039','A2 GDB3154','A3 TEX 2365201','A5 206710','A8 207 860','A9 13.04605711.2','A9 23652 148 05','A9 BP28039','A9 GDB3154','B1 ABS36757','B1 ABS36758','B1 ATE13.0460-5557','B1 ATE13.0460-5711','B1 BLPADH24247','B1 BREP28039','B1 KAMJQ1018538','B1 LUCGDB3154','B7 B110907/DKM','C4 2365201TX','C4 605711','C9 0252171914/PD','C9 0252373615','C9 13.0460-5711.2','C9 19-3669','C9 2365201','C9 ADH24247','C9 GDB3154','C9 QP7537C','D1 BP ADH24247')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #