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 ('C9 2533701','C9 ADG042154','A3 BOS 0986494417','E6 BP2135','B1 ATE13.0470-5786','C4 LP2295','A2 ADG042100','C9 GDB3494','B7 25337.160.2','B7 1362.32/REM','C9 2493401','C4 GDB3494','A2 T 2533701','A8 237 644','A5 88358','A1 0986494557','B1 FEB16799','C9 0986494557','B1 LUCGDB3494','A1 13.0460-5786.2','C4 2493401TX','A1 0986495351','A8 234 678','A5 119337','A2 BD S907','B1 BOS0986494557','A1 LP2295','A1 0986494417','C4 25337.160.2','B1 BOS0986494635','C9 25337-15,7','C4 25337.160.1','B1 BREP30067','A9 T 2533701','C4 0986494417','A3 TEX 2564701','A1 13.0470-5786.2','C9 13.0460-5786.2','B1 ZIM25337.160.2','A2 T 2493401','B1 VAL301301','A8 233 614','A8 230 696','A9 0986494417','B7 1362.02/REM','B1 ZIM25337.160.1','A3 BOS 0986494557','C4 0986494557','C9 PP-K06AF','A3 TEX 2493401','C9 ADG042109','A5 139569','A1 P30067','A3 DLP LP2195','A9 GDB3494','A8 236 940','A2 BP30047','A1 P30054','C4 FDB4387','B1 BOS0986494417','B1 BLPADG042154','B7 25337.160.1','C9 VAL301301','D1 BP ADG042109','B7 1362.42/REM','C4 LP2195','A1 P30047','A2 0986495351','B7 1362.52/REM','A1 GDB3494','A9 BD S907','B7 1583.02/REM','C9 24934-15,5','C9 0986494417','D1 BP ADG042100','B1 BLPADG042100','C4 605786','B1 BREP30047','A3 DLP LP2295','B7 1362.04/REM','C4 05P1558','C9 25647-15,7','A8 237 798','A8 229 223','A8 252 502','A2 GDB3494','A8 256 357','A9 T 2493401','A9 13.04705786.2','A1 LP2195','C9 25976-16,7 1 5','A1 FDB4387','C9 ADG042100','A2 13.04605786.2','A2 0986494417','A9 ADG042100','C9 2564701','A1 51-0K-K06ASK','A3 TEX 2533701','C4 05P1710','C9 2597601','B1 BLPADG042109','C9 13.0470-5786.2','D1 BP ADG042154','C9 0986494635','C4 2533701TX','A9 BP30047','A1 16799 FE','A1 2533701 TEX','A1 WBP801','B1 ATE13.0460-5786','C4 KRO3494','A2 13.04705786.2','B7 51K06/JAPKO','A3 FER FDB4387','A9 13.04605786.2','A1 2493401 TEX','B1 BREP30054','A1 13.0460-5650.2','A1 GDB3569','A1 WBP1258','A2 13.04605650.2','A2 RH 21362.42','A3 ROA 2136202','A3 ROA 2136242','A5 236579','A5 287407','A5 287428','A5 289441','A5 289827','A5 389981','A8 228 195','A8 228 553','A8 230 264','A8 234 156','A9 13.04605650.2','A9 RH 21362.02','A9 RH 21362.42','B1 ATE13.0460-5650','B1 ATE13.0470-5650','B1 BLPADG042127','B1 BLPADG042134','B1 BLPADG042138','B1 BLPADG042165','B1 BREP30067X','B1 FEB116289','B1 FEB116294','B1 FEB116301','B1 FEB116336','B1 FEB116378','B1 KAMJQ101268','B1 LUCGDB3569','B7 B111279/DKM','C4 05P1344','C4 116285F','C4 116294F','C4 116378F','C4 GDB3569','C9 0252493415/W','C9 13.0460-5650.2','C9 13.0470-5650.2','C9 19-2129','C9 ADG042127','C9 ADG042134','C9 ADG042138','C9 ADG042160','C9 GDB3569','C9 QP0611','C9 QP5713','C9 QP5713C','D1 BP ADG042127','D1 BP ADG042160','D1 BP ADG042165','E7 903.0')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #