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